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 FTW04LA198Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · La Porte, TXThe loss of engine power for undetermined reasons.NTSB FTW04CA200Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bay City, TXThe pilot's failure to maintain directional control during landing. A contributing factor was the pilot's decision to land with a quartering tailwind.NTSB FTW04LA195Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Columbus, TXthe pilot's failure to maintain directional control during the takeoff roll and abort the attempted takeoff.NTSB FTW04CA192Accident · Minor injuriesData collectionFinal reportRotorway Exec · Conroe, TXThe loss of engine power due to the tripped fuel pump circuit breaker which resulted in the failure of the electric fuel pump.NTSB FTW04LA189Accident · Serious injuriesLimited investigationFinal reportCalhoun RV-4 · Latexo, TXThe pilot's failure to maintain directional control and attain adequate airspeed resulting in a stall. Contributing factors were the pilot's diverted attention with closing the canopy, and the quartering crosswind.NTSB FTW04CA234Accident · No injuriesData collectionFinal reportLindstrand Balloons 90A · Allen, TXThe pilot's failure to maintain clearance with the power lines. A contributing factor was the gusty wind conditions.NTSB FTW04LA190Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Caddo Mills, TXThe other pilot's inability to maintain directional control during landing roll as a result of the failure of the landing gear.NTSB FTW04LA187Accident · Serious injuriesLimited investigationFinal reportSaladino Searey · Lewisville, TXThe pilot's failure to maintain control of the airplane during final approach. A contributing factor was the gusty crosswind condition.NTSB FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA175Accident · No injuriesLimited investigationFinal reportAeronca/Bubeck Bubeck-Aeronca · Burleson, TXThe pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the night visual conditions, and the lack of suitable terrain for landing.NTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB FTW04LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Dalhart, TXloss of engine power due to a corroded magneto for undetermined reasons.NTSB FTW04LA178Accident · No injuriesLimited investigationFinal reportCessna 172S · San Antonio, TXThe student pilot's failure to maintain control of the airplane during landing.NTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.NTSB FTW04LA164Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe separation of the right main landing gear wheel and axle during take-off. Contributing factors were the fatigue of the bolts on the right main landing gear and the rough and uneven terrain.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB FTW04CA161Accident · No injuriesData collectionFinal reportRuehle Glastar · Lancaster, TXThe pilot's improper flare resulting in a hard landing.NTSB FTW04LA159Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eagle Lake, TXThe partial collapse of the left main landing gear as a result of a failure of the fuselage structure due to corrosion.NTSB FTW04IA160Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-135LR · Dallas, TXThe loss of pressure in Electrohydraulic Servovalve (EHSV) within the nose wheel steering manifold due to contamination in the C1 orifice of the valve, which resulted in an uncommanded turn of the nose wheel during landing rollout. A contributing factor was…NTSB FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.NTSB FTW04LA157Accident · No injuriesLimited investigationFinal reportSnow S2C · La Feria, TXThe pilot's failure to maintain clearance from the obstacle while maneuvering to perform an aerial application. A contributing factor was the high vegetation.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB FTW04FA144Accident · 2 fatalField investigationFinal reportAviat A-1 · Harwood, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB FTW04FA143Accident · Minor injuriesField investigationFinal reportEurocopter AS355N · League City, TX"This case was modified may 30, 2006." The pilot's misjudged flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB FTW04LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Cleveland, TXThe in-flight fire that resulted from an electrical arc in the main battery cable near the main power bus. The cause of the arcing event could not be determined.NTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.NTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.NTSB FTW04LA133Accident · No injuriesLimited investigationFinal reportBell 412 · San Antonio, TXThe pilot's failure to maintain clearance with the parked helicopter while performing a hovering turn.NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.NTSB FTW04IA134Incident · No injuriesIncident investigationFinal reportBeech A23A · Kress, TXThe in-flight separation of the crankshaft for undetermined reasons.NTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.NTSB FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA128Incident · No injuriesIncident investigationFinal reportLockheed 1329-23E · Houston, TXThe fatigue failure of the inboard left wing actuator fitting.NTSB FTW04LA123Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-40 · Georgetown, TXThe failure of both pilot's to maintain an adequate visual lookout, which resulted in a midair collision between the two airplanes.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.NTSB FTW04LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lake Dallas, TXThe pilot's failure to maintain proper airspeed for flight resulting in a stall/spin during the forced landing. A contributing factors was the loss of engine power for undetermined reasons.NTSB FTW04LA119Accident · Minor injuriesLimited investigationFinal reportHolmes RV-6A · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA121Accident · No injuriesLimited investigationFinal reportCessna 150-G · Livingston, TXA loss of engine power due to the blockage of the fuel system vents, resulting in fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA117Accident · No injuriesLimited investigationFinal reportBell 407 · Hurst, TXThe student pilot's excessive flare prior to touchdown during the practice autorotation which resulted in the tailboom stinger striking the ground. A contributing factor was the flight instructor's delay to take remedial action.NTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.NTSB FTW04LA111Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Holliday, TXThe failure of the upper tail rotor shaft due to excessive misalignment after two hard landings. Also causal was the manufacturer's failure to provide specific maintenance procedures for checking the alignment of the upper tail rotor shaft.NTSB FTW04CA112Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · San Angelo, TXThe pilot's improper preflight performance planning, and his failure to establish a climb. Factors were the high density altitude and crosswind.NTSB FTW04LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sweetwater, TXThe propeller overspeed for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.NTSB FTW04LA108Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Goliad, TXThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.NTSB FTW04CA107Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Friona, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were prevailing crosswind, rain, and the restricted vision from water on the windscreen, and a vehicle parked near the runway.NTSB FTW04LA102Accident · No injuriesLimited investigationFinal reportWaco RBA · Temple, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the locked wheel.NTSB FTW04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.