Crashes 'common' on bend near Harrogate village, says resident