NTSB investigations
423 cases where the sequence of events included 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 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 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 WPR20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Creation/Sides Rick A Manta 503 · Ramona, CAThe solo student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB DCA22LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Orlando, FLAn encounter with moderate turbulence during descent.NTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…NTSB DCA20WA110Accident · Serious injuriesForeign investigationBoeing 737 · Matsuyama, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on April 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20LA127Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28R · Pleasant Plain, OHThe pilot’s encounter with convective turbulence and low-level wind shear in dark night instrument meteorological conditions that resulted in spatial disorientation and the loss of airplane control.NTSB DCA20WA086Accident · Serious injuriesForeign investigationBoeing 737 · Incheon, North KoreaThe government of Korea, Democratic People's Republic Of has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea,…NTSB DCA20CA071Accident · Serious injuriesClass 4 · Data collectionFinal reportBombardier CL-600-2D24 · Waynesville, NCAn encounter with severe convective turbulence associated with a strong sheared environment associated with the jet stream.NTSB DCA20WA070Accident · Serious injuriesForeign investigationAirbus A380 · Los Angeles, CAThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has informed the NTSB of an accident involving an Airbus A-380, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist the GCAA investigation…NTSB DCA20WA051Accident · Serious injuriesForeign investigationBoeing 737 · Fukuoka, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB DCA20CA058Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · New Orleans, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB WPR20CA069Accident · Serious injuriesData collectionFinal reportGulfstream G IV · Van Nuys, CAThe airplane’s encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB DCA20CA043Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ190 · Disputanta, VAan encounter with clear air turbulence during cruise flight.NTSB DCA20CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB 135KL · Alexandria, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB DCA20CA040Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB145 · Philadelphia, PAAn inadvertent encounter with convective turbulence.NTSB ANC20FA005Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Blythe, CAA loss of control in flight due to the pilot’s decision to fly into a mountain range, at night, in conditions conducive to high wind, mountain waves, and turbulence.NTSB DCA20WA012Incident · No injuriesForeign investigationBoeing 737 · Malta, MaltaThe AAIU of Ireland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU of Ireland's investigation under the provisions of ICAO…NTSB DCA19CA213Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Fort Myers, FLan encounter with convectively induced turbulence associated with towering cumulus clouds during descent.NTSB DCA19CA208Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Chicago, ILan encounter with convective turbulence during descent.NTSB DCA19CA206Accident · Serious injuriesData collectionFinal reportAirbus A320 · Denver, COan encounter with mountain wave turbulence.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 WPR19LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Ontario, CAA partial loss of engine power during descent due to an incorrectly installed carburetor.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…