Skip to content

NTSB investigations: Cessna U206, AK

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

19652026

Where

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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073306')) 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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073306'))
  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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073306'))
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 ERA22LA410Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Buckland, AKThe installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power.Sep 9, 2022 · N8019Z · Substantial damage NTSB ANC13CA080Accident · Minor injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection.Aug 15, 2013 · N2141F · Substantial damage NTSB ANC11FA062Accident · No injuriesField investigationFinal reportCessna U206 · Port Alsworth, AKThe pilot’s failure to see and avoid the approaching airplane. Contributing to the accident was that the pilot’s failure to listen to radio position reports from the other airplane on the common traffic advisory frequency and the absence of any forward-facing…Jul 10, 2011 · N2186F · 2 aircraft · Minor damage NTSB ANC07LA104Accident · Minor injuriesLimited investigationFinal reportCessna U206 · McGrath, AKA separation of the engine connecting rod and engine cylinder due to the loss of a connecting rod nut that was stripped from the rod bolt.Sep 21, 2007 · N8030Z · Substantial damage NTSB ANC05LA079Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Stony River, AKA partially blocked fuel pump, which resulted in a loss of engine power while in cruise flight. A factor associated with the accident was an inoperative electric auxiliary fuel pump.Jun 6, 2005 · N2125F · Substantial damage NTSB ANC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tyonek, AKThe pilot's continued flight into adverse weather conditions, and his inadequate in-flight planning/decision. Factors in the accident were weather conditions consisting of a mountain wave, and downdrafts.May 27, 1998 · N5297U · Substantial damage NTSB ANC95FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 206 · Kenai, AKUndetermined.Dec 3, 1994 · N5282U · Substantial damage NTSB ANC92LA027Accident · No injuriesLimited investigationFinal reportCessna 206 · English Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the ice and slush on the runway, the snowbank, and the crosswind.Jan 8, 1992 · N5282U · Substantial damage NTSB ANC88LA070Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Black Lake, AKThe pilot attempted a landing at a mining strip which was 1000 feet long. The pilot overshot the runway touchdown point; he then attempted a go-around, lost control , and crashed 300 feet off the departure end of the runway.Jun 22, 1988 · N2183F · Substantial damage NTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…Feb 24, 1986 · N8022Z · Destroyed NTSB ANC81FA081Accident · 3 fatalClosedCessna 180 · Naknek, AKJul 15, 1981 · N2827A · 2 aircraft · Destroyed NTSB ANC81DA002Accident · Minor injuriesClosedCessna 206 · Pilot Point, AKOct 11, 1980 · N7950N · Substantial damage NTSB ANC80DA013Accident · No injuriesClosedCessna 206 · Gold King Crk, AKNov 20, 1979 · N206JP · Substantial damage NTSB ANC79DAG55Accident · No injuriesClosedCessna 206 · Kustatan, AKMay 19, 1979 · N29029 · Substantial damage NTSB ANC79DAG30Accident · No injuriesClosedCessna U206 · Atmautluak, AKJan 4, 1979 · N2183F · Substantial damage NTSB ANC78FAA28Accident · Minor injuriesClosedCessna 206 · Unalakleet, AKJul 18, 1978 · N625Q · Substantial damage NTSB ANC77DA032Accident · No injuriesClosedCessna 206 · Alexander Crk, AKFeb 21, 1977 · N625Q · Substantial damage NTSB ANC76DAH85Accident · No injuriesClosedCessna 206 · Bethel, AKSep 24, 1976 · N5279U · Substantial damage NTSB ANC76DAH39Accident · Minor injuriesClosedCessna U206 · Chinitna Bay, AKJul 3, 1976 · N8015Z · Substantial damage NTSB ANC76AA079Accident · No injuriesClosedCessna U206 · Beluga, AKApr 4, 1976 · N2141F · Substantial damage NTSB ANC76AA066Accident · Minor injuriesClosedCessna 206 · Takotna, AKFeb 5, 1976 · N5273U · Substantial damage NTSB ANC75AA038Accident · No injuriesClosedCessna 206 · Tuntutuliak, AKOct 21, 1974 · N2183F · Substantial damage NTSB ANC74AA051Accident · No injuriesClosedCessna U206 · St Marys, AKJan 5, 1974 · N2125F · Substantial damage NTSB ANC74DAG69Accident · No injuriesClosedCessna U206 · Bethel, AKOct 20, 1973 · N8015Z · Substantial damage NTSB ANC74DAG68Accident · No injuriesClosedCessna U206 · Akiak, AKOct 15, 1973 · N2125F · Substantial damage NTSB ANC74AA02CAccident · 1 fatalClosedCessna 206 · Togiak, AKAug 17, 1973 · N9616G · Substantial damage NTSB ANC72AA031Accident · 1 fatalClosedCessna U206 · Wainwright, AKDec 22, 1971 · N3978G · Destroyed NTSB ANC69D0021Accident · No injuriesClosedCessna U206 · Port Heiden, AKJun 12, 1968 · N2139F · Substantial damage NTSB ANC68A0027Accident · No injuriesClosedCessna U206 · Anchorage, AKOct 18, 1967 · N5279U · Substantial damage NTSB ANC67A0039Accident · No injuriesClosedCessna U206 · Seldovia, AKOct 16, 1966 · N2156F · Substantial damage NTSB ANC66F0022Accident · Serious injuriesClosedCessna U206 · Sitka, AKAug 15, 1965 · N2150F · Destroyed