NTSB investigations, 2015, TX
59 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 56 |
|---|---|
| 2009 | 32 |
| 2010 | 49 |
| 2011 | 58 |
| 2012 | 59 |
| 2013 | 49 |
| 2014 | 53 |
| 2015 | 59 |
| 2016 | 68 |
| 2017 | 44 |
| 2018 | 64 |
| 2019 | 53 |
| 2020 | 31 |
| 2021 | 20 |
| 2022 | 22 |
| 2023 | 21 |
| 2024 | 20 |
| 2025 | 14 |
| 2026 | 14 |
Where
Latest 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 year(c.\"eventDate\") = 2015
AND 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\" = '470' 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 year(c."eventDate") = 2015 AND 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" = '470' 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 GAA16CA083Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Friendswood, TXThe student pilot's loss of directional control during an aborted landing, which resulted in a collision with a tree and impact with the ground.NTSB GAA16CA076Accident · Minor injuriesData collectionFinal reportCessna 172 · Abilene, TXThe student pilot's abrupt control inputs during the flare, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's lack of over sight and delayed reaction while landing.NTSB CEN16LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Angleton, TXA loss of control while hovering for reasons that could not be determined, because postaccident examination revealed no mechanical anomalies or failures that would have precluded normal operation.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 GAA16CA034Accident · No injuriesData collectionFinal reportCessna 182R · Abilene, TXThe pilot's diverted attention while taxiing, which resulted in a collision with a fence post.NTSB GAA16CA018Accident · No injuriesData collectionFinal reportFurgason James E Vans RV 4 · San Marcos, TXThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB CEN16LA018Accident · No injuriesLimited investigationFinal reportDiamond DA20-C1 · Waskom, TXThe pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion.NTSB CEN16LA008Accident · No injuriesLimited investigationFinal reportBeechcraft A36 · Dallas, TXThe pilot’s improper navigation onto a vehicle service road while taxiing and his subsequent distraction while looking at an airport diagram, which led to the airplane impacting a fence post.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 CEN16LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G · Huntsville, TXThe pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.NTSB CEN16FA001Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Huntsville, TXThe pilot's mismanagement off the fuel supply to the engine, which resulted in fuel starvation.NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB CEN15LA428Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-26 · Slidell, TXThe pilot's attempt to recover from an aerobatic maneuver at too low of an altitude to make a safe recovery.NTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB CEN15FA422Accident · 2 fatalField investigationFinal reportPierce, Henry Bushby Mustang II · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.NTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…NTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.NTSB CEN15LA392Accident · No injuriesLimited investigationFinal reportCessna T240 · Houston, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadequate fuel management and the flight instructor’s failure to verify the fuel level and fuel selector position in flight.NTSB GAA15CA242Accident · No injuriesData collectionFinal reportCessna 305A · Midlothian, TXThe failure of the brake line tubing for the right main landing gear brake, due to a non-standard method used to secure the brake line, which resulted in a loss of control during landing, and a ground loop.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 CEN15LA375Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Carlos, TXThe pilot’s improper decision to turn the helicopter toward a tailwind during an out-of-ground-effect hover, which resulted in a loss of tail rotor effectiveness. Contributing to the accident was the accident and lead pilots’ inadequate preflight risk…NTSB CEN15CA356Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Pearland, TXThe student pilot inadvertently shut off the fuel valve while on the downwind leg, which resulted in a total loss of engine power due to fuel starvation and a forced landing short of the runway.NTSB CEN15LA355Accident · No injuriesLimited investigationFinal reportWorld Spirit · Granbury, TXThe pilot’s failure to use the fuel boost pump following the loss of engine power and the fuel system’s inadequate design, which did not allow for equalization of fuel between the fuel tanks and led to a total loss of engine power due to fuel starvation and…NTSB CEN15LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Austin, TXA total loss of engine power due to an excessively rich fuel mixture as a result of the improper adjustment of the fuel pump aneroid.NTSB CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…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 GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB CEN15FA305Accident · 2 fatalField investigationFinal reportPiper PA 32-300 · Brazoria, TXThe student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.NTSB CEN15LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA 30 · Clifton, TXThe pilot's failure to maintain control during a precautionary landing following a total loss of power to one engine. The reason for the loss of engine power could not be determined based on available information.NTSB CEN15LA298Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXMaintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.NTSB CEN15FA291Accident · 2 fatalField investigationFinal reportChampion 7BCM · Portland, TXThe pilot’s ostentatious low-altitude aerobatic display, which resulted in an aerodynamic stall/spin when he exceeded the airplane’s critical angle of attack. Contributing to the accident was the pilot’s impairment due to alcohol and drugs.NTSB GAA15CA182Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Llano, TXThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.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 CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…NTSB CEN15LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Galveston, TXThe loss of engine power due to a failure of a crankshaft idler gear shaft.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 GAA15CA152Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Edna, TXThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and collision with a fence.NTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…NTSB CEN15LA266Accident · Serious injuriesLimited investigationFinal reportHunziker Eros 1650R · Quitman, TXThe pilot's failure to maintain adequate airspeed for the approach to landing.NTSB CEN15LA263Accident · Minor injuriesLimited investigationFinal reportBelcher CH601XLB · Alpine, TXThe pilot/builder's failure to properly adjust the fuel flow, which resulted in reduced flow to the engine and a subsequent total loss of engine power.NTSB CEN15LA241Accident · No injuriesLimited investigationFinal reportGarratt Mansfield W IV-P · Hamilton, TXThe pilot’s decision to continue flight into known severe thunderstorm conditions, which resulted in the loss of engine power during the descent due to the engine’s ingestion of water and ice and a subsequent forced landing.NTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.NTSB CEN15LA224Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28F · Argyle, TXThe pilot and flight instructor's inadvertent encounter with settling with power during a confined area takeoff at an altitude that was too low for recovery.NTSB CEN15FA214Accident · Serious injuriesField investigationFinal reportBeech B35 · Orange, TXThe impact with power lines for reasons that could not be determined based on the available information.NTSB GAA15CA059Accident · No injuriesData collectionFinal reportCessna 180K · Pearland, TXThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB CEN15LA183Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Gordonville, TXThe pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB CEN15LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301T · Stephenville, TXThe partial loss of engine power after takeoff for undetermined reasons, which necessitated a forced landing, during which the airplane impacted trees and a power line.