NTSB investigations, TX

151 cases where the sequence of events included Attempted remediation/recovery.

Cases, newest first

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\" = '060' 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.

NTSB CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.Dec 26, 2022 · N26625 · Substantial damageNTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.Dec 13, 2022 · N231GZ · Substantial damageNTSB CEN23LA052Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Del Rio, TXThe pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.Nov 22, 2022 · N968T · Substantial damageNTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.Oct 5, 2022 · N119TX · Substantial damageNTSB CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.Sep 10, 2022 · N25144 · Substantial damageNTSB 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.Jul 12, 2022 · N131WK · Substantial damageNTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.Jun 4, 2022 · N596JW · Substantial damageNTSB CEN22LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Port Bolivar, TXThe pilot’s failure to attain a proper soft field takeoff pitch attitude during takeoff that resulted in a runway excursion and subsequent impact with a canal.May 12, 2022 · N9380G · Substantial damageNTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.Jan 18, 2022 · N3735B · Substantial damageNTSB 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.Nov 10, 2021 · N3027W · Substantial damageNTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.Aug 19, 2021 · N55245 · Substantial damageNTSB CEN21LA269Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Corpus Christi, TXThe pilot’s failure to maintain directional control during the takeoff roll.Jun 14, 2021 · N7476J · Substantial damageNTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…Mar 6, 2021 · N3394V · Substantial damageNTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.Jun 3, 2020 · N3107R · Substantial damageNTSB 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.Apr 22, 2020 · N13005 · Substantial damageNTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.Apr 21, 2020 · N419TW · Substantial damageNTSB CEN20CA105Accident · No injuriesData collectionFinal reportRaf SE5A · Kingsbury, TXThe pilot's failure to maintain a proper landing flare, which resulted in a hard, bounced landing, and his subsequent loss of directional control, which resulted in a ground loop.Feb 27, 2020 · N685SE · Substantial damageNTSB CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.Feb 14, 2020 · N441KA · Substantial damageNTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.Feb 12, 2020 · N654CE · Substantial damageNTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.Jan 26, 2020 · N238SH · Substantial damageNTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.Jan 4, 2020 · N5573M · Substantial damageNTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.Nov 8, 2019 · N9925N · Substantial damageNTSB GAA19CA587Accident · No injuriesData collectionFinal reportBeech 36 · Lubbock, TXThe pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…Sep 25, 2019 · N5836B · Substantial damageNTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.Aug 31, 2019 · N55633 · Substantial damageNTSB CEN19LA245Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Water Valley, TXThe loss of helicopter performance for undetermined reasons.Jul 8, 2019 · N334DC · Substantial damageNTSB 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.Jun 24, 2019 · N8521T · Substantial damageNTSB GAA19CA317Accident · No injuriesData collectionFinal reportPiper PA 11 · Paducah, TXThe pilot's failure to maintain directional control during the landing on a road in crosswind conditions, which resulted in the airplane exiting the road and subsequently nosing over.Jun 5, 2019 · N78641 · Substantial damageNTSB GAA19CA299Accident · Minor injuriesData collectionFinal reportCirrus SR20 · San Antonio, TXThe pilot's inadequate approach, delayed decision to abort the landing, and failure to properly configure the flap setting for the initial climb during the attempted aborted landing, which resulted in impact with trees.May 31, 2019 · N902ES · Substantial damageNTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.May 23, 2019 · N1568J · DestroyedNTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.May 14, 2019 · N8159U · Substantial damageNTSB CEN19FA140Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Eagle Lake, TXThe non-instrument-rated pilot's decision to fly into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and a subsequent impact with terrain.May 11, 2019 · N713LA · DestroyedNTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.Apr 17, 2019 · N96671 · Substantial damageNTSB CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.Feb 15, 2019 · N737MC · Substantial damageNTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.Dec 29, 2018 · N6202M · Substantial damageNTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.Dec 27, 2018 · N17SJ · Substantial damageNTSB 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.Dec 20, 2018 · N8487X · Substantial damageNTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.Dec 15, 2018 · N923DJ · Substantial damageNTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 18, 2018 · N667J · Substantial damageNTSB 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.Oct 27, 2018 · N3973L · Substantial damageNTSB 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.Sep 1, 2018 · N212NA · Substantial damageNTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 27, 2018 · N1701Q · Substantial damageNTSB GAA18CA460Accident · No injuriesData collectionFinal reportCessna 172 · Grand Prairie, TXThe student pilot’s failure to maintain the runway centerline during takeoff with a crosswind.Jul 29, 2018 · N24144 · Substantial damageNTSB CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.Jul 21, 2018 · N3611Y · Substantial damageNTSB CEN18LA290Accident · Minor injuriesLimited investigationFinal reportBell 206 · Todd Mission, TXThe passenger’s inadvertent interference with the tail rotor pedals, which resulted in a loss of helicopter control during takeoff and the subsequent impact with terrain.Jul 20, 2018 · N352CT · Substantial damageNTSB GAA18CA393Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · San Saba, TXThe pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over.Jul 4, 2018 · N127VV · Substantial damageNTSB CEN18LA251Accident · No injuriesLimited investigationFinal reportRobinson R22 · Georgetown, TXA partial loss of engine power for reasons that could not be determined based on the available information, which resulted in an impact with terrain during the subsequent forced landing.Jul 2, 2018 · N830J · Substantial damageNTSB 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.May 19, 2018 · N427LS · Substantial damageNTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.May 11, 2018 · N833DW · DestroyedNTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.Mar 1, 2018 · N6699B · Substantial damageNTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.Nov 23, 2017 · N1780K · Substantial damage