The driver of a wagon that crashed into a bridge and landed in the river has died, police have confirmed.