Fatal NTSB investigations: Cessna 152, 2000
12 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 | 11 |
| 1979 | 10 |
| 1980 | 13 |
| 1981 | 15 |
| 1982 | 10 |
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 7 |
| 1986 | 10 |
| 1987 | 10 |
| 1988 | 11 |
| 1989 | 17 |
| 1990 | 11 |
| 1991 | 5 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 6 |
| 1995 | 8 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 7 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 3 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 3 |
| 2015 | 3 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2025 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB LAX01FA024Accident · 2 fatalField investigationFinal reportCessna 152 · Alpine, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB FTW00FA268Accident · 2 fatalField investigationFinal reportCessna 152 · Navasota, TXthe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributory factors were the clouds, dark night light conditions, the pilot's lack of total instrument flight time, and the pilot's self-induced pressure to complete the…NTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…NTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.NTSB DEN00FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Karval, COthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's inadvertent flight into the clouds, and his becoming spatially disorientated.NTSB LAX00FA209Accident · 2 fatalField investigationFinal reportCessna 152 · Palm Springs, CAThe failure of the pilot/flight instructor to maintain sufficient airspeed to prevent the aircraft stalling and spinning. Factors in the accident were terrain induced windshear and sudden wind shift and the pilot/flight instructor's lack of total experience.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB LAX00FA171Accident · 2 fatalField investigationFinal reportCessna 152 · Austin, NVThe pilot's decision to attempt flight in an area of high rising mountainous terrain at an inadequate altitude, which resulted in an impact during a turn to reverse direction. A contributing factor was the pilot's lack of total experience in mountain flying…NTSB DEN00FA067Accident · 1 fatalField investigationFinal reportCessna 152 · Roswell, NMThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin. A factor was the pilot's diverted attention to over flying her residence.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 FTW00FA063Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, ARthe pilot's failure to maintain aircraft control.