NTSB investigations: Cessna 152
22 cases on aircraft the registry lists as Cessna 152, where NTSB found Incorrect action performance. 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
| 2008 | 5 |
|---|---|
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2018 | 1 |
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 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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '02041015')))
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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '02041015')))
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 CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.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 WPR16LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's improper landing approach, which resulted in a hard landing and the subsequent overstress failure of the nose landing gear.NTSB WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.NTSB WPR13CA130Accident · No injuriesData collectionFinal reportCessna 152 · Kelso, WAThe student pilot's inadequate landing flare and lack of remedial actions, which resulted in a hard bounced landing.NTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB WPR11CA262Accident · No injuriesData collectionFinal reportCessna 152 · Idaho Falls, IDThe pilot's inadequate landing flare and improper bounced landing recovery.NTSB CEN11CA344Accident · No injuriesData collectionFinal reportCessna 152 · Carbondale, ILThe student pilot's relinquishing of the flight controls during the landing flare and the flight instructor's delay in taking remedial action.NTSB CEN11CA278Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA380Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot’s improper recovery from a bounced landing.NTSB ERA10CA369Accident · No injuriesData collectionFinal reportCessna 152 · Indian Head, MDThe pilot's loss of control while landing in gusting crosswind conditions.NTSB CEN10CA346Accident · No injuriesData collectionFinal reportCessna 152 · St. Charles, MOThe pilot's improper takeoff procedure that led to a decreased climb rate and subsequent off-airport landing.NTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.NTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB DEN08CA126Accident · No injuriesData collectionFinal reportCessna 152 · Mc Alester, OKThe student pilot's improper flare and improper recovery from a bounced landing.NTSB MIA08CA113Accident · No injuriesData collectionFinal reportCessna 152 · Okeechobee, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.