NTSB investigations: Cessna 152, 2019
16 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
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\") = 2019
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") = 2019
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 GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.NTSB GAA19CA581Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, which resulted in a hard landing and a collapsed nose landing gear.NTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ERA19TA235Accident · No injuriesClass 3Final reportCessna 152 · Wakefield, VAThe pilot's inadequate preflight inspection, which failed to detect and remove all water from fuel, and maintenance personnel’s unapproved repair of the right wing fuel cap, which resulted in fuel contamination and a subsequent partial loss of engine power…NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB GAA19CA389Accident · No injuriesData collectionFinal reportCessna 152 · Paris, TXThe student pilot's failure to maintain the runway heading during takeoff with a crosswind, which resulted in impact with a hay bale left of the runway, and his improper decision to perform a soft-field takeoff without adequate practice.NTSB GAA19CA390Accident · No injuriesData collectionFinal reportCessna 152 · Tracy, CAThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a vehicle.NTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.NTSB GAA19CA346Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, TXThe passing pilot’s failure to maintain clearance from the airplane that he was attempting to pass during taxi operations. Contributing to the accident was the passing pilot's distraction due to looking at his on-board navigation device while attempting to…NTSB GAA19CA213Accident · Minor injuriesData collectionFinal reportCessna 152 · Bangor, METhe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA19CA148Accident · Minor injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.NTSB GAA19CA169Accident · No injuriesData collectionFinal reportCessna 152 · Madras, ORThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a collision with a snow berm and a subsequent nose-over.NTSB WPR19FA095Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28 · Compton, CAThe failure of the T-28 pilot to see and avoid the Cessna while landing with reduced visibility due to sun glare, which resulted in a collision on the runway. Contributing to the accident was his failure to use the airport's common traffic advisory frequency…