NTSB investigations, TX
148 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 14 |
|---|---|
| 1983 | 13 |
| 1984 | 13 |
| 1985 | 11 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 4 |
| 1990 | 10 |
| 1991 | 10 |
| 1992 | 2 |
| 1993 | 7 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2007 | 5 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 DFW08LA020Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Catarina, TXThe loss of control due to the pilot's failure to maintain clearance with trees while hovering . A contributing factor was the low altitude.NTSB DFW07LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · Lueders, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DFW07CA114Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Edmonson, TXThe pilot's failure to maintain clearance with the crops.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 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 DFW05TA056Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe inadequate supervision and delayed remedial action by the flight instructor, which resulted in an inadvertent dynamic rollover.NTSB DFW05LA041Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Texas City, TXThe pilot's failure to maintain clearance with terrain while performing aerobatics at a low altitude.NTSB FTW04TA237Accident · 1 fatalFinal reportBell OH-58C · Beaumont, TX**This probable cause was modified on 2/22/2016. Please see the public docket for this accident for additional details.** The pilot's failure to maintain a safe altitude, resulting in collision with the water. A factor was the dark night.NTSB FTW04CA224Accident · Minor injuriesData collectionFinal reportCessna 172S · Leakey, TXThe pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.NTSB FTW03LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Fabens, TXThe pilot's failure to maintain terrain clearance. The pilot's attempt to avoid an obstacle was a contributing factor.NTSB FTW03CA146Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Robinson, TXThe pilot's failure to maintain clearance with the ground while performing a quick stop maneuver which resulted in a dynamic rollover.NTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.NTSB FTW02LA068Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXthe student pilot's failure to maintain directional control during landing.NTSB FTW02LA045Accident · No injuriesLimited investigationFinal reportCessna 140 · Gilchrist, TXthe pilot's improper use of carburetor heat during takeoff and his selection of a downwind runway, which resulted in a degradation of performance and the airplane impacting an embankment.NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB FTW01LA119Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Rosharon, TXthe pilot's failure to maintain aircraft control while maneuvering. Factors were the weather conditions and the muddy terrain.NTSB FTW01FA101Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Brackettville, TXthe pilot's intentional low flight and his poor judgment to intentionally fly into known adverse weather, which resulted in an in-flight collision with terrain. Contributing factors were the dark night conditions and the thunderstorm.NTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.NTSB FTW01FA065Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Pampa, TXthe pilot's failure to maintain terrain clearance. Contributing factors were the dark night and the fog.NTSB FTW01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Bishop, TXthe pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.NTSB FTW01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Burnet, TXthe pilot's failure to maintain proper glide path during a practice instrument approach, which resulted in an in-flight collision with terrain. Contributory factors to the accident were the dark night light condition and the safety pilot's inadequate…NTSB FTW01LA029Accident · 2 fatalLimited investigationFinal reportLandes/Karich/Schmidt Christen Eagle II · Tyler, TXthe pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain terrain clearance.NTSB FTW00LA269Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Tomball, TXThe student pilot's abrupt lowering of the collective. Factors were the student pilot's lack of experience in helicopters and the CFI's delayed remedial action.NTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.NTSB FTW00FA103Accident · 1 fatalField investigationFinal reportCessna 525 · Buda, TXthe pilot's inadequate in-flight decision to continue a visual approach in instrument meteorological conditions which resulted in his failure to maintain terrain clearance. Contributing factors were the fog, drizzle, and low ceilings.NTSB FTW99LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Marfa, TXThe pilot's failure to maintain clearance with the dirt bank during the landing flare.NTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.NTSB FTW99FA075Accident · 5 fatalField investigationFinal reportCessna 182B · Ozona, TXthe pilot's failure to obtain/maintain clearance from terrain during initial climb after take off. A contributing factor was the dark night.NTSB FTW98LA278Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain tail rotor-ground clearance due to his improper flare while hovering.NTSB FTW98FA127Accident · 1 fatalField investigationFinal reportIreneusz Rans S-12 · Rockwall, TXThe pilot's failure to maintain clearance while performing low altitude flight over the water.NTSB FTW98FA117Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Graford, TXThe pilot's failure to maintain clearance with the ground. Factors were the dark night, the rising terrain, and the ground fog obscuring the ground.NTSB FTW98LA098Accident · 1 fatalLimited investigationFinal reportPoling Keleher Lark KR1B · Georgetown, TXThe pilot's failure to maintain aircraft control. A contributing factor was the pilot's physical impairment due to drugs.NTSB FTW97LA300Accident · No injuriesLimited investigationFinal reportPoor Boys Toys Exec 90 · Patricia, TXThe failure of the pilot to maintain terrain clearance with the crops during a surveying flight. A factor was the pilots diverted attention.NTSB FTW97LA275Accident · 1 fatalLimited investigationFinal reportEichman Aerobat III · Brownsville, TXinadequate design by the pilot/builder/designer. Related factors were: the porpoise that was encountered by the pilot during the takeoff, and the subsequent jammed rudder.NTSB FTW97TA115Accident · Minor injuriesFinal reportPiper PA-18-150 · Laredo, TXthe pilot allowed the airplane to get into an excessive rate of descent, during approach for an off-airport landing.NTSB FTW97FA073Accident · 2 fatalField investigationFinal reportCessna 210L · Brackettville, TXfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while on a cross-country flight at night. Factors relating to the accident were: darkness, the prevailing low ceilings, and mountainous/hilly terrain.NTSB FTW97LA059Accident · No injuriesLimited investigationFinal reportCessna 340 · El Dorado, TXthe pilot's inadequate compensation for wind conditions. The gusty wind was a related factor.NTSB FTW97LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Plainview, TXthe pilot's continued descent below the minimum descent altitude (MDA). Factors relating to the accident were: darkness, the adverse weather conditions.NTSB FTW96LA131Accident · No injuriesLimited investigationFinal reportRobinson R22B · Garland, TXFailure of the pilot to maintain sufficient altitude and tail rotor clearance from the terrain, while demonstrating rearward movement in a hover.NTSB FTW96FA027Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Paint Rock, TXThe pilot's impairment of judgment and performance due to alcohol which resulted in his improper decision to shutdown an engine, and his failure to maintain adequate airspeed for single-engine flight.NTSB FTW95FA112Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Conroe, TXThe pilot's failure to follow published IFR procedures. Factors were the weather conditions, the dark night, and the pilot's failure to activate the approach lighting system.NTSB FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.NTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.NTSB FTW94FA272Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Van Horn, TXThe uncorrected descent by the pilot. A factor was the lack of total experience in type aircraft.NTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.NTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.NTSB FTW93LA249Accident · No injuriesLimited investigationFinal reportCessna T188C · Rockport, TXInadvertent stall/mush experienced by the pilot.NTSB FTW93FA235Accident · 1 fatalField investigationFinal reportMooney M20C · Big Lake, TXThe pilot's failure to maintain terrain clearance.NTSB FTW93FA096Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXThe pilot's failure to maintain control of the airplane for undetermined reasons