Skip to content

NTSB investigations, 2015

23 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") = 2015 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\") = 2015
    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") = 2015
  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 DCA16WA040Incident · No injuriesForeign investigationBoeing 777-333ER · Calgary, CanadaThe NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…Dec 31, 2015 · C-FRAM · No damage NTSB GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.Dec 28, 2015 · N9083U · Substantial damage NTSB DCA16CA052Accident · Serious injuriesData collectionFinal reportBoeing 737 76N · San Diego, CAAn inadvertent encounter with clear air turbulence.Dec 26, 2015 · N7733B · No damage NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.Dec 12, 2015 · N784AN · No damage NTSB DCA16CA030Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Great Falls, MTan encounter with turbulence during initial descent.Dec 10, 2015 · N3014R · No damage NTSB DCA16CA026Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · St Louis, MOan inadvertent encounter with clear air turbulence.Nov 29, 2015 · N467WN · No damage NTSB DCA16CA023Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 112 · Philadelphia, PAan inadvertent encounter with clear air turbulence.Nov 23, 2015 · N725UW · No damage NTSB DCA16CA021Accident · Serious injuriesData collectionFinal reportBoeing 787 · Beaumont, TXAn inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.Nov 7, 2015 · N27958 · No damage NTSB DCA16CA010Accident · Serious injuriesData collectionFinal reportBoeing 737-924ER · Plevna, KSAn inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.Oct 24, 2015 · N69838 · No damage NTSB GAA16CA030Accident · No injuriesData collectionFinal reportMcpherson John G Pietenpol Aircamper · Placerville, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and an impact with terrain.Oct 23, 2015 · N169JG · Substantial damage NTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…Oct 11, 2015 · N4485D · Destroyed NTSB GAA16CA003Accident · Minor injuriesData collectionFinal reportBushmaster Super Bushmaster · Marble Canyon, AZThe pilot's failure to maintain descent rate durring the landing resulting in collision with terrain.Oct 4, 2015 · C-FIIB · Substantial damage NTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.Oct 1, 2015 · N9026C · No damage NTSB OPS15IA020Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 211 · Max, NEThe flight crew's continued flight into a closing gap between areas of thunderstorm activity and their failure to maintain the required lateral separation from the thunderstorms, which resulted in the airplane's encounter with hail and subsequent airplane…Aug 8, 2015 · N332NW · Minor damage NTSB WPR15LA239Accident · Serious injuriesLimited investigationFinal reportEmbraer E175 · South Lake Tahoe, CAThe airplane's encounter with moderate turbulence during descent, which resulted in a serious injury to a flight attendant who was not securely seated. Contributing to the accident was the flight attendant's decision to continue to secure items before the…Aug 7, 2015 · N204NN · No damage NTSB ANC15CA051Accident · No injuriesData collectionFinal reportCessna 140 · Homer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.Jul 14, 2015 · N72784 · Substantial damage NTSB DCA15CA131Accident · Serious injuriesData collectionFinal reportBombardier CL600 2D24 · McCook, NEinadvertent encounter with turbulence while deviating around an area of known convective activity.Jun 10, 2015 · N246LR · No damage NTSB DCA15CA136Accident · Serious injuriesData collectionFinal reportBoeing 777 - 236 · Windsor Locks, CTan inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.May 27, 2015 · G-VIIY · No damage NTSB GAA15CA051Accident · No injuriesData collectionFinal reportPiper PA 32R-300 · Gatlinburg, TNThe pilot's encounter with extreme turbulence during descent over mountainous terrain, which resulted in a loss of control, and structural damage in flight.Apr 26, 2015 · N2269M · Substantial damage NTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.Apr 5, 2015 · N27QV · Substantial damage NTSB DCA15WA080Accident · Serious injuriesForeign investigationBoeing 737 - 8AS · Bordeaux, FranceThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist…Feb 25, 2015 · EI-DAC · No damage NTSB DCA15LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Honolulu (Pacific Ocean)an encounter with convective turbulence associated with a forecasted area of thunderstorms.Feb 15, 2015 · N59053 · No damage NTSB WPR15CA110Accident · No injuriesData collectionFinal reportRaytheon B300 · Mammoth Lakes, CAThe airplane encountered extreme turbulence during descent.Feb 10, 2015 · N49WC · Substantial damage