NTSB investigations, 2016
28 cases where the sequence of events included Turbulence encounter.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 21 |
| 2010 | 17 |
| 2011 | 27 |
| 2012 | 28 |
| 2013 | 13 |
| 2014 | 20 |
| 2015 | 23 |
| 2016 | 28 |
| 2017 | 18 |
| 2018 | 22 |
| 2019 | 24 |
| 2020 | 17 |
| 2021 | 14 |
| 2022 | 19 |
| 2023 | 25 |
| 2024 | 40 |
| 2025 | 25 |
| 2026 | 22 |
Where
Open the mapLatest 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\") = 2016
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") = 2016 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 DCA17CA042Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Denver, COAn inadvertent encounter with mountain wave turbulence.NTSB ERA17FA066Accident · 1 fatalField investigationFinal reportFairchild SA227 · Camilla, GAThe pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.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 ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…NTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…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 GAA16CA461Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Sedona, AZThe pilot’s failure to maintain directional control during the landing in gusting wind conditions, which resulted in a runway excursion.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 WPR16FA144Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA40 F · Logan, UTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in turbulence and gusty wind conditions, which resulted in an aerodynamic stall/spin.NTSB DCA16CA197Accident · No injuriesData collectionFinal reportFacebook UK Aquila · Yuma, AZa structural failure of the wing as a result of exceeding the airspeed envelope due to wind gusts which were beyond the capabilities of the autopilot. Contributing to the accident was an insufficient amount of drag to track the glideslope in the presence of…NTSB WPR16FA130Accident · 2 fatalField investigationFinal reportRobinson Helicopter R66 · Wikieup, AZAn encounter with turbulence due to updrafts and/or dust devils that resulted in mast bumping and an in-flight break-up.NTSB ERA16CA246Accident · No injuriesData collectionFinal reportMooney M20 · Clifton, TNThe flight's encounter with unforecast extreme turbulence, which resulted in a loss of airplane control and structural damage.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 GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.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.