Fatal NTSB investigations: Cessna 207

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

19702026

Fatal NTSB investigations: Cessna 207 per year, 1970–2026: 23 cases
1970	2
1972	2
1973	1
1976	4
1977	1
1979	2
1980	1
1988	2
1992	2
1999	1
2000	1
2011	2
2015	1
2018	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 ('2073602')) 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 ('2073602'))
  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 ('2073602'))
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 ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.Jun 13, 2018 · N9423B · 2 aircraft · Substantial damage NTSB ANC15FA032Accident · 1 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…May 30, 2015 · N1653U · Substantial damage NTSB ANC12FA009Accident · 1 fatalField investigationFinal reportCessna 207 · Chuathbaluk, AKThe pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.Nov 29, 2011 · N1673U · Substantial damage NTSB ANC11FA077Accident · 2 fatalField investigationFinal reportCessna 207 · McGrath, AKThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Aug 14, 2011 · N91099 · Substantial damage NTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…Sep 20, 2000 · N42472 · Destroyed NTSB ANC00FA018Accident · 6 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.Dec 7, 1999 · N1747U · Destroyed NTSB ANC93FA012Accident · 2 fatalField investigationFinal reportCessna 207 · Montague Island, AKThe pilot's intentional VFR departure into instrument meteorological conditions, and the company chief pilot's failure to exercise adequate supervision. The weather conditions were factors in the accident.Nov 6, 1992 · N1686U · Destroyed NTSB ANC92LA115Accident · 1 fatalLimited investigationFinal reportCessna 207 · Yakutat, AKThe pilot elected to fly an improper altitude. Contributing factors were the pilots attempt to fly VFR into IMC conditions, and the obscured weather.Jul 29, 1992 · N7ME · Destroyed NTSB NYC89FA022Accident · 1 fatalField investigationFinal reportCessna 207 · Monoghan, PAEvidence indicates that the airplane flew straight into the side of a 1320 ft mountain at the 1280 ft level. The recommended minimum flight altitude for this designated mountainous area, at night, is 3500 ft. there was no evidence of any mechanical problems.Nov 5, 1988 · N91036 · Destroyed NTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…Apr 4, 1988 · N207CA · Destroyed NTSB MKC81FA005Accident · 2 fatalClosedCessna 207 · Cedar Rapids, IAOct 16, 1980 · N91026 · Destroyed NTSB ANC80FA007Accident · 1 fatalClosedCessna 207 · Venetie, AKOct 25, 1979 · N1684U · Substantial damage NTSB ANC80FA001Accident · 3 fatalClosedCessna 207 · Juneau, AKOct 3, 1979 · N1726U · Destroyed NTSB MIA77FA048Accident · 1 fatalClosedCessna 207 · Atlanta, GAMar 30, 1977 · N91073 · Destroyed NTSB CHI76AC086Accident · 2 fatalClosedCessna 207 · East Troy, WIAug 17, 1976 · N91061 · Destroyed NTSB ANC76AA082Accident · 5 fatalClosedCessna 207 · Anaktuvuk Pass, AKApr 27, 1976 · N1707U · Destroyed NTSB SEA76AS042Accident · 7 fatalClosedCessna 207 · Friday Harbor, WAApr 8, 1976 · N1645U · Destroyed NTSB ANC76AA074Accident · 4 fatalClosedCessna 207 · Igiugig, AKMar 7, 1976 · N91142 · Destroyed NTSB CHI73AC066Accident · 1 fatalClosedCessna 207 · Marion, ILJan 26, 1973 · N1582U · Destroyed NTSB CHI72ACO96Accident · 1 fatalClosedCessna 207 · Cochrane, WIJun 2, 1972 · N91005 · Destroyed NTSB BAH72ATC25Accident · 2 fatalClosedCessna 207 · San Salvdor, Burkina FasoMar 4, 1972 · N1607U · Destroyed NTSB OAK71AP029Accident · 1 fatalClosedCessna 207 · No.Pacific Ocean (Pacific Ocean)Dec 5, 1970 · N91110 · Destroyed NTSB NYC71AN064Accident · 1 fatalClosedCessna 207 · Lewis, NYNov 19, 1970 · N91119 · Destroyed