NTSB investigations: Pratt & Whitney PW4000 series
15 cases on aircraft whose registry engine model is Pratt & Whitney PW4000 series, where the defining event was Turbulence encounter. 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
| 2009 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2026 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52119')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '360'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52119')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '360'))
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 DCA27LA019Accident · Serious injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · Pacific Ocean (Pacific Ocean)NTSB DCA25LA091Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Gulf of America (Gulf of Mexico)An encounter with an area of clear air turbulence during cruise, which resulted in a serious injury to a flight attendant.NTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.NTSB DCA24LA097Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 777-222ER · Kelsey, NYThe airplane’s encounter with an unanticipated localized region of moderate-to-severe turbulence while in instrument meteorological conditions (IMC) associated with strong upper-level wind shear and convective cells. Contributing to the severity of the…NTSB DCA23LA421Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-222 · Over the (Atlantic Ocean)An inadvertent encounter with clear air turbulence during cruise flight.NTSB DCA19CA189Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · San Juan, PRAn encounter with convective turbulence during cruise flight.NTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.NTSB DCA17LA173Accident · Serious injuriesLimited investigationFinal reportAirbus 330 · East Hampton, NYan inadvertent encounter with convective turbulence.NTSB DCA16CA220Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · International Waters, A1an inadvertent encounter with severe convective turbulence.NTSB DCA14WA042Incident · No injuriesForeign investigationBoeing 767 332 · Buenos Aires, ArgentinaThe Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…NTSB WPR13LA131Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean, A1The flight’s encounter with moderate clear air turbulence while en route, which resulted in a serious injury to a flight attendant. Contributing to the accident was the lack of communication equipment in the rest compartment, which, if installed, could have…NTSB DCA12WA109Accident · Serious injuriesForeign investigationBoeing 777-222 · Narita, JapanNTSB DCA11FA091Accident · Serious injuriesField investigationFinal reportBoeing 747-422 · Tangshan, Chinaan inadvertent encounter with convectively induced turbulence likely due to radar limitations and convective weather developing upwards into the flight path.NTSB DCA10FA012Accident · Serious injuriesField investigationFinal reportBoeing 777-200 · New Market, VAThe flight crew’s inadvertent encounter with a small area of cumulous clouds at night that resulted in moderate to severe convectively induced turbulence.NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, Japan