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 CEN11LA186Accident · Minor injuriesLimited investigationFinal reportGadbois Eugene W Apex CROSS-5 · Lago Vista, TXThe simultaneous loss of engine and electrical power after takeoff for undetermined reasons.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.NTSB CEN11LA162Accident · No injuriesLimited investigationFinal reportPiper PA24 · Huntsville, TXThe pilot’s inadequate preflight inspection to ensure the main tanks were full, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN11LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Matador, TXThe loss of engine power during initial climb for undetermined reasons.NTSB CEN11CA165Accident · No injuriesData collectionFinal reportCulver Glenn Kitfox III · Terlingua, TXThe pilot's loss of directional control on takeoff.NTSB CEN11CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Corsicana, TXThe student pilot’s failure to maintain directional control during landing.NTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.NTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.NTSB CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11IA146Incident · No injuriesIncident investigationFinal reportColumbia LC41 · Milsap, TXA total loss of engine power in flight due to a loss of engine oil for reasons that could not be determined during a postaccident teardown examination of the engine.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 CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.NTSB CEN11LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Nacogdoches, TXThe total loss of engine power during cruise flight for undetermined reasons.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB CEN11LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Nocagdoches, TXA total loss of power in both engines for undetermined reasons.NTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.NTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.NTSB CEN11LA076Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Roanoke, TXA loss of engine power for undetermined reasons.NTSB CEN11CA103Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Spring, TXThe failure of the right landing gear down-lock mechanism to fully engage. Contributing to the accident was the pilot’s inability to verify the landing gear extension due to the inoperative alternator.NTSB CEN11LA073Accident · Serious injuriesLimited investigationFinal reportCessna 172K · San Antonio, TXThe pilot's failure to maintain aircraft control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.NTSB CEN11CA057Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 · Winnie, TXThe collapse of the powered parachute's canopy on short final for undetermined reasons, resulting in a loss of lift.NTSB CEN11LA061Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Fruitvale, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN11CA121Accident · No injuriesData collectionFinal reportPiper J3C-65 · Cypress, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN11LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Robstown, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN11LA043Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Port Mansfield, TXThe total loss of engine power for undetermined reasons because examination of the airframe and engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB CEN11LA034Accident · No injuriesLimited investigationFinal reportCessna T210N · Presidio, TXA loss of engine power due to fuel exhaustion for undetermined reasons.NTSB CEN11CA036Accident · Minor injuriesData collectionFinal reportFrederick R Goenne Glastar · Recklaw, TXThe pilot's failure to maintain directional control during the landing roll on a rough runway surface.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.NTSB CEN11CA028Accident · Minor injuriesData collectionFinal reportWeddington Double Eagle · Temple, TXThe loss of engine power for undetermined reasons.NTSB CEN11CA037Accident · No injuriesData collectionFinal reportCessna 182K · Henderson, TXThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in a hard landing.NTSB CEN11LA023Accident · Serious injuriesLimited investigationFinal reportBell 206B · Newton, TXThe pilot’s attempted takeoff with the fuel hose attached to the helicopter and the pilot and ground crew’s failure to accurately communicate.NTSB CEN11CA030Accident · No injuriesData collectionFinal reportConrad Theodore J Thorp T-18 · Fredericksburg, TXThe malfunction of the throttle clamp, which resulted in the pilot's inability to control the engine's power setting.NTSB CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.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.NTSB CEN10LA558Accident · 1 fatalLimited investigationFinal reportWorthington Rotorway · Pattison, TXThe pilot's failure to maintain main rotor rpm, which resulted in an uncontrolled descent and collision with terrain.NTSB CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10CA553Accident · Serious injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Blessing, TXThe pilot's failure to maintain clearance from wires while maneuvering.NTSB CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.NTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.