NTSB investigations: Pratt & Whitney PW4000 series, 2016
4 cases on aircraft whose registry engine model is Pratt & Whitney PW4000 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1990 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 7 |
| 2024 | 6 |
| 2025 | 2 |
| 2026 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\") = 2016
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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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") = 2016
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ENG17IA003Incident · No injuriesIncident investigationFinal reportAirbus A330 223 · Seattle, WAA No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration…NTSB DCA16CA220Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · International Waters, A1an inadvertent encounter with severe convective turbulence.NTSB DCA16WA191Incident · No injuriesForeign investigationAirbus Industrie A330 323 · London, United KingdomAir Accident Investigation Branch (AAIB) notified the NTSB of a serious incident involving a AIRBUS INDUSTRIE A330 323 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA16RA175Accident · Minor injuriesForeign investigationMcdonnell Douglas MD11 · Incheon, South Koreaimport