Skip to content

NTSB investigations: Dehavilland BEAVER DHC-2 MK.1

71 cases on aircraft the registry lists as Dehavilland BEAVER DHC-2 MK.1. 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, newest first

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 ('2800102')) 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 ('2800102'))
  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 ('2800102'))
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 SEA87LA111Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Sedro Woolley, WAShortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections…Jun 8, 1987 · N64384 · Destroyed NTSB ANC86LA167Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fognak Island, AKOn takeoff, the right door popped open. The pilot reached across to pull the door closed and lost directional control of the aircraft. The aircraft then struck a tree near the bank of the lake.Oct 1, 1986 · N5354G · Substantial damage NTSB ANC86LA086Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bulchitna Lake, AKThe airplane struck a wingtip on the water while step taxiing downwind attempting a left turn.Jun 23, 1986 · N67686 · Substantial damage NTSB ANC85FA184Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Merrill Pass, AKThe acft collided with terrain in a mountain Pass at an elevation of 3600 ft MSL. The plt obtained a wx briefing at 1329 gmt on 9/26/86 at which time Merrill Pass was forecast to be closed by 1100 adt due to deteriorating wx. The last radio communication with…Sep 26, 1985 · N5317G · Destroyed NTSB ANC85FA154Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK.1 · Tutna Lake, AKThe acft crashed on the side of a mountain at an elev of 2200 ft aprx 3 miles from its intended destination, a remote lake. Purpose of the flt was to discharge caribou hunters into an area where caribou were spotted early that day. The acft was destroyed by…Aug 18, 1985 · N68085 · Destroyed NTSB ANC84LA183Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKWhile taxiing for takeoff the aircraft's left wing struck a duck shack.Sep 15, 1984 · N5349G · Substantial damage NTSB ANC83LA158Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2, MK-1 · Barrow, AKThe acft collided with a ditch during landing. The sandbar used for landing had a light covering of snow and a ditch wasobscured by the snow. During landing rollout the acft collided with the ditch and one of the main landing gear collapsed. No mechanical…Sep 1, 1983 · N5147G · Substantial damage NTSB ANC81DA051Accident · No injuriesClosedDehavilland DHC-2 · Klawock, AKMay 8, 1981 · N64384 · Substantial damage NTSB ANC80DA077Accident · Minor injuriesClosedDehavilland DHC-2 · Cordova, AKJul 30, 1980 · N67676 · Substantial damage NTSB ANC78FA030Accident · 2 fatalClosedDehavilland DHC-2 · Cordova, AKApr 18, 1978 · N4747S · Destroyed NTSB ANC76AA120Accident · No injuriesClosedDehavilland DHC-2 · Petersburg, AKAug 9, 1976 · N616W · Substantial damage NTSB ANC76AA102Accident · No injuriesClosedDehavilland DHC-2 · Craig, AKJun 3, 1976 · N64384 · Substantial damage NTSB ANC76AA032Accident · 8 fatalClosedDehavilland DHC-2 · Kijik, AKSep 12, 1975 · N64392 · Destroyed NTSB DEN76FTM05Accident · No injuriesClosedDehavilland DHC-2 · Ogden, UTAug 15, 1975 · N5317G · Substantial damage NTSB SEA76DYE09Accident · No injuriesClosedDehavilland DHC-2 · Kent, WAAug 14, 1975 · N5162G · Substantial damage NTSB ANC75DAD01Accident · No injuriesClosedDehavilland DHC-2 · Sitka, AKJul 15, 1974 · N4794C · Substantial damage NTSB ANC73AA042Accident · No injuriesClosedDehavilland DHC-2 · Sitka, AKFeb 28, 1973 · N616W · Substantial damage NTSB ANC73AA008Accident · No injuriesClosedDehavilland DHC-2 · Juneau, AKJul 24, 1972 · N4747S · Substantial damage NTSB ANC69A0046Accident · 9 fatalClosedDehavilland DHC-2 · Craig, AKApr 19, 1969 · N167W · Destroyed NTSB ANC69D0089Accident · No injuriesClosedDehavilland DHC-2 · Ketchikan, AKNov 30, 1968 · N17597 · Substantial damage NTSB MKC67D0295Accident · No injuriesClosedDehaviland DHC-2 · Forsyth, MONov 8, 1966 · N192Z · Substantial damage