# NTSB investigations: Pratt & Whitney JT9D series, NY

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 DCA01MA063](https://openairdocs.org/ntsb/DCA01MA063.md): Boeing 767-200ER · New York City, NY · Accident · 65 fatal · Major investigation · Final report · Sep 11, 2001 · N612UA · Destroyed
  > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…
- [NTSB IAD96IA098](https://openairdocs.org/ntsb/IAD96IA098.md): Boeing 747-136 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Jun 18, 1996 · N606FF · Minor damage
  > failure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.
- [NTSB NYC93IA184](https://openairdocs.org/ntsb/NYC93IA184.md): Boeing 747-200 · New York, NY · Incident · No injuries · Incident investigation · Final report · Sep 11, 1993 · N17025 · Minor damage
  > The improper installation of the fairing by company maintenance personnel, resulting in the infligh separation of the fairing in flight.
- [NTSB NYC89IA123](https://openairdocs.org/ntsb/NYC89IA123.md): Fairchild Swearingen SA-227AC · New York, NY · Incident · No injuries · Incident investigation · Final report · Apr 23, 1989 · N3044J · 2 aircraft · No damage
  > The failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R.

## 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" = 'NY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52054'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52054&state=NY

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