Skip to content

NTSB investigations

24 cases where the sequence of events included Clear air turbulence encounter.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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" = '362' 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

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\" = '362' 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" = '362' 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 DCA27LA014Occurrence · No injuriesClass 4 · LimitedInvestigation openBoeing 777 · Orlando, FLOct 12, 2026 · G-VIIT · No damage NTSB DCA26LA340Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A319-132 · Houston, TXAug 27, 2026 · N884UA · No damage NTSB DCA25LA045Accident · Serious injuriesClass 3 · LimitedPreliminary reportEmbraer S A ERJ 170-200 LR · Warnock, OHOn November 20, 2024, about 1846 eastern standard time (2346 UTC), a Mesa Airlines, Inc., Embraer SA ERJ 170-200 LR, N85352, dba as United Express flight 6149, encountered “moderate to severe” turbulence during descent to its destination, Cleveland Hopkins…Nov 20, 2024 · N85352 · No damage NTSB DCA24WA298Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Tokyo, JapanSep 4, 2024 · JA863J · Minor damage NTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.Mar 29, 2022 · N469SL · No damage 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.Nov 21, 2021 · N743QS · No damage NTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.Mar 3, 2020 · N157SF · Destroyed NTSB DCA19CA198Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · Charlottesville, VAan inadvertent encounter with clear air turbulence.Aug 8, 2019 · N505JB · No damage NTSB DCA18CA007Accident · Serious injuriesData collectionFinal reportBoeing 767 328 · Honolulu, HIan inadvertent encounter of clear air turbulence.Oct 15, 2017 · N342AX · No damage NTSB DCA17WA154Accident · Serious injuriesForeign investigationBoeing 787-9 · Fukushima, JapanThe Japanese Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 787-9 airplane that occurred on July 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions…Jul 1, 2017 · N29968 · No damage NTSB DCA16CA181Accident · Serious injuriesData collectionFinal reportBoeing 737 724 · Port Arthur, TXan inadvertent encounter with clear air turbulence.Mar 15, 2016 · N23708 · No damage NTSB DCA16CA053Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Charlotte, NCAn inadvertent encounter with clear air turbulence.Dec 23, 2015 · N475WN · No damage NTSB DCA14CA014Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · Houston, TXThe airplane's inadvertent encounter with clear air turbulence during cruise flight, which resulted in a serious injury to a flight attendant.Oct 18, 2013 · N665UA · No damage NTSB WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.Aug 31, 2012 · N4454D · Substantial damage NTSB ERA11CA511Accident · Serious injuriesData collectionFinal reportBoeing 737-823 · Miami, FLThe in-flight encounter with clear air turbulence, which resulted in an injury to a cabin attendant.Sep 29, 2011 · N804NN · No damage NTSB CEN10CA480Accident · Serious injuriesData collectionFinal reportBuckeye Industries Dream Machine · Seymour, INAn inadvertent encounter with turbulence which exceeded the performance capability of the powered parachute.Aug 14, 2010 · N61638 · Substantial damage NTSB DCA10FA076Accident · Serious injuriesField investigationFinal reportBoeing 767 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with clear air turbulence.Jul 15, 2010 · N184DN · No damage NTSB CEN10LA189Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-100 SE · Runnells, IAA clear air turbulence encounter during cruise flight, during which an unrestrained cabin flight attendant sustained a hip fracture.Apr 3, 2010 · N869RW · No damage NTSB DCA10CA032Accident · Serious injuriesData collectionFinal reportBoeing 747 · Anchorage, AKan inadvertent encounter with clear air turbulence.Feb 19, 2010 · N173UA · Minor damage NTSB CEN10LA204Accident · No injuriesLimited investigationFinal reportCessna 680 · Eagle, COThe airplane’s encounter with localized severe to extreme mountain wave turbulence which resulted in substantial damage to both wings.Feb 13, 2010 · N606CS · Substantial damage 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.Jun 15, 2009 · N4490M · No damage 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.May 8, 2009 · N11LF · Substantial damage NTSB DCA08FA064Accident · Serious injuriesField investigationFinal reportEmbraer 140 · Dallas, TXThe flight's inadvertent encounter with turbulence.May 27, 2008 · N816AE · No damage NTSB DEN08LA055Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-202 · Denver, COThe encounter with severe turbulence causing serious injury to the flight attendant.Feb 3, 2008 · N444YV · No damage