Fatal NTSB investigations: Cessna P206A

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

19662026

Fatal NTSB investigations: Cessna P206A per year, 1966–2026: 11 cases
1966	2
1968	1
1971	1
1975	2
1980	1
1981	1
1995	1
1996	1
1997	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."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 ('2073308')) 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 ('2073308'))
  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 ('2073308'))
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 FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.Dec 7, 1997 · N693SB · 2 aircraft · Destroyed NTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.Feb 10, 1996 · N4655F · Destroyed NTSB NYC96FA004Accident · 1 fatalField investigationFinal reportCessna P206A · Fishkill, NYThe pilot's VFR flight into instrument meteorological conditions. Contributing factors were the fog and dusk light conditions.Oct 7, 1995 · N4704F · Destroyed NTSB ATL82FA022Accident · 1 fatalClosedCessna 206 · Pine Mountain, GANov 27, 1981 · N4617F · Destroyed NTSB LAX80FA042Accident · 1 fatalClosedCessna 206 · Carson City, NVJan 26, 1980 · N2670X · Destroyed NTSB DEN76AD006Accident · 5 fatalClosedCessna P206A · Parowan, UTJul 24, 1975 · N4693F · Destroyed NTSB LAX75AL047Accident · 2 fatalClosedCessna P206 · Wheaton Spring, CAMar 11, 1975 · N2661X · Destroyed NTSB LAX72AL004Accident · 2 fatalClosedCessna 206A · Flagstaff, AZJul 17, 1971 · N2688X · Destroyed NTSB NYC69A0022Accident · 1 fatalClosedCessna 206 · Snowshoe, PAAug 21, 1968 · N2680X · Destroyed NTSB MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNDec 26, 1966 · N4663F · Substantial damage NTSB MIA67A0012Accident · 3 fatalClosedCessna P206A · Opa Locka, FLJul 22, 1966 · N2676X · Destroyed