NTSB investigations
343 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '360') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '360') 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 DCA17CA042Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Denver, COAn inadvertent encounter with mountain wave turbulence.NTSB DCA17WA035Accident · Serious injuriesForeign investigationBoeing 777 · Lajes Terceira Island, PortugalThe government of Portugal has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on December 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…NTSB WPR17FA023Accident · 1 fatalField investigationFinal reportCessna 172N · Moss Beach, CAThe pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…NTSB DCA17WA029Accident · No injuriesForeign investigationBoeing 767 · Kagoshima, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767, which occurred on November 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…NTSB DCA16WA230Accident · Serious injuriesForeign investigationBoeing 737 · Lores, NetherlandsThe Dutch Safety Board (DSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on September 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DSB's investigation under the provisions of ICAO Annex 13 as…NTSB DCA16CA220Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · International Waters, A1an inadvertent encounter with severe convective turbulence.NTSB DCA16CA214Accident · Serious injuriesData collectionFinal reportBoeing 737 924 · Waco, TXan encounter with convective turbulence.NTSB DCA16IA215Incident · Minor injuriesIncident investigationFinal reportAirbus A320 232 · Wood, SDan inadvertent encounter with convective turbulence while in cruise flight.NTSB DCA16CA209Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Grand Cayman Island (GCM), Cayman Islandsan inadvertent encounter with clear air turbulence.NTSB DCA16CA205Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Bermuda, Bermudaan inadvertent encounter with clear air turbulence.NTSB DCA16CA208Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Cleveland, OHan inadvertent encounter with turbulence.NTSB DCA16CA202Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Jamaica, NYan encounter with convective turbulence that resulted in a flight attendant injury.NTSB DCA16CA182Accident · Serious injuriesData collectionFinal reportBoeing 737-932ER · Las Vegas, NVAn encounter with wake turbulence that resulted in a flight attendant injury.NTSB WPR16LA114Accident · Serious injuriesLimited investigationFinal reportMichael Burton Calidus · Fruitland, UTThe pilot's improper judgment in conducting a flight in a gyroplane over mountainous terrain near its demonstrated maximum operating altitude and his subsequent failure to maintain adequate clearance with terrain during cruise flight in turbulent weather…NTSB DCA16CA153Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 214 · Philadelphia, PAan inadvertent encounter with clear air turbulence that resulted in a serious injury to a flight attendant.NTSB ERA16LA137Accident · No injuriesLimited investigationFinal reportBeech 99 · Rockland, METhe airplane’s encounter with isolated severe turbulence, which resulted in substantial airframe damage.NTSB DCA16CA089Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 132 · Minneapolis, MNan encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.NTSB DCA16CA077Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Titusville, FLan inadvertent encounter with clear air turbulence.NTSB DCA16CA041Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Raleigh, NCan encounter with turbulence resulting in a serious injury to a flight attendant.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…NTSB DCA16CA052Accident · Serious injuriesData collectionFinal reportBoeing 737 76N · San Diego, CAAn inadvertent encounter with clear air turbulence.NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.NTSB DCA16CA030Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Great Falls, MTan encounter with turbulence during initial descent.NTSB DCA16CA026Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · St Louis, MOan inadvertent encounter with clear air turbulence.NTSB DCA16CA023Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 112 · Philadelphia, PAan inadvertent encounter with clear air turbulence.NTSB DCA16CA021Accident · Serious injuriesData collectionFinal reportBoeing 787 · Beaumont, TXAn inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.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.NTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.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…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…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.NTSB DCA15CA131Accident · Serious injuriesData collectionFinal reportBombardier CL600 2D24 · McCook, NEinadvertent encounter with turbulence while deviating around an area of known convective activity.NTSB DCA15CA136Accident · Serious injuriesData collectionFinal reportBoeing 777 - 236 · Windsor Locks, CTan inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.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.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…NTSB DCA15LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Honolulu (Pacific Ocean)an encounter with convective turbulence associated with a forecasted area of thunderstorms.NTSB WPR15CA110Accident · No injuriesData collectionFinal reportRaytheon B300 · Mammoth Lakes, CAThe airplane encountered extreme turbulence during descent.NTSB DCA15WA041Accident · Serious injuriesForeign investigationBoeing 777 223 · Ishikawa, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…NTSB DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.NTSB DCA15WA002Accident · Serious injuriesForeign investigationBoeing 777 223 · Buenos Aires, ArgentinaNTSB DCA15WA039Accident · No injuriesForeign investigationBoeing 737-700 · Belo Horizonte, BrazilThe Aeronautical Accident Investigation and Prevention Center (CENIPA) of Brazil has notified the NTSB of an accident involving a Boeing 737-700 that occurred on September 25, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB DCA14WA160Incident · No injuriesForeign investigationEmbraer EMB 145LR · London, CanadaThe TSB of Canada has notified the NTSB of an accident involving a Embraer EMB145LR airplane that occurred on September 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the TSB-Canada's investigation under the provisions of ICAO…NTSB ANC14CA047Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's encounter with a wind gust during takeoff from a short gravel bar, which resulted in the airplane settling after rotation and striking obstacles.NTSB DCA14WA176Accident · Serious injuriesForeign investigationBoeing Boeing 737-8AS · Tarragona, SpainThe CIAIAC of Spain has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on June 23, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…NTSB ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.NTSB OPS14IA007Incident · Minor injuriesIncident investigationFinal reportBoeing 757 · Powhatan, VAThe air traffic controller’s failure to provide required advisories about significant radar-observed convective precipitation along both airplanes’ flight routes and the air route traffic control center’s lack of a program to ensure that air traffic…NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…NTSB DCA14WA104Incident · No injuriesForeign investigationBoeing 767-300 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 767-300 that occurred on March 19, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…NTSB DCA14WA088Accident · Serious injuriesForeign investigationBoeing 737-800 · En route, United KingdomThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an accident involving a Boeing 737-800 that occurred on March 9, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…