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 CEN10LA052Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saginaw, TXThe pilot's inability to maintain control of the airplane due to a pinched trim system wire that resulted in a runaway nose-down pitch trim.NTSB CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…NTSB CEN10FA044Accident · 3 fatalField investigationFinal reportBeech A36 · Spring Branch, TXThe pilot's failure to maintain control of the airplane during cruise flight in instrument meteorological conditions. Contributing to this accident was the pilot’s lack of recent experience in flying in instrument meteorological conditions.NTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.NTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.NTSB CEN10FA028Accident · 4 fatalField investigationFinal reportBeech B100 · Benavides, TXThe pilot's failure to avoid severe weather, and the air traffic controller's failure to provide adverse weather avoidance assistance, as required by Federal Aviation Administration directives, both of which led to the airplane's encounter with a severe…NTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.NTSB CEN10LA008Accident · Minor injuriesLimited investigationFinal reportCrawford Alan R Glasair II · San Saba, TXA partial loss of engine power for undetermined reasons.NTSB CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.NTSB CEN09LA611Accident · 1 fatalLimited investigationFinal reportMckenna James E AVID-CATAL · Inks Lake, TXThe pilot’s decision to take off with a known airframe deficiency.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB CEN09IA595Incident · No injuriesIncident investigationFinal reportBeech V35 · Nacogdoches, TXThe complete loss of engine power due to failure of the number two connecting rod. The reason for the connecting rod failure could not be determined.NTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.NTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.NTSB CEN09LA575Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Preston, TXThe loss of engine power for undetermined reasons.NTSB CEN09CA581Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN09IA578Incident · No injuriesIncident investigationFinal reportCessna 421 · Sugar Land, TXThe improper installation of the pitch trim cable which resulted in it making improper contact with a guard pin that led to the fatigue failure of the cable.NTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.NTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.NTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.NTSB CEN09IA481Incident · No injuriesIncident investigationFinal reportRaytheon BE-400A · Sugar Land, TXThe failure of the spinner following an unavoidable bird strike. Contributing to the incident were the inadequate engine bird strike certification requirements in place at the time the engine was certified.NTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.NTSB CEN09LA445Accident · Serious injuriesLimited investigationFinal reportMarvin Faulk Tinker Bell · La Porte, TXThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in a collision with terrain.NTSB CEN09CA458Accident · No injuriesData collectionFinal reportCessna 172M · New Braunfels, TXThe pilot's inadequate recovery from a bounced landing.NTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.NTSB CEN09LA442Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Boyd, TXA total loss of engine power due to the pilot's improper leaning procedures, resulting in a forced landing and collision with a fence.NTSB CEN09CA431Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Porter, TXThe partial loss of engine power due to carburetor icing resulting in the pilot's inability to clear the wires.NTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.NTSB CEN09CA419Accident · No injuriesData collectionFinal reportCessna 182Q · Ballinger, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning.NTSB CEN09IA416Incident · No injuriesIncident investigationFinal reportMooney M20J · Midland, TXThe pilot’s failure to ensure the airplane was properly configured, which resulted in a wheels-up landing.NTSB CEN09CA406Accident · Serious injuriesData collectionFinal reportNorth American T-28B · Waxahachie, TXThe total loss of engine power for undetermined reasons.NTSB CEN09FA405Accident · 1 fatalField investigationFinal reportBeech C35 · Weslaco, TXThe pilot's failure to maintain aircraft control while operating with a fuel imbalance. Contributing to the accident was the pilot/owner's decision to fly the airplane outside of the operating limitations.NTSB CEN09LA400Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bastrop, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly verify the fuel load prior to departure.NTSB CEN09CA394Accident · Minor injuriesData collectionFinal reportSidler Mike Rotorway · Waxahachie, TXThe pilot’s failure to control his rate of descent during autorotation, which required an aggressive recovery maneuver and resulted in a sudden loss of tail rotor effectiveness.NTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.NTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.NTSB CEN09CA382Accident · Serious injuriesData collectionFinal reportBakeng Deuce · Beach City, TXThe loss of engine power due to fuel starvation resulting from a partially crimped fuel tank vent tube.NTSB CEN09LA379Accident · No injuriesLimited investigationFinal reportUrban Air Sro UFM-13 · Bourne Stage, TXThe pilot’s exceedance of the aircraft’s placarded never-exceed speed (Vne), resulting in aerodynamic flutter in the empennage and the subsequent in-flight structural failure of the aft portion of the fuselage.NTSB CEN09LA375Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mineola, TXThe pilot's failure to maintain control of the airplane during taxi, and his subsequent failure to maintain control after the inadvertent takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09CA352Accident · No injuriesData collectionFinal reportAviat A-1A · Marfa, TXThe pilot's failure to maintain control while landing in gusty winds.NTSB CEN09CA351Accident · No injuriesData collectionFinal reportBell 206B · Justin, TXThe instructor pilot's failure to add sufficient power early enough to compensate for the strong gusting headwinds.NTSB CEN09CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Brownwood, TXAn in-flight collision with a large bird while on the downwind leg of a traffic pattern.