NTSB investigations: Cessna 152, 2000, FL
8 cases on aircraft the registry lists as Cessna 152. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1977 | 4 |
|---|---|
| 1978 | 9 |
| 1979 | 9 |
| 1980 | 13 |
| 1981 | 9 |
| 1982 | 12 |
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 15 |
| 1988 | 8 |
| 1989 | 15 |
| 1990 | 10 |
| 1991 | 15 |
| 1992 | 6 |
| 1993 | 11 |
| 1994 | 17 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 8 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 8 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 1 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 2000
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 2000
AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.