# NTSB investigations: Douglas DC-3A-S1C3G

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 MIA95LA040](https://openairdocs.org/ntsb/MIA95LA040.md): Cessna 208B · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Dec 15, 1994 · N927FE · 2 aircraft · Substantial damage
  > The inability of the pilot of Cessna 208, N927FE to see Douglas DC3, N24320, as he taxied to takeoff due to inoperative tail navigation lights and beacon lights on the DC3 and due to glare on the wet taxiway.
- [NTSB MIA79FKG16](https://openairdocs.org/ntsb/MIA79FKG16.md): Douglas DC-3 · Williamson, GA · Accident · No injuries · Closed · Jan 21, 1979 · N133D · Substantial damage
- [NTSB MIA74AM050](https://openairdocs.org/ntsb/MIA74AM050.md): Douglas DC3A · W.Palm Beach, FL · Accident · Minor injuries · Closed · Dec 27, 1973 · N19428 · Substantial damage
- [NTSB MIA73OM088](https://openairdocs.org/ntsb/MIA73OM088.md): Douglas DC-3C · San Salvador, Burkina Faso · Accident · Serious injuries · Closed · Mar 2, 1973 · N6574 · Substantial damage
- [NTSB FTW71AF049](https://openairdocs.org/ntsb/FTW71AF049.md): Douglas DC-3 · Houston, TX · Accident · No injuries · Closed · Feb 19, 1971 · N99H · Substantial damage
- [NTSB MIA70A0004](https://openairdocs.org/ntsb/MIA70A0004.md): Douglas DC-3A · Chamblee, GA · Accident · No injuries · Closed · Jul 26, 1969 · N686RP · Substantial damage
- [NTSB CHI69I0003](https://openairdocs.org/ntsb/CHI69I0003.md): Douglas DC-3A · Oshkosh, WI · Incident · No injuries · Closed · Jul 4, 1968 · N4007C · Minor damage
- [NTSB NYC66A0053](https://openairdocs.org/ntsb/NYC66A0053.md): Douglas DC-3 · Coraopolis, PA · Accident · Serious injuries · Closed · Nov 9, 1965 · N52 · Destroyed
- [NTSB NYC66A0024](https://openairdocs.org/ntsb/NYC66A0024.md): Douglas DC-3 · Newport, VT · Accident · Serious injuries · Closed · Aug 2, 1965 · N19428 · No damage
- [NTSB UNK65X1481](https://openairdocs.org/ntsb/UNK65X1481.md): Douglas DC-3 · Andros Is, Mexico · Accident · Serious injuries · Closed · Apr 5, 1965 · N150A · Substantial damage
- [NTSB UNK64X1250](https://openairdocs.org/ntsb/UNK64X1250.md): Douglas DC-3 · Ontpelier, VT · Accident · No injuries · Closed · Apr 10, 1964 · N19428 · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3021440'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3021440

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