Eyes of Terror (1994)

Dr. Jesse Newman is assigned to treating David, a grieving policeman who lost his partner in a shootout. It seems the case is solved, until a lucky coin belonging to David's partner triggers a revealing series of psychic visions for Dr. Newman. The visions not only implicate the killer, but also reveal the sordid habits of San Francisco's business and political elite.