Skip to content

NTSB investigations: Dehavilland DHC-6 TWIN OTTER, AK

14 cases on aircraft the registry lists as Dehavilland DHC-6 TWIN OTTER. 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

19692026

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 ('2802606')) 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 ('2802606'))
  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 ('2802606'))
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 ANC05LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Toksook Bay, AKThe pilot's inadequate compensation for the gusty crosswind wind condition, which resulted in a loss of control during the landing roll, and the collapse of the nose landing gear. Factors associated with the accident were the crosswind and wind gusts.Jan 27, 2005 · N201EH · Substantial damage NTSB ANC02LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Toksook Bay, AKA bird strike during takeoff, which resulted in damage to the right wing.Jul 13, 2002 · N885EA · Substantial damage NTSB ANC89LA168Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Sleepy Bay, AKSelection of unsuitable terrain (water condition) by the pilot. The rough water condition was a related factor.Sep 19, 1989 · N851TB · Substantial damage NTSB ANC89IA059Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Barrow, AKThe propagation of a fatigue crack from multiple origins due to manufacturing defects in the elevator bellcrank mounting quadrant.Apr 14, 1989 · N100AP · No damage NTSB ANC89LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Homer, AKAfter landing, the plt was advised to taxi to the ramp via the south taxiway, since this was the only taxiway that had been snow plowed. Only about a 12 ft width of the 80 ft wide taxiway had been plowed. The cleared portion was on the outer edge of the…Dec 4, 1988 · N525EH · Substantial damage NTSB ANC86LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Mekoryuk, AKThe PIC stated that he was landing to the southwest because the fog was obscuring the apch path to rwy 05. After aligning with rwy 23, the acft drifted off course. The plt was attempting to realign the acft with the rwy when he touched down in a bank and…Feb 7, 1986 · N204EH · Substantial damage NTSB ANC85FA054Accident · Serious injuriesField investigationFinal reportde Havilland DHC-6-300 · Barter Island, AKAcft crashed during missed apch to temporary winter landing strip. Acft hit in steep nose down attitude. Marginal wx conditions prevailed, with icing reported.Mar 12, 1985 · N540N · Substantial damage NTSB ANC82IA048Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Near Port Heide, AKWhile in cruise flight, the left engine surged twice and the pilot observed fire emitting from the exhaust and cowling. After securing the engine and discharging the fire bottle without effect, the pilot made a precautionary landing at Port heiden airport.…Jun 16, 1982 · N525N · Minor damage NTSB DCA82AA022Accident · Serious injuriesFinal reportde Havilland DHC-6-200 · Hooper Bay, AKAt 0833 adt, the acft departed bethel, AK on a scheduled pax/cargo commuter flt to chevak, scammon bay & Hooper Bay, AK. The operator's commuter flts had not landed at scammon bay for svrl days since the rwy was soft & muddy from meltingsnow. Bfr departing…May 16, 1982 · N103AQ · Destroyed NTSB ANC79DA036Accident · No injuriesClosedDehavilland DHC-6 · Anaktuvuk Pass, AKJan 28, 1979 · N851TB · Substantial damage NTSB ANC79FA004Accident · 1 fatalClosedDehavnd Can DHC-6 · Barrow, AKOct 13, 1978 · N4048B · Substantial damage NTSB DCA77AA026Accident · 13 fatalClosedDehavilland DHC-6 · Iliamna, AKSep 6, 1977 · N563MA · Destroyed NTSB ANC77DA035Accident · No injuriesClosedDehavilland DHC-6 · Emmonak, AKMar 9, 1977 · N2714R · Substantial damage NTSB ANC70A0021Accident · 2 fatalClosedDehavilland DHC-6 · Sagwon, AKSep 6, 1969 · N2711N · Destroyed