NTSB investigations: Cessna 152
12 cases on aircraft the registry lists as Cessna 152, where the sequence of events included Miscellaneous/other. 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
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2024 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN25LA036Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.NTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…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 GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB GAA17CA051Accident · No injuriesData collectionFinal reportCessna 152 · Chickaloon, AKThe flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.NTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.NTSB CEN15CA095Accident · No injuriesData collectionFinal reportCessna 152 · Mount Pleasant, TXThe pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.NTSB WPR14LA257Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Agua Dulce, CAThe pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.NTSB WPR13FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Tucson, AZThe pilot's incapacitation due to his preexisting cardiac disease, which resulted in his degraded or complete loss of ability to control the airplane.NTSB CEN12LA314Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe student pilot's improper configuration of the airplane flaps during an aborted landing, which resulted in an inadequate climb rate and subsequent collision with trees.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.