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 FTW04LA004Accident · 2 fatalLimited investigationFinal reportColliander RV-8 · Van, TXThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors were the low ceilings, rain, and fog.NTSB FTW04CA002Accident · No injuriesData collectionFinal reportPrice Cuby Acro Trainer · Canutillo, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.NTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW03CA233Accident · Minor injuriesData collectionFinal reportHughes 269C · Gail, TXThe loss of control for undetermined reasons.NTSB FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.NTSB FTW03LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Houston, TXThe pilot's failure to maintain aircraft control during a landing. A contributing factor was the pilot's diverted attention while performing the after landing check.NTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.NTSB DEN03FA155Accident · 3 fatalField investigationFinal reportHawker Siddeley HS-125-700A · Beaumont, TXthe first pilot's failure to maintain aircraft control and adequate airspeed. Contributing factors included performing intentional stalls at too low an altitude to afford a safe recovery, the pilot's failure to add power in an attempt to recover, and the…NTSB FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.NTSB FTW03LA223Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Farwell, TXThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall.NTSB FTW03LA222Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Porter, TXThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane while landing. A contributing factor was the gusty winds.NTSB FTW03LA219Accident · No injuriesLimited investigationFinal reportCessna 150F · Knox City, TXThe student pilot's inadequate flight planning/decision, resulting in fuel exhaustion and the loss of engine power. Contributing factors were the student pilot's failure to refuel the airplane and lack of suitable terrain for the forced landing.NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB FTW03FA211Accident · Minor injuriesField investigationFinal reportAgusta A109E · Dallas, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the failure to maintain clearance with the safety fence during the aborted takeoff, which resulted in a dynamic rollover of the helicopter.NTSB FTW03LA209Accident · No injuriesLimited investigationFinal reportPilatus PC-6/C-H2 · Vigo Park, TXThe loss of propeller pitch control for undetermined reasons.NTSB FTW03LA203Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Ozona, TXThe pilot's decision to hover out of ground effect, which resulted in a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB FTW03LA206Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · McKinney, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall during landing. A contributing factor was flaring too high.NTSB FTW03LA199Accident · No injuriesLimited investigationFinal reportCessna T188C · Colorado City, TXThe loss of engine power due to failure of the crankshaft. A contributing factor was low altitude flight.NTSB FTW03LA197Accident · Minor injuriesLimited investigationFinal reportBell 206B · Mason, TXThe pilot's failure to maintain clearance with the power line. A contributing factor was the sunglare.NTSB FTW03CA201Accident · No injuriesData collectionFinal reportCessna 210D · San Antonio, TXThe pilot's failure to comply with the checklist resulting in a wheels up landing. Contributing to the accident was self-induced pressure.NTSB FTW03LA202Accident · Minor injuriesLimited investigationFinal reportBeech BE-36TC · Temple, TXThe pilot's failure to attain adequate airspeed and his failure to abort the takeoff roll resulting in an overrun.NTSB FTW03LA196Accident · No injuriesLimited investigationFinal reportHolmes Challenger II · Eldorado, TXThe loss of engine power during the takeoff/initial climb following the separation of the front cockpit throttle control cable resulting from inadequate maintenance.NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB FTW03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Alpine, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW03LA191Accident · No injuriesLimited investigationFinal reportBeech 19A · Fredericksburg, TXA partial loss of engine power due to a rich mixture and reduced airflow to the engine. Contributing factors were the owner's failure to obtain an annual inspection, and improper maintenance procedures used in the installation of the air filter.NTSB FTW03TA190Accident · Minor injuriesFinal reportHughes 269A · Freer, TXLoss of engine power for undetermined reasons.NTSB FTW03LA189Accident · Serious injuriesLimited investigationFinal reportBeech 35-A33 · Fort Worth, TXThe loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…NTSB FTW03LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kerrville, TXThe loss of engine power due to the failure of the number three cylinder as the result of undertorqued cylinder bolts. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD03CA065Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 Katana · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor in the accident was the pilot's lack of total flying experience.NTSB IAD03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Burnet, TXThe pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…NTSB FTW03FA184Accident · 2 fatalField investigationFinal reportCessna 172M · McAllen, TXThe pilot's failure to recover from a bounced landing which resulted in a loss of control. Contributing factors were the gusty winds.NTSB FTW03FA182Accident · 2 fatalField investigationFinal reportCessna 172S · McKinney, TXThe CFI's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing. A contributing factor was the impact with a bird, which affected the performance of the airplane.NTSB FTW03LA200Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · San Antonio, TXThe pilot's failure to maintain minimum required airspeed while maneuvering, resulting in an inadvertent stall of the airplane.NTSB FTW03CA180Accident · No injuriesData collectionFinal reportSchweizer G-164B · Vega, TXThe failure of the left brake for undetermined reasons.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.NTSB FTW03LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Gruver, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA179Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Spring, TXThe failure of the pilot to maintain aircraft control due to wake turbulence.NTSB FTW03LA173Accident · 1 fatalLimited investigationFinal reportApex CAP 10B · Gladewater, TXThe failure of the left wing, which resulted from progressive compressive fractures in the upper wooden spar cap. Contributing the accident was the difficulty in performing adequate inspections of the spar caps in an attempt to detect the compressive…NTSB LAX03LA193Accident · Serious injuriesLimited investigationFinal reportBoeing MD-82 · Fort Worth, TXThe encounter with severe turbulence during descent, prior to the cabin crew taking their seats, which resulted in serious injury to two flight attendants.NTSB FTW03LA172Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain rotor RPM and the improper landing flare resulting in a hard landing. A contributing factor was the prevailing high winds.NTSB LAX03LA192Accident · 1 fatalLimited investigationFinal reportArgus CA-7 · Angleton, TXthe pilot's loss of lateral aircraft control. Also causal was the pilot's intentional flight with an asymmetrical fuel loading, and his improper use of the fuel system. A factor in the accident was the insufficient information provided by the kit manufacturer…NTSB LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB FTW03LA168Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encinal, TXThe pilot's failure to maintain clearance from a tree. A contributing factor was the pilot's diverted attention.NTSB FTW03LA169Accident · Minor injuriesLimited investigationFinal reportKilishek RV-8 · Crawford, TXThe pilot's intentional ground looping of the airplane. A contributing factor was the pilot's improper in-flight planning resulting in an improper selection of a touchdown point.NTSB LAX03LA183Accident · Minor injuriesLimited investigationFinal reportBell 206B · Malone, TXa fuel starvation induced loss of engine power due to fuel contamination.NTSB LAX03LA180Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502A · Raywood, TXthe pilot's encounter with a stall/mush condition in the takeoff initial climb due to his inadequate preflight/pretakeoff procedures and failure to set the wing flaps to the proper takeoff configuration before beginning the takeoff ground roll.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB FTW03LA164Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Grand Prairie, TXthe pilot's improper inspection of the aircraft after impacting trees on a previous flight which resulted in an in-flight separation of the lower left wing and aileron while performing aerobatic maneuvers.