NTSB investigations, 2017, TX
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1962 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 397 |
| 1965 | 415 |
| 1966 | 429 |
| 1967 | 433 |
| 1968 | 360 |
| 1969 | 357 |
| 1970 | 330 |
| 1971 | 310 |
| 1972 | 260 |
| 1973 | 292 |
| 1974 | 318 |
| 1975 | 292 |
| 1976 | 312 |
| 1977 | 316 |
| 1978 | 276 |
| 1979 | 304 |
| 1980 | 293 |
| 1981 | 367 |
| 1982 | 295 |
| 1983 | 256 |
| 1984 | 255 |
| 1985 | 229 |
| 1986 | 185 |
| 1987 | 195 |
| 1988 | 153 |
| 1989 | 154 |
| 1990 | 143 |
| 1991 | 132 |
| 1992 | 130 |
| 1993 | 136 |
| 1994 | 119 |
| 1995 | 164 |
| 1996 | 141 |
| 1997 | 138 |
| 1998 | 141 |
| 1999 | 136 |
| 2000 | 140 |
| 2001 | 135 |
| 2002 | 119 |
| 2003 | 126 |
| 2004 | 137 |
| 2005 | 129 |
| 2006 | 108 |
| 2007 | 117 |
| 2008 | 125 |
| 2009 | 120 |
| 2010 | 127 |
| 2011 | 121 |
| 2012 | 126 |
| 2013 | 102 |
| 2014 | 120 |
| 2015 | 110 |
| 2016 | 126 |
| 2017 | 91 |
| 2018 | 119 |
| 2019 | 116 |
| 2020 | 116 |
| 2021 | 97 |
| 2022 | 118 |
| 2023 | 104 |
| 2024 | 101 |
| 2025 | 103 |
| 2026 | 91 |
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 year(c.\"eventDate\") = 2017
AND 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 year(c."eventDate") = 2017 AND 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 CEN18LA071Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Angleton, TXThe passenger's inadvertent activation of the left brake during landing, which resulted in a loss of directional control and a runway excursion.NTSB CEN18CA058Accident · No injuriesData collectionFinal reportPiaggio P.180 · Georgetown, TXThe pilot's inadequate compensation for crosswind conditions, which resulted in a hard landing and the right main landing gear collapsing.NTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.NTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.NTSB CEN18FA035Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Electra, TXThe pilot's failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB GAA18CA034Accident · No injuriesData collectionFinal reportAirbus Helicopters EC 130 · La Paloma, TXThe separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.NTSB CEN18LA020Accident · No injuriesLimited investigationFinal reportBell 206B · Groom, TXThe total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to operate the helicopter with minimum fuel on board.NTSB CEN18LA019Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502B · Olton, TXThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB CEN18LA017Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Port Mansfield, TXThe pilot’s improper landing flare, which led to a hard landing and the subsequent collapse of the nosewheel landing gear due to the overstress failure of the nosewheel landing gear trunnion casting.NTSB CEN18FA004Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Vernon, TXAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB CEN18LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sweetwater, TXThe loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.NTSB CEN18LA002Accident · Serious injuriesLimited investigationFinal reportCharles A Brazil MTO Sport · McCoy, TXThe pilot’s failure to maintain clearance from a powerline during landing.NTSB CEN17CA371Accident · No injuriesData collectionFinal reportVans RV7 · Itasca, TXThe pilot’s inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA368Accident · 1 fatalLimited investigationFinal reportEris E. Ervin Quicksilver · Cleburne, TXAn engine loss of power due to fuel starvation from a broken fuel line between the fuel tank and the engine; the loss of engine power prevented the pilot from reaching a suitable landing area. Contributing to the accident was the inadequate maintenance of the…NTSB CEN17LA366Accident · No injuriesLimited investigationFinal reportEmerson Kitfox · Waller, TXA partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17FA342Accident · 2 fatalField investigationFinal reportRans S-6 · Stonewall, TXThe pilot's failure to maintain terrain clearance while conducting aerobatic flight maneuvers with insufficient altitude to recover.NTSB CEN17LA351Accident · No injuriesLimited investigationFinal reportCessna 340 · McKinney, TXThe failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.NTSB GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB DCA17CA194Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD 90-30 · El Paso, TXan inadvertent encounter with turbulence.NTSB CEN17LA336Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Burnet, TXThe pilot's inadequate inflight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA330Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Pearsall, TXThe fatigue crack of an engine cylinder, which resulted in a partial loss of engine power.NTSB GAA17CA510Accident · No injuriesData collectionFinal reportLuscombe 8 · Angleton, TXThe pilot’s failure to maintain directional control during landing.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB CEN17LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Beckville, TXA stuck exhaust valve, which resulted in the failure of the valve and a loss of engine power. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA466Accident · No injuriesData collectionFinal reportAB Sportine Aviacija LAK 17 · Uvalde, TXThe ground crewmember’s failure to fully engage the tow hook release arm during preflight, which resulted in the premature release of the glider at insufficient altitude to complete a safe landing.NTSB CEN17LA298Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Bullard, TXThe partial loss of engine power due to carburetor icing and the pilot's inability to maintain adequate airspeed during the soft-field takeoff, which resulted in an exceedance of the airplane's critical angle-of-attack and an aerodynamic stall.NTSB GAA17CA460Accident · No injuriesData collectionFinal reportCessna 305 · Eagle Lake, TXThe pilot’s loss of directional control during landing in variable wind conditions.NTSB GAA17CA457Accident · No injuriesData collectionFinal reportSwearingen SA26 · Hondo, TXThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.NTSB CEN17LA290Accident · Minor injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri G2 · Beaumont, TXThe flight instructor's low-altitude maneuvering, which exceeded the helicopter's performance capability in the high-density altitude conditions and resulted in a loss of control.NTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.NTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…NTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.NTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.NTSB GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB GAA17CA418Accident · No injuriesData collectionFinal reportPiper PA32 · San Antonio, TXThe pilot’s failure to extend the landing gear before touchdown.NTSB CEN17LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · El Paso, TXA partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.NTSB CEN17LA254Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Alpine, TXFracture of a compressor turbine (CT) blade due to operational overtemperatures and the failure of a maintenance technician to detect an existing crack in the CT blade during the last engine inspection.NTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.NTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.NTSB GAA17CA366Accident · No injuriesData collectionFinal reportBellanca 1730 · Burnet, TXThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing.NTSB GAA17CA356Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Matagorda, TXThe pilot’s failure to maintain helicopter control during an agricultural flight in gusting wind conditions.NTSB GAA17CA343Accident · No injuriesData collectionFinal reportBurkhart Grob G103C · Boerne, TXThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway.NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17FA209Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Dimmitt, TXThe pilot's incapacitation due to scarring from previous heart attacks and severe hypertrophy of the left ventricular wall which resulted in arrhythmia and a loss of control while maneuvering at low altitude.