We will have to wait for someone who knows pills better then us.
Drowning panic and adrenaline usually wakes us up from most of the things.
But i guess if you can knock yourself out long enough and in a way where you dont feel pain, both drowning and hanging could succeed theoretically,if nobody rescues you.
Then again, i dont know the doses that would work. So be patient