NTSB investigations, TX
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.NTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.NTSB WPR23LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206-L4 · Ft Worth, TXThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident, was the flight instructor’s inadequate supervision.NTSB CEN23LA063Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S2R-G6 · Mission, TXThe pilot's failure to maintain clearance from an electrical box.NTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.NTSB CEN23LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Waco, TXThe nose landing gear retract arm separation for reasons that could not be determined.NTSB CEN23LA052Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Del Rio, TXThe pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.NTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.NTSB CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…NTSB CEN23LA033Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Bridgeport, TXThe pilot’s loss of control due to a wind gust during landing.NTSB CEN23LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesquite, TXThe student pilot’s failure to maintain directional control while taking off from a touch and go landing.NTSB CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB CEN23LA023Accident · Minor injuriesClass 4 · LimitedFinal reportStephen J Hoffman MS-500 · Houston, TXThe pilot’s failure to secure the magneto switch before attempting to hand rotate the engine which resulted in an inadvertent engine start, a runaway airplane, and subsequent impact with parked airplanes. Contributing to the accident was the failure to…NTSB CEN23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Burleson, TXThe pilot’s mismanagement of the fuel supply, which led to fuel starvation and a loss of engine power.NTSB CEN23LA018Accident · No injuriesClass 3 · LimitedFinal reportSea Ray LSX · Lago Vista, TXThe pilot’s inadequate fuel planning and improper in-flight decision making which resulted in a low fuel status and a loss of engine power due to fuel starvation.NTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.NTSB CEN23LA008Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Iola, TXThe pilot’s failure to maintain control of the airplane while landing.NTSB CEN23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Navasota, TXThe pilot’s loss of control while landing resulting in a runway excursion and ground loop.NTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.NTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.NTSB CEN23LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Burnet, TXThe pilot’s failure to maintain directional control during the landing roll with an unexpected quartering tailwind.NTSB CEN22LA437Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · San Antonio, TXThe student pilot’s failure to maintain control of the airplane during the landing.NTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.NTSB CEN22LA429Accident · No injuriesClass 3 · LimitedFinal reportCommander 114TC · Savoy, TXA loss of engine power for reasons that could not be determined.NTSB CEN22FA416Accident · 1 fatalClass 3 · FieldFinal reportPipistrel Italia S R L Sinus 912 LSA · Waller, TXThe pilot’s failure to maintain aircraft control, which led to an aerodynamic stall at an altitude where recovery was not possible.NTSB CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.NTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.NTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…NTSB CEN22LA402Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopters 369E · Pearland, TXThe pilot receiving instruction’s failure to maintain aircraft control, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB CEN22LA400Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · San Isidro, TXThe pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.NTSB WPR22FA311Accident · 1 fatalClass 3 · FieldFinal reportSmyth Sidewinder TD · Wichita Falls, TXThe pilot’s inexperience with the airplane and inadequate takeoff procedures, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.NTSB CEN22LA363Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20B · Waller, TXThe pilot’s failure to maintain the proper descent rate during an off-airport landing.NTSB CEN22LA368Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Midland, TXThe student pilot’s failure to maintain control of the airplane while landing with gusting wind.NTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.NTSB WPR22FA264Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-235 · Seguin, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…NTSB CEN22LA322Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 112 · Granbury, TXThe loss of engine power due to metal contamination within the cylinder following poor maintenance.NTSB CEN22LA325Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305A · Mc Kinney, TXThe failure of the pilot to maintain adequate airspeed during landing resulting in an inadvertent aerodynamic stall.NTSB CEN22LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Kendleton, TXThe pilot’s improper in-flight planning and fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN22LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Frankston, TXThe pilot’s delayed aborted takeoff that resulted in a runway overrun and impact with terrain.NTSB CEN22FA299Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Mount Pleasant, TXThe pilot’s failure to maintain the proper glidepath while on final approach in night visual conditions, which resulted in a collision with trees.NTSB CEN22FA288Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Blackwell, TXThe pilot’s failure to maintain proper altitude and clearance during low-level aerial application, resulting in an in-flight collision with power lines.NTSB WPR22FA229Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Kerrville, TXThe pilot’s failure to maintain aircraft control during a base leg turn in the airport traffic pattern, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight training experience.NTSB CEN22LA283Accident · No injuriesClass 3 · LimitedFinal reportOsprey II · Bulverde, TXA loss of engine power due to fuel starvation due to a blockage of the fuel tank outlet port.