NTSB investigations, 2009
15 cases where the defining event was Turbulence encounter.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 15 |
| 2010 | 9 |
| 2011 | 22 |
| 2012 | 22 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 18 |
| 2016 | 19 |
| 2017 | 16 |
| 2018 | 18 |
| 2019 | 24 |
| 2020 | 13 |
| 2021 | 11 |
| 2022 | 18 |
| 2023 | 22 |
| 2024 | 31 |
| 2025 | 25 |
| 2026 | 22 |
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\") = 2009
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE 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 year(c."eventDate") = 2009 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '360') 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 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 ERA10CA036Accident · Serious injuriesData collectionFinal reportBoeing 767-432ER · Atlanta, GAUnforecasted turbulence resulting in a flight attendant being injured.NTSB ERA10CA022Accident · Serious injuriesData collectionFinal reportBoeing 767-3P6 · ArgentinaAn inadvertent encounter with turbulence, which resulted in an injury to a flight cabin attendant.NTSB ERA09LA488Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Inverness, FLThe flight crew's encounter with convective turbulence. Contributing to the accident was the failure of the operator's dispatch department to provide the flightcrew with current adverse weather information along the planned route of flight. Also contributing…NTSB ERA09LA444Accident · Serious injuriesLimited investigationFinal reportBoeing Of Canada/Dehav Div DHC-8-311 · Fayetteville, NCAn in-flight encounter with convective clouds resulting in moderate turbulence and serious injury to a flight attendant.NTSB DCA09CA069Accident · Serious injuriesData collectionFinal reportBombardier CL-600-2B19 · Louisville, KYan inadvertent encounter with convective turbulence.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 DCA09FA068Accident · Serious injuriesField investigationFinal reportEmbraer EMB170 · Norfolk, VAan inadvertent encounter with convective turbulence that resulted in serious injuries to a flight attendant.NTSB CEN09LA461Accident · Serious injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De ERJ 170-20 · Indianapolis, INThe passenger's failure to comply with crewmember instructions to remain seated while the airplane was in turbulent weather conditions, resulting in an injury to the passenger.NTSB ERA09LA396Accident · Serious injuriesLimited investigationFinal reportAirbus A320-232 · Fort Myers, FLAn inadvertent in-flight encounter with turbulence during approach. Contributing to the accident was the passengers' failure to follow the instructions of the illuminated seatbelt sign.NTSB DCA09CA051Accident · Serious injuriesData collectionFinal reportBoeing 767 332 · San Juan, PRInadvertent encounter with convective turbulence while in cruise.NTSB ERA09LA418Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Cuba, CubaAn unanticipated inflight encounter with turbulence.NTSB CEN09LA256Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · McAllen, TXThe injured passenger's failure to comply with the requirement to remain seated with a fastened seatbelt.NTSB ERA09LA224Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD88 · Atlanta, GAThe flight attendant’s failure to properly restrain herself after taking her jumpseat.NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, Japan