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 DEN08LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Athens, TXA partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…NTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.NTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.NTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.NTSB DFW08LA196Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Petersburg, TXA partial loss of engine power due to the substandard and incomplete maintenance of the engine.NTSB DFW08FA190Accident · 3 fatalField investigationFinal reportPiper PA-22 · Kemp, TXThe pilot's failure to maintain adequate airspeed while maneuvering, which led to an aerodynamic stall and subsequent loss of control.NTSB DEN08LA124Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Cleveland, TXthe pilot's failure to maintain aircraft control during his attempted performance of aerobatic maneuvers shortly after takeoff.NTSB DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.NTSB DFW08CA194Accident · No injuriesData collectionFinal reportBeech 65-A80 · Midland, TXThe failure of the landing gear retraction/extension mechanism due to it being jammed by displaced sound proofing material.NTSB DFW08CA193Accident · No injuriesData collectionFinal reportPiper PA-30 · Rockport, TXThe pilot's failure to complete all cockpit checklist items prior to takeoff. Contributing to the accident was the pilot's failure to properly configure the landing gear switch.NTSB DFW08CA191Accident · No injuriesData collectionFinal reportCessna T210M · Van Horn, TXThe pilot's failure to maintain altitude due to his diverted attention. Contributing to the accident was complications manually extending the landing gear.NTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB DFW08CA177Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Canyon Lake, TXA total loss of tail rotor effectiveness. Contributing to the accident was the pilot's improper decision to operate inside the height velocity curve.NTSB DFW08CA172Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Somerset, TXThe right main landing gear strut failure due to metal fatigue.NTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.NTSB DEN08LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Garwood, TXA loss of engine power due to the total failure of the number 2 cylinder.NTSB DFW08CA179Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Wharton, TXThe pilot's failure to maintain aircraft control.NTSB DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.NTSB CEN09CA108Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Sunrise Beach, TXThe pilot's failure to maintain altitude/clearance from a powerline while maneuvering. A contributing factor was the powerline.NTSB DFW08CA164Accident · No injuriesData collectionFinal reportBritish Jet Provost T Mk.5A · Bay City, TXThe pilot's failure to maintain aircraft control during final approach. Contributing to the accident was the downdraft.NTSB DEN08LA102Accident · No injuriesLimited investigationFinal reportCessna 150G · Brenham, TXThe sudden windshift (crosswind gust), rendering directional control impossible. Contributing factors in this accident were the high speed during the aborted takeoff and trees.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB DEN08LA098Accident · 2 fatalLimited investigationFinal reportHarms Robert M KIT FOX SE · La Porte, TXThe pilot's failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and uncontrolled descent.NTSB DFW08CA162Accident · No injuriesData collectionFinal reportCessna CE-152 · Castroville, TXAn improper flare during landing. Contributing to the accident was a porpoise induced oscillation.NTSB DFW08CA154Accident · No injuriesData collectionFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain clearance from an object while taxiing. Contributing to the accident were the pilot's diverted attention and a vehicle.NTSB DCA08FA064Accident · Serious injuriesField investigationFinal reportEmbraer 140 · Dallas, TXThe flight's inadvertent encounter with turbulence.NTSB DFW08CA152Accident · Serious injuriesData collectionFinal reportRotorway 162F · Gonzales, TXfailure of the main rotor drive belt for undetermined reasons.NTSB DEN08LA096Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Roanoke, TXThe pilot's physiologic impairment and failure to attain the proper touchdown point during an intentional off airport landing. Contributing to the accident was the pilot's improper in-flight planning.NTSB DEN08CA091Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · East Bernard, TXTwo engine cylinder exhaust valves stuck open for an undetermined reason, resulting in a loss of engine power.NTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.NTSB DFW08CA146Accident · No injuriesData collectionFinal reportAir Tractor 401-0860 · Mumford, TXA total loss of engine power for undetermined reasons.NTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB DEN08CA087Accident · No injuriesData collectionFinal reportCessna 172H · Brookshire, TXThe pilot's decision to duck under marked transmission lines and his failure to maintain clearance from the fence. Contributing to the accident was the marked transmission lines.NTSB DFW08LA140Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Marine · Austin, TXThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude, which resulted in a loss of control.NTSB DFW08TA137Accident · No injuriesFinal reportSchweizer 269D · San Antonio, TXThe pilot's failure to compensate for the excessive rate of descent on final approach. A contributing factor was the reported down draft.NTSB DFW08CA132Accident · Minor injuriesData collectionFinal reportCessna C-210 · Pleasanton, TXThe pilot's failure to obtain the proper touchdown point resulting in an overrun. Contributing to the accident was the pilot's failure to abort the landing.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB DFW08IA126Incident · No injuriesIncident investigationFinal report2007 Savage Air Epic LT · Uvalde, TXThe pilot's excessive speed during a turn off the active runway to the taxiway which exceeded the lateral limits of the supporting landing gear structure resulting in the collapse of the left main gear.NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.NTSB DEN08CA083Accident · No injuriesData collectionFinal reportBeech 76 · Cleburne, TXThe failure of the flight instructor and student pilot to extend the landing gear prior to the airplane touching down on the runway.NTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…NTSB DFW08CA114Accident · No injuriesData collectionFinal reportHughes 269A · Killeen, TXThe pilot's failure to maintain main rotor RPM and a safe rate of descent during the autorotation. A contributing factor was the gusty winds.NTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.NTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.NTSB DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.