The dramatic limo crash is set to have a long lasting impact in the fictional Yorkshire village