How to make a boat slowly sink for 30 minutes?

I am trying to make a boat steadily sink in a body of water for about 30 minutes. I’m hoping to incorporate a rope attached to the boat that is also slowly pulling down another boat. But, what is the best way to do this? Is there a way to create an animation that lasts for 30 minutes before concluding once the boat is entirely underwater? I am certain there is but I am not sure what it is and if anybody could write me up a quick how-to on it, I would be immensely grateful. Thanks.

I don’t use the sequencer much, but I assume 30 minutes animations are possible.

You could defintely do it with blueprint, just gradually change the transform of the boat over time:

( a simplistic representation ).