NTSB investigations: Cessna 152, 2023
7 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
| 1964 | 2 |
|---|---|
| 1969 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 18 |
| 1978 | 103 |
| 1979 | 126 |
| 1980 | 129 |
| 1981 | 151 |
| 1982 | 126 |
| 1983 | 124 |
| 1984 | 128 |
| 1985 | 120 |
| 1986 | 98 |
| 1987 | 126 |
| 1988 | 115 |
| 1989 | 107 |
| 1990 | 103 |
| 1991 | 88 |
| 1992 | 72 |
| 1993 | 82 |
| 1994 | 71 |
| 1995 | 71 |
| 1996 | 70 |
| 1997 | 61 |
| 1998 | 69 |
| 1999 | 56 |
| 2000 | 59 |
| 2001 | 49 |
| 2002 | 36 |
| 2003 | 28 |
| 2004 | 21 |
| 2005 | 33 |
| 2006 | 22 |
| 2007 | 23 |
| 2008 | 24 |
| 2009 | 25 |
| 2010 | 19 |
| 2011 | 10 |
| 2012 | 11 |
| 2013 | 19 |
| 2014 | 6 |
| 2015 | 11 |
| 2016 | 24 |
| 2017 | 14 |
| 2018 | 16 |
| 2019 | 16 |
| 2020 | 10 |
| 2021 | 7 |
| 2022 | 12 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 7 |
| 2026 | 6 |
Where
Open the mapLatest 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\") = 2023
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") = 2023
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 WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.NTSB ERA23LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manatí, PRThe flight instructor’s inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.NTSB ERA23LA316Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Maiden, NCThe flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.NTSB ERA23LA191Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Danbury, CTThe flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.NTSB CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.