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.
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
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 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.NTSB 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.NTSB 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…NTSB 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.NTSB GAA17CA366Accident · No injuriesData collectionFinal reportBellanca 1730 · Burnet, TXThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN15CA134Accident · No injuriesData collectionFinal reportMaule MX 7-180 · Georgetown, TXThe pilot did not maintain control of the airplane while landing in gusting crosswind conditions.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.NTSB 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.NTSB 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.NTSB 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.