# NTSB investigations: Douglas DC3, CA

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR09LA108](https://openairdocs.org/ntsb/WPR09LA108.md): Douglas DC-3/65AR · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Feb 4, 2009 · N834TP · Substantial damage
  > The 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 LAX85FA240](https://openairdocs.org/ntsb/LAX85FA240.md): Douglas DC3 · Perris, CA · Accident · No injuries · Field investigation · Final report · May 5, 1985 · N157U · Destroyed
  > The 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 LAX73AL005](https://openairdocs.org/ntsb/LAX73AL005.md): Douglas DC-3G · Pt.Mugu Nas, CA · Accident · No injuries · Closed · Aug 4, 1972 · N31538 · Substantial damage
- [NTSB OAK71AP056](https://openairdocs.org/ntsb/OAK71AP056.md): Douglas DC-3 · Garberville, CA · Accident · 17 fatal · Closed · Jun 27, 1971 · N90627 · Destroyed
- [NTSB LAX70IL049](https://openairdocs.org/ntsb/LAX70IL049.md): Douglas DC-3 · Burbank, CA · Incident · No injuries · Closed · Feb 19, 1970 · N31538 · Minor damage
- [NTSB DCA69A0014](https://openairdocs.org/ntsb/DCA69A0014.md): Douglas DC-3 · Lone Pine, CA · Accident · 35 fatal · Closed · Feb 18, 1969 · N15570 · Destroyed
- [NTSB LAX62A0081](https://openairdocs.org/ntsb/LAX62A0081.md): Douglas DC-3 · Big Trees, CA · Accident · Serious injuries · Closed · Jan 20, 1962 · N58731 · Minor damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?model=3021401&state=CA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.