The Bad Lieutenant: Port of Call - New Orleans

In August 2005, Terence McDonagh (Nicolas Cage) is a New Orleans police sergeant. While cleaning out a locker after Hurricane Katrina, he notices that a prisoner may not have been transferred. When he finds the prisoner about to drown, he mocks him before eventually jumping in the water to save him. He is promoted to police lieutenant and given a medal for his work, but has suffered a serious back injury because of the rescue. As a result, he is prescribed Vicodin which he will most likely need to take for the rest of his life to manage the pain.