Final NTSB investigations
325 cases where the sequence of events included Turbulence encounter.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 20 |
| 2010 | 17 |
| 2011 | 25 |
| 2012 | 23 |
| 2013 | 9 |
| 2014 | 12 |
| 2015 | 21 |
| 2016 | 25 |
| 2017 | 13 |
| 2018 | 19 |
| 2019 | 18 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 13 |
| 2023 | 20 |
| 2024 | 26 |
| 2025 | 17 |
| 2026 | 4 |
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 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."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 DCA26LA286Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Sanford, FLAn encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.NTSB DCA26LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Providence, RIThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant.NTSB DCA26LA167Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean (Pacific Ocean)An unanticipated encounter with clear air turbulence while in cruise flight.NTSB DCA26LA165Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Atlantic Ocean (Atlantic Ocean)The airplane’s encounter with turbulence resulted in serious injuries to a flight attendant who was not seated due to completion of arrival compliance checks.NTSB WPR26LA048Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Evanston, WYThe airplane’s encounter with downdrafts in mountainous terrain, which resulted in a collision with terrain. Contributing to the accident was the pilot’s decision to continue the flight through mountainous terrain in marginal weather conditions.NTSB DCA25LA341Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321 · Las Vegas, NVThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant who was standing at the time of the encounter.NTSB DCA25LA323Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Port Orange, FLAn encounter with convective turbulence during descent, which resulted in serious injuries to a flight attendant.NTSB DCA25LA307Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Peaster, TXThe airplane’s encounter with convective turbulence that resulted in serious injuries to a passenger who was out of their seat when the seatbelt sign was illuminated.NTSB DCA25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD 83 · Miami, FLAn encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.NTSB DCA25LA269Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Jacksonville, GAThe airplane’s encounter with unanticipated moderate turbulence.NTSB DCA25LA272Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · Germantown, KYAn inadvertent encounter with severe turbulence during descent.NTSB DCA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A321-211 · Miami, FLThe unexpected encounter with a rapidly developing convective cell during climb resulting in convectively induced turbulence on a dark moon-less evening.NTSB DCA25LA239Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Nashville, TNThe airplane’s encounter with moderate convective turbulence during descent.NTSB DCA25LA241Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Barlow Bend, ALThe airplane’s encounter with unanticipated turbulence during descent, resulting in a serious injury to a flight attendant.NTSB DCA25LA238Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Fort Myers, FLThe airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.NTSB DCA25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Ebro, FLThe airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…NTSB DCA25LA190Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Tahlequah, OKThe airplane’s encounter with moderate turbulence during descent.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 DCA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · San Diego, CAAn encounter with an area of moderate clear air turbulence associated with the jet stream during cruise.NTSB DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.NTSB DCA25LA102Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Ojai, CAAn encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.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 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 DCA25LA041Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-231 · Cooper Hill, MOAn encounter with convective induced turbulence which resulted in a flight attendant serious injury.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 CEN25LA011Accident · Serious injuriesClass 4 · LimitedFinal reportPowrachute SKY Rascal · Peculiar, MOThe failure of the pilot to use appropriate engine power during descent in turbulent air which resulted in a loss of control.NTSB CEN24FA326Accident · 1 fatalClass 3 · FieldFinal reportRans S19 · Crofton, NEThe non-instrument-rated pilot's decision to continue visual flight into an area of low cloud cover and precipitation which resulted in an inadvertent encounter with instrument meteorological conditions and a loss of control due to spatial disorientation.NTSB DCA24LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Highland Meadows, NMAn encounter with convectively induced turbulence during descent.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB DCA24LA256Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Severn, MDA passenger’s failure to comply with crew member instructions to remain seated with seatbelt fastened.NTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB ERA24LA317Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Montauk, NYThe pilot’s failure to maintain an appropriate glide path during the landing approach in terrain induced turbulence, resulting in a hard landing and subsequent runway excursion.NTSB ANC24FA063Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Kekaha, HIAn encounter with turbulence due to downdraft winds that resulted in mast bumping and an in-flight breakup.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB ERA24LA247Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Southampton Township, NJThe flight instructor’s failure to maintain control of the airplane during a low approach and subsequent go-around in turbulent wind conditions.NTSB ERA24FA217Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Franklin, TNThe pilot’s flight into convective weather, which resulted in a loss of control due to spatial disorientation and a subsequent inflight breakup of the airplane. Contributing to the accident was the lack of accurate weather intensity depiction on the…NTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.NTSB DCA24LA174Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Hogansville, GAAn encounter with convectively induced turbulence during descent.NTSB DCA24LA144Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Cecil, NCAn encounter with clear air turbulence.NTSB DCA24FA143Accident · Serious injuriesClass 3 · FieldFinal reportBoeing 737-7CT · Gulf of America (Gulf of Mexico)The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…NTSB DCA24LA135Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-232 · Lakeland, GAAn inadvertent encounter with convective turbulence that resulted in a serious injury to a flight attendant.NTSB DCA24LA130Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-800 · Paris, TNAn encounter with convective turbulence.NTSB DCA24LA124Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Aylett, VAAn encounter with clear air turbulence during descent.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 CEN24LA100Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft BE58 · DeRidder, LAThe pilot’s encounter with heavy rain, hail, and severe turbulence associated with a thunderstorm, which resulted in substantial damage to the airplane.NTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…NTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.NTSB DCA23LA462Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Caribbean Sea (Atlantic Ocean)An inadvertent encounter with convectively induced turbulence during cruise that was not depicted by the airplane’s weather radar system.