NTSB investigations, TX
116 cases where the sequence of events included Collision during takeoff/land.
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\" = '490' 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" = '490' 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 CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.NTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB CEN20CA129Accident · No injuriesData collectionFinal reportPiper PA18 · Canyon, TXThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch and the left main landing gear collapsing.NTSB CEN20CA104Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Athens, TXThe rear seat pilot and the student pilot's failure to see and avoid trees during initial climb following an aborted landing.NTSB CEN20LA066Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Charlotte, TXThe pilot's failure to maintain clearance from a powerline during landing.NTSB 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.NTSB CEN20LA037Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Beeville, TXThe solo student pilot's improper cyclic input during takeoff, which resulted in dynamic rollover.NTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.NTSB 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.NTSB 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.NTSB CEN19LA153Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 8KCAB · Fredericksburg, TXA total loss of engine power due to fuel exhaustion.NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB 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.NTSB CEN18LA341Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Granbury, TXThe pilot’s failure to maintain directional control during a crosswind landing, which resulted in the airplane exiting the runway and impacting a ditch, tree, and fence.NTSB 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.NTSB 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.NTSB CEN18FA244Accident · 1 fatalField investigationFinal reportRobinson R22 · Sterling City, TXA loss of control during the landing approach for reasons that could not be determined based on the available information.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.NTSB CEN18LA002Accident · Serious injuriesLimited investigationFinal reportCharles A Brazil MTO Sport · McCoy, TXThe pilot’s failure to maintain clearance from a powerline during landing.NTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.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 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 GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.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 CEN15LA376Accident · 1 fatalLimited investigationFinal reportSchleicher ASW 20 · Hempstead, TXThe pilot’s failure to maintain clearance from power lines during an attempted off-airport landing.NTSB CEN15LA350Accident · Minor injuriesLimited investigationFinal reportJal R Dennis Trixy Princess · Midland, TXThe pilot's inadequate preflight planning during which he failed to account for the high-density altitude conditions and high gross weight, which degraded the gyroplane's climb performance and resulted in a hard landing.NTSB CEN15LA266Accident · Serious injuriesLimited investigationFinal reportHunziker Eros 1650R · Quitman, TXThe pilot's failure to maintain adequate airspeed for the approach to landing.NTSB CEN15LA247Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon G36 · Horseshoe Bay, TXThe pilot’s failure to abort the takeoff after the partial loss of engine power before liftoff, and the partial loss of engine power for undetermined reasons.NTSB CEN15LA212Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Smithville, TXThe noncertificated pilot's loss of directional control during takeoff, which resulted in impact with a utility pole and hangar. Contributing to the accident was the pilot's failure to obtain flight instruction before attempting to fly the aircraft.NTSB CEN15LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-500 · Sugarland, TXThe pilot's engagement of the emergency parking brake during the landing roll, which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the pilot's decision to engage the emergency parking…NTSB CEN14LA527Accident · 1 fatalLimited investigationFinal reportButcher Russell A RV9A · Shepherd, TXThe pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…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 CEN14CA023Accident · No injuriesData collectionFinal reportCessna 172R · Tomball, TXThe student pilot delay in aborting the takeoff which resulted in the airplane going off the end of the runway and impacting trees.NTSB CEN13CA303Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TXThe pilot's delay to not perform a go-around when he lost sight of the runway while on final approach to land at night. Contributing to the accident was the obscuration (tall grass) of the runway edge lights.NTSB CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.NTSB CEN13CA022Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Loop, TXThe pilot’s inadequate performance calculations, which resulted in an overweight takeoff for the conditions and the subsequent hard impact with terrain.NTSB CEN12FA654Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Roanoke, TXThe loss of engine power during takeoff due to fuel contamination. Contributing to the accident was maintenance personnel's failure to adequately correct the water contamination effects. Contributing to the severity of the occupants' injuries was the lack of…NTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.NTSB CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.NTSB CEN12LA229Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · San Marcos, TXThe pilot's failure to ensure that he was aware of the NOTAM describing the runway closure, which resulted in a landing on the closed runway and subsequent collision with a barrier. Contributing to the accident was the failure of air traffic control personnel…NTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.NTSB CEN12CA085Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Bulverde, TXThe pilot's improper glidepath while on final approach.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 CEN11CA126Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Hemphill, TXThe student pilot’s improper decision to carry an unauthorized passenger and the passenger’s loss of control of the helicopter during take-off.NTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.