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 GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.NTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.NTSB GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB GAA17CA418Accident · No injuriesData collectionFinal reportPiper PA32 · San Antonio, TXThe pilot’s failure to extend the landing gear before touchdown.NTSB CEN17LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · El Paso, TXA partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.NTSB CEN17LA254Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Alpine, TXFracture of a compressor turbine (CT) blade due to operational overtemperatures and the failure of a maintenance technician to detect an existing crack in the CT blade during the last engine inspection.NTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.NTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.NTSB GAA17CA366Accident · No injuriesData collectionFinal reportBellanca 1730 · Burnet, TXThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing.NTSB GAA17CA356Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Matagorda, TXThe pilot’s failure to maintain helicopter control during an agricultural flight in gusting wind conditions.NTSB GAA17CA343Accident · No injuriesData collectionFinal reportBurkhart Grob G103C · Boerne, TXThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway.NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17FA209Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Dimmitt, TXThe pilot's incapacitation due to scarring from previous heart attacks and severe hypertrophy of the left ventricular wall which resulted in arrhythmia and a loss of control while maneuvering at low altitude.NTSB CEN17FA208Accident · 1 fatalField investigationFinal reportMichael S. Logan Kitfox · New Berlin, TXA total loss of engine power for reasons that could not be determined based on the available information, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and experiencing…NTSB CEN17LA202Accident · Serious injuriesLimited investigationFinal reportPiper PA36 · El Campo, TXFoam contamination in the fuel injector nozzles from deteriorated foam baffles and water in the fuel flow divider, the combination of which resulted in the loss of engine power.NTSB CEN17LA198Accident · No injuriesLimited investigationFinal reportMooney M20J · Lakeway, TXThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway excursion. Contributing to the accident was the pilot’s impaired vision due to his broken eyeglasses.NTSB GAA17CA308Accident · Minor injuriesData collectionFinal reportRobert Hamblin Autogyro Gmbh Cavalo · Fort Worth, TXThe pilot’s failure to maintain clearance from terrain.NTSB DCA17CA123Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 132 · South Toledo Bend, TXan encounter with convective turbulence.NTSB GAA17CA285Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Dumas, TXThe pilot’s failure to maintain lateral control while maneuvering at a low altitude.NTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.NTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.NTSB CEN17LA179Accident · Minor injuriesLimited investigationFinal reportBeech 19 · Weatherford, TXThe flight instructor’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN17LA190Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Tahoka, TXThe partial loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB GAA17CA252Accident · No injuriesData collectionFinal reportMaule MX7 · Floydada, TXThe pilot's decision to fly into and land at an area of known widespread high gusting wind, which resulted in a nose-over.NTSB CEN17FA168Accident · 3 fatalClass 2 · FieldFinal reportPilatus PC 12 · Amarillo, TXThe pilot's loss of airplane control due to spatial disorientation during the initial climb after takeoff in night instrument meteorological conditions and moderate turbulence.NTSB CEN17FA167Accident · 1 fatalField investigationFinal reportCessna 421C · Huntsville, TXThe pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined…NTSB GAA17CA243Accident · No injuriesData collectionFinal reportCessna 182 · Killeen, TXThe pilot's incorrect landing flare in gusting wind conditions.NTSB GAA17CA233Accident · No injuriesData collectionFinal reportPiper PA 34 · Llano, TXThe pilot’s complacency during the en route phase of flight, which resulted in fuel mismanagement and a subsequent gear-up landing.NTSB CEN17LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.NTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.NTSB CEN17LA151Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Nome, TXAn in-flight fire for reasons that could not be determined based on available information.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN17LA149Accident · Serious injuriesLimited investigationFinal reportAero Adventure Aventura UL · Garden Ridge, TXThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…NTSB DCA17CA079Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TXan inadvertent encounter with convective turbulence.NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB CEN17LA105Accident · Serious injuriesLimited investigationFinal reportAmerican AA 1A · Gainesville, TXThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing in a field. Contributing to the accident was the pilot’s delayed action in taking control of the…NTSB GAA17CA165Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Spofford, TXThe pilot's decision to hover-taxi out of the hangar and his subsequent failure to maintain clearance from the hangar.NTSB GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.NTSB CEN17LA113Accident · Serious injuriesLimited investigationFinal reportBell-Transworld Helicopters 47D1 · Archer City, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadvertent positioning of the mixture control to the “fuel cutoff” position.NTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.NTSB GAA17CA130Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Armstrong, TXThe pilot’s failure to remove the left helicopter skid tie-down before takeoff, which resulted in dynamic roll-over.NTSB CEN17LA096Accident · Serious injuriesLimited investigationFinal reportCook Smith Aviation Repli · Justin, TXA total loss of engine power due to fuel starvation as the result of a disruption in fuel flow.NTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.NTSB CEN17LA093Accident · No injuriesLimited investigationFinal reportPiper J3C · Brenham, TXThe reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.NTSB CEN17LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Butterfield, TXA malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…NTSB GAA17CA129Accident · No injuriesData collectionFinal reportCessna 182 · Midland, TXThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.