NTSB investigations, 2019, TX
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2019
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") = 2019 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 CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB CEN20LA037Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Beeville, TXThe solo student pilot's improper cyclic input during takeoff, which resulted in dynamic rollover.NTSB ERA20LA054Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · San Antonio, TXMaintenance personnel’s failure to complete all necessary steps of a service bulletin and subsequent failure to identify the loose lower actuator bearing support bracket during inspections, which resulted in the misalignment of the clutch actuator, resulted…NTSB CEN20FA032Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Victoria, TXThe pilot’s loss of control due to spatial disorientation. Contributing to the accident were the inoperative attitude indicator and horizontal situation indicator on the pilot’s side of the cockpit, and the pilot’s failure to reference the flight instruments…NTSB CEN20TA031Accident · No injuriesClass 3Final reportBeech 36 · Spring Branch, TXThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…NTSB CEN20FA023Accident · 3 fatalClass 3 · FieldFinal reportPiper PA24 · San Antonio, TXThe loss of engine power for reason that could not be determined. Contributing to the accident was the pilot’s failure to maintain aircraft control while maneuvering to landing which resulted in an inadvertent stall/spin with insufficient altitude to recover.NTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.NTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.NTSB CEN20LA020Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tyler, TXA total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.NTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.NTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.NTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.NTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB GAA20CA054Accident · Serious injuriesData collectionFinal reportBeech 200 · New Braunfels, TXThe airplane’s in-flight collision with a bird.NTSB CEN20FA012Accident · 2 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Hebbronville, TXThe failure of the spotter helicopter pilot to maintain clearance from the gunner helicopter while maneuvering. Contributing to the accident were the effects from the pilot’s use of impairing drugs.NTSB CEN20LA013Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502 · Lamesa, TXThe pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.NTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.NTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.NTSB GAA20CA031Accident · No injuriesData collectionFinal reportErcoupe 415 · Alvin, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport landing, during which the airplane landed hard and then ground looped.NTSB GAA20CA013Accident · No injuriesData collectionFinal reportSocata TBM700 · Breckenridge, TXThe pilot's failure to maintain bank control and adequate altitude during the approach, which resulted in his failure to maintain the runway heading and a subsequent collision with trees and terrain.NTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.NTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.NTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.NTSB CEN20LA004Accident · No injuriesClass 3 · LimitedFinal reportBeech B36 · Ranger, TXA lack of climb performance after takeoff for reasons that could not be determined based on the available information.NTSB GAA20CA005Accident · No injuriesData collectionFinal reportPavel Vagner Tango · Dublin, TXThe pilot's improper landing flare and failure to maintain lateral control, which resulted in a hard landing, loss of directional control, and subsequent roll-over.NTSB CEN20LA005Accident · No injuriesLimited investigationFinal reportZenair Zenith CH 701 · Garden Ridge, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA19CA587Accident · No injuriesData collectionFinal reportBeech 36 · Lubbock, TXThe pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…NTSB CEN19LA326Accident · No injuriesClass 3 · LimitedFinal reportVans Vans RV-10 · Lancaster, TXA partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.NTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB CEN19LA331Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Orange, TXA total loss of engine power due to a fatigue failure of the fuel line from the fuel manifold to the No. 1 cylinder.NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.NTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.NTSB CEN19LA304Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28D-180 · Midlothian, TXMisalignment of the fuel selector valve when the right fuel tank was selected, which restricted fuel flow and resulted in a total loss of engine power due to fuel starvation.NTSB GAA19CA548Accident · No injuriesData collectionFinal reportCessna 180 · Lancaster, TXThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.NTSB CEN19CA336Accident · No injuriesData collectionFinal reportPiper PA38 · Taylor, TXThe flight instructor's inadequate supervision of the student's soft-field takeoff, which resulted in an excessive pitch attitude, settling effect, and impact with a ditch off the end of the runway.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA295Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Olney, TXA loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.NTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…NTSB GAA19CA510Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Waco, TXThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover.NTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.NTSB CEN19LA267Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC6 · San Marcos, TXThe pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.NTSB CEN19LA266Accident · Serious injuriesClass 3 · LimitedFinal reportCanadair CL600 2B16 · Lubbock, TXThe unexpected wake turbulence encounter while climbing in smooth air to cruise, resulting in passenger injuries. Contributing to the accident was the passenger seat belt sign was off.NTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.