NTSB investigations: Cessna 182J, KS
10 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 2 |
| 1971 | 3 |
| 1975 | 1 |
| 1986 | 1 |
| 1999 | 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\" = 'KS' 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" = 'KS' 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 CHI99FA190Accident · 1 fatalField investigationFinal reportCessna 182J · Satanta, KSthe preflight planning/preparation and the missed approach not performed by the pilot. The obstruction clearance not maintained by the pilot was an additional cause. Contributing factors were the low ceiling and the fog.NTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…NTSB MKC76DCQ24Accident · Minor injuriesClosedCessna 182J · Garden City, KSNTSB MKC72AK028Accident · 3 fatalClosedCessna 182J · Longton, KSNTSB MKC72FCQ24Accident · No injuriesClosedCessna 182J · Arkansas Cty, KSNTSB MKC71DCG52Accident · Minor injuriesClosedCessna 182 · Olathe, KSNTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSNTSB MKC68F0450Accident · No injuriesClosedCessna 182J · Kansas City, KSNTSB MKC67F0448Accident · No injuriesClosedCessna 182 · Norton, KSNTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KS