NTSB investigations: Cessna 182J, IL
18 cases on aircraft the registry lists as Cessna 182J. 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
| 1966 | 3 |
|---|---|
| 1967 | 3 |
| 1969 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1975 | 3 |
| 1977 | 2 |
| 1979 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 2002 | 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\" = '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 ('2072722'))
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 ('2072722'))
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 CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB CHI87LA181Accident · No injuriesLimited investigationFinal reportCessna 182J · Lansing, ILWhile landing on runway 27, the pilot overshot the runway and rolled into a shallow ditch.NTSB CHI83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Wheaton, ILWhile in cruise flight at 2500' AGL the carburetor ice warning light came on. The pilot applied carburetor heat and the light went out. After the light went out the pilot returned the heat to 'off.' The pilot repeated the above sequence and when the light…NTSB CHI80DEE03Accident · No injuriesClosedCessna 182J · Wheeling, ILNTSB CHI77FCA06Accident · No injuriesClosedCessna 182 · Granite City, ILNTSB CHI77FEV36Accident · Minor injuriesClosedCessna 182 · Urbana, ILNTSB CHI76FC030Accident · 1 fatalClosedCessna 182J · Cissna Park, ILNTSB CHI76FEE08Accident · Serious injuriesClosedCessna 182J · Kankakee, ILNTSB CHI75FEV38Accident · No injuriesClosedCessna 182 · Peoria, ILNTSB CHI74AC012Accident · 1 fatalClosedCessna 182J · Chicago, ILNTSB CHI71DCA04Accident · No injuriesClosedCessna 182 · East Alton, ILNTSB CHI70D0385Accident · No injuriesClosedCessna 182 · Galesburg, ILNTSB CHI68D0363Accident · No injuriesClosedCessna 182 · Valmeyer, ILNTSB CHI68D0225Accident · No injuriesClosedCessna 182 · Chicago, ILNTSB CHI68D0059Accident · No injuriesClosedCessna 182 · Chicago, ILNTSB CHI67D0371Accident · No injuriesClosedCessna 182 · Macomb, ILNTSB CHI67F0040Accident · No injuriesClosedCessna 182 · West Chicago, ILNTSB CHI67D0324Accident · No injuriesClosedCessna 182 · Chicago, IL