Skip to content

NTSB investigations, 2023

25 cases where the sequence of events included 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 year(c."eventDate") = 2023 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

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\") = 2023
    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 year(c."eventDate") = 2023
  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 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…Nov 29, 2023 · N745MB · Substantial damage NTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.Sep 28, 2023 · N804AN · No damage 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.Sep 25, 2023 · N569JB · No damage NTSB DCA23LA445Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Hebron, KYAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Sep 7, 2023 · N37531 · No damage NTSB DCA23FA428Accident · Serious injuriesClass 3 · FieldFinal reportAirbus A350-941 · Atlanta, GAThe flight crew’s unintentional encounter with rapidly developing cumulus clouds which resulted in an encounter with severe convectively induced turbulence.Aug 29, 2023 · N576DZ · Minor damage NTSB DCA23LA421Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-222 · Over the (Atlantic Ocean)An inadvertent encounter with clear air turbulence during cruise flight.Aug 18, 2023 · N209UA · No damage NTSB DCA23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Eleroy, ILAn encounter with clear air turbulence.Aug 14, 2023 · N776MS · No damage NTSB DCA23LA382Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Myrtle Beach (Atlantic Ocean)An encounter with convectively induced turbulence (CIT) while in cruise flight.Jul 28, 2023 · N77431 · No damage NTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Jul 24, 2023 · N279WN · No damage NTSB DCA23LA378Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Inverness, FLAn inadvertent encounter with convectively induced turbulence during descent.Jul 12, 2023 · N249NV · No damage NTSB DCA23WA350OccurrenceClass 5 · ForeignBoeing 777 · ChinaJun 28, 2023 · G-YMML · No damage NTSB DCA23WA328Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Singapore, SingaporeJun 15, 2023 · G-STBL · No damage NTSB DCA23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Chicago, ILAn encounter with convectively-induced turbulence (CIT).Jun 1, 2023 · N28457 · No damage NTSB DCA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXAn encounter with convectively-induced turbulence (CIT).Jun 1, 2023 · N479UA · No damage NTSB DCA23WA292Incident · Serious injuriesClass 5 · ForeignBoeing 777 · Bangkok, ThailandMay 10, 2023 · A7-BAN · No damage NTSB DCA23LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Atlantic Ocean (Atlantic Ocean)An encounter with inadvertent convective turbulence during cruise flight.Apr 22, 2023 · N770AN · No damage NTSB DCA23WA236Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Incheon, South KoreaMar 22, 2023 · HL8254 · No damage NTSB 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.Mar 21, 2023 · N314FR · Substantial damage NTSB DCA23LA213Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-224 · Sacramento, CAAn encounter with forecast convective turbulence during climb.Mar 21, 2023 · N79011 · No damage NTSB DCA23LA196Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Dallas, TXThe flight’s encounter with convective turbulence.Mar 2, 2023 · N366FR · No damage NTSB DCA23LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319-132 · New Orleans, LAThe flight’s encounter with convective turbulence.Feb 16, 2023 · N505NK · No damage NTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.Feb 11, 2023 · N944AN · No damage NTSB DCA23LA477Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Lake Butler, FLAn inadvertent encounter with convectively induced turbulence.Feb 10, 2023 · N13138 · No damage NTSB DCA23WA313Incident · Serious injuriesClass 5 · ForeignAirbus A330 · Grand Anse Village, SeychellesFeb 3, 2023 · D-ANRA NTSB 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.Jan 25, 2023 · N23FD · Substantial damage