NTSB investigations: Cessna 182F, CO
11 cases on aircraft the registry lists as Cessna 182F. 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
| 1967 | 3 |
|---|---|
| 1971 | 2 |
| 1977 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 2004 | 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 ('2072714'))
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 ('2072714'))
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 DEN04FA057Accident · 1 fatalField investigationFinal reportCessna 182F · Burlington, COloss of aircraft control due to structural icing. Factors contributing to the accident were the pilot's inadvertent flight into adverse weather conditions, the icing conditions, and ice fog.NTSB FTW94LA308Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Monte Vista, COThe pilot's failure to maintain directional. Factors were the cross wind conditions, and the pilot's poor evaluation of the weather.NTSB DEN87LA248Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Colorado City, COThe plt made several circling approaches before landing. When he did land his acft, he said that he landed fast and long. He applied the brakes but went off the end of the rwy, hit an embankment, and nosed over.NTSB DEN83LA208Accident · No injuriesLimited investigationFinal reportCessna 182F · Fort Morgan, COThe acft went off the rwy and nosed over during landing. The plt landed on rwy 14 with the wind reported as being from 250 degrees at 5 KTS with gusts to 7 KTS. The plt reported a gust of wind picked up the right wing. He lost directional control, the acft…NTSB DEN83LA030Accident · No injuriesLimited investigationFinal reportCessna 182F · Olathe, COAircraft ran off end of runway during takeoff during abort. Pilot heard stall warning and aborted takeoff. He also said he forgot 10 degrees of flaps.NTSB DEN77FTE36Accident · Serious injuriesClosedCessna 182F · Walden, CONTSB DEN72FTE41Accident · No injuriesClosedCessna 182F · Aurora, CONTSB DEN72FTE03Accident · Serious injuriesClosedCessna 182F · Lake City, CONTSB DEN68D0137Accident · No injuriesClosedCessna 182 · Gunnison, CONTSB DEN68D0142Accident · Minor injuriesClosedCessna 182F · Mesa, CONTSB DEN67F0293Accident · Serious injuriesClosedCessna 182F · Arapahoe, CO