NTSB investigations: Douglas DC3, CA
7 cases on aircraft the registry lists as Douglas DC3. 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
| 1962 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1985 | 1 |
| 2009 | 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\" = 'CA' 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 ('3021401'))
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" = 'CA' 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 ('3021401'))
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 WPR09LA108Accident · No injuriesLimited investigationFinal reportDouglas DC-3/65AR · Mojave, CAThe student pilot failed to follow the checklist and set the takeoff trim properly prior to takeoff resulting in a loss of directional control. Contributing to the accident were the certified flight instructor's inadequate supervision and delayed remedial…NTSB LAX85FA240Accident · No injuriesField investigationFinal reportDouglas DC3 · Perris, CAThe aircraft's left engine caught fire during the takeoff roll. The pilot managed to stop the aircraft on the runway and all 31 skydivers and the two member crew evacuated without injury. The left engine propeller had lost one blade which was found several…NTSB LAX73AL005Accident · No injuriesClosedDouglas DC-3G · Pt.Mugu Nas, CANTSB OAK71AP056Accident · 17 fatalClosedDouglas DC-3 · Garberville, CANTSB LAX70IL049Incident · No injuriesClosedDouglas DC-3 · Burbank, CANTSB DCA69A0014Accident · 35 fatalClosedDouglas DC-3 · Lone Pine, CANTSB LAX62A0081Accident · Serious injuriesClosedDouglas DC-3 · Big Trees, CA