Given scene/plot descriptions from movies or TV shows, and given a specific question about the scene, summarize the question into a title

In the television series Supernatural, at what point of time and during which season did Sam lose his powers? EDIT: I mean to ask whether it was around the time Sam was brought back from hell without his soul by Cass, that he completely lost all his powers?
When does Sam lose his psychic powers?