# NTSB investigations: Pratt & Whitney PW4000 series, 2018

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 DCA19CA034](https://openairdocs.org/ntsb/DCA19CA034.md): Boeing 767 · SUNNS intersection, Osaka, Japan · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 4, 2018 · N193DN · No damage
  > The airplane’s encounter with severe turbulence.
- [NTSB DCA18LA163](https://openairdocs.org/ntsb/DCA18LA163.md): Airbus A330 323 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2018 · N806NW · Substantial damage
  > The flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that…
- [NTSB DCA18RA093](https://openairdocs.org/ntsb/DCA18RA093.md): Airbus A330 · Lagos, Nigeria · Incident · Minor injuries · Foreign investigation · Feb 13, 2018 · N858NW · Minor damage
  > The AIB of Nigeria has notified the NTSB of an incident involving a Airbus A330 airplane that occurred on February 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB of Nigeria's investigation under the provisions of ICAO…

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

This list as a web page: https://openairdocs.org/ntsb?engine=52119&year=2018

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