NTSB investigations: Cessna 182, IA

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

19642026

NTSB investigations: Cessna 182, IA per year, 1964–2026: 8 cases
1964	2
1965	1
1971	1
1974	2
1975	1
1982	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" = '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 ('2072702')) 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\" = '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 ('2072702'))
  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 ('2072702'))
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 MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…Jun 12, 1982 · N5392B · Substantial damage NTSB MKC76FCD04Accident · Minor injuriesClosedCessna 182 · Humeston, IAAug 10, 1975 · N6490A · Substantial damage NTSB MKC74AK030Accident · 1 fatalClosedCessna 182 · Beacon, IADec 12, 1974 · N5323B · Destroyed NTSB MKC74FCD42Accident · Serious injuriesClosedCessna 182 · Cedar Rapids, IAJun 20, 1974 · N5715B · Substantial damage NTSB MKC71DCD63Accident · No injuriesClosedCessna 182 · Waterloo, IAMar 6, 1971 · N5418B · Substantial damage NTSB MKC65D0088Accident · No injuriesClosedCessna 182 · Lansing, IAApr 11, 1965 · N5620B · Substantial damage NTSB UNK64X1959Accident · Serious injuriesClosedCessna 182 · Grinnell, IAMay 26, 1964 · N5562B · Destroyed NTSB UNK64X0683Accident · No injuriesClosedCessna 182 · Ft Madison, IAFeb 24, 1964 · N5562B · Substantial damage