Suffocating and drowning would be the most horrible ways.
And to all those who say that drowning is not a painful death
You are unable to catch your breath, and if something is preventing you from reaching air (you're being held under the water) then you suffer in complete agony for about 11 minutes.