# NTSB investigations: Douglas DC3A, 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 FTW96FA262](https://openairdocs.org/ntsb/FTW96FA262.md): Douglas DC3A · Cut And Shoot, TX · Accident · Minor injuries · Field investigation · Final report · Jun 20, 1996 · N23WT · Destroyed
  > The flight instructor's failure to use the single engine best angle of climb airspeed resulting in a loss of control of the aircraft. Factors were the loss of power to the left engine for undetermined reasons, the flight instructor not being qualified to be…
- [NTSB FTW87LA180](https://openairdocs.org/ntsb/FTW87LA180.md): Douglas DC-3A · Laredo, TX · Accident · No injuries · Limited investigation · Final report · Jul 29, 1987 · N39DT · Substantial damage
  > The left engine failed during initial climb immediately after liftoff. Airspeed could not be maintained with one engine out due to the fact that the aircraft was climbing slowly just above the surface and was loaded to 3,809 pounds above its maximum allowable…
- [NTSB FTW76AF056](https://openairdocs.org/ntsb/FTW76AF056.md): Douglas DC-3A · Corpus Christi, TX · Accident · No injuries · Closed · Jan 4, 1976 · N80BA · Substantial damage
- [NTSB FTW70A0002](https://openairdocs.org/ntsb/FTW70A0002.md): Douglas DC3A · Austin, TX · Accident · No injuries · Closed · Jul 19, 1969 · N25661 · Substantial 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" = '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 ('3021433'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3021433&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.