A car left the road and went crashing into the water at Alum Bay on the Isle of Wight on Friday evening, as holidaymakers looked on in horror.