Fatal NTSB investigations: Douglas DC3C-S1C3G
8 cases on aircraft the registry lists as Douglas DC3C-S1C3G. 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
| 1964 | 1 |
|---|---|
| 1970 | 2 |
| 1977 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2001 | 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 ('3021458'))
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 ('3021458'))
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 ANC01FA033Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Unalaska, AKThe airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…NTSB NYC95FA167Accident · 1 fatalField investigationFinal reportDouglas DC-3 · Independence, NYThe loss of engine power for undetermined reasons, and the pilot's shutdown of the wrong engine, which resulted in a forced landing and collision with trees.NTSB CHI89MA095Accident · 3 fatalMajor investigationFinal reportDouglas DC3C-S13CG · Waterman, ILThe pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…NTSB ATL84FA251Accident · 3 fatalField investigationFinal reportDouglas DC3C-S1C3G · Memphis, TNMoments after the DC-3 took off, the twr ctlr noted the l eng was torching & asked the flt if it was 'having a problem.'the crew replied 'affirmative,' then the ctlr clrd the flt to lnd on any rwy. The acft began turning left at the end of the rwy & contd…NTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INNTSB ANC71AA001Accident · 5 fatalClosedDouglas DC-3 · Mcgrath, AKNTSB FTW70DRA10Accident · 2 fatalClosedDouglas DC-3A · Melcor Ocampo, MexicoNTSB UNK64X0890Accident · 5 fatalClosedDouglas DC-3C · Miles City, MT