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 DFW05CA206Accident · No injuriesData collectionFinal reportCessna 182T · Houston, TXThe gear-up landing as result of the separation of the hydraulic line in the landing gear extension system.NTSB DFW05CA225Accident · No injuriesData collectionFinal reportAyres S2R-T15 · Taylor, TXThe pilot's misjudgement while landing resulting in an overrun. A factor was fluctuating engine power.NTSB DFW05CA220Accident · No injuriesData collectionFinal reportRobinson R-44 · Odessa, TXThe pilot's failure to maintain main rotor RPM and the improper landing flare which resulted in a hard landing.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB DFW05CA223Accident · Serious injuriesData collectionFinal reportAerostar International RX-8 · Denton, TXThe passenger's failure to follow landing instructions, which resulted in serious injury. A contributing factor was the high wind.NTSB DFW05CA210Accident · No injuriesData collectionFinal reportMcCain RV-8 · Stephenville, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA209Accident · No injuriesData collectionFinal reportRockwell S-2R · Lyford, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA211Accident · No injuriesData collectionFinal reportSchleicher ASW-27b · Encinal, TXThe pilot's misjudgment of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DFW05CA201Accident · Minor injuriesData collectionFinal reportSmith Aerostar 601P · Sinton, TXThe pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…NTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DFW05LA193Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540-T · Denison, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the low altitude.NTSB DFW05CA195Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · New Braunfels, TXThe student pilot's failure to maintain control of the helicopter and delayed remedial action by the flight instructor.NTSB DFW05FA192Accident · 2 fatalField investigationFinal reportAero Commander 112 · Junction, TXThe pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.NTSB DFW05CA189Accident · No injuriesData collectionFinal reportRockwell International S-2R · Hamlin, TXThe failure of the propeller blade seal resulting in an oil leak. Contributing factors were the limited forward visibility and lack of suitable terrain for the precautionary landing.NTSB DFW05FA185Accident · 3 fatalField investigationFinal reportMooney M20J · Saginaw, TXThe pilot's loss of control for undetermined reasons while maneuvering.NTSB DFW05CA181Accident · No injuriesData collectionFinal reportMesserschmitt BK-117 B-2 · Houston, TXThe separation of the left passenger door due to worn attaching hardware.NTSB DFW05CA157Accident · Serious injuriesData collectionFinal reportGrumman AA1B · Llano, TXThe partial loss of engine power for undetermined reasons during takeoff resulting in an overrun. A factor was the high density altitude.NTSB DFW05CA174Accident · No injuriesData collectionFinal reportLearjet 25 · Amarillo, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the prevailing crosswind.NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.NTSB DFW05LA175Accident · No injuriesLimited investigationFinal reportNorth American T-28B · Abilene, TXThe pilot's failure to maintain clearance while taxiing. Contributing factors were the pilot's diverted attention and the inaccurate frequency listing for ground control.NTSB DFW05CA173Accident · No injuriesData collectionFinal reportAyres S-2R · Eagle Lake, TXThe pilot's failure to maintain directional control during landing.NTSB DFW05CA168Accident · No injuriesData collectionFinal reportHughes 269C · Bruceville, TXThe flight instructor's improper flare during autorotation, which resulted in a hard landing. Contributing factor was, the lack of suitable terrain.NTSB DFW05CA172Accident · Serious injuriesData collectionFinal reportGarlick Helicopters OH-58A+ · Graham, TXThe pilot's failure to maintain clearance with the wire while maneuvering during an aerial application flight. Low altitude flight is a contributing factor.NTSB DFW05LA167Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Carizzo Springs, TXThe failure of the stabilator trim control rod due to internal corrosion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA165Accident · Minor injuriesLimited investigationFinal reportCessna 401A · Houston, TXThe loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA163Accident · No injuriesData collectionFinal reportCarterCopter CarterCopter · Olney, TXThe pilot's inability to maintain control of the gyrocraft during a forced landing as a result of a loss of cyclic and collective control. Contributing factors were the sheared propeller drive pulley bolts, broken wire on the co-pilots cyclic boost control…NTSB DFW05LA159Accident · 1 fatalLimited investigationFinal reportHughes 269A · Rusk, TXA loss of engine power for undermined reasons, and the subsequent collision with power lines and the ground. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA155Accident · No injuriesData collectionFinal reportCessna A188B · Goodlett, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain (soft) for the forced landing.NTSB DFW05CA158Accident · Minor injuriesData collectionFinal reportRose Parakeet A-1 · Boyd, TXThe in-flight separation of the outboard section of the propeller for unknown reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05FA152Accident · 1 fatalField investigationFinal reportBeech 76 · Conroe, TXThe pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.NTSB DFW05IA150Incident · No injuriesIncident investigationFinal reportCessna 208B · Clarendon, TXThe loss of total engine power due to damage of the compressor stator vanes caused by a foreign object. A contributing factor was an in-flight ingestion of bird(s).NTSB DFW05LA151Accident · Minor injuriesLimited investigationFinal reportBeaton RV-6A · Boerne, TXThe hard landing as a result of the pilot’s improper flare and his failure to recover from a bounced landing. A contributing factor was the pilot's diverted attention.NTSB DFW05CA146Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Waller, TXThe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed resulting in fuel exhaustion and a stall.NTSB DFW05LA153Accident · No injuriesLimited investigationFinal reportParkwood Enterprises Glasair Super II-S · Los Fresnos, TXA blocked fuel line in the fuel tank, which resulted in a loss of engine power due to fuel starvation.NTSB DFW05CA144Accident · Minor injuriesData collectionFinal reportHughes 269A · Sherman, TXThe applicant's failure to maintain directional control of the helicopter during a simulated power failure from a hover and the FAA inspector's delayed remedial action resulted in a dynamic rollover.NTSB DFW05CA148Accident · No injuriesData collectionFinal reportAermacchi Bosbok AM 3-C · Marfa, TXThe pilot's failure to attain adequate airspeed, and his premature liftoff resulting in a loss of directional control.NTSB DFW05LA139Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Arcola, TXThe pilot's failure to maintain directional control and airspeed which resulted in an inadvertent stall while attempting a go-around. A contributing factor was the quartering tailwind.NTSB DFW05CA142Accident · No injuriesData collectionFinal reportWestland Wasp · Denison, TXThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Roanoke, TXThe pilot's misjudgment of distance needed to land to a full stop resulting in an overrun. Contributing factors were the prevailing rain and the encounter with hydroplaning conditions.NTSB DFW05LA138Accident · 1 fatalLimited investigationFinal reportStearman D75 · Taylor, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was low altitude selected by the pilot.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB DFW05CA132Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Tornillo, TXThe loss of engine power as result of the failure of a cylinder.NTSB DFW05CA128Accident · Serious injuriesData collectionFinal reportBellanca 17-30A · Houston, TXThe pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.NTSB DFW05LA126Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Ralls, TXThe pilot's failure to maintain clearance from the antenna tower. Contributing factors were the recency of the tower's construction and the lack of obstruction lights on the tower.NTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.NTSB DFW05CA127Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Rock Springs, TXThe pilot's failure to maintain clearance with a static line. A contributing factor was the low altitude.NTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.