NTSB investigations: Cessna 182, WI

12 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

19652026

NTSB investigations: Cessna 182, WI per year, 1965–2026: 12 cases
1965	1
1966	1
1969	1
1970	1
1974	1
1977	1
1979	1
1991	1
1992	1
1993	1
1995	1
1997	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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Jul 20, 1997 · N5820B · Substantial damage NTSB CHI95LA309Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Walworth, WIloss of engine power which occurred for an undetermined reason. A factor was the soft terrain in the emergency landing site.Sep 3, 1995 · N5465B · Substantial damage NTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.Oct 24, 1993 · N5390B · Destroyed NTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.Apr 1, 1992 · N1230D · Destroyed NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.Feb 3, 1991 · N4676R · 2 aircraft · Destroyed NTSB CHI79FEP60Accident · Minor injuriesClosedCessna 182 · Bristol, WIJul 21, 1979 · N5325B · Substantial damage NTSB CHI77DEP17Accident · No injuriesClosedCessna 182F · Milwaukee, WIFeb 15, 1977 · N3578Y · Substantial damage NTSB CHI75DEP18Accident · Minor injuriesClosedCessna 182P · Delavan, WIAug 21, 1974 · N52715 · Destroyed NTSB CHI70FDJ12Accident · No injuriesClosedCessna 182 · Stevens Point, WIMar 27, 1970 · N6498A · Substantial damage NTSB CHI69F0513Accident · No injuriesClosedCessna 182 · New Holstein, WIFeb 25, 1969 · N5505B · Substantial damage NTSB CHI66D0682Accident · No injuriesClosedCessna 182 · Watertown, WIMar 17, 1966 · N5532B · Substantial damage NTSB CHI66D0153Accident · No injuriesClosedCessna 182 · Franklin, WIJun 9, 1965 · N5568B · Substantial damage