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 DFW07CA126Accident · Minor injuriesData collectionFinal reportGray Jack Tean Rocket F1 · Seabrook, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.NTSB DFW07CA123Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Banquete, TXThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.NTSB DFW07CA121Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lubbock, TXThe failure of the engine fuel supply line and the separation of the number one cylinder exhaust pipe resulting in an engine fire.NTSB DFW07LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Castroville, TXThe flight instructor's inability to maintain directional control due to the drag created by the tall grass adjacent to the runway. A contributing factor was the tall grass.NTSB DFW07GA119Accident · 1 fatalFinal reportEurocopter AS 350 B3 · San Elizario, TXThe pilot's encounter with a vortex ring state and his inability to maintain control of the helicopter.NTSB DFW07LA118Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Hilltop Lakes, TXThe loss of engine power due to carburetor ice. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions that were conducive to carburetor ice.NTSB DFW07CA122Accident · Minor injuriesData collectionFinal reportLuciani RV8 · Tomball, TXThe deflated right main landing gear tire, which resulted in a loss of control during the landing roll and a nose over. A factor associated with the accident was the pilot's decision to operate the airplane without having the leaking tire inspected.NTSB DFW07CA117Accident · Minor injuriesData collectionFinal reportCessna A188B · Fabens, TXThe pilot's failure to compensate for the existing wind conditions during takeoff. A contributing factor was the crosswind.NTSB DFW07CA114Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Edmonson, TXThe pilot's failure to maintain clearance with the crops.NTSB DFW07LA111Accident · Minor injuriesLimited investigationFinal reportBell 206B · Horseshoe Bay, TXThe pilot's loss of control as result of dynamic rollover while attempting to takeoff. Facrots were the landing skid becoming snagged and the soft terrain.NTSB DFW07CA112Accident · No injuriesData collectionFinal reportCessna 180 · Austin, TXThe loss of engine power as result of carburetor icing. Contributing factors were the lack of suitable terrain for the forced landing and the weather conditions conducive to carburetor icing.NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB DFW07LA103Accident · 2 fatalLimited investigationFinal reportLivpt Lancair IV-P · McAllen, TXA loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA102Accident · 1 fatalLimited investigationFinal reportWalker Zenith Zodiac 601 XL · Canadian, TXThe pilot's improper pre-flight planning and decision to depart into deteriorating weather conditions, which resulted in a loss of control and subsequent in-flight break up.NTSB DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe single-engine pilot's failure to avoid the jet blast while taxiing and the ground controller's inattentiveness to the situation, which resulted in the airplane's being blown over.NTSB DFW07CA098Accident · No injuriesData collectionFinal reportFlagg Kitfox IV · Centerville, TXThe loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07GA112Accident · 1 fatalFinal reportCessna 182R · Rachal, TXThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall/spin and subsequent impact with the ground. A factor was the gusty tailwind condition.NTSB DFW07CA096Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · Spring, TXThe student pilot's improper use of the flight controls resulting in dynamic rollover. Contributing factors were the delayed remedial action by the flight instructor and the uneven, muddy terrain conditions.NTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.NTSB SEA07LA111Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Van Horn, TXClearance was not maintained after landing by the instructor pilot, which resulted in an on ground collision with the helicopter standing near the refueling pumps. The aircraft standing in the refueling area was a factor.NTSB SEA07CA100Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA093Accident · No injuriesData collectionFinal reportDwayne Smith RV-6 · Fort Worth, TXThe loss of engine power during cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA091Accident · No injuriesData collectionFinal reportCessna 320C · McKinney, TXThe collapsed of the right main landing gear as result of the failure of the over center down lock.NTSB DFW07LA090Accident · 1 fatalLimited investigationFinal reportSchilleci RV-6 · Sinton, TXThe pilot's loss of control while performing an instrument approach. A contributing factor was the prevailing fog.NTSB DFW07TA089Accident · Minor injuriesFinal reportPiper PA-18 · Sweetwater, TXThe loss of engine power due to the failure of the throttle lever/linkage. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA087Accident · No injuriesLimited investigationFinal reportPZL 101A · Spicewood, TXThe loss of engine power due to water contamination in the fuel system. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB DFW07CA086Accident · No injuriesData collectionFinal reportBrantly Helicopter B2 · Vernon, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA085Accident · Minor injuriesData collectionFinal reportCessna 150 · Brownfield, TXThe pilot's failure to maintain aircraft control while maneuvering. A contributing factor was the gusty wind conditions.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna T210R · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB DFW07LA078Accident · Serious injuriesLimited investigationFinal reportCessna T182T · Athens, TXThe loss of engine power as result of the failure of a mechanic to properly check the torque on the input and output fuel lines to the fuel transducer during the manufacturing process. A contributing factor was the lack of suitable terrain for the forced…NTSB DFW07IA077Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dallas, TXThe pilot's failure to maintain directional control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.NTSB DFW07CA074Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Granbury, TXThe pilot's misjudgment of altitude and distance while landing, which resulted in an undershoot of the runway. A contributing factor was the rising terrain on approach to the runway.NTSB DFW07CA066Accident · No injuriesData collectionFinal reportBell ARH-70 Exp. · Mansfield, TXFuel starvation due to blockage in a fuel system check valve which was the result of the improper assembly of fuel boost pump by company maintenance personnel.NTSB DFW07FA073Accident · 1 fatalField investigationFinal reportCessna 210K · Lago Vista, TXThe pilot's failure to maintain clearance from terrain. A factor was the pilot's diverted attention with a reported autopilot malfunction.NTSB DFW07CA072Accident · No injuriesData collectionFinal reportAmerican Legend AL-11 · Dryden, TXThe pilot's inadequate compensation for the existing crosswind conditions and failure to maintain proper runway alignment.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB DFW07CA069Accident · Serious injuriesData collectionFinal reportCessna 172 · Lancaster, TXThe spectator's inadvertent contact with the turning propeller while the airplane was standing with the engine operating. A contributing factor was the dark night conditions.NTSB DFW07CA068Accident · No injuriesData collectionFinal reportFortuna Sonex · Atlanta, TXThe pilot's failure to maintain an adequate airspeed that resulted in a stall/mush. A contributing factor was the group of trees located near the departure end of the runway.NTSB DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA061Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Fulshear, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07CA060Accident · No injuriesData collectionFinal reportTanker DR-107 One Design · Rockwall, TXA loss of engine power for an undetermined reason during a go-around, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · El Paso, TXThe pilot's foot becoming lodged behind the right rudder pedal which resulted in a loss of directional control during landing.NTSB DFW07CA053Accident · No injuriesData collectionFinal reportEnstrom F28A · Bruceville, TXThe instructor pilot's improper demonstration of an autorotation, resulting in the helicopter's main rotor blades impacting the ground.NTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.