NTSB investigations: Cessna 152, 2003
28 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\") = 2003
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") = 2003
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 ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB NYC04LA045Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot's improper use of carburetor heat, which resulted in a total loss of engine power during cruise flight. A factor was carburetor icing conditions.NTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.NTSB MIA04CA025Accident · No injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLThe student pilot improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.NTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB MIA04CA010Accident · Minor injuriesData collectionFinal reportCessna 152 · Pierson, FLIn flight collision with a bird, resulting in airplane not being able to maintain altitude and nosing over during a forced landing on unsuitable terrain.NTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.NTSB MIA03LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLA loss of engine power due to inadequate maintenance.NTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB CHI03LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe student pilot's inadequate recovery from the bounced landing. Factors contributing to the accident were the variable crosswind, the misjudged flare that resulted in the bounced landing and the subsequent collapse of the nose landing gear.NTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.NTSB CHI03LA233Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Brooklyn, MIThe pilot's failure to attain the proper touchdown point, and his failure to maintain control of the airplane.NTSB NYC03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe student pilot's failure to maintain directional control during an aborted landing.NTSB LAX03LA214Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt. Charleston, NVthe pilot's inadequate in-flight planning and selection of the wrong route of flight, which led the airplane toward rising terrain in excess of the performance capability of the airplane. Also causal was the pilot's delayed decision to divert her route of…NTSB CHI03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensville, MOThe pilots delayed attempt to perform an aborted takeoff and subsequent overrun. Contributing factors to the accident were the fence and the ditch.NTSB LAX03LA148Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pala, CAthe dual student's delay in executing the proper recovery procedures and improper retraction of the flaps, the CFI's inadequate supervision during the recovery to normal flight, the CFI's delayed remedial action, and the failure of both pilots to maintain an…NTSB CHI03LA109Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Red Owl, SDThe pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.NTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.NTSB SEA03LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Butte, MTThe pilot's inadequate compensation for gusty variable wind conditions and his improper flare. Factors include gusty and variable winds .NTSB FTW03LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB ATL03LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe pilot's improper flare and recovery from a bounced landing.NTSB ATL03LA050Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood, SCThe pilot's continued visual flight into instrument meteorological conditions and loss of aircraft control, which resulted in an in-flight collision with the ground.NTSB NYC03LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's misjudgment of distance/altitude and the instructor's delayed remedial action,NTSB FTW03LA095Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lockhart, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.NTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.NTSB LAX03LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Salinas, CAThe student pilot's inadequate compensation and his failure to maintain directional control. Contributing factors were wet and dirt terrain.NTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.