NTSB investigations: Dehavilland DHC-6-300, AK
5 cases on aircraft the registry lists as Dehavilland DHC-6-300. 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
| 1991 | 1 |
|---|---|
| 1999 | 2 |
| 2002 | 1 |
| 2003 | 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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802630'))
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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802630'))
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 ANC03LA043Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Anchorage, AKThe failure of the captain to maintain adequate clearance between the airplane's wingtip and a parked vehicle. A factor contributing to the accident was the failure of ground personnel to utilize a wing walker as prescribed in company policy when aircraft are…NTSB ANC02LA053Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKThe failure of a ground handler to follow company proceedure/directives, and his premature release of a mooring line. Factors associated with the accident were the congested operations area, and the operator's failure to provide adequate safe zones for the…NTSB ANC99LA107Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKA failure of ground handling personnel to verify a release procedure/directive, and removal of the airplane's tiedown, and subsequent collision with a parked airplane.NTSB ANC99LA064Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Anchorage, AKAn in-flight collision with a bird.NTSB ANC92LA010Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-6 · Chevak, AKThe high crosswind condition, the pilot in commands inability to compensate for the wind conditions, and his failure to follow company procedures and the procedures recommended in the aircraft flight manual. Factor relating to the accident was the captain's…