Final NTSB investigations: Dehavilland DHC-2 MK.I
4 cases on aircraft the registry lists as Dehavilland DHC-2 MK.I. 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
| 2002 | 1 |
|---|---|
| 2014 | 1 |
| 2021 | 2 |
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2808007'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2808007'))
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 ANC21FA069Accident · 6 fatalClass 2 · FieldFinal reportDehavilland DHC-2 MK.I · Ketchikan, AKThe pilot’s decision to continue visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in controlled flight into terrain. Contributing to the accident was the FAA’s reliance on voluntary compliance with the Ketchikan…NTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.NTSB ANC14LA058Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 · Talkeetna, AKThe pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…NTSB ANC02LA051Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of an unsuitable taxi area, which resulted in substantial damage to the left elevator when the tailwheel encountered a hole. A factor associated with the accident was rough/uneven terrain.