In the movie, the character of Malcolm Crowe, a child psychologist, is treating a young boy named Cole who claims to see dead people. Throughout the film, Crowe is haunted by the ghost of a former patient, Vincent Gray.
The climax of the film reveals that Crowe's patient, Vincent, was actually killed by Crowe himself when he was a child. Vincent's remains were hidden under the fireplace in Crowe's house.
Let me know if you have any other film mysteries you'd like solved!