I have over 5000 hours as a C-130 loadmaster and I know of at least one C-130 ditching where the aircraft remained intact and eight people survived. That was a Colombian C-130 that ditched in 1982.
I’m glad they made it.
A rarity for sure.
As you learned in your training.