# Fatal NTSB investigations: Pratt & Whitney PT6SER TP

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 DCA04WA009](https://openairdocs.org/ntsb/DCA04WA009.md): Socata TBM-700 · Oxford, United Kingdom · Accident · 3 fatal · Foreign investigation · Dec 6, 2003 · N30LT · Destroyed
- [NTSB LAX00GA297](https://openairdocs.org/ntsb/LAX00GA297.md): Bell 412 · Cold Springs, NV · Accident · 1 fatal · Final report · Aug 13, 2000 · N174EH · Destroyed
  > failure of the compressor turbine disc due to cyclic fatigue brought about by repeated operation near or above the engines' temperature/power limits by company personnel over an extended period of time. Factors in the accident were: 1) the high density…
- [NTSB NYC86MA148](https://openairdocs.org/ntsb/NYC86MA148.md): Sikorsky S-76B · Sutton, MA · Accident · 4 fatal · Major investigation · Final report · Jun 6, 1986 · N5AZ · Destroyed
  > About 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the…

## 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 ('52045'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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