NTSB investigations, TX
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 GAA16CA206Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Spring, TXThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and substantial damage to the lower left wing spar.NTSB CEN16LA153Accident · No injuriesLimited investigationFinal reportGill Craig Lancair IV P Propjet · Addison, TXCollapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.NTSB CEN16LA139Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402 · Beyersville, TXThe pilot's failure to maintain visual separation from the power line due to a lack of identifiable and contrasting features, which led to an inflight collision with the line while maneuvering in gray, hazy conditions.NTSB GAA16CA171Accident · No injuriesData collectionFinal reportRockwell International 114 · Addison, TXThe private pilot's failure to maintain directional control during the landing roll and the flight instructor's delayed remedial action, which resulted in a runway excursion, collision with an airport sign, and a nose gear collapse.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB CEN16LA137Accident · Serious injuriesLimited investigationFinal reportMatthews H Thomas Jodel F11 A · Marathon, TXThe pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.NTSB CEN16LA134Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Stephenville, TXThe loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB DCA16CA181Accident · Serious injuriesData collectionFinal reportBoeing 737 724 · Port Arthur, TXan inadvertent encounter with clear air turbulence.NTSB CEN16CA126Accident · No injuriesData collectionFinal reportNakajima A6M2 Model 21 · Midland, TXThe Goodyear pilot did not see and avoid the Nakajima ahead on the taxiway.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB GAA16CA145Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Canton, TXThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.NTSB CEN16LA121Accident · Serious injuriesLimited investigationFinal reportAriosto James J Ariosto Mustang II · Normangee, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…NTSB CEN16FA111Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Navasota, TXThe flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…NTSB CEN16LA107Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Bryan, TXA failure of the crankshaft due to improper torque of the crankcase through bolts.NTSB GAA16CA130Accident · Minor injuriesData collectionFinal reportCessna 182 · Hudson Oaks, TXThe pilot's decision to continue the high approach, resulting in excessive speed during the landing roll, a loss of directional control, runway excursion, and nose over.NTSB CEN16IA103Incident · No injuriesIncident investigationFinal reportCessna 560 · Dallas, TXThe loss of aileron trim due to the lack of separation between the cannon head on the back of autopilot cannon plug and the aileron trim tab control gear. Contributing to the incident was the lack of guidance in the airplane maintenance manual to verify…NTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.NTSB GAA16CA133Accident · Minor injuriesData collectionFinal reportNorth American P 51 · Dallas, TXThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB CEN16FA094Accident · 1 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Arcola, TXThe student pilot's loss of control after exceeding the airplane's critical angle-of-attack, which lead to a power-on, aerodynamic departure stall. Contributing to the accident was the flight instructor's inadequate oversight of the student pilot.NTSB CEN16LA101Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Bulverde, TXThe failure of the left main landing gear wheel casting due to fatigue, which resulted in a loss of directional control during the landing roll.NTSB GAA16LA117Accident · No injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri · Beaumont, TXThe pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.NTSB CEN16LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA31 · Denton, TXThe total loss of engine power due to fuel exhaustion for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA106Accident · No injuriesData collectionFinal reportPiper PA 28RT-201 · Terrell, TXThe private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.NTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…NTSB CEN16LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Sulfur Springs, TXThe student pilot’s failure to maintain directional control during landing.NTSB CEN16LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Ingleside, TXThe loss of engine power during takeoff due to carburetor icing, which resulted in a forced landing.NTSB GAA16CA095Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Fort Worth, TXAn inadvertent collision with a bird while on downwind in the airport pattern.NTSB CEN16LA068Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Baytown, TXThe pilot's failure to maintain directional control during landing in gusting wind conditions.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 CEN16LA040Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Sugarland, TXThe overspeed of the main rotor system for reasons that could not be determined based on the available information.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 DCA16CA021Accident · Serious injuriesData collectionFinal reportBoeing 787 · Beaumont, TXAn inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.NTSB CEN16LA027Accident · No injuriesLimited investigationFinal reportBell 407 · San Antonio, TXThe failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…NTSB DCA16CA009Accident · Serious injuriesData collectionFinal reportBoeing 757 223 · Dallas, TXthe disabled passenger not being properly secured during the transfer from the aisle chair causing him to slide to floor and receive a serious injury.NTSB GAA16CA024Accident · No injuriesData collectionFinal reportCessna 120 · McKinney, TXThe pilot's use of excessive brake input during the recovery from the ground loop, which resulted in a nose over.NTSB CEN16LA016Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Lancaster, TXThe pilot’s failure to maintain a proper glidepath during a night visual approach, which resulted in impact with a power line. Contributing to the accident was an inoperative precision approach path indicator.NTSB CEN16LA015Accident · No injuriesLimited investigationFinal reportBobby Martin Autogyro MTO Sport · Wallisville, TXFracture of the pusher propeller blade due to impact damage from an unknown object while in flight, which resulted in a severe vibration and a loss of thrust.NTSB GAA16CA042Accident · No injuriesData collectionFinal reportCessna 421 · Amarillo, TXThe loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.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.