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 FTW02LA220Accident · Serious injuriesLimited investigationFinal reportFleet 7 Deluxe · Canyon, TXThe loss of engine power as a result of the malfunction of the magneto switch.NTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.NTSB FTW02FA211Accident · 1 fatalField investigationFinal reportNorth American AT-6A · Albany, TXThe pilot's failure to maintain aircraft control.NTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.NTSB FTW02CA206Accident · Serious injuriesData collectionFinal reportAero Commander Callair A-9B · El Paso, TXthe loss of control due to the encounter with the dust devil.NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.NTSB FTW02LA201Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Waco, TXThe partial loss of engine power due to undetermined reasons. A contributing factor was the pilot's inadequate landing flare which resulted in a hard landing.NTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB FTW02LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 · Houston, TXThe pilot's loss of control after encountering dynamic rollover during takeoff. A contributing factor was the pilot's inadequate preflight inspection.NTSB DEN02LA058Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Giddings, TXthe failure of the pilot to maintain aircraft control during the landing rollout. A contributing factor was the subsequent inadvertent ground loop of the airplane.NTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.NTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.NTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.NTSB FTW02LA182Accident · No injuriesLimited investigationFinal reportCessna R172K · Llano, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and a forced landing.NTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.NTSB FTW02LA198Accident · No injuriesLimited investigationFinal reportAirbus Industrie A300-600F · El Paso, TXThe flight crew's failure to obtain the Vr speed prior to rotation which resulted in insufficient lift and the subsequent tail strike.NTSB FTW02LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Crawford, TXThe loss of engine power as a result of the pilot's exceedence of the engine's temperature limits, resulting in the melting of blades on the first and second stage turbine wheels. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.NTSB FTW02LA174Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXthe partial loss of engine power due to the mixture control rod separating from the carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.NTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.NTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.NTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.NTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.NTSB FTW02LA165Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Palestine, TXThe failure of the nose gear actuator aft attach point from the tube cluster on the engine mount assembly. A contributing factor was the owner's non-compliance with the service bulletin for inspection/replacement of the engine mount.NTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.NTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB FTW02LA139Accident · Minor injuriesLimited investigationFinal reportBoeing A75SN1 · Georgetown, TXThe pilot's inadequate planning/decision resulting in the wake turbulence encounter during the takeoff/initial climb of the formation flight. A contributing factor was the partial loss of engine power for an undetermined reason.NTSB FTW02LA136Accident · No injuriesLimited investigationFinal reportCessna 560 · Leakey, TXThe pilots failure to land the aircraft at the proper touchdown point on the runway to allow adequate stopping distance.NTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.NTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.NTSB FTW02LA120Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of engine power due to contamination of the fuel system. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.NTSB FTW02LA124Accident · No injuriesLimited investigationFinal reportCessna 172R · Longview, TXThe in-flight collision with a bird.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB FTW02LA119Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cypress, TXthe total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB FTW02LA114Accident · No injuriesLimited investigationFinal reportMcClung Starduster SA-1 · Sherman, TXthe pilot's inadvertent use of unsuitable taxi terrain, which resulted in an encounter with a ditch while taxing from landing.NTSB FTW02FA112Accident · 1 fatalField investigationFinal reportNorth American T-28B · Uvalde, TXThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB FTW02LA110Accident · Serious injuriesLimited investigationFinal reportThornley Thornley 2000 · Granite Shoals, TXthe pilot's failure to maintain clearance with a power line while maneuvering. Contributing factors were the pilot's diverted attention and the power lines.NTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.