The design of the hull means that the cargo doors are slightly below the water line on spawn.
To safely open them without flooding:

- Ballast must be empty
- Set the Manual Vertical Thruster Control throttle to maximum (0.8). This is located on the bridge

Location of throttle circled in red
https://i.imgur.com/8sx6PDu.jpg