NTSB investigations: Cessna 152, CA
10 cases on aircraft the registry lists as Cessna 152, where the sequence of events included Hard landing. 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 | 3 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2018 | 1 |
| 2022 | 1 |
| 2026 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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')
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\" = '092' 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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')
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" = '092' 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 WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CANTSB WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.NTSB GAA18CA500Accident · No injuriesData collectionFinal reportCessna 152 · Sacramento, CAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA16CA209Accident · No injuriesData collectionFinal reportCessna 152 · Palo Alto, CAThe student pilot's decision to takeoff in wind conditions that exceeded his certificated flight instructor's maximum wind endorsement, and the student pilot's failure to maintain pitch control during the touchdown, resulting in abnormal runway contact, and…NTSB GAA16CA211Accident · No injuriesData collectionFinal reportCessna 152 · Hayward, CAThe student pilot's high descent rate during the landing flare, which resulted in a hard landing, nose landing gear collapse, and runway excursion during an aborted landing.NTSB WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.NTSB WPR13CA032Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's improper landing flare and recovery from a bounced landing.NTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB LAX08CA090Accident · No injuriesData collectionFinal reportCessna 152 · El Cajon, CAthe student pilot's inadequate compensation for gusty, crosswind conditions, and failure to maintain an adequate airspeed.NTSB LAX08LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CALoss of engine power during the takeoff initial climb due to lack of compression to a cylinder.