NTSB investigations: Dehavilland BEAVER DHC-2 MK.1
6 cases on aircraft the registry lists as Dehavilland BEAVER DHC-2 MK.1, where the sequence of events included Loss of control on ground. 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
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2800102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ANC24LA060Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Susitna, AKThe pilot’s selection of an unsuitable takeoff area, resulting in the floats contacting the shallow river bottom during takeoff, and a subsequent loss of control.NTSB ANC22LA056Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot's failure to maintain control of the airplane during taxi operations on a riverbank with shallow water.NTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.NTSB ANC18LA047Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-2 · Dillingham, AKThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ANC10LA044Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Anchorage, AKThe commercial pilot’s loss of airplane control while landing in a crosswind, resulting in a nose-over. Contributing to the accident was the check pilot's inadequate supervision of the commercial pilot while landing.NTSB SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.