Haunted (2002)

After having a near-death experience, ex-cop-turned-private-eye Frank Taylor learns that he has the ability to see and communicate with restless ghosts of murdered people who ask for his help in solving their deaths.