It’ll sink wihout a trace once the game decides it’s fully in the water. There’s a proposal to have it be placed underwater instead, which would require either shifting it fully into the water, or marking part of the vehicle “sunken”. Gets complicated rather quickly.