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 CEN17LA330Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Pearsall, TXThe fatigue crack of an engine cylinder, which resulted in a partial loss of engine power.Aug 24, 2017 · N4532F · Substantial damageNTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.Aug 2, 2017 · N38HT · Substantial damageNTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…Jul 22, 2017 · N3119D · Substantial damageNTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.Jul 14, 2017 · N82629 · Substantial damageNTSB GAA17CA366Accident · No injuriesData collectionFinal reportBellanca 1730 · Burnet, TXThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing.Jun 24, 2017 · N575JH · Substantial damageNTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.May 13, 2017 · N616NG · Substantial damageNTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.Apr 11, 2017 · N92873 · Substantial damageNTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.Mar 3, 2017 · N2892Y · Substantial damageNTSB CEN17LA032Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Ingleside, TXThe pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.Oct 25, 2016 · N48182 · Substantial damageNTSB GAA16CA385Accident · No injuriesData collectionFinal reportRockwell International 114 · Munday, TXThe pilot's failure to maintain directional control during takeoff, which resulted in an aborted takeoff, runway excursion, collision with a fence, and substantial damage.Jun 13, 2016 · N5814N · Substantial damageNTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…Jun 11, 2016 · N6700J · Substantial damageNTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.Jun 6, 2016 · N10325 · DestroyedNTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.Mar 20, 2016 · N975MA · Substantial damageNTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.Mar 12, 2016 · N9309J · Substantial damageNTSB GAA16LA117Accident · No injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri · Beaumont, TXThe pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.Jan 30, 2016 · N503DS · Substantial damageNTSB CEN16LA039Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Alpine, TXThe pilot’s failure to maintain adequate rotor speed while maneuvering at low altitude, which resulted in a descent from which he was unable to recover. Contributing to the accident was the pilot's decision to conduct the flight at or near the helicopter's…Nov 13, 2015 · N449MC · Substantial damageNTSB GAA16CA024Accident · No injuriesData collectionFinal reportCessna 120 · McKinney, TXThe pilot's use of excessive brake input during the recovery from the ground loop, which resulted in a nose over.Oct 17, 2015 · N2099V · Substantial damageNTSB GAA16CA020Accident · No injuriesData collectionFinal reportBeech A36 · Jasper, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.Oct 6, 2015 · N4151Q · Substantial damageNTSB GAA16CA007Accident · Minor injuriesData collectionFinal reportBogle Absey C Breezy RLU-1 · Bryan, TXThe pilot's excessive descent rate, which resulted in a hard landing and substantial damage.Oct 5, 2015 · N477UC · Substantial damageNTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.Oct 5, 2015 · N174CD · Substantial damageNTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.Aug 10, 2015 · N6356Z · Substantial damageNTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.Jul 23, 2015 · N5542M · Substantial damageNTSB GAA15CA232Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Prairie Lea, TXThe pilot's failure to maintain rotor rpm, resulting in an uncontrolled descent and collision with trees.Jul 16, 2015 · N804DF · Substantial damageNTSB CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.Jul 3, 2015 · N2320U · Substantial damageNTSB GAA15CA154Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Eagle Lake, TXThe pilot's failure to secure the iPad during flight, resulting in an inadvertent cyclic input, and collision with terrain.Jun 25, 2015 · N842SH · Substantial damageNTSB CEN15LA215Accident · No injuriesLimited investigationFinal reportCessna 172 - H · Circleville, TXThe failure of the engine to regain normal power after a simulated engine failure due to carburetor icing, which resulted in a forced landing on muddy terrain and a subsequent nose-over.Mar 24, 2015 · N8282L · Substantial damageNTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.Mar 12, 2015 · N638J · Substantial damageNTSB CEN15CA134Accident · No injuriesData collectionFinal reportMaule MX 7-180 · Georgetown, TXThe pilot did not maintain control of the airplane while landing in gusting crosswind conditions.Jan 23, 2015 · N773MC · Substantial damageNTSB CEN14LA446Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 - D · Burnet, TXThe flight instructor’s failure to adequately supervise the student pilot and his decision to conduct training in an airplane without dual brakes, which resulted in the student pilot’s loss of directional control during initial taxi and subsequent impact with…Aug 5, 2014 · N44335 · Substantial damageNTSB CEN14LA259Accident · Serious injuriesLimited investigationFinal reportSibley Glasair · Midlothian, TXThe pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.May 24, 2014 · N4VX · DestroyedNTSB CEN14LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 - II · Menard, TXThe pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.Mar 23, 2014 · N44MD · Substantial damageNTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.Feb 18, 2014 · N13HP · DestroyedNTSB CEN13IA563Incident · Minor injuriesIncident investigationFinal reportPilatus PC-12/47E · Austin, TXThe pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…Sep 12, 2013 · N617BG · Minor damageNTSB CEN13LA531Accident · No injuriesLimited investigationFinal reportCessna/Weaver 305 - E · Paris, TXThe failure of a landing gear O-ring, which prevented the pilot from being able to maintain directional control of the airplane during landing.Aug 31, 2013 · N862 · Substantial damageNTSB CEN13LA523Accident · No injuriesLimited investigationFinal reportBell-Transworld Helicopter Cor 47G-2 · Wichita Falls, TXThe delayed remedial action by the flight instructor during a simulated autorotation, which resulted in a hard landing.Aug 28, 2013 · N8051E · Substantial damageNTSB CEN13LA380Accident · Minor injuriesLimited investigationFinal reportDiamond Aicraft Industries DA 20-C1 · Odessa, TXThe pilot's use of an improper flap setting and a subsequent inadequate flare of the airplane, which resulted in a bounced landing, and the pilot's delay in executing a go-around.Jun 27, 2013 · N322FS · Substantial damageNTSB CEN13IA285Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Dallas, TXThe failure of the airplane’s parachute to deploy when activated during a loss of control in cruise flight due to the dynamic maneuvering of the airplane at the time of the activation, which exceeded the parachute system’s certification requirements.May 16, 2013 · N715CD · No damageNTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.May 11, 2013 · N1752V · Substantial damageNTSB CEN13CA276Accident · No injuriesData collectionFinal reportBell 206-L4 · Fort Worth, TXThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing.May 10, 2013 · N2036F · Substantial damageNTSB CEN13LA147Accident · No injuriesLimited investigationFinal reportWebb Webb 2 · Gainsville, TXThe pilot’s failure to follow his test plan and abort the takeoff after inadvertently lifting off during a high speed taxi test. Contributing to the accident was the pilot’s lack of flight experience in the gyroplane.Jan 28, 2013 · N4844W · Substantial damageNTSB CEN13LA062Accident · 1 fatalLimited investigationFinal reportJabiru USA Sport J250-SP · Jacksonville, TXThe pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.Nov 18, 2012 · N635J · Substantial damageNTSB CEN12CA482Accident · No injuriesData collectionFinal reportNelson Miles Sky Star Kitfox · Weatherford, TXThe pilot's failure to maintain directional control during the landing flare. Contributing to the accident was the pilot’s delay in aborting the landing.Jul 25, 2012 · N4454U · Substantial damageNTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.Apr 25, 2012 · N510KW · Substantial damageNTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.Jul 20, 2011 · N3656X · Substantial damageNTSB CEN10CA120Accident · No injuriesData collectionFinal reportAviat A1 · Austin, TXThe pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.Feb 13, 2010 · N741MA · Substantial damageNTSB CEN09CA351Accident · No injuriesData collectionFinal reportBell 206B · Justin, TXThe instructor pilot's failure to add sufficient power early enough to compensate for the strong gusting headwinds.Jun 12, 2009 · N43791 · Substantial damageNTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.May 10, 2009 · N602DB · Substantial damageNTSB CEN09CA273Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's failure to maintain adequate main rotor rpm during a practice autorotation. Contributing to the accident was the instructor pilot's delayed remedial action.Apr 30, 2009 · N7519V · Substantial damageNTSB CEN09CA203Accident · No injuriesData collectionFinal reportBell 407 · Lancaster, TXThe failure of the pilot to maintain adequate main rotor rpm and the failure of the CFI to provide appropriate instruction during the maneuver.Feb 27, 2009 · N2592T · Substantial damageNTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.Feb 25, 2009 · N387AC · Substantial damage