It was a 767, Ethiopian hijacking, most killed (many due premature inflation of lifejackets inside the a/c) - filmed from the beach.
Last premeditated ditching I know of was a DC-9 in Carribean some years ago - some survivors.
It is more than possible that water survival eqpt will be required even if not flying oceanic. Many runways project into oceans and rivers - a/c can come to earth anywhere inc. rivers and lakes.