# NTSB investigations: Douglas DC3, TX

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 WPR18FA201](https://openairdocs.org/ntsb/WPR18FA201.md): Douglas DC3 · Burnet, TX · Accident · Serious injuries · Class 2 · Field · Final report · Jul 21, 2018 · N47HL · Destroyed
  > The copilot's failure to maintain directional control during the initial takeoff roll and the pilot's failure to adequately monitor the copilot during the takeoff and his delayed remedial action, which resulted in the airplane briefly becoming airborne and…
- [NTSB FTW86FA060](https://openairdocs.org/ntsb/FTW86FA060.md): Douglas DC-3C · El Paso, TX · Accident · No injuries · Field investigation · Final report · Apr 6, 1986 · N25CE · Substantial damage
  > The pilot reported that he was leveling off from climb when he experienced a prop runaway. He observed oil streaming from the left engine, but could not feather. Unable to maintain altitude with a windmilling prop, he performed a gear up emergency landing in…
- [NTSB FTW75AF051](https://openairdocs.org/ntsb/FTW75AF051.md): Douglas DC-3C · Houston, TX · Accident · 5 fatal · Closed · Feb 1, 1975 · N15HC · Destroyed
- [NTSB FTW62A0028](https://openairdocs.org/ntsb/FTW62A0028.md): Douglas DC-3 · Dallas, TX · Accident · 3 fatal · Closed · Apr 18, 1962 · N3588 · Destroyed

## 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" = 'TX' 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=TX

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