NTSB investigations, CO
12 cases where the defining event was Turbulence encounter.
Cases per year
| 2012 | 1 |
|---|---|
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2026 | 2 |
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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' 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 DCA26LA270Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A321-231 · Somerset, CONTSB DCA26WA249Occurrence · No injuriesClass 5 · ForeignAirbus Canada BD500 · Berthoud, CONTSB DCA23LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COThe flight’s encounter with mechanical turbulence.NTSB DCA23LA008Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COAn encounter with clear air turbulence during cruise flight.NTSB DCA22LA196Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Denver, COAn encounter with clear air turbulence, which resulted in a serious injury as a flight attendant was lowering her jumpseat.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 DCA19CA206Accident · Serious injuriesData collectionFinal reportAirbus A320 · Denver, COan encounter with mountain wave turbulence.NTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.NTSB DCA19CA010Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Denver, COinadvertent encounter with clear air turbulence resulting in a flight attendant receiving serious injuries.NTSB DCA17CA042Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Denver, COAn inadvertent encounter with mountain wave turbulence.NTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.NTSB DCA12CA062Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-132 · Buena Vista, COan inadvertent encounter with mountain wave turbulence.