Is a tornado most dangerous when it is over water?

No. Tornadoes are most dangerous when they hit a city or town. Then as the tornado starts destroying buildings it generates flying debris, which is what causes most tornado deaths and injuries.