NTSB investigations: Cessna 162
9 cases on aircraft the registry lists as Cessna 162, where the sequence of events included Aerodynamic stall/spin. 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 | 1 |
|---|---|
| 2009 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2018 | 1 |
| 2022 | 1 |
| 2025 | 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 ('060005E')
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\" = '241' 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 ('060005E')
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" = '241' 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 ERA25LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Miami, FLThe student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.NTSB WPR22LA145Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 162 · Palo Alto, CAThe pilot’s failure to maintain pitch control during a go-around maneuver, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB ERA15LA269Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Dunkirk, NYThe pilot's failure to maintain control of the airplane while attempting to close an open cabin door, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA15LA184Accident · Serious injuriesLimited investigationFinal reportCessna 162 · Shelter Island, NYThe pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.NTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.NTSB CEN14CA323Accident · No injuriesData collectionFinal reportCessna E162 · Wichita, KSThe student pilot's failure to maintain adequate airspeed during the landing approach which resulted in an inadvertent stall and impact with the runway.NTSB CEN09FA220Accident · No injuriesField investigationFinal reportCessna E162 · El Dorado, KSThe failure of the Ballistic Recovery System to disconnect due to twisted attachment straps.NTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.