NTSB investigations, 2012
22 cases where the defining event was Turbulence encounter.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 15 |
| 2010 | 9 |
| 2011 | 22 |
| 2012 | 22 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 18 |
| 2016 | 19 |
| 2017 | 16 |
| 2018 | 18 |
| 2019 | 24 |
| 2020 | 13 |
| 2021 | 11 |
| 2022 | 18 |
| 2023 | 22 |
| 2024 | 31 |
| 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\") = 2012
AND 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 year(c."eventDate") = 2012 AND 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 DCA12CA149Accident · Serious injuriesData collectionFinal reportAirbus Industrie A330-323 · Sophia, NCan encounter with moderate turbulence while the flight attendant was securing the cabin for arrival.NTSB WPR12LA428Accident · Minor injuriesLimited investigationFinal reportRockwell International 690A · Ellensburg, WAThe pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.NTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…NTSB ERA12LA498Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Hilton Head, SCThe passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path.NTSB ERA12WA457Accident · 2 fatalForeign investigationBeech B36TC · Nassau, BahamasNTSB DCA12WA109Accident · Serious injuriesForeign investigationBoeing 777-222 · Narita, JapanNTSB DCA12WA108Accident · Serious injuriesForeign investigationBoeing 747-400 · Tokyo, JapanOn July 5, 2012, a Boeing 747-400, HL7473, operated by Korean Air Lines Co., Ltd., as flight KAL2711, departed from the Gimpo International Airport (GMP), Seoul, South Korea, en route to the Tokyo International Airport (HND), Tokyo, Japan. Approximately 100…NTSB DCA12WA104Accident · Serious injuriesForeign investigationBoeing 737 · Frankfurt, GermanyOn 5 July, 2012, at approximately 1100 UTC, a SunExpress Deutschland B737-800, registration D-ASXE, encountered turbulence during cruise between Gaziantep, Turkey, and Frankfurt, Germany. Of the 86 passengers and crew onboard, one crew member received serious…NTSB CEN12CA403Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Minden, NEThe pilot’s failure to maintain clearance from the wake turbulence from a previous pass.NTSB DCA12LA091Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Winnie, TXthe flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.NTSB DCA12CA088Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320-212 · Minneapolis, MNInadvertent encounter with convective turbulence while in descent.NTSB DCA12CA086Accident · Serious injuriesData collectionFinal reportBoeing 757 2B7 · Philadelphia, PAan inadvertent encounter with convective turbulence.NTSB DCA12WA081Accident · No injuriesForeign investigationBoeing 737-800 · Dusseldorf, GermanyThe German Federal Bureau of Aircraft Accidents (BFU) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the provisions of…NTSB DCA12FA069Accident · Serious injuriesField investigationFinal reportAirbus A319-112 · Fort Lauderdale, FLan inadvertent encounter with convectively induced turbulence developing upwards into the flight path, which was not detected on weather radar as configured by the crew. Contributing to the delay in emergency medical personnel notification was the incomplete…NTSB DCA12CA062Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-132 · Buena Vista, COan inadvertent encounter with mountain wave turbulence.NTSB WPR12LA149Accident · Serious injuriesLimited investigationFinal reportPowrachute Sky Rascal · Indio, CAThe operation of an airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot's failure to maintain clearance from powerlines during initial climb in gusty wind conditions.NTSB WPR12LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Laverne, OKThe airplane’s encounter with severe turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB DCA12CA059Accident · Serious injuriesData collectionFinal reportBombardier CL-600-2B19 · Harrisburg, PAan inadvertent encounter with clear air turbulence during descent.NTSB DCA12FA046Accident · Serious injuriesField investigationFinal reportAirbus A321 · Millville, NJan encounter with convective turbulence that resulted in injury to a passenger who was not seated when the seatbelt sign was illuminated.NTSB WPR12LA119Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Pawnee, NEThe airplane's encounter with moderate turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.NTSB DCA12CA033Accident · Serious injuriesData collectionFinal reportAntonov AN124 · Anchorage, AKan inadvertent encounter with Clear Air Turbulence that resulted in serious injuries to two crewmembers.