NTSB investigations, TX
580 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 32 |
|---|---|
| 1983 | 32 |
| 1984 | 34 |
| 1985 | 26 |
| 1986 | 25 |
| 1987 | 23 |
| 1988 | 24 |
| 1989 | 17 |
| 1990 | 23 |
| 1991 | 25 |
| 1992 | 19 |
| 1993 | 21 |
| 1994 | 17 |
| 1995 | 20 |
| 1996 | 19 |
| 1997 | 21 |
| 1998 | 25 |
| 1999 | 19 |
| 2000 | 21 |
| 2001 | 21 |
| 2002 | 13 |
| 2003 | 25 |
| 2004 | 20 |
| 2005 | 25 |
| 2006 | 17 |
| 2007 | 16 |
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\" = 250)
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" = 250) 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 DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB DFW08CA041Accident · No injuriesData collectionFinal reportCessna 172P · Bridgeport, TXThe pilot's failure to maintain direction control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB DFW08CA014Accident · No injuriesData collectionFinal reportAir Tractor 402B · Taft, TXThe pilot's failure to maintain control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.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 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 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 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 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 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 DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.NTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.NTSB DFW07FA036Accident · 3 fatalField investigationFinal reportCessna 310Q · Waco, TXThe pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…NTSB DFW07LA026Accident · 2 fatalLimited investigationFinal reportKeesler Pulsar · Alvarado, TXThe pilot's improper handling of the airplane while manuevering at a low altitude, which resulted in an inadvertant stall.NTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.NTSB DFW06CA189Accident · Serious injuriesData collectionFinal reportPiper PA19/L-18C · Katy, TXThe pilot's failure to maintain adequate airspeed while maneuvering resulting in an inadvertent stall/spin.NTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.NTSB DFW06CA156Accident · Minor injuriesData collectionFinal reportCampbell W/Smiley J Execytive 162F · Porter, TXThe pilot's loss of control after encountering dynamic rollover while hovering.NTSB DFW06FA140Accident · 2 fatalField investigationFinal reportAviat A-1B · Edna, TXThe pilot's ostentatious display while maneuvering at low altitude which resulted in an inadvertent stall/spin and subsequent impact with the water.NTSB DFW06FA136Accident · 2 fatalField investigationFinal reportCessna 150F · Levelland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Contributing factors were low altitude and the gusting wind.NTSB DFW06CA133Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · La Porte, TXThe student pilot's inadequate weather evaluation and his failure to maintain airspeed which resulted in a stall. A contributing factor was the prevailing tailwind.NTSB DFW06CA123Accident · Minor injuriesData collectionFinal reportBell 47G-2 · Rosenberg, TXThe pilots encounter with loss of tail rotor effectiveness during an aerial application flight. A contributing factor was the gusty winds.NTSB DFW06LA087Accident · 1 fatalLimited investigationFinal reportWeatherly 201B · Hondo, TXA loss of aircraft control for undetermined reasons.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB DFW06FA076Accident · 2 fatalField investigationFinal reportCessna 182N · Georgetown, TXThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control.NTSB DFW06CA063Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gail, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/mush.NTSB DFW06CA043Accident · No injuriesData collectionFinal reportMooney M20J · San Antonio, TXThe pilot's failure to maintain sufficient airspeed on takeoff, which resulted in an inadvertent stall and subsequent hard landing.NTSB DFW06CA042Accident · No injuriesData collectionFinal reportCASA 1.131E · McKinney, TXThe pilot's failure to maintain directional control and airspeed, which resulted in an inadvertent stall. A contributing factor was the pilot's helmet and goggles shifting while maneuvering.NTSB DFW06CA032Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Anahuac, TXThe student pilot's loss of directional control during the landing. A contributing factor was the flight instructor' delayed remedial action.NTSB DFW06LA028Accident · 1 fatalLimited investigationFinal reportRehler Gyrocopter · New Braunfels, TXThe pilot's failure to maintain control while landing. A contributing factor was the high winds.NTSB DFW06CA030Accident · No injuriesData collectionFinal reportCessna 172N · Arlington, TXThe students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.NTSB DFW06FA021Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Tomball, TXThe pilot's failure to maintain control of the aircraft while attempting to execute a missed approach procedure in weather that was below landing minimums. Contributing factors were the low ceiling, and the below approach landing minimums.NTSB DFW06FA019Accident · 2 fatalField investigationFinal reportCessna 500 · Houston, TXThe pilot's failure to maintain directional control of the airplane resulting in an inadvertent stall/mush. Contributing factors were the unsecured passenger door and the pilot's diverted attention.NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.NTSB DFW06CA003Accident · No injuriesData collectionFinal reportHarms KitFox Series 5 · La Porte, TXThe pilot's failure to obtain/maintain adequate airspeed on takeoff, which resulted in two hard landings and subsequent loss of control.NTSB DFW06CA001Accident · No injuriesData collectionFinal reportCessna 195 · Addison, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the wind gusts.NTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.NTSB DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.NTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DFW05LA193Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540-T · Denison, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the low altitude.NTSB DFW05CA195Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · New Braunfels, TXThe student pilot's failure to maintain control of the helicopter and delayed remedial action by the flight instructor.NTSB DFW05FA185Accident · 3 fatalField investigationFinal reportMooney M20J · Saginaw, TXThe pilot's loss of control for undetermined reasons while maneuvering.NTSB DFW05FA152Accident · 1 fatalField investigationFinal reportBeech 76 · Conroe, TXThe pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.