NTSB investigations, 2012
4 cases where NTSB found Terrain induced turbulence.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 4 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032010'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03032010')) 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 CEN13CA026Accident · Minor injuriesData collectionFinal reportMace Justin I Dragonfly · Durango, COThe pilot’s delayed decision to perform a go-around, which resulted in the airplane impacting trees. Contributing to the accident was the pilot’s inexperience in the accident airplane and his encounter with conditions that exceeded his capabilities.NTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.NTSB WPR12LA205Accident · Serious injuriesLimited investigationFinal reportInfinity 2000 · Hurricane, UTThe pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.NTSB DCA12CA062Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-132 · Buena Vista, COan inadvertent encounter with mountain wave turbulence.