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 DFW08CA016Accident · No injuriesData collectionFinal reportWard RC 350 HP · Magnolia, TXThe in-flight fire and loss of engine power as a result of a ruptured fuel line for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Houston, TXThe pilot's failure to properly position the fuel tank selector before takeoff. Contributing to the accident were the non suitable terrain for the forced landing and fuel starvation.NTSB DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB DFW08CA007Accident · No injuriesData collectionFinal reportCessna 172R · New Braunfels, TXThe pilot's improper recovery from a bounced landing.NTSB DFW08CA014Accident · No injuriesData collectionFinal reportAir Tractor 402B · Taft, TXThe pilot's failure to maintain control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.NTSB DFW08IA002Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron 206L-1 · Galveston, TXThe loss of tail rotor control during initial takeoff climb due to the fracture of a tail rotor blade as result of impact with a foreign object.NTSB DFW08LA001Accident · Serious injuriesLimited investigationFinal reportIndus T211 Thorpedo · Denton, TXThe pilot's improper preflight planning and preparation which led to his getting lost on a local area flight and his failure to maintain clearance from the trees. Contributing to the accident were the prevailing dark night illumination and the pilot's lack of…NTSB DFW07IA212Incident · No injuriesIncident investigationFinal reportSchweizer 269D · Houston, TXThe fatigue failure during hover of the drive adapter between the engine and lower pulley drive shaft.NTSB DFW07CA211Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Navasota, TXThe hard landing as result of the pilot's improper landing flare.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.NTSB DFW07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Floydada, TXA leak in the outer ply of the BeCu bellows. This hole appeared to be the result of pitting corrosion, but the corroding agent was not determined.NTSB DFW07LA197Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Fort Stockton, TXThe failure of the v-belt drive system to the main rotor for undetermined reasons. Contributing to the accident was insufficient altitude to perform a successful autorotation.NTSB DFW07IA204Incident · No injuriesIncident investigationFinal reportMooney M20TN · Kerrville, TXThe incorrect wire labeling, resulting in the trim controls operating in the opposite direction of the pilot's input.NTSB DFW07CA195Accident · No injuriesData collectionFinal reportCessna 140 · Lubbock, TXThe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.NTSB DFW07LA191Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Borger, TXA loss of engine power while on approach due to fuel starvation. Contributing to the accident were a corroded carburetor fuel needle valve, inlet fuel screen and no suitable terrain for the forced landing.NTSB DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB DFW07CA186Accident · No injuriesData collectionFinal reportEurocopter Deutschland BK117 · Slaton, TXThe pilot's failure to maintain control of the hovering helicopter and the flight instructor's improper supervision of the flight.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB DFW07CA175Accident · Minor injuriesData collectionFinal reportMellema Bede 4 · Ennis, TXThe pilot's inability to maintain control of the airplane following the disconnect of the tailwheel steering chain while landing.NTSB DFW07LA173Accident · Serious injuriesLimited investigationFinal reportBell 206B · Grand Prairie, TXThe loss of engine power as result of the failure of one or more of the compressor blades for the 5th stage compressor for undetermined reasons. A contributing factor was the lack of suitable terrain for the pilot to execute a successful autorotation.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.NTSB DFW07CA177Accident · No injuriesData collectionFinal reportAeronca Champion · Kirbyville, TXThe pilot's inability to maintain directional control during takeoff roll as result of the failure of the airplane's tailwheel's steering arm.NTSB DFW07LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Slaton, TXAn uncontained failure of the turbine engine's power section for undetermined reasons.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA156Accident · Minor injuriesData collectionFinal reportBell 47G-2A · Mercedes, TXThe pilot's failure to maintain clearance from the power transmission line.NTSB DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.NTSB DFW07CA151Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Eldorado, TXThe loss of engine power as result of water contamination due to a faulty seal on the refuel tank port. A contributing factor was t he lack of suitable terrain for the forced landing.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · Lueders, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.NTSB DFW07CA145Accident · No injuriesData collectionFinal reportEvektor sportstar · Grand Prairie, TXLoss of control due to an unexpected crosswind gust. *This report was modified on May 23, 2008.*NTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.NTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB DFW07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rockport, TXThe pilots improper landing flare which resulted in a hard landing. Contributing factors were the pilot's delayed actions to abort a wheels-up landing.NTSB DFW07CA125Accident · Minor injuriesData collectionFinal reportCessna A188B · Happy, TXAn in-flight fire while maneuvering for an undetermined reason.NTSB DFW07CA128Accident · No injuriesData collectionFinal reportDoggett Jack Samson · Conroe, TXThe failure of the main landing gear for undetermined reasons.