NTSB investigations, 2021
14 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\") = 2021
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") = 2021 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 CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.NTSB DCA22LA012Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Lexington, VAThe airplane’s inadvertent encounter with convective turbulence.NTSB DCA21LA209Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 319-132 · Chicago, ILAn encounter with clear air turbulence.NTSB DCA21WA187Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Nice, ItalyNTSB DCA21LA176Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Miami, FLan inadvertent encounter with convective turbulence.NTSB DCA21LA164Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · New Orleans, LAAn inadvertent encounter with severe turbulence during cruise flight that caused a flight attendant to fall and fracture his ankle.NTSB DCA21WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Kolkata, IndiaNTSB ANC21LA043Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Cordova, AKAn encounter with mountain wave turbulence and windshear that exceeded the climb capability of the airplane and resulted in impact with terrain.NTSB DCA21WA143Accident · Serious injuriesClass 5 · ForeignBoeing 767 · Yesan, South KoreaNTSB DCA21LA109Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer EMB-145LR · Charlotte, NCan encounter with convective turbulence during descent.NTSB CEN21LA170Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Boerne, TXThe pilot’s failure to maintain control of the airplane during a full stop landing and the subsequent attempted go-around in turbulent conditions.NTSB DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachNTSB WPR21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46R-350T · Tehachapi, CAThe pilot’s encounter with mountain wave activity with severe turbulence, which resulted in a loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a preflight weather briefing.NTSB ERA21LA115Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 300 · Myrtle Beach, SCAn encounter with severe turbulence, which resulted in serious injury to an unseated passenger.