NTSB investigations: Cessna 152, 2005
33 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\") = 2005
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") = 2005
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 CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB LAX05CA238Accident · No injuriesData collectionFinal reportCessna 152 · Rio Vista, CAthe student pilot's inadequate recovery from a bounced landing and his failure to maintain directional control of the airplane during landing rollout. A contributing factor was the student's failure to divert to an airport with less severe crosswind…NTSB IAD05LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot's failure to maintain airspeed, and the flight instructor's inadequate remedial action, which resulted in an inadvertant stall and uncontrolled descent into terrain.NTSB MIA05CA128Accident · No injuriesData collectionFinal reportCessna 152 · St. Augustine, FLThe failure of the student pilot to maintain directional control during the landing roll resulting in the on-ground encounter with wet grass and subsequent nose over.NTSB MIA05CA125Accident · No injuriesData collectionFinal reportCessna 152 · Williston, FLThe inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.NTSB NYC05CA112Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, PAThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a nose gear collapse while landing.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.NTSB ATL05LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, NCThe loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.NTSB DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.NTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB CHI05LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.