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 DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.NTSB DFW06LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Midland, TXThe partial loss of engine power as result of the maintenance personnel's failure to comply with a manufacture's Service Bulletin (SB). A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06IA171Incident · No injuriesIncident investigationFinal reportMooney M20J · Beaumont, TXThe improper installation of the propeller governor by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA168Accident · No injuriesData collectionFinal reportCessna TU206G · Eldorado, TXThe pilot's failure to maintain airspeed during an emergency simulation resulting in a hard landing. A contributing factor was the flight instructor's delayed remedial action.NTSB DFW06CA167Accident · Minor injuriesData collectionFinal reportAgin Jeffrey T RV-4 · Arlington, TXThe pilot's improper recovery from a bounced landing.NTSB DFW06CA162Accident · No injuriesData collectionFinal reportCessna 182L · Coupland, TXThe pilot's disorientation. Contributing factors were the prevailing night light condition and the inoperative landing light.NTSB DFW06CA161Accident · No injuriesData collectionFinal reportLindstrand Balloons 105A · Frisco, TXThe pilot's failure to maintain the proper glidepath while landing. Contributing factors were the prevailing high winds and the downdraft encountered on final approach.NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA157Accident · Serious injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. Calif A-21 · San Antonio, TXThe pilot/owner's failure to properly secure the right wing, which resulted in the in-flight separation of the right wing.NTSB DFW06CA156Accident · Minor injuriesData collectionFinal reportCampbell W/Smiley J Execytive 162F · Porter, TXThe pilot's loss of control after encountering dynamic rollover while hovering.NTSB DFW06CA152Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Victoria, TXThe pilot's delay in aborting the takeoff which resulted in an overrun. A contributing factor was the unfavorable wind.NTSB DFW06CA158Accident · No injuriesData collectionFinal reportAyres S2R-600 · Childress, TXThe pilot's inability to maintain directional control while landing due to the failure of the rudder horn due to corrosion.NTSB DFW06CA149Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Garden City, TXThe pilot's improper in-flight planning resulting in the loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA144Accident · No injuriesData collectionFinal reportMooney M20J · Wichita Falls, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the gusty crosswind.NTSB DFW06LA141Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Payne Springs, TXThe loss of engine power for undetermined reasons.NTSB DFW06FA140Accident · 2 fatalField investigationFinal reportAviat A-1B · Edna, TXThe pilot's ostentatious display while maneuvering at low altitude which resulted in an inadvertent stall/spin and subsequent impact with the water.NTSB DFW06CA143Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Justin, TXThe pilot's improper compensation for the prevailing high wind conditions.NTSB DFW06FA136Accident · 2 fatalField investigationFinal reportCessna 150F · Levelland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Contributing factors were low altitude and the gusting wind.NTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,NTSB DFW06CA133Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · La Porte, TXThe student pilot's inadequate weather evaluation and his failure to maintain airspeed which resulted in a stall. A contributing factor was the prevailing tailwind.NTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.NTSB DFW06CA126Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Paris, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB DFW06CA125Accident · No injuriesData collectionFinal reportBellanca 17-A30 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA123Accident · Minor injuriesData collectionFinal reportBell 47G-2 · Rosenberg, TXThe pilots encounter with loss of tail rotor effectiveness during an aerial application flight. A contributing factor was the gusty winds.NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB DFW06CA119Accident · No injuriesData collectionFinal reportCessna 150G · Coleman, TXThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB DFW06LA121Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-802A · Jasper, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable landing for the pilot to execute the forced landing.NTSB DFW06CA116Accident · Minor injuriesData collectionFinal reportHeliotech H-250 · Woodville, TXThe pilot's failure to maintain clearance with obstructions at the departure end of the airstrip during an aborted landing. A contributing factor was dusk light conditions.NTSB DFW06LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 777-233ER · DFW Int'l Apt, TXThe in-flight encounter with turbulence in clouds resulting in a flight attendant being injured.NTSB DFW06CA111Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Midlothian, TXThe inadvertent deployment of the spoilers during the aero tow takeoff for undetermined reasons, resulting in a hard landing.NTSB DFW06LA093Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Houston, TXThe failure by maintenance personnel to secure the tail rotor driveshaft cowling after performing maintenance which resulted in a loss of tail rotor control. A contributing factor was the pilot's improper preflight inspection of the tail rotor driveshaft area.NTSB DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.NTSB DFW06LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Denton, TXThe flight instructor's failure to maintain rotor RPM, resulting in a hard landing.NTSB DFW06CA105Accident · No injuriesData collectionFinal reportParks RV-7 · Fort Worth, TXThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the prevailing crosswind.NTSB DFW06LA104Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Lubbock, TXAn in-flight electrical fire for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06FA102Accident · 2 fatalField investigationFinal reportRobinson R44 II · Fredericksburg, TXThe pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.NTSB DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA087Accident · 1 fatalLimited investigationFinal reportWeatherly 201B · Hondo, TXA loss of aircraft control for undetermined reasons.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB DFW06CA085Accident · No injuriesData collectionFinal reportCessna 182 · Houston, TXThe pilot's failure to maintain directional control while taxiing. A contributing factor was the gusty winds.NTSB DFW06FA076Accident · 2 fatalField investigationFinal reportCessna 182N · Georgetown, TXThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control.NTSB DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.NTSB DFW06LA071Accident · Serious injuriesLimited investigationFinal reportHodge Express · Tyler, TXA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA065Accident · No injuriesData collectionFinal reportRalph Sanders Murphy Acft Elite · Presidio, TXThe pilot's failure to maintain directional control during the takeoff roll.NTSB DFW06CA064Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawaokecie PZL-104 Wilga 80 · Comstock, TXThe pilot's inadequate preflight planning and preparation leading to him becoming lost. Contributing factors were the unfavorable winds and the lack of suitable terrain for a precautionary landing.NTSB DFW06CA063Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gail, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/mush.