# Fatal NTSB investigations: Pratt & Whitney R-1830 series

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 ERA16FA269](https://openairdocs.org/ntsb/ERA16FA269.md): Yakovlev YAK11 · West Mifflin, PA · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2016 · N5940 · Substantial damage
  > A malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…
- [NTSB ANC01FA033](https://openairdocs.org/ntsb/ANC01FA033.md): Douglas DC-3 · Unalaska, AK · Accident · 2 fatal · Field investigation · Final report · Jan 24, 2001 · N19454 · Destroyed
  > The airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…
- [NTSB MIA00RA224](https://openairdocs.org/ntsb/MIA00RA224.md): Douglas DC-3 · Nassau, Bahamas · Accident · 2 fatal · Foreign investigation · Jul 20, 2000 · N54AA
- [NTSB SEA97FA034](https://openairdocs.org/ntsb/SEA97FA034.md): Douglas DC-3C · Boise, ID · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1996 · N75142 · Destroyed
  > A fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.
- [NTSB ANC81FA074](https://openairdocs.org/ntsb/ANC81FA074.md): Douglas DC-3 · Pilot Point, AK · Accident · 3 fatal · Closed · Jul 1, 1981 · N111ST · Destroyed
- [NTSB MIA79DA001](https://openairdocs.org/ntsb/MIA79DA001.md): Douglas DC-3 · Ft Walton Bch, FL · Accident · 1 fatal · Closed · Oct 1, 1978 · N74Z · Destroyed
- [NTSB DCA78AA001](https://openairdocs.org/ntsb/DCA78AA001-79688.md): Douglas DC-3 · Evansville, IN · Accident · 29 fatal · Closed · Dec 13, 1977 · N51071 · Destroyed
- [NTSB LAX74FUJ73](https://openairdocs.org/ntsb/LAX74FUJ73.md): Convair P4Y-2 · Safford, AZ · Accident · 2 fatal · Closed · Jun 27, 1974 · N7237C · Destroyed
- [NTSB DCA69A0015](https://openairdocs.org/ntsb/DCA69A0015.md): Douglas DC3A · New Orleans, LA · Accident · 16 fatal · Closed · Mar 20, 1969 · N142D · Destroyed
- [NTSB CHI66A0025](https://openairdocs.org/ntsb/CHI66A0025.md): Douglas DC3 · Louisville, KY · Accident · 1 fatal · Closed · Sep 10, 1965 · N272R · 2 aircraft · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52020&fatal=1

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