Skip to content

Fatal NTSB investigations: Cessna 206

17 cases on aircraft the registry lists as Cessna 206. 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

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 ('2073302')) 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 ('2073302'))
  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 ('2073302'))
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 CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.Aug 16, 2013 · N2070K · Minor damage NTSB CEN10FA465Accident · 4 fatalField investigationFinal reportCessna U206F · Ludington, MIThe total loss of engine power due to fuel starvation as a result of accumulated debris in the fuel system from an undetermined source. Also causal was the inadequate annual maintenance inspection that did not include inspection of the firewall fuel strainer…Jul 23, 2010 · N82531 · Substantial damage NTSB MIA05WA115Accident · 5 fatalForeign investigationCessna 206C · Puntarenas, Costa RicaMay 31, 2005 · N558DZ · Destroyed NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.Mar 20, 1994 · N5222U · Destroyed NTSB SEA91FA186Accident · 5 fatalField investigationFinal reportCessna 206 · Salmon, IDImproper inflight planning and decisions and failure to maintain airspeed.Jul 23, 1991 · N5183U · Destroyed NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.Nov 18, 1990 · N5184U · Destroyed NTSB ANC88LA081Accident · 1 fatalLimited investigationFinal reportCessna 206 · Naknek, AKThe pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…Jul 3, 1988 · N5045U · Destroyed NTSB NYC83FA248Accident · 4 fatalField investigationFinal reportCessna U-206FG · Jones Beach, NYThe acft ditched in the ocean about 4 miles se of Jones Beach, NY following eng power failure. The 4 occupants drowned. The plt was going from Washington,DC to westhampton Beach, NY, the acft was last refueled before its departure from westhampton Beach on…Sep 17, 1983 · N50807 · No damage NTSB MIA82FKA05Accident · 1 fatalFinal reportCessna 206 · Saint CroixAircraft landed during darkness before control tower had opened. While taxiing to ramp, aircraft was struck by an ambulance as aircraft was crossing parallel taxiway. Aircraft immediately burst into flames, and ambulance continued to travel through the…Jan 4, 1982 · N5151U · Destroyed NTSB DEN78FA026Accident · 5 fatalClosedCessna 206 · Yoder, COFeb 25, 1978 · N5205U · Destroyed NTSB OAK75AP003Accident · 1 fatalClosedCessna 206 · Lathrop Wells, NVJul 20, 1974 · N5218U · Substantial damage NTSB DEN73AD003Accident · 4 fatalClosedCessna U206 · Aspen, COJul 24, 1972 · N5290U · Destroyed NTSB FTW72AF024Accident · 2 fatalClosedCessna 206 · Bossier City, LAOct 28, 1971 · N5168U · Destroyed NTSB MIA71AM067Accident · 2 fatalClosedCessna 206 · Hillsboro, TNJan 30, 1971 · N5169U · Destroyed NTSB OAK70AP037Accident · 1 fatalClosedCessna 206 · Jackson, CAJan 11, 1970 · N5085U · Destroyed NTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARDec 4, 1964 · N5089U · Destroyed NTSB UNK65X0635Accident · 2 fatalClosedCessna 206 · Ponca City, OKNov 9, 1964 · N5034U · 2 aircraft · Substantial damage