NTSB investigations: Cessna 152, 2004
21 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\") = 2004
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") = 2004
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 DEN05LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Lyons, COthe pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.NTSB ATL05CA021Accident · No injuriesData collectionFinal reportCessna 152 · Rocky Mount, NCThe pilot's improper landing flare, and improper recovery from a bounced landing.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.NTSB LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.NTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.NTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.NTSB SEA04CA194Accident · No injuriesData collectionFinal reportCessna 152 · Friday Harbor, WAThe pilot's delay in executing an aborted landing and his failure to obtain altitude/clearance from trees during the aborted landing. A factor was the pilot's failure to obtain the proper touchdown point as a result of his high airspeed on approach.NTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB FTW04LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Abita Springs, LAThe pilot's failure to maintain obstacle clearance. The pilot's inadequate evaluation of the weather and dark night conditions are contributing factors.NTSB MIA04CA116Accident · No injuriesData collectionFinal reportCessna 152 · Sarasota, FLThe student pilot's incorrect recovery following a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB IAD04CA014Accident · Minor injuriesData collectionFinal reportCessna 152 · Hamilton, OHThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.