NTSB investigations, 2009
27 cases where NTSB found Turbulence.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 27 |
| 2010 | 28 |
| 2011 | 36 |
| 2012 | 28 |
| 2013 | 16 |
| 2014 | 18 |
| 2015 | 24 |
| 2016 | 25 |
| 2017 | 21 |
| 2018 | 22 |
| 2019 | 22 |
| 2020 | 16 |
| 2021 | 17 |
| 2022 | 26 |
| 2023 | 23 |
| 2024 | 31 |
| 2025 | 17 |
| 2026 | 7 |
Where
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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030320'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030320')) 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 ANC10LA006Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKThe pilot's decision to fly at a low altitude in strong winds and turbulence, resulting in a loss of control and a collision with terrain.NTSB ERA10CA036Accident · Serious injuriesData collectionFinal reportBoeing 767-432ER · Atlanta, GAUnforecasted turbulence resulting in a flight attendant being injured.NTSB ANC10FA004Accident · 1 fatalField investigationFinal reportCessna A185E · Healy, AKThe pilot's decision to maneuver at a low altitude over rising terrain in conditions conducive to turbulence/downdrafts, resulting in a loss of control and impact with terrain.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 WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.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 WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.NTSB DCA09FA068Accident · Serious injuriesField investigationFinal reportEmbraer EMB170 · Norfolk, VAan inadvertent encounter with convective turbulence that resulted in serious injuries to a flight attendant.NTSB WPR09CA358Accident · Minor injuriesData collectionFinal reportWsk-Pzl Meilec PZL M18B · Rockland, IDThe pilot's failure to maintain clearance from the terrain during an aerial application reversal turn.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 ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.NTSB WPR09CA479Accident · Minor injuriesData collectionFinal reportSchleicher ASK-21 · Jean, NVThe pilot's failure to maintain control of the glider during the initial climb due to an inadvertent encounter with wind.NTSB WPR09LA301Accident · Serious injuriesLimited investigationFinal reportPaul Antares · Petaluma, CAThe pilot's failure to maintain aircraft control while landing in gusting winds.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB CEN09LA388Accident · Serious injuriesLimited investigationFinal reportBeech B100 · Rapid City, SDThe flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.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 WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.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 WPR09IA187Incident · No injuriesIncident investigationFinal reportLiberty Aerospace Liberty XL-2 · Camarillo, CAThe cruise flight separation of the canopy door. Contributing to the incident was the pilot's failure to ensure that the left side door was securely closed prior to takeoff.NTSB ERA09LA224Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD88 · Atlanta, GAThe flight attendant’s failure to properly restrain herself after taking her jumpseat.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.