# NTSB investigations: Pratt & Whitney PW4000 series, 2006

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 DCA06WA072](https://openairdocs.org/ntsb/DCA06WA072.md): McDonnell Douglas MD-11 · Subic Bay, Philippines · Accident · No injuries · Foreign investigation · Sep 14, 2006 · N623FE · Substantial damage
- [NTSB NYC06LA151](https://openairdocs.org/ntsb/NYC06LA151.md): Boeing 767-300 · Dulles, VA · Accident · No injuries · Limited investigation · Final report · Jun 17, 2006 · N653UA · Substantial damage
  > The driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.
- [NTSB DCA06WA035](https://openairdocs.org/ntsb/DCA06WA035.md): Boeing 777 · Shanghai, China · Accident · Serious injuries · Foreign investigation · Apr 19, 2006 · N216UA · No damage
- [NTSB DEN06IA034](https://openairdocs.org/ntsb/DEN06IA034.md): Boeing B777-200B · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jan 19, 2006 · N798UA · Minor damage
  > the truck driver's failure to maintain clearance from the airplane and the boom operator's failure to adequately clear the boom from the airplane. Contributing to the accident was the low visibility due to snow and mist.

## 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") = 2006
  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=2006

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