A driver has died after a wagon crashed into a bridge and came to rest in the river of a North Yorkshire village.