NTSB investigations: Cessna 182C, WA

12 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, WA per year, 1964–2026: 12 cases
1964	1
1965	1
1966	1
1970	1
1975	2
1980	1
1991	1
1997	1
2003	1
2007	1
2019	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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR20LA028Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Metaline, WAImpact with a lake for reasons that could not be determined.Nov 11, 2019 · N8749T · Destroyed NTSB SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.Dec 8, 2007 · N9048T · Substantial damage NTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.Jul 23, 2003 · N8492T · Substantial damage NTSB SEA97FA201Accident · 5 fatalField investigationFinal reportCessna 182C · Bremerton, WAThe pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.Sep 1, 1997 · N9015T · Destroyed NTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.Nov 19, 1991 · N9033T · Substantial damage NTSB SEA80FYM57Accident · No injuriesClosedCessna 182C · Orchards, WAAug 24, 1980 · N8800T · Substantial damage NTSB SEA75DYE44Accident · No injuriesClosedCessna 182C · Vashon, WAMay 23, 1975 · N9900T · Substantial damage NTSB SEA75DYE36Accident · No injuriesClosedCessna 182C · Vashon, WAMar 9, 1975 · N9900T · Substantial damage NTSB SEA71FWG14Accident · Serious injuriesClosedCessna 182C · E.Wenatchee, WAAug 30, 1970 · N8775T · Destroyed NTSB SEA67D0206Accident · No injuriesClosedCessna 182 · Georgetown, WAJul 22, 1966 · N182Y · Substantial damage NTSB SEA65A0064Accident · 1 fatalClosedCessna 182C · Forks, WAMay 26, 1965 · N8536T · Destroyed NTSB UNK64X0504Accident · 3 fatalClosedCessna 182 · Prosser, WAFeb 9, 1964 · N8660T · Destroyed