NTSB investigations: Cessna 182B, WI

10 cases on aircraft the registry lists as Cessna 182B. 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 182B, WI per year, 1965–2026: 10 cases
1965	1
1967	2
1969	1
1971	1
1977	1
1979	1
1981	1
1988	1
1992	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 ('2072706')) 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 ('2072706'))
  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 ('2072706'))
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 CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.Sep 21, 1992 · N90BF · Destroyed NTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…Jul 22, 1988 · N2486G · Substantial damage NTSB CHI81DEP11Accident · No injuriesClosedCessna 182 · Portage, WIMar 10, 1981 · N8415T · Substantial damage NTSB CHI79FER03Accident · Minor injuriesClosedCessna 182B · Osceola, WIJun 30, 1979 · N7228E · Substantial damage NTSB CHI77DEP44Accident · No injuriesClosedCessna 182 · Burlington, WIJul 16, 1977 · N2683G · Substantial damage NTSB CHI71FDJ44Accident · Minor injuriesClosedCessna 182B · Kenosha, WIMar 16, 1971 · N2291G · Substantial damage NTSB CHI70A0026Accident · 2 fatalClosedCessna 182B · Watertown, WINov 5, 1969 · N2795G · Destroyed NTSB CHI68F0270Accident · No injuriesClosedCessna 182 · Osceola, WIJun 17, 1967 · N7228E · Substantial damage NTSB CHI67D0498Accident · No injuriesClosedCessna 182 · Shawano, WIFeb 14, 1967 · N2786G · Substantial damage NTSB CHI66A0022Accident · 2 fatalClosedCessna 182 · Burlington, WIAug 25, 1965 · N2402G · Destroyed