NTSB investigations: Cessna U206F

9 cases on aircraft the registry lists as Cessna U206F, where the first occurrence was “Loss of control - in flight”. 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: 9 cases
1982	1
1986	1
1987	1
1988	1
1991	1
1994	1
1996	1
2002	1
2004	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" = 250)) 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\" = 250))
  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" = 250))
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 ANC04LA050Accident · No injuriesLimited investigationFinal reportCessna U206F · Nanwalek, AKA loss of directional control for an undetermined reason during takeoff-initial climb, which resulted in the left wing colliding with the ground.May 2, 2004 · N35860 · Substantial damage NTSB ANC02LA074Accident · No injuriesLimited investigationFinal reportCessna U206F · Koliganek, AKThe pilot's premature lift-off which precipitated an in-flight loss of control, and subsequent collision with terrain.Jul 12, 2002 · N696TK · Substantial damage NTSB ANC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.Sep 3, 1996 · N1801Q · Substantial damage NTSB ANC94LA115Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilots inadequate compensation for the high wind condition during takeoff. The wind was a factor.Aug 9, 1994 · N14C · Substantial damage NTSB ANC92LA007Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Scammon Bay, AKThe pilot's failure to maintain airspeed during the aborted landing. Contributing to the accident was the unfavorable wind.Oct 18, 1991 · N7353Q · Substantial damage NTSB ANC89LA003Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKWhile flying through a mountain pass the pilot encountered a high wind condition. The pilot lost control of the airplane, and the airplane crashed at the 900 foot level.Oct 3, 1988 · N122SC · Substantial damage NTSB NYC88LA035Accident · No injuriesLimited investigationFinal reportCessna U206F · New Bedford, MAThe Cessna U206F was taking off from a harbor. After becoming airborne it experienced a 40 knot airspeed loss. The plt stated that he was unable to maintain altitude and was forced to land on a beach. The acft flipped ovr after a pontoon caught a rock. A…Nov 6, 1987 · N8384Q · Substantial damage NTSB FTW86FRG16Accident · Minor injuriesFinal reportCessna U206F · Mcallen, TXOn 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft…Mar 5, 1986 · N8502Q · Destroyed NTSB ANC82FA091Accident · 4 fatalField investigationFinal reportRobertson C-U206F · Near Nondalton, AKShortly after takeoff from hudson lake the left wingtip contacted the water causing the acft to cartwheel. The acft came to rest inverted & floated for a short time before sinking. A witness reported the waves on the lake were at least 4 ft high & breaking…Sep 17, 1982 · N33249 · Destroyed