NTSB investigations: Cessna U206F

7 cases on aircraft the registry lists as Cessna U206F, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 U206F per year, 1982–2026: 7 cases
1982	2
1986	1
1988	1
1991	1
1993	1
1995	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 ('2073333', '207333A') 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" = 351)) 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 ('2073333', '207333A')
      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\" = 351))
  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 ('2073333', '207333A')
    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" = 351))
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 ANC95LA058Accident · No injuriesLimited investigationFinal reportCessna 206 · Bethel, AKA failure of the #2 main engine bearing and subsequent fatigue failure of the engine crankshaft. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.May 25, 1995 · N19BR · Substantial damage NTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.Nov 19, 1993 · N8260Q · Substantial damage NTSB SEA91LA212Accident · No injuriesLimited investigationFinal reportCessna U206F · Nimrod, ORThe fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.Aug 19, 1991 · N35831 · Substantial damage NTSB DEN88IA204Incident · No injuriesIncident investigationFinal reportCessna 206 · Glade Park, COThe failure of the #1 connecting rod assembly in the engine, resulting in a forced landing. A factor in the incident was that the pilot did not see & avoid power wires in the forced landing path.Sep 15, 1988 · N71001 · No damage NTSB NYC86FA234Accident · Serious injuriesField investigationFinal reportCessna U206F · Holoyoke, MAWhile en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.…Sep 11, 1986 · N8316Q · Substantial damage NTSB MKC82DA173Accident · Minor injuriesFinal reportCessna U206F · Baton Rouge, LAThe pilot changed the fuel selector from right to left while descending through 2200 ft MSL. The engine failed immediately after the fuel selector was moved. Repeated attempts to restart the engine by changing fuel selector position was unsuccessful. The…Sep 20, 1982 · N9530G · Substantial damage NTSB DEN82DA196Accident · No injuriesFinal reportCessna U206F · Kemmerer, WYThe aircraft lost power after takeoff in a large field. During the landing roll, the aircraft crossed a dirt road that crossed the field, the nose gear failed and the aircraft nosed over. A section of aluminum from the air induction box was missing. Aluminum…Sep 15, 1982 · N8317Q · Substantial damage