NTSB investigations, TX
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CEN13LA186Accident · 1 fatalLimited investigationFinal reportFisher Michael E Celebrity · Terrell, TXThe pilot’s exceedance of the airplane’s design stress limits while performing aerobatic maneuvers.NTSB ENG13IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 · Dallas, TXFuel leaking from a fractured fuel manifold feeder line that ignited on contact with the engine’s hot compressor rear frame, which resulted in an engine undercowl fire. The fuel manifold feeder line failed due to high amplitude fatigue because the fuel…NTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.NTSB CEN13TA165Accident · Minor injuriesFinal reportBell OH-58A · Pine Springs, TXThe pilot's failure to maintain directional control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.NTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.NTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…NTSB CEN13LA148Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Gillett, TXA loss of tail rotor effectiveness while manuevering at low altitude.NTSB CEN13LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Victoria, TXThe mechanical failure of the engine power section, which resulted in a loss of engine power.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 CEN13LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · McKinney, TXCollapse of the landing gear for reasons that could not be determined because visual examination did not reveal any mechanical malfunction or failure that would have prevented the gear from locking in the extended position and postaccident damage precluded…NTSB CEN13FA131Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Paris, TXThe pilot's encounter with convective weather, which resulted in a loss of airplane control.NTSB CEN13CA124Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Menard, TXThe helicopter landed hard during a forced landing.NTSB CEN13LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mc Allen, TXA loss of engine power due to carburetor icing.NTSB CEN13LA119Accident · No injuriesLimited investigationFinal reportBell 407 · Big Lake, TXThe loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.NTSB CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.NTSB CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.NTSB CEN13FA105Accident · 2 fatalField investigationFinal reportBeech E-90 · Amarillo, TXThe pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.NTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.NTSB CEN13FA100Accident · 2 fatalField investigationFinal reportAerovodochody L-29 Delfin · Combine, TXThe airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.NTSB CEN13LA097Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Moody, TXThe total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Abilene, TXThe flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate…NTSB CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…NTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.NTSB CEN13LA068Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · San Antonio, TXA partial loss of engine power during takeoff, likely due to the accumulation of carburetor ice.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 CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13CA053Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bryan, TXThe pilot’s over-correction in an attempt to stabilize the helicopter during liftoff.NTSB CEN13LA046Accident · 1 fatalLimited investigationFinal reportSorensen Sprint Mxii · Groesbeck, TXThe pilot’s failure to maintain control of the noncertificated airplane during a go-around. Contributing to the accident was the pilot’s physical and psychological impairment.NTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…NTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.NTSB CEN13FA039Accident · 1 fatalField investigationFinal reportCessna 320E · San Marcos, TXThe non-instrument-rated pilot’s decision to takeoff in night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.NTSB CEN13LA029Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Castroville, TXThe pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.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 CEN13CA017Accident · Serious injuriesData collectionFinal reportHunthrop Autogyro MTO Sport · Bourland, TXThe pilot's decision to fly the gyroplane in gusty wind conditions that exceeded his limitations and his resultant loss of control during takeoff.NTSB CEN13FA010Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 II · Blanco, TXThe pilot's loss of helicopter control as a result of spatial disorientation due to dark night conditions and marginal visual flight rules weather conditions.NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB CEN13FA006Accident · 4 fatalField investigationFinal reportBeech A36 · Mabank, TXThe pilot's loss of airplane control while maneuvering in instrument meteorological conditions.NTSB CEN12LA669Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Nocona, TXThe noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.NTSB CEN12FA670Accident · Serious injuriesField investigationFinal reportAgusta A109E · Eastland, TXThe loss of helicopter control after an in-flight upset, which occurred when the pilot selected the autopilot’s altitude hold mode; the reason for the reported in-flight control anomaly could not be determined during postaccident helicopter examinations.…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 CEN12LA650Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Rio Vista, TXThe catastrophic failure and disintegration of the No. 6 engine piston, which resulted in a total loss of engine power.NTSB CEN12CA643Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Slaton, TXThe pilot’s misalignment of the helicopter during landing, which resulted in the helicopter’s fall from a raised platform.