NTSB investigations: Dehavilland-Kenmore DHC-2
4 cases on aircraft the registry lists as Dehavilland-Kenmore DHC-2. 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
| 1987 | 1 |
|---|---|
| 1994 | 1 |
| 1998 | 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 ('2805001'))
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 ('2805001'))
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 ANC24LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland-Kenmore DHC-2 · Juneau, AKA partial loss of engine power during initial climb due to a cracked cylinder.NTSB ANC98FA145Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors associated with this accident were the pilot's unfamiliarity with the geographic area, the low clouds, his becoming disoriented, and the blind canyon into which…NTSB ANC94LA142Accident · No injuriesLimited investigationFinal reportde Havilland DHC2 · Whittier, AKThe pilot's inadequate in-flight planning and inadequate compensation for the wind conditions. An initial tail wind and later a crosswind were factors in the accident.NTSB ANC87LA078Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot stated that he started his takeoff run in the middle of the lake. The aircraft overran the lake and ended up on the tundra approximately 75 yards from the lake shore.