NTSB investigations: Cessna 182Q
15 cases on aircraft the registry lists as Cessna 182Q, 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
| 2009 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732')
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 ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA23LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Richmond, VAThe pilot’s delay in performing a go-around after a likely encounter with low-level wind shear, resulting in a hard landing. Contributing to the accident were the pilot’s failure to recognize the severity of the actual and forecasted weather near the airport…NTSB CEN22LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Hebbronville, TXThe pilots improper landing flare which resulted in a hard landing and loss of airplane control.NTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.NTSB ERA21LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Flemingsburg, KYThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing.NTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.NTSB GAA19CA591Accident · Serious injuriesData collectionFinal reportCessna 182 · Elizabethtown, NCThe pilot's improper landing flare, which resulted in a hard landing and postaccident fire. Contributing to the accident was the pilot’s distraction during short final.NTSB GAA18CA396Accident · No injuriesData collectionFinal reportCessna 182 · San Luis Obispo, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.NTSB GAA17CA529Accident · Minor injuriesData collectionFinal reportCessna 182 · Fairfield, MTThe pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB CEN16LA231Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blaine, MNThe pilot's failure to maintain a proper airspeed during the landing approach, which resulted in an improper flare and hard landing.NTSB GAA15CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Palm Springs, CAThe pilot's improper landing flare which resulted in a hard landing and substantial damage to the firewall.NTSB ERA14CA023Accident · No injuriesData collectionFinal reportCessna 182Q · Wauchula, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.