Final NTSB investigations, Outside the U.S.
20 cases where the sequence of events included Turbulence encounter.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2024 | 4 |
| 2025 | 1 |
Latest 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.\"eventCountry\" <> 'USA'
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventCountry" <> 'USA' AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 DCA25LA173Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Claveria, PhilippinesAn encounter with convective turbulence during cruise that was not detected in advance by cockpit weather radar or weather information services.NTSB DCA25LA055Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean, Hong Kong SAR ChinaAn encounter with unexpected turbulence during descent.NTSB DCA25LA047Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Brasilia, BrazilThe airplane’s encounter with unanticipated turbulence during cruise flight, which resulted in serious injury to one passenger who was not seated.NTSB DCA25LA044Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Tokyo, JapanAn encounter with turbulence while in cruise flight, resulting in serious injuries to two flight attendants.NTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.NTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.NTSB DCA16CA220Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · International Waters, A1an inadvertent encounter with severe convective turbulence.NTSB DCA16CA209Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Grand Cayman Island (GCM), Cayman Islandsan inadvertent encounter with clear air turbulence.NTSB DCA16CA205Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Bermuda, Bermudaan inadvertent encounter with clear air turbulence.NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.NTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.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 ANC11CA101Accident · Serious injuriesData collectionFinal reportDouglas DC-8-62F · Yakota, JapanThe passenger's decision to ignore the fasten seatbelt sign, resulting in serious injury to the passenger during a turbulence encounter.NTSB 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 WPR11LA071Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Pago Pago, AntarcticaThe airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.NTSB DCA10FA064Accident · Serious injuriesField investigationFinal reportBoeing 777 · Southern Tip of Greenland, DenmarkAn inadvertent encounter with unforecast turbulence in cruise flight.NTSB ERA10CA022Accident · Serious injuriesData collectionFinal reportBoeing 767-3P6 · ArgentinaAn inadvertent encounter with turbulence, which resulted in an injury to a flight cabin attendant.NTSB DCA09IA071Incident · Minor injuriesIncident investigationFinal reportBoeing 767-224 · Bavaro, Dominican RepublicThe flight crew's inadvertent flight through the top of a convective updraft that resulted in an encounter with convective induced turbulence. Contributing to the severity of the incident was the unrestrained status of several passengers, contrary to the…NTSB ERA09LA418Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Cuba, CubaAn unanticipated inflight encounter with turbulence.