After giving a guest lecture on criminal psychology at a local university, Dr Helen Hudson (Weaver), a respected field expert on serial killers, is cornered in a lavatory by one of her previous subjects, Daryll Lee Cullum (Harry Connick, Jr.), who kills a police officer and brutally attacks her. Helen becomes severely agoraphobic as a result, sealing herself inside an expensive hi-tech apartment, conducting her entire life from behind a computer screen and assisted by a friend, Andy (John Rothman).
When a new series of murders spreads fear and panic across her home city of San Francisco, Inspector M.J. Monahan (Hunter) and her partner Reuben Goetz (Dermot Mulroney) solicit Helen's expertise. Initially reluctant, Helen soon finds herself drawn into the warped perpetrator's game of wits. A sideline to the serial killer's antics is the budding romance growing between M.J. and Reuben. One night as Reuben and M.J. are following up on leads, alone together, the stress of the case proves too much for them and they argue. In the midst of his frustration, Reuben declares his romantic feelings for M.J. as they have become considerably close in the last while. M.J. smiles back at him coyly and they share their first kiss.
As the murders continue, Helen realizes that the elusive assailant draws inspiration from notorious serial killers, including Albert DeSalvo, The Hillside Strangler, David Berkowitz, Jeffrey Dahmer, and Ted Bundy. When the murderer begins contacting and even stalking Helen, she and M.J. realize that he is after them, and they enlist the aid of Cullum, who tells them what he knows about the killer. M.J. and Reuben are now seeing each other, and are losing focus on the serial killer, which is noted by all especially Helen who finds it very unprofessional. Helen soon realizes that the Copycat Killer has been following the list of serial killers in the same order as she had presented them in her lecture at the university on the night of her attack, and the two work to figure out where and when he will strike next.l Again while Reuben and M.J stay late at the office, M.J. gets upset about their lack of progress and how their relationship is affecting the case. Reuben comforts her, by holding her, and they begin to kiss. Their passion succumbs and they spend the night together. Unfortunately, Reuben is later killed in an unrelated shooting incident at the police station, leaving only M.J. now heartbroken that she never got to tell Reuben she loved him to continue the search for the serial killer.
After Andy is killed in a manner reminiscent of Jeffrey Dahmer, M.J. deduces the killer to be Peter Foley (William McNamara). After leading a failed attempt to catch Foley at his house, M.J. discovers that he has kidnapped Helen and taken her back to the scene of Daryll Lee's attempt at killing herâthe restroom of the lecture hall. Once she gets there, M.J. finds Helen bound and gagged in the same manner that Cullum did before, but she is ambushed and shot by Foley, rendering her unconscious. As Foley prepares to kill M.J., Helen desperately attempts to save her by ruining Foley's carefully replicated crime scene the only way she canâby attempting to hang herself. Foley panics and cuts Helen down, and Helen is able to get away and escape to the building's roof. Her agoraphobia kicks in again, and Helen finds herself cornered. Accepting her fate, she turns to face Foley. However, just as he is about to kill her, M.J. shoots him in the brachial nerve, giving him one last chance to surrender. When he pulls his gun back on her, however, she shoots him dead.
Some time later, Daryll Lee writes a letter to another serial killer, instructing him on how to kill Helen, revealing that he had been aiding Foley all along.

Question: How is Reuben killed?
Answer: a shooting at the police station
Alternative answer: He is shot at the police station.