NTSB investigations, TX
9 cases where the defining event was Windshear or thunderstorm.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 4 |
| 2014 | 1 |
| 2019 | 1 |
| 2026 | 1 |
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\" = 'TX' 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\" = '390')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '390') 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 CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.NTSB CEN19FA094Accident · 4 fatalField investigationFinal reportCessna T337 · Longview, TXThe noninstrument-rated pilot's improper decision to continue flight into convective weather conditions, which resulted in the airplane exceeding its maximum maneuvering speed and the subsequent in-flight breakup. Contributing to the accident was the pilot's…NTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…NTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.NTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.NTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…NTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…NTSB CEN11CA440Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Stonewall, TXThe loss of directional control during an off-field landing in gusting wind.NTSB CEN10CA318Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Brookshire, TXThe pilot's failure to maintain directional control during the landing roll.