An elderly man died after his car entered the water near Colne during Storm Bert.