NTSB investigations, TX
584 cases where NTSB found Action/decision.
Cases per year
| 2008 | 29 |
|---|---|
| 2009 | 37 |
| 2010 | 39 |
| 2011 | 47 |
| 2012 | 44 |
| 2013 | 34 |
| 2014 | 35 |
| 2015 | 28 |
| 2016 | 33 |
| 2017 | 26 |
| 2018 | 36 |
| 2019 | 22 |
| 2020 | 28 |
| 2021 | 23 |
| 2022 | 29 |
| 2023 | 24 |
| 2024 | 28 |
| 2025 | 27 |
| 2026 | 15 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0204'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0204')) 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 CEN26LA304Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Hudson Oaks, TXThe pilot’s loss of directional control during the rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to abort the takeoff after the airplane had accelerated above its normal rotation speed. Also…NTSB CEN26LA298Accident · Minor injuriesClass 4 · LimitedFinal reportRotor Effects M24 Plus · Waelder, TXThe pilot’s improper execution of rejected takeoff procedures, which resulted in loss of control and subsequent runway excursion.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…NTSB CEN26LA203Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Fort Worth, TXThe flight instructor’s delayed remedial action and the student pilot’s failure to maintain helicopter control during hover.NTSB CEN26LA195Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Littlefield, TXThe pilot's excessive approach speed, which resulted in a hard, bounced landing and nose-over.NTSB CEN26LA205Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Conroe, TXThe pilot’s failure to properly latch the canopy before flight, which led to the canopy opening shortly after takeoff.NTSB CEN26LA188Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Corpus Christi, TXThe pilot's failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN26LA168Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mount Blanco, TXThe pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.NTSB CEN26LA145Accident · No injuriesClass 4 · LimitedFinal reportClassic Waco YMF · Galveston, TXThe biplane pilot’s failure to maintain an adequate visual lookout while taxiing, which included the failure to perform S-turns to compensate for limited forward visibility.NTSB CEN26LA144Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20 · Northlake, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB DCA26LA142Accident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Houston, TXThe captain’s inadvertent activation of the takeoff/go around switch at touchdown that caused an increase in the airplane pitch attitude that was not corrected before the lower fuselage contacted the runway.NTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB CEN26LA091Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Burnet, TXThe pilot’s improper judgement to relinquish his pilot responsibilities to the passenger with the engine operating, which resulted in a loss of airplane control and impact with a parked vehicle.NTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.NTSB CEN26LA076Accident · Serious injuriesClass 4 · LimitedFinal reportNanchang China CJ-6A · Burnet, TXThe pilot’s failure to secure the airplane before hand-propping the engine, which resulted in the airplane’s unexpected movement and subsequent impact with an airport fence.NTSB CEN26LA070Accident · Serious injuriesClass 4 · LimitedFinal reportGlynn RS-3 · Crabapple, TXThe pilot's failure to maintain clearance from a fence cable guy-line during low-level maneuvering over a river.NTSB CEN26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe flight instructor’s inadequate supervision during the approach and delayed remedial action, which resulted in a loss of control.NTSB CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN25LA391Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Seagoville, TXThe pilot’s inadequate fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA389Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Decatur, TXThe pilot’s loss of control during an off-airport, pinnacle landing, and the flight instructor’s inadequate supervision of the instructional flight.NTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB DCA25LA307Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Peaster, TXThe airplane’s encounter with convective turbulence that resulted in serious injuries to a passenger who was out of their seat when the seatbelt sign was illuminated.NTSB CEN25LA381Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe manufacturer flight instructor’s failure to maintain proper airspeed and a proper descent rate during a demonstrated hover out of ground effect (HOGE) autorotation, which resulted in a hard landing. Contributing to the accident was the manufacturer flight…NTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN25LA302Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Taylor, TXThe flight instructor’s inadequate supervision and delayed remedial action which resulted in a skid contacting the terrain. Contributing to the accident was the flight instructor’s improper judgement to allow the student pilot to manipulate the flight…NTSB CEN25LA237Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pecos, TXThe pilot’s failure to maintain aircraft control during gusty wind conditions.NTSB CEN25LA209Accident · No injuriesClass 4 · LimitedFinal reportVans RV-14 · Sealy, TXThe pilot’s improper use of airplane’s wheel brakes during the landing roll-out.NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Pearland, TXBoth pilots’ failure to follow emergency procedures pertaining to the partial loss of engine power by either applying carburetor heat to address the carburetor icing or to abort the takeoff when they observed a partial loss of engine power during the takeoff…NTSB CEN25LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Breckenridge, TXThe mechanic’s failure to properly install the throttle cable hardware resulting in a separation of the cable and loss of engine throttle control.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.NTSB DCA25LA114Occurrence · No injuriesClass 3 · LimitedFinal reportAirbus Industrie A319 · Houston, TXThe failure of the cabin crew to activate the evacuation alarm and to maintain coordinated communication with the flight crew following the cabin crew’s decision to command an evacuation, which resulted in an engine running during the initial evacuation.…NTSB CEN25LA087Accident · No injuriesClass 4 · LimitedFinal reportEpic E1000 · Arcola, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN25LA079Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Tyler, TXAn electrical system surge for a reason that could not be determined that resulted in an overvoltage event, internal damage to electronics equipment, smoke in the cockpit, and a gear up landing.NTSB CEN25LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · McKinney, TXThe flight instructor’s inadequate supervision and delayed remedial action and the student pilot’s failure to maintain a proper landing flare, which resulted in a nose down impact with the runway.NTSB CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB CEN25LA036Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.NTSB DCA25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Houston, TXBrake application before all three landing gears were on the ground, which caused the failure of the right main landing gear tires and resulted in tire fragments impacting the fuselage.NTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.NTSB CEN24LA377Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Manvel, TXThe pilot’s improper recovery from a practice autorotation which resulted in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN24LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Weslaco, TXThe student pilot’s failure to maintain control of the airplane during landing.NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…