NTSB investigations: Cessna 182P, WY

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

19732026

NTSB investigations: Cessna 182P, WY per year, 1973–2026: 6 cases
1973	1
1976	2
1977	1
1986	1
1988	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" = 'WY' 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 ('2075816')) 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\" = 'WY' 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 ('2075816'))
  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" = 'WY' 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 ('2075816'))
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 DEN88LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Casper, WYDrg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,…Aug 8, 1988 · N182AD · Substantial damage NTSB DEN86LA177Accident · No injuriesLimited investigationFinal reportCessna 182P · Sheridan, WYA loss of directional control occurred during landing roll and the acft departed the left side of the grass/dirt landing strip. The acft then traveled down a slight embankment and collided with a wire fence and fence posts.Jun 28, 1986 · N9099M · Substantial damage NTSB DEN78FA006Accident · 2 fatalClosedCessna 182P · Kemmerer, WYNov 7, 1977 · N7368S · Destroyed NTSB DEN76DTC46Accident · No injuriesClosedCessna 182 · Big Piney, WYSep 24, 1976 · N5789J · Substantial damage NTSB DEN76DTC40Accident · No injuriesClosedCessna 182 · Cheyenne, WYJun 27, 1976 · N9445M · Substantial damage NTSB DEN74AD028Accident · 3 fatalClosedCessna 182 · Cokeville, WYNov 29, 1973 · N9338G · Destroyed