NTSB investigations, 2021
11 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\") = 2021
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") = 2021 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 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 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 DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachNTSB ERA21LA115Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 300 · Myrtle Beach, SCAn encounter with severe turbulence, which resulted in serious injury to an unseated passenger.