I've seen multiple people black out and have blacked out myself under water ... twice? (while training freediving). It comes on slowly and is far easier to do than you'd think.

If you do any of this without supervision it's just a matter of time until you die.