NTSB investigations: Douglas DC3C, AK
13 cases on aircraft the registry lists as Douglas DC3C. 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
| 1965 | 1 |
|---|---|
| 1970 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1998 | 2 |
| 2006 | 1 |
| 2009 | 1 |
| 2019 | 1 |
| 2026 | 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 ('3021457', '3021455'))
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 ('3021457', '3021455'))
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 ANC26LA040Accident · No injuriesClass 4 · LimitedInvestigation openDouglas DC3C · Anchorage, AKNTSB GAA19CA492Accident · No injuriesData collectionFinal reportDouglas DC3C · Kenai, AKThe pilot's failure to maintain a proper approach path in gusting crosswind wind conditions, which resulted in landing short of the runway and impact with a ditch and runway light.NTSB ANC09LA064Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Skwentna, AKA fracture of the airplane's tailwheel shock absorber linkage during taxi, resulting in the collapse of the tailwheel.NTSB ANC06LA032Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Beluga, AKThe pilot's failure to maintain altitude/clearance from trees on final approach, which resulted in an in-flight collision with trees.NTSB ANC98LA114Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's failure to maintain directional control during landing, and the resulting overload fracture of the tailwheel fork assembly.NTSB ANC98LA055Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the soft, marshy terrain at the forced landing area.NTSB ANC86LA015Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Dillingham, AKNTSB ANC83FA103Accident · No injuriesField investigationFinal reportDouglas DC-3 · Fort Yukon, AKThe acft had an in-flt fire in the accessory section of the lt eng. According to the passenger there was a long delay between outbreak of fire and corrective action by the crew. The passengers also commented on the lack of communication from the cockpit to…NTSB ANC81DA061Accident · No injuriesClosedDouglas DC-3 · Togiak, AKNTSB ANC79FA074Accident · No injuriesClosedDouglas DC3C · Bettles, AKNTSB ANC71AA021Accident · 2 fatalClosedDouglas DC-3C · Anchorage, AKNTSB ANC70AA080Accident · Minor injuriesClosedDouglas DC-3C · Barrow, AKNTSB ANC66A0010Accident · No injuriesClosedDouglas DC-3 · Mc Carthy, AK