# NTSB investigations: Douglas DC3, 1985

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 ANC85FA112](https://openairdocs.org/ntsb/ANC85FA112.md): Douglas DC-3 · King Salmon, AK · Accident · No injuries · Field investigation · Final report · Jun 30, 1985 · N168Z · Substantial damage
  > During an instrument apch, the acft's right eng lost power. The plt moved the right fuel selector to the left main tank & began emergency procedures. Shortly after that, the acft broke out of the overcast & the aircrew saw the arpt. However, the left eng also…
- [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…

## 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 year(c."eventDate") = 1985
  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&year=1985

---
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.
