NTSB investigations: Cessna 182A, IA
9 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 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1971 | 1 |
| 1986 | 2 |
| 1993 | 1 |
| 2003 | 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\" = 'IA' 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" = 'IA' 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 CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.NTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.NTSB MKC86LA145Accident · No injuriesLimited investigationFinal reportCessna 182A · Davis City, IAStatements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…NTSB MKC86FA048Accident · 1 fatalField investigationFinal reportCessna 182A · Clinton, IAThe pilot normally made several touch and go landings before departing the local area. He was known to not fly near clouds or at night. For this flight, the ceiling was at least 1000 feet at takeoff and was at least 700 feet in the accident area. Airplane was…NTSB MKC71DCD48Accident · No injuriesClosedCessna 182A · Fairfield, IANTSB MKC67D0601Accident · No injuriesClosedCessna 182A · Ottumwa, IANTSB MKC67F0146Accident · Minor injuriesClosedCessna 182A · Mason City, IANTSB UNK64X3917Accident · No injuriesClosedCessna 182 · Lemars, IANTSB UNK64X0863Accident · No injuriesClosedCessna 182A · Martinsdale, IA