NTSB investigations, Outside the U.S.
7 cases where NTSB found Clear air turbulence.
Cases per year
| 2010 | 1 |
|---|---|
| 2013 | 1 |
| 2016 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2024 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032015'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03032015')) 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 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 ERA22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier BD-100-1A10 · Atlantic Ocean, Turks & Caicos IslandsThe airplane’s encounter with moderate clear air turbulence which resulted in a serious injury to one unrestrained passenger.NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air 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 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 DCA10FA064Accident · Serious injuriesField investigationFinal reportBoeing 777 · Southern Tip of Greenland, DenmarkAn inadvertent encounter with unforecast turbulence in cruise flight.