South Park Season 8, Episode 13: Cartman's Incredible Gift

Cartman thinks that he has gained paranormal powers after getting in an accident, and abuses them to become a psychic detective for hire.