NTSB investigations: Cessna 182K, IL

5 cases on aircraft the registry lists as Cessna 182K. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

NTSB investigations: Cessna 182K, IL per year, 1971–2026: 5 cases
1971	1
1977	1
1994	1
1995	1
2001	1

Where

Open the map

Latest cases

Query with SQL

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 ('2072724')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072724'))
  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 ('2072724'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.Jul 5, 2001 · N2501Q · Substantial damage NTSB CHI96LA051Accident · No injuriesLimited investigationFinal reportCessna 182 · Tamms, ILfuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.Dec 14, 1995 · N2465Q · Substantial damage NTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.Jul 26, 1994 · N2564R · Substantial damage NTSB CHI78DEE12Accident · No injuriesClosedCessna 182 · Rock Falls, ILNov 24, 1977 · N2447Q · Substantial damage NTSB CHI72AC009Accident · 2 fatalClosedCessna 182K · Springfield, ILJul 23, 1971 · N7600K · Destroyed