Cold Cases Database

This database consists of unsolved homicides collected from family submissions, law enforcement submissions, and public records. This database is not part of our advocacy and awareness platform but a separate database for information purposes only. 

Please note: This database is not updated regularly due to cost and manpower. A bug occurred during a recent update and reset many of the dates to January 1, 1970.

Search

Show More Options

25202 cases found.
CCR: 1988-083378
Date Reported: April 24, 1988
VICTIM DETAILS
Name Ricky Jones
Gender Unknown
Race Unknown
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 4725 S Rio Grande Ave #50
Orlando, Florida, 32839
Orange County
L.E.A Orange County Sheriff's Office, Orlando, Florida

Anyone with information regarding this case is encouraged to contact the Orange County Sheriff's Office at 407-254-7280.
CCR: Unknown
Date Reported: March 20, 1994
VICTIM DETAILS
Name Amy Gellert
Age 21
Gender Female
Race Caucasian/White
DOB 02/22/1973
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Knife/Stabbing
Location At Large
CASE DETAILS
Status Unsolved
Incident Location S. Orlando Avenue
Cocoa Beach, Florida, 32931
Brevard County
L.E.A Brevard County Sheriff's Office - Titusville, Florida

On the evening of Sunday, March 20, 1994, Charlotte "Amy" Gellert was attacked by an intruder outside her residence in Cocoa Beach. She died as a result of her injuries. The intruder was described as a white male, early twenties, 5'07" – 5'10" tall, weighing between 165 to 185 pounds used a distinct knife. If you have information about this case call the Brevard County Sheriff's Office at (321) 633-8413 or contact CRIMELINE at 1-(800)-423-TIPS. If you call CrimeLine with tips about a case, you can remain anonymous and may be eligible for a reward of up to $5,000 for information leading to a Murder arrest.
CCR: 1980-060185
Date Reported: June 20, 1980
VICTIM DETAILS
Name Margaret Applegate
Age 29
Gender Female
Race Caucasian/White
DOB 07/23/1950
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 5207 12th Ave Dr W.
Bradenton, Florida, 34209
Manatee County
L.E.A Manatee County Sheriff's Office, Bradenton, Florida

Anyone with information regarding this case is encouraged to contact the Manatee County Sheriff's Office at (941) 747-3011.
CCR: Unknown
Date Reported: April 30, 2016
VICTIM DETAILS
Name Ernesto Lora Jr.
Age 29
Gender Male
Race Hispanic/Latino
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 411 Wayne Ave
Oakland, California, 94606
Alameda County
L.E.A Oakland Police Department, Oakland, California

CCR: 95-09546
Date Reported: April 21, 1995
VICTIM DETAILS
Name Michael Constanzo
Age 18
Gender Male
Race Caucasian/White
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Gun/Firearm
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location Memorial Caueway Blvd.
East of Island Way
Clearwater, Florida, 33767
Pinellas County
L.E.A Clearwater Police Department, Clearwater, Florida

White male, 18 years of age Case#: 95-09546 Date Found: April 21, 1995 Location: Memorial Causeway Blvd, East Of Island Way, Clearwater, FL (road to Clearwater Beach) Suspect Vehicle: Late model full size gray Cadillac, possibly a 4-door, in good condition with wire rims, dark tinted windows, and Cadillac emblem above the license plate. The license plate number is unknown. Michael Constanzo was shot and killed as he drove his car across Memorial Causeway. At the time of the shooting, the above described Cadillac was seen traveling next to Constanzo's vehicle. Anyone with information regarding this case is encouraged to contact the Clearwater Police Department at (727) 562-4383.
CCR: 0492487B
Date Reported: September 12, 2003
VICTIM DETAILS
Name John Bellamy
Age 48
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Other
Location Murder
CASE DETAILS
Status Unsolved
Incident Location 1241 NW 173RD TER
Miami-Dade County
L.E.A Miami-Dade Sheriff's Office, Miami, Florida

CCR: 425714
Date Reported: June 21, 1996
VICTIM DETAILS
Name Lawanna Brinson
Gender Female
Race African American/Black
DOB 02/06/1977
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Gun/Firearm
Location At Large
CASE DETAILS
Status Unsolved
Incident Location 2000 Grunthal St
Jacksonville, Florida, 32209
Duval County
L.E.A Jacksonville Sheriff's Office, Jacksonville, Florida

No narrative given by law enforcement. Anyone who has any information about this case, the identity, or location of the suspect(s) is asked to contact the Jacksonville Sheriff`s Office at 904-630-0500 or email them at JSOCrimeTips@jaxsheriff.org. To remain anonymous and receive a possible reward up to $3,000, contact Crime Stoppers at 1-866-845-TIPS.
CCR: Unknown
Date Reported: February 12, 1999
VICTIM DETAILS
Name Pilar Rodriguez
Age 4
Gender Female
Race Hispanic/Latino
DOB 04/05/1995
SUSPECT DETAILS
Name Keith Wilson
Offense Murder
Cause Undisclosed
Location Under Arrest
CASE DETAILS
Status Solved
Incident Location Trail Apartments
Punta Gorda, Florida, 33955
Charlotte County
L.E.A Charlotte County Sheriff's Office - Punta Gorda, Florida

Update: October 2017 - Keith Wilson was sentenced to life in prison following being convicted of second-degree murder of 4-year old Pilar Rodriquez. Rodriquez went with her babysitter Melissa Harding-Jones to spend two weeks at her boyfriend's place. They never returned. Harding-Jones told police that her boyfriend, Wilson, had beaten Pilar to death and got rid of the body. The body has still not been found. If you have information that can help solve this crime: please call the Charlotte County Sheriff's Office Cold Case Unit at (941)575-5361 or after hours call (941)639-2101, or email them at coldcase@ccso.org
CCR: Unknown
Date Reported: March 29, 2015
VICTIM DETAILS
Name Alfred Lyons
Age 19
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 1589 Pleasure St
New Orleans, Louisiana, 70122
Orleans Parish
L.E.A New Orleans Police Department, New Orleans, Louisiana

CCR: 1993-235211
Date Reported: August 9, 1993
VICTIM DETAILS
Name Helen Williams
Gender Unknown
Race Unknown
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 2034 Maguire Blvd
Orlando, Florida, 32803
Orange County
L.E.A Orange County Sheriff's Office, Orlando, Florida

Anyone with information regarding this case is encouraged to contact the Orange County Sheriff's Office at 407-254-7280.