NTSB investigations, TX
123 cases where the sequence of events included Other weather encounter.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 7 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 8 |
| 2015 | 6 |
| 2016 | 17 |
| 2017 | 6 |
| 2018 | 15 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 7 |
| 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\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB CEN26LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Pottsboro, TXThe pilot’s failure to maintain control during the landing roll with a crosswind.NTSB CEN25LA228Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Ben Bolt, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Sweetwater, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna P206 · Frankston, TXThe pilot’s failure to maintain directional control during the landing with a gusting crosswind.NTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.NTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.NTSB CEN24LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Weslaco, TXThe student pilot’s failure to maintain control of the airplane during landing.NTSB CEN24LA292Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Lewisville, TXThe pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.NTSB CEN24LA165Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Olney, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB CEN24LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Ben Wheeler, TXThe pilot’s failure to maintain control while landing in a gusting wind.NTSB CEN24LA132Accident · No injuriesClass 4 · LimitedFinal reportPietenpol Aircamper · Lockhart, TXThe pilot’s failure to maintain control during after takeoff.NTSB CEN24LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Dalhart, TXThe total loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…NTSB CEN24LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Denton, TXThe student pilot’s failure to maintain directional control while landing with a tailwind.NTSB CEN23LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 182T · Klein, TXThe pilot’s failure to maintain directional control during the crosswind landing.NTSB CEN23LA378Accident · No injuriesClass 4 · LimitedFinal reportPiper J4 · Cleburne, TXThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions.NTSB CEN23LA356Accident · No injuriesClass 4 · LimitedFinal reportVans JV-Special / RV8 · Roanoke, TXThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB CEN23LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Grand Prairie, TXThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the unexpected sudden wind shift.NTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.NTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.NTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA207Accident · No injuriesClass 4 · LimitedFinal reportBellanca Cruisemaster · Gainesville, TXThe pilot’s failure to extend the landing gear before landing due to his distraction with the wind gusts.NTSB CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.NTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.NTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.NTSB CEN21LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Austin, TXThe pilot’s failure to maintain directional control while turning onto the taxiway in variable wind conditions.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB GAA19CA389Accident · No injuriesData collectionFinal reportCessna 152 · Paris, TXThe student pilot's failure to maintain the runway heading during takeoff with a crosswind, which resulted in impact with a hay bale left of the runway, and his improper decision to perform a soft-field takeoff without adequate practice.NTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.NTSB GAA19CA250Accident · No injuriesData collectionFinal reportBell 47G · Denton, TXThe flight instructor's improper decision to instruct the student pilot to establish a hover and reposition the helicopter with a tailwind, which resulted in the student pilot's loss of pitch control.NTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.NTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB CEN19LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXThe pilot's failure to apply carburetor heat while operating in an area conducive to carburetor icing, which resulted in a total loss of engine power on approach and subsequent forced landing into a creek.NTSB GAA19CA019Accident · No injuriesData collectionFinal reportChampion 7ECA · Cleveland, TXThe pilot’s failure to maintain directional control while landing in a gusting crosswind conditions.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 GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA287Accident · No injuriesData collectionFinal reportMaule M 7 · Burnet, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions and with an incorrect flap configuration.