A desperate search by police for a missing detective ended in tragedy Thursday when his body was found at Plumb Beach in Brooklyn, multiple law enforcement sources said.

Det. Joseph Calabrese, 57, had been last seen between midnight and two a.m. at Maimonides Medical Center, according to sources.

After his car was found abandoned at Plumb Beach near the Belt Parkway about 3 a.m., dozens of officers scoured the Sheepshead Bay area with K-9 dogs, boats and helicopters in the search. As many as 100 police vehicles rushed to the scene, tangling traffic on the parkway.

The search continued into the afternoon when Calabrese was found.

“I am shocked and shattered beyond belief. Joseph Calabrese was a dedicated detective, union official, husband and father. He was the salt of the earth," said Michael Palladino, president of the Detectives Endowment Association.

His wife had just had a minor surgical procedure and was expected to leave the hospital Thursday morning, the sources said. He visited her Wednesday night, just before his disappearance.

Calabrese was assigned to the Brooklyn South Homicide Squad and is a longtime board member for the Detectives Endowment Association.

He joined the NYPD in 1982 and rose to detective first grade, a much-coveted title. He lives in Marine Park close to the area where his car was discovered. Read more at NY Daily News