NTSB investigations: Cessna 182A, CO
15 cases on aircraft the registry lists as Cessna 182A. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 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 ('2072704'))
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 ('2072704'))
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 CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.NTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.NTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.NTSB FTW96LA138Accident · No injuriesLimited investigationFinal reportCessna 182A · Walsenburg, COFailure of the pilot to maintain directional control of the airplane after the left main tire went flat during the landing roll. The flat tire was a related factor.NTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB DEN86LA078Accident · No injuriesLimited investigationFinal reportCessna 182 · Wray, COAccording to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the…NTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…NTSB DEN81FTE22Accident · No injuriesClosedCessna 182A · Colorado Spgs, CONTSB DEN80FTE13Accident · Minor injuriesClosedCessna 182 · Gunnison, CONTSB DEN76FTF02Accident · No injuriesClosedCessna 182A · Poncha Pass, CONTSB DEN75AD024Accident · 2 fatalClosedCessna 182A · Springfield, CONTSB DEN74FTE27Accident · No injuriesClosedCessna 182A · Breckenridge, CONTSB DEN68D0117Accident · Minor injuriesClosedCessna 182 · Colo.Springs, CONTSB DEN66A0030Accident · 4 fatalClosedCessna 182 · Sapinero, CONTSB UNK64X2404Accident · 1 fatalClosedCessna 182A · Woodland Pk, CO