NTSB investigations
423 cases where the sequence of events included Turbulence encounter.
Cases, newest first
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.\"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."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 DCA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXAn encounter with convectively-induced turbulence (CIT).NTSB DCA23WA292Incident · Serious injuriesClass 5 · ForeignBoeing 777 · Bangkok, ThailandNTSB DCA23LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Atlantic Ocean (Atlantic Ocean)An encounter with inadvertent convective turbulence during cruise flight.NTSB DCA23WA236Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Incheon, South KoreaNTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.NTSB DCA23LA213Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-224 · Sacramento, CAAn encounter with forecast convective turbulence during climb.NTSB DCA23LA196Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Dallas, TXThe flight’s encounter with convective turbulence.NTSB DCA23LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319-132 · New Orleans, LAThe flight’s encounter with convective turbulence.NTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.NTSB DCA23LA477Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Lake Butler, FLAn inadvertent encounter with convectively induced turbulence.NTSB DCA23WA313Incident · Serious injuriesClass 5 · ForeignAirbus A330 · Grand Anse Village, SeychellesNTSB WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.NTSB DCA23LA107Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GIV-X (G450) · Miami, FLAn unanticipated encounter with convective induced turbulence from developing cumulus clouds below the flight path, which produced strong updrafts and downdrafts.NTSB DCA23WA097Accident · Serious injuriesClass 5 · ForeignBoeing 737-824 · Chiacam, GuatemalaNTSB DCA23LA096Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Kahului, HIThe flight crew’s decision to fly over an observed storm cell instead of deviating around it despite sufficient meteorological information indicating the potential for severe convective activity.NTSB DCA23LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Newark, NJAn inadvertent encounter with clear air turbulence during descent.NTSB DCA23LA090Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Taneytown, MDAn encounter with turbulence during descent.NTSB DCA23LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COThe flight’s encounter with mechanical turbulence.NTSB DCA23LA050Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Miami, FLAn encounter with convective turbulence during descent.NTSB DCA23WA012Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Komatsu, Ishikawa, JapanNTSB DCA23LA008Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COAn encounter with clear air turbulence during cruise flight.NTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB DCA22LA198Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 220 · New York, NYAn encounter with convective turbulence.NTSB DCA22LA196Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Denver, COAn encounter with clear air turbulence, which resulted in a serious injury as a flight attendant was lowering her jumpseat.NTSB DCA22LA191Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Detroit, MIAn encounter with moderate turbulence during descent.NTSB DCA22LA188Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Pharisburg, OHThe airplane’s inadvertent encounter with convective turbulence.NTSB DCA22WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Naha, JapanNTSB DCA22WA190Accident · Serious injuriesClass 5 · ForeignBoeing 787-900 · Lahore, PakistanNTSB DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.NTSB DCA22WA074Accident · Serious injuriesClass 5 · ForeignAirbus A320 · Okayama City, JapanNTSB DCA22WA223OccurrenceClass 5 · ForeignBoeing 737 · Durgapur, IndiaNTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.NTSB DCA22LA012Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Lexington, VAThe airplane’s inadvertent encounter with convective turbulence.NTSB DCA21LA209Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 319-132 · Chicago, ILAn encounter with clear air turbulence.NTSB DCA21WA187Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Nice, ItalyNTSB DCA21LA176Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Miami, FLan inadvertent encounter with convective turbulence.NTSB DCA21LA164Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · New Orleans, LAAn inadvertent encounter with severe turbulence during cruise flight that caused a flight attendant to fall and fracture his ankle.NTSB DCA21WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Kolkata, IndiaNTSB ANC21LA043Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Cordova, AKAn encounter with mountain wave turbulence and windshear that exceeded the climb capability of the airplane and resulted in impact with terrain.NTSB DCA21WA143Accident · Serious injuriesClass 5 · ForeignBoeing 767 · Yesan, South KoreaNTSB DCA21LA109Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer EMB-145LR · Charlotte, NCan encounter with convective turbulence during descent.NTSB CEN21LA170Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Boerne, TXThe pilot’s failure to maintain control of the airplane during a full stop landing and the subsequent attempted go-around in turbulent conditions.NTSB DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachNTSB WPR21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46R-350T · Tehachapi, CAThe pilot’s encounter with mountain wave activity with severe turbulence, which resulted in a loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a preflight weather briefing.NTSB ERA21LA115Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 300 · Myrtle Beach, SCAn encounter with severe turbulence, which resulted in serious injury to an unseated passenger.NTSB DCA21LA058Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXan encounter with forecasted convective turbulence during approach.NTSB DCA21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777 · Anchorage, AKThe airplane’s encounter with severe turbulence while flying over a mountain range during cruise.NTSB WPR20CA276Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Hillsboro, ORThe pilot’s failure to maintain altitude on short final due to an encounter with a down draft and the flight instructor's delayed remedial action.NTSB DCA20WA131Accident · Serious injuriesForeign investigationBoeing 737 · Durban, South AfricaThe CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…NTSB WPR20LA216Accident · 1 fatalClass 3 · LimitedFinal reportSchleicher ASW27 · Ely, NVThe pilot’s loss of glider control while maneuvering near a mountain ridge in downdrafts and dry microbursts at an altitude that precluded recovery.