This idiom or expression means:

In trouble.
Under pressure.

Political scandals have landed several public figures in hot water.

Also see:
In deep sh-t. (Not a polite thing to say.)