NTSB investigations, TX
10 cases where NTSB found Turbulence, general.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2021 | 2 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032000'))
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" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03032000')) 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 DCA23LA196Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Dallas, TXThe flight’s encounter with convective turbulence.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 CEN21LA167Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Bridgeport, TXThe pilots’ failure to maintain adequate airspeed during a simulated power-off approach in gusting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and loss of control.NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB DCA17CA194Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD 90-30 · El Paso, TXan inadvertent encounter with turbulence.NTSB CEN17FA168Accident · 3 fatalClass 2 · FieldFinal reportPilatus PC 12 · Amarillo, TXThe pilot's loss of airplane control due to spatial disorientation during the initial climb after takeoff in night instrument meteorological conditions and moderate turbulence.NTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.NTSB DCA12LA091Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Winnie, TXthe flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.NTSB CEN11CA406Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Shepard, TXthe pilot's loss of aircraft control after encountering windshear and turbulence on takeoff.NTSB CEN09LA256Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · McAllen, TXThe injured passenger's failure to comply with the requirement to remain seated with a fastened seatbelt.