Skip to content

Fatal NTSB investigations: Cessna 182M

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

19692026

Where

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072728')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072728'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072728'))
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 CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.Mar 24, 2011 · N70922 · Substantial damage NTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.Jun 3, 2009 · N70946 · Substantial damage NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…Feb 28, 2009 · N91593 · Substantial damage NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.Nov 11, 2008 · N71276 · Substantial damage NTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.May 15, 2005 · N333LP · Destroyed NTSB FTW03WA043Accident · 2 fatalForeign investigationCessna 182M · Gonzaga, MexicoNov 15, 2002 · N70685 · Destroyed NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.Feb 16, 2000 · N91994 · 2 aircraft · Destroyed NTSB MIA96WA056Accident · 3 fatalForeign investigationCessna 182M · Trujillo, HondurasJan 3, 1996 · N91682 · Substantial damage NTSB LAX94FA006Accident · 2 fatalField investigationFinal reportCessna 182M · Seligman, AZthe separation of the carburetor float and needle valve from the upper half of the carburetor bowl, due to improper installation of the float kit.Oct 8, 1993 · N91849 · Destroyed NTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.May 30, 1993 · N91633 · Destroyed NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.Apr 11, 1990 · N71779 · Destroyed NTSB ATL87FA248Accident · 1 fatalField investigationFinal reportCessna 182 · Lima, OHDuring a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…Sep 4, 1987 · N71536 · Destroyed NTSB ANC82DAG16Accident · 2 fatalFinal reportCessna 182M · Bethel, AKThe pilot filed a VFR, round robin, flight plan. When the time on the flight plan had elapsed, a search was initiated. Later, the plane was found where it had crashed on a frozen lake surrounded by low terrain. An examination of the wreckage revealed that the…Jan 25, 1982 · N71734 · Destroyed NTSB ATL81FA090Accident · 2 fatalClosedCessna 182M · Haleyville, ALJul 2, 1981 · N71859 · Destroyed NTSB LAX81FA048Accident · 2 fatalClosedCessna 182M · Truckee, CAFeb 19, 1981 · N71803 · Destroyed NTSB NYC79FA016Accident · 1 fatalClosedCessna 182 · Panama, NYDec 21, 1978 · N71206 · Substantial damage NTSB LAX78FA079Accident · 2 fatalClosedCessna 182M · Santa Barbara, CASep 24, 1978 · N71182 · Destroyed NTSB MKC78FA009Accident · 1 fatalClosedCessna 182M · Hill City, SDNov 29, 1977 · N71026 · Destroyed NTSB MKC77FA021Accident · 1 fatalClosedCessna 182M · Aberdeen, SDApr 22, 1977 · N91622 · Destroyed NTSB IAD76AI080Accident · 1 fatalClosedCessna 182M · Beaufort, NCJul 3, 1976 · N71432 · Destroyed NTSB IAD76AI073Accident · 2 fatalClosedCessna 182 · Burnsville, NCMay 14, 1976 · N71387 · Destroyed NTSB FTW75AF020Accident · 2 fatalClosedCessna 182M · Hillsboro, TXSep 15, 1974 · N71038 · Destroyed NTSB DEN74AD014Accident · 4 fatalClosedCessna 182 · Artesia, NMOct 6, 1973 · N71227 · Destroyed NTSB MKC73AK037Accident · 2 fatalClosedCessna 182 · Duluth, MNNov 8, 1972 · N70586 · Destroyed NTSB MIA73AM025Accident · 3 fatalClosedCessna 182M · Keystone Hgts, FLSep 3, 1972 · N91658 · Destroyed NTSB CHI73AC018Accident · 5 fatalClosedCessna 182M · Brownsburg, INAug 15, 1972 · N92004 · Destroyed NTSB DEN72AD049Accident · 1 fatalClosedCessna 182M · Counselor, NMMay 6, 1972 · N71503 · Destroyed NTSB OAK72AP018Accident · 1 fatalClosedCessna 182M · Reno, NVDec 14, 1971 · N71592 · Destroyed NTSB MKC71AK028Accident · 2 fatalClosedCessna 182M · Kingsville, MONov 26, 1970 · N71319 · Destroyed NTSB FTW71AF023Accident · 5 fatalClosedCessna 182M · Vidalia, LANov 18, 1970 · N71605 · 2 aircraft · Substantial damage NTSB SEA70AS045Accident · 2 fatalClosedCessna 182M · Laurier, WAMay 26, 1970 · N91648 · Destroyed NTSB MKC70AK053Accident · 4 fatalClosedCessna 182M · Adair, IAApr 12, 1970 · N91598 · Destroyed NTSB CHI70A0021Accident · 2 fatalClosedCessna 182M · Mazomanie, WIOct 11, 1969 · N70696 · Destroyed NTSB MKC70A0012Accident · 3 fatalClosedCessna 182M · Kansas City, MOSep 23, 1969 · N91785 · Destroyed