It depends a lot on the extent of the damage I think.

I've had a ship giving nearly constant blips of the taking on water icon for quite a while & she was able to still play a major part in the battle without sinking.

Definitely making tight turns & using full sail seems to be a sure-fire way to have a holed ship sink though.