NTSB investigations, 2020
17 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\") = 2020
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") = 2020 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 DCA21LA058Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXan encounter with forecasted convective turbulence during approach.NTSB DCA21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777 · Anchorage, AKThe airplane’s encounter with severe turbulence while flying over a mountain range during cruise.NTSB WPR20CA276Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Hillsboro, ORThe pilot’s failure to maintain altitude on short final due to an encounter with a down draft and the flight instructor's delayed remedial action.NTSB DCA20WA131Accident · Serious injuriesForeign investigationBoeing 737 · Durban, South AfricaThe CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…NTSB WPR20LA216Accident · 1 fatalClass 3 · LimitedFinal reportSchleicher ASW27 · Ely, NVThe pilot’s loss of glider control while maneuvering near a mountain ridge in downdrafts and dry microbursts at an altitude that precluded recovery.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.