The water could well be the cause, but it is not certain - there might still be some other cause of the tripping.
I
I would doubt the water could make the socket go 'dead', apart from when the RCD tripped. It is not uncommon for electrics to continue to work, despite not being in anyway designed for submersion, even deep under water. Several years ago a bank I attended was functioning absolutely fine, everything normal. No problems reported, until I tried to take a look in the basement. The incoming mains, 3ph meter, and a large dis-board were all six feet under water. It took several days to pumps all that water out, during which time the bank remained fully open. It then took several more weeks for all of the damaged MCB's/meters and etc. to be replaced.