NTSB investigations: Cessna 182A, IL
17 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 | 2 |
| 1967 | 2 |
| 1969 | 1 |
| 1973 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2014 | 2 |
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\" = 'IL' 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" = 'IL' 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 CEN14CA365Accident · Minor injuriesData collectionFinal reportCessna 182A · Geneseo, ILThe pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.NTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB CHI89DEV05Accident · No injuriesFinal reportCessna 182A · Sparta, ILPoor and improper maintenance which resulted in the carburetor venturi being blocked by the duct tape. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB CHI81FEE07Accident · Serious injuriesClosedCessna 182 · Grayslake, ILNTSB CHI79FEV30Accident · Minor injuriesClosedCessna 182A · Hillsboro, ILNTSB CHI78FEV03Accident · No injuriesClosedCessna 182A · Greenville, ILNTSB CHI77DEE24Accident · No injuriesClosedCessna 182 · Elgin, ILNTSB CHI74FEE29Accident · No injuriesClosedCessna 182A · Marseilles, ILNTSB CHI70D0374Accident · No injuriesClosedCessna 182 · Wheeling, ILNTSB CHI68F0368Accident · No injuriesClosedCessna 182 · Roodhouse, ILNTSB CHI67F0679Accident · No injuriesClosedCessna 182 · Columbia, ILNTSB CHI66F0531Accident · Serious injuriesClosedBeechcraft 23 · Wheeling, ILNTSB CHI66F0059Accident · No injuriesClosedCessna 182 · Carbondale, ILNTSB UNK64X4144Accident · No injuriesClosedCessna 182 · Chicago, IL