NTSB investigations, 2017

11 cases where NTSB found Convective turbulence.

Cases per year

20082026
NTSB investigations, 2017 per year, 2008–2026: 145 cases
20083
200910
20106
201114
20128
20132
20145
20158
20169
201711
20187
201910
20208
20213
20227
202310
202411
202511
20262

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\") = 2017
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032020'))
  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.

NTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.Dec 6, 2017 · N670NK · No damageNTSB WPR17LA202Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Ogden, UTThe airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.Sep 12, 2017 · N9798L · Substantial damageNTSB DCA17LA183Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier CL 600 2C10 · McKellar, TNAn encounter with convective turbulence while maneuvering to avoid conflicting traffic.Aug 22, 2017 · N745SK · No damageNTSB DCA17LA173Accident · Serious injuriesLimited investigationFinal reportAirbus 330 · East Hampton, NYan inadvertent encounter with convective turbulence.Aug 5, 2017 · N276AY · No damageNTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.Jul 24, 2017 · N4216D · Substantial damageNTSB DCA17CA155Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer S A ERJ170-200LR · Minneapolis, MNAn encounter with convective turbulence.Jul 20, 2017 · N427YX · No damageNTSB DCA17CA123Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 132 · South Toledo Bend, TXan encounter with convective turbulence.May 22, 2017 · N512NK · No damageNTSB DCA17CA111Accident · Serious injuriesData collectionFinal reportAirbus A320 232 · Boston, MAan inadvertent encounter with convective turbulence.May 2, 2017 · N595JB · No damageNTSB DCA17CA101Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190 100 IGW · Orlando, FLan inadvertent encounter with convective turbulence, which resulted in a serious injury to a flight attendant.Apr 14, 2017 · N373JB · No damageNTSB WPR17FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-310P · Harrisburg, ORAn encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…Apr 7, 2017 · N123SB · DestroyedNTSB DCA17CA079Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TXan inadvertent encounter with convective turbulence.Mar 10, 2017 · N9615W · Minor damage