Fatal NTSB investigations: Douglas DC3C
11 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 | 2 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 MIA99WA023Accident · 11 fatalForeign investigationDouglas DC3C · Quetzaltenanang, GuatemalaNTSB SEA97FA034Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Boise, IDA fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.NTSB NYC95WA235Accident · 2 fatalForeign investigationDouglas DC-3C · Lobito, Central African RepublicNTSB SEA94FA085Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Spokane, WAThe failure of the pilot-in-command to maintain airspeed. Factors to the accident were: cylinder fatigue, dark night and stall encountered.NTSB MIA91FA140Accident · 2 fatalField investigationFinal reportMcdonnell Douglas DC-3C · Aguadilla, PRThe pilot in command's failure to maintain airspeed (vs) after a partial loss of engine power on the left engine due to failure of the no. 8 engine assembly cylinder. This resulted in an in flight loss of control (stall), and in flight collision with terrain.NTSB OAK79DAMS7Accident · 2 fatalClosedDouglas DC-3 · Honolulu (Pacific Ocean)NTSB CHI76AC026Accident · 2 fatalClosedDouglas DC-3C · Wakeman, OHNTSB ANC71AA021Accident · 2 fatalClosedDouglas DC-3C · Anchorage, AKNTSB DEN68A0027Accident · 2 fatalClosedDouglas DC-3C · Denver, CONTSB CHI66A0025Accident · 1 fatalClosedDouglas DC3 · Louisville, KYNTSB UNK65X1474Accident · 2 fatalClosedDouglas DC-3 · Waterville, Canada