NTSB investigations: Cessna 207A

7 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19822026

NTSB investigations: Cessna 207A per year, 1982–2026: 7 cases
1982	1
1983	1
1986	1
1992	2
1998	1
2003	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073605', '2073604') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073605', '2073604')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073605', '2073604')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 NYC03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Put In Bay, OHThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during the initial climb.Jan 20, 2003 · N9945M · Substantial damage NTSB ANC99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Aniak, AKA loss of engine power due to fuel contamination. A factor in the accident was unsuitable terrain for a forced landing.Oct 26, 1998 · N73533 · Substantial damage NTSB ANC92LA118Accident · No injuriesLimited investigationFinal reportCessna 207A · Pilot Station, AKThe total loss of engine power for undetermined causes, and the unsuitable terrain.Aug 4, 1992 · N70364 · Substantial damage NTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.Feb 28, 1992 · N6312H · Substantial damage NTSB DEN86FA115Accident · Minor injuriesField investigationFinal reportCessna 207A · Ogden, UTAcft was en route to slc where it was to be put on static display with other acft equipped with soloy-conversions (allison 250-C20S turboshaft engine installation). During descent through 12,000 ft into slc area eng flamed out and the prop auto-feathered. Plt…Apr 12, 1986 · N1721Q · Substantial damage NTSB ANC83FA030Accident · No injuriesField investigationFinal reportCessna 207A · Aniak, AKThe acft began to lose power at 700 ft MSL during climbout. The pilot tried the boost pumps and was able to regain some power momentarily. When all power was lost the pilot was forced to land short of the airport on a frozen river. The rough ice sheared the…Jan 7, 1983 · N7389U · Substantial damage NTSB ANC82IA095Incident · No injuriesIncident investigationFinal reportCessna C-207 · Near Dillingham, AKShortly after takeoff, the aircraft experienced a power failure. The pilot stated that when the power loss occurred he switched the fuel selector from the left tank to the right tank and selected "max hi-on" on the fuel boost pump. His attempts to restart the…Sep 21, 1982 · N7394U · Minor damage