NTSB investigations: Cessna 182Q, CO
12 cases on aircraft the registry lists as Cessna 182Q. 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
| 1979 | 2 |
|---|---|
| 1980 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2019 | 1 |
| 2022 | 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\" = 'CO' 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 ('2072732'))
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" = 'CO' 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 ('2072732'))
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 CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.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 DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.NTSB DEN05LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Grand Junction, COthe pilot's failure to maintain aircraft control during aborted landing and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the encounter with wind shear during final approach and landing.NTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.NTSB DEN91LA084Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lafayette, COThe pic's abrupt touchdown. Factors were: approach reference speed not maintained, proper descent rate not maintained by the PIC and inattention by the designated examiner.NTSB DEN85LA145Accident · No injuriesLimited investigationFinal reportCessna 182 · Byers, COPlt stated that he was 'in a rush to get home' after his extended trip. He continued to state 'I wanted to get home thatafternoon without another stop and I wanted the performance figures to show me that I could.' The plt executed an emerg landing after the…NTSB DEN81DTE05Accident · 1 fatalClosedCessna 182Q · Grand Junction, CONTSB DEN80DTE15Accident · No injuriesClosedCessna 182 · Ft Collins, CONTSB DEN80FTE10Accident · No injuriesClosedCessna 182 · Longmont, CO