In the lively atmosphere of Miami, the quirky private detective Ace Ventura, portrayed by Jim Carrey, has carved out an identity as an unexpectedly heroic figure dedicated to rescuing animals in perilous situations. While his eccentric tactics often earn him disdain from the Miami Police Department, particularly from Lieutenant Lois Einhorn, Ace is thrust into the spotlight when Melissa Robinson, the Miami Dolphins' publicist, reaches out with a plea for help. The Dolphins are in dire need of assistance to locate their captive mascot, Snowflake, a Bottlenose dolphin, especially with the Super Bowl fast approaching.
As Ace dives headfirst into the enigma surrounding Snowflake's disappearance, he follows a series of elusive clues that lead him to suspect Ronald Camp, an affluent collector of exotic creatures. Nevertheless, after infiltrating one of Camp's extravagant gatherings and coming face-to-face with a fearsome shark, he dismisses the billionaire as a potential suspect. Instead, Ace's attention shifts to a rare amber stone discovered within Snowflake's enclosure. This leads him to formulate a theory connecting the stone to a 1984 AFC Championship ring, suggesting that someone from the Dolphins' roster during that time had a hand in the kidnapping.
Meanwhile, the mysterious death of Roger Podacter, the Dolphins' head of operations, compels Ace to dig into the circumstances surrounding his murder. His investigation reveals a complex web of treachery and potential motives, ultimately guiding him to Ray Finkle, a former Dolphins placekicker whose mental stability deteriorated after the team's failure in the 1984 Super Bowl. Finkle, it turns out, harbors a grudge against Dan Marino, the quarterback blamed for a botched game-winning kick.
The stakes escalate as Ace finds himself engaged in a suspenseful game of wits with Finkle, who has disguised himself within the police department and is holding both Marino and Snowflake captive. In a dramatic twist, Ace unveils Finkle’s shocking identity as Einhorn, leading to a thrilling confrontation that ends with the felon's arrest.
The film reaches its exhilarating peak during the Super Bowl halftime show, where both Marino and Snowflake are honored, and Ace is celebrated on the jumbotron as a hero. This exhilarating scene concludes with a humorous tussle between Ace and the Philadelphia Eagles' mascot over a rare pigeon, culminating in a standing ovation from the enthusiastic crowd.