This is a detective story about a serial killer who likes to tell police about each of his crimes immediately afterwards and plays a tape of the song `Little Red Riding Hood' over the phone to taunt them. But Detective Sergeant Tom Hardy (Bruce Willis), who is one member of a police family in the Pittsburgh Police Department, is now on the case. Tom Hardy is out of favour with his colleagues because he reported his partner and cousin, Sergeant Jimmy Detillo (Robert Pastorelli), for using excessive force. However, Tom's father, Captain Vince Hardy (John Mahoney) is on his side and believes he did the right thing.
Almost from the beginning they have the killer cornered with his latest victim and a long and exciting car chase involving Tom and Vince Hardy follows. But there are several accidents along the way and in the last of these, the killer shoots Vince Hardy and gets away. All the evidence suggests the killer is a cop but Tommy's uncle, Captain Nick Detillo (Dennis Farina) railroads some unlikely suspect into custody as the killer. In a separate incident, Jimmy Detillo throws himself into the Ohio River, presumably as an act of desperation.
The story now moves on two years and Tommy is now a member of the river police with a new partner, Jo Christman, alias Emily Harper (Sarah Jessica Parker). But the bodies keep coming and `Little Red Riding Hood' keeps in touch with Tommy, even dumping his victims in the river for him to find. The dead women were all people Tommy knew earlier in his life. There is plenty of action in this movie and enough twists in the yarn to keep up the interest till the end.