NTSB investigations: Cessna 182C, MI

10 cases on aircraft the registry lists as Cessna 182C. 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 182C, MI per year, 1964–2026: 10 cases
1964	2
1965	1
1969	1
1972	1
1975	1
1977	1
1978	1
1987	1
2013	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" = 'MI' 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 ('2072708')) 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\" = 'MI' 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 ('2072708'))
  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" = 'MI' 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 ('2072708'))
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 CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.May 18, 2013 · N9075T · Substantial damage NTSB CHI87LA170Accident · No injuriesLimited investigationFinal reportCessna 182C · Clio, MIThe plt stated he departed with 55 gals of fuel. After 3.5 hrs of level flt at 7500 ft MSL he declared fuel exhaustion to the FAA flint twr. He was 3-4 miles frm a suitable arpt but was too low on final to reach the rwy. He landed on a road and struck a pole…Jul 17, 1987 · N8576T · Substantial damage NTSB CHI78FEM41Accident · No injuriesClosedCessna 182 · Charlotte, MISep 7, 1978 · N8659T · Substantial damage NTSB CHI77FA053Accident · 5 fatalClosedCessna 182C · Grattan, MIJun 25, 1977 · N8723T · Destroyed NTSB CHI76DEM04Accident · No injuriesClosedCessna 182 · Charlotte, MIAug 3, 1975 · N8659T · Substantial damage NTSB CHI72FEC44Accident · Minor injuriesClosedCessna 182C · Saline, MIJun 4, 1972 · N8477T · Substantial damage NTSB CHI70A0037Accident · 3 fatalClosedCessna 182C · Saginaw, MINov 24, 1969 · N8471T · Destroyed NTSB CHI65D0166Accident · No injuriesClosedCessna 182 · Pnt.Aux Pins, MIMay 8, 1965 · N8790T · Substantial damage NTSB UNK64X2279Accident · No injuriesClosedCessna 182 · Big Rapids, MIJun 14, 1964 · N8531T · Substantial damage NTSB UNK64X0472Accident · No injuriesClosedCessna 182 · Grayling Afb, MIFeb 5, 1964 · N314NF · Substantial damage