Fatal NTSB investigations: Cessna P206

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

Fatal NTSB investigations: Cessna P206 per year, 1969–2026: 13 cases
1969	1
1970	1
1971	2
1976	1
1984	2
1987	1
2000	1
2004	1
2007	1
2008	2

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."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 ('2073304')) 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 ('2073304'))
  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 ('2073304'))
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 WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.Oct 29, 2008 · N2570X · Substantial damage NTSB DEN08FA078Accident · 2 fatalField investigationFinal reportCessna P206 · Mount Vernon, MOThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing factors in this accident were the entanglement of the parachute in the elevator control system, reducing the pilot's ability to regain control.Apr 19, 2008 · N2537X · Destroyed NTSB ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.Aug 26, 2007 · N904DZ · Substantial damage NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…Oct 30, 2004 · N2588X · Substantial damage NTSB DEN00FA104Accident · 2 fatalField investigationFinal reportCessna P206 · Howard, COThe pilot's failure to maintain aircraft control. A factor was a thunderstorm.Jun 5, 2000 · N2577X · Destroyed NTSB LAX87FA213Accident · 4 fatalField investigationFinal reportCessna P206 · Tehachapi, CAAn USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government…May 22, 1987 · N2520X · 2 aircraft · Destroyed NTSB DEN85FA034Accident · 4 fatalField investigationFinal reportCessna P206 · Wagon Mound, NMPlt received 3 wx briefings before flt and informed of possibility of diminishing conditions. Acft collided with terrain 1 1/2 mi from I-25 that goes from raton to albuquerqe. Local residents described wx at aprx time of accident as heavy snow, high winds,…Nov 26, 1984 · N2797Y · Destroyed NTSB LAX84FA134Accident · 4 fatalField investigationFinal reportCessna P206 · Redding, CAWhile en route, the plt contacted a fss & was advised that the Redding arpt was below minimums due to fog. He then contacted the benton UNICOM (7 mi nw of Redding muni) & reported that he could not see the rwy lights at the benton arpt, but that he would…Jan 5, 1984 · N2645X · Destroyed NTSB FTW76AF119Accident · 4 fatalClosedCessna P206 · Shamrock, TXAug 30, 1976 · N2580X · Destroyed NTSB SEA72AS018Accident · 2 fatalClosedCessna P206 · Durkee, ORNov 1, 1971 · N2531X · Destroyed NTSB FTW71DRG89Accident · 1 fatalClosedCessna 206 · Lagunitas, MexicoMar 1, 1971 · N2660X · Destroyed NTSB FTW71AF022Accident · 7 fatalClosedCessna P206 · San Antonio, TXNov 24, 1970 · N2654X · Destroyed NTSB DEN70A0033Accident · 3 fatalClosedCessna P206 · Bryce Canyon, UTNov 8, 1969 · N2502X · Destroyed