NTSB investigations, 2014
5 cases where NTSB found Convective turbulence.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 10 |
| 2010 | 6 |
| 2011 | 14 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 8 |
| 2016 | 9 |
| 2017 | 11 |
| 2018 | 7 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 3 |
| 2022 | 7 |
| 2023 | 10 |
| 2024 | 11 |
| 2025 | 11 |
| 2026 | 2 |
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\") = 2014
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032020'))
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") = 2014 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03032020')) 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 DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…NTSB DCA14LA060Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Kaycee, WYan encounter with severe mountain wave turbulence during cruise flight.NTSB DCA14CA036Accident · Serious injuriesData collectionFinal reportBoeing 757 232 · Atlanta, GAunexpected encounter with convective turbulence while the flight attendants were preparing for arrival.