Fatal NTSB investigations: Dehavilland DHC-3
13 cases on aircraft the registry lists as Dehavilland DHC-3. 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.
Cases per year
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1980 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2019 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802412', '2800202', '2802414'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802412', '2800202', '2802414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…NTSB ANC15FA071Accident · 3 fatalField investigationFinal reportDehavilland DHC 3T · Iliamna, AKThe pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…NTSB ANC15MA041Accident · 9 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Ketchikan, AK(1) the pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in his geographic disorientation and controlled flight into terrain; and (2) Promech's company culture, which tacitly endorsed flying in…NTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…NTSB ANC11FA107Accident · 1 fatalField investigationFinal reportDehavilland DHC-3T · Kodiak, AKThe pilot’s failure to maintain clearance from a tree during a low altitude maneuver and his failure to maintain control of the airplane. Contributing to the accident was the pilot’s use of over-the-counter sedating medications.NTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…NTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.NTSB SEA89FA036Accident · 2 fatalField investigationFinal reportde Havilland DHC-3 · Ketchikan, AKThe pilot's inadvertant flight into IFR conditions and the stall which occurred during the turn to reverse course. Contributing to the accident were the snow conditions encountered.NTSB MIA87FA015Accident · 1 fatalField investigationFinal reportde Havilland DHC-3 · San Juan, PRWitnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The…NTSB ANC80FA081Accident · 2 fatalClosedDehavnd Can DHC-3 · Togiak, AKNTSB FTW78FRG39Accident · 3 fatalClosedDehaviland DHC-3 · Del Rio, TXNTSB ANC77FA067Accident · 1 fatalClosedDehavilland DHC-3 · Bettles, AK