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 DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB CEN19LA266Accident · Serious injuriesClass 3 · LimitedFinal reportCanadair CL600 2B16 · Lubbock, TXThe unexpected wake turbulence encounter while climbing in smooth air to cruise, resulting in passenger injuries. Contributing to the accident was the passenger seat belt sign was off.NTSB DCA19CA189Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · San Juan, PRAn encounter with convective turbulence during cruise flight.NTSB CEN19LA188Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 560 · Janesville, WIThe passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.NTSB WPR19LA170Accident · Serious injuriesClass 3 · LimitedFinal reportJames Experimental Cub · Stanley, IDOverstress failure of the right-wing spar due to an encounter with turbulence.NTSB DCA19CA151Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737-8H4 · Waycross, GAan encounter with convectively induced turbulence while penetrating cumulus clouds during descent.NTSB DCA19WA172Accident · Serious injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe ARAIB of Korea has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB's investigation under the provisions of ICAO Annex 13 as State…NTSB GAA19CA245Accident · No injuriesData collectionFinal reportErcoupe 415 C · Rosendale, WIThe pilot's selection of unsuitable terrain for an off-airport precautionary landing, which resulted in impact with a fence and a nose-over.NTSB DCA19WA222Accident · Serious injuriesForeign investigationBoeing 737 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…NTSB DCA19CA088Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 777 · Honolulu, HIthe airplanes encounter with clear air turbulence.NTSB DCA19CA091Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Franklin, TNan encounter with convective turbulence during descent.NTSB DCA19WA082Incident · No injuriesForeign investigationBoeing 737 · Albania, AlbaniaThe government of Albania has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Albania's investigation under the provisions…NTSB DCA19CA081Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Reno, NVan inadvertent encounter with convective turbulence that resulted in a TCAS RA, which required an abrupt control input by the flight crew to resolve the conflict.NTSB ANC19TA014Accident · Serious injuriesClass 3Final reportPiper PA32R · Anchorage, AKThe pilot’s failure to ensure that the passenger’s lap belt was appropriately fastened for the forecast turbulent conditions, and the passenger’s failure to tighten her lap belt appropriately, which resulted in the passenger’s serious injury during an…NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.NTSB CEN19WA077Accident · 2 fatalForeign investigationRans S12 · Bavispe, MexicoNTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.NTSB DCA19CA037Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · LAS Vegas, NVThe airplane’s encounter with severe turbulence.NTSB ERA19LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 690 · Myrtle Beach, SCAn encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.NTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.NTSB DCA19CA207Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Albany, NYan encounter with convective turbulence that resulted in a serious injury to a flight attendant.NTSB DCA19CA010Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Denver, COinadvertent encounter with clear air turbulence resulting in a flight attendant receiving serious injuries.NTSB ANC18LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot's failure to avoid wake turbulence from a crossing heavy airplane.NTSB DCA18WA296Incident · Minor injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA18CA303Accident · No injuriesClass 4 · Data collectionFinal reportEmbraer EMB120 · 40 nm vicinity south of Lake Jackson, TXan encounter with severe turbulence, which caused the improperly secured cargo to shift and damage the airplane floor structure.NTSB DCA18WA313Incident · No injuriesForeign investigationHarbin Y12 · Antioq, ColombiaThe Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an incident involving a HAIC Harbin Y12E, which occurred on August 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…NTSB DCA18CA316Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · West Palm Beach, FLAn inadvertent encounter with convective turbulence.NTSB DCA18CA251Accident · Serious injuriesClass 4 · Data collectionFinal reportMcdonnell Douglas MD88 · Charlotte, NCAn inadvertent encounter with convective turbulence.NTSB DCA18WA238Incident · Minor injuriesForeign investigationAirbus A330 · Gander, CanadaThe government of Canada has notified the NTSB of an accident involving a Airbus A330 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA18CA255Accident · Serious injuriesData collectionFinal reportEmbraer ERJ175 · Cut Bank, MTan unexpected encounter with clear air turbulence.NTSB DCA18CA201Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Decatur, TXthe passengers failure to comply with the fasten seatbelt sign when the airplane encountered convective turbulence.NTSB ERA18LA112Accident · Serious injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G V · Miami, FLThe passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter.NTSB DCA18CA102Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A330 323 · Minneapolis, MNan inadvertent encounter with clear air turbulence.NTSB WPR18FA073Accident · 1 fatalField investigationFinal reportPiper PA 23-250 · Elko, NVThe pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.NTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.NTSB DCA18WA027Accident · Serious injuriesForeign investigationBoeing 757 224 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State…NTSB DCA18WA017Accident · Serious injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on October 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions of ICAO Annex 13 as the…NTSB WPR17FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Perkinsville, AZThe pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.NTSB DCA17WA198Accident · Serious injuriesForeign investigationBoeing 737 · Adelaide, AustraliaThe ATSB of Australia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…NTSB DCA17CA194Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD 90-30 · El Paso, TXan inadvertent encounter with turbulence.NTSB DCA17LA183Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier CL 600 2C10 · McKellar, TNAn encounter with convective turbulence while maneuvering to avoid conflicting traffic.NTSB DCA17LA173Accident · Serious injuriesLimited investigationFinal reportAirbus 330 · East Hampton, NYan inadvertent encounter with convective turbulence.NTSB DCA17WA174Accident · Serious injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) Ministry of Transport of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA17CA155Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer S A ERJ170-200LR · Minneapolis, MNAn encounter with convective turbulence.NTSB DCA17CA123Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 132 · South Toledo Bend, TXan encounter with convective turbulence.NTSB DCA17CA111Accident · Serious injuriesData collectionFinal reportAirbus A320 232 · Boston, MAan inadvertent encounter with convective turbulence.NTSB 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.NTSB DCA17CA079Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TXan inadvertent encounter with convective turbulence.NTSB DCA17CA071Accident · Serious injuriesData collectionFinal reportBombardier DHC 8 311 · Dulles, VAan inadvertent encounter with clear air turbulence.NTSB DCA17WA139Accident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-800, which occurred on January 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…