NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 FTW91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gilmer, TXA power loss due to the pilot's improper use of carburetor heat.NTSB FTW91LA022Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Boerne, TXThe pilot's inability to climb over obstacles due to encountering a downdraft which exceeded the climb capability of the airplane. Factors in the accident were the gusty wind conditions and the downdraft.NTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB FTW91LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe pilot's failure to follow the approved start procedures which resulted in an induction fire and the destruction of the airplane.NTSB FTW91LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Granbury, TXTotal loss of engine power due to fuel exhaustion. Factors were the pilot's improper fuel consumption calculations, and the darkness of the night.NTSB DEN91LA023Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Clifton, TXInadvertent stall. Factors were: tailwind, wrong runway selected, and failure to raise flaps.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB FTW91DRG01Accident · 1 fatalFinal reportTaylor Titch MK III · Seguin, TXThe pilot lost control at low level. Factors were the pilot attempting aerobatic maneuvers with insuffient altitude for recovery.NTSB FTW91LA014Accident · No injuriesLimited investigationFinal reportCessna 140 · Roanoake, TXThe pilot's failure to maintain directional control. A factor was his lack of flying tail wheel (conventional) gear airplanes.NTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.NTSB FTW91FA012Accident · 5 fatalField investigationFinal reportPiper 601P · Nacogdoches, TXFailure of the pilot to follow IFR procedures and maintain the proper altitude. Factors related to the accident were: the adverse weather conditions, dark night, low fuel state of the aircraft, and trees at the accident site.NTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB FTW91LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Abilene, TXPilot's failure to compensate for gusty wind condition.NTSB FTW91DPD01Accident · No injuriesFinal reportRans S-9 · Iowa Park, TXThe total loss of engine power due to fuel starvation as the result of a blocked fuel filter in the fuel system.NTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.NTSB FTW91LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Prairie, TXThe student pilot's improper flare technique and use of rudder.NTSB FTW91LA007Accident · No injuriesLimited investigationFinal reportBell 47G · Grand Prairie, TXThe pilot's inadequate compensation for the existing tailwind conditions and his failure to maintain rotor RPM.NTSB DEN91FA010Accident · 2 fatalField investigationFinal reportPiper PA-38-125 · Levelland, TXInadvertent stall/spin at an altitude insufficient to effect recovery.NTSB FTW91FA002Accident · 1 fatalField investigationFinal reportEnstrom F28-C · Mesquite, TXInstallation error of company maintenance personnel. Factors were the unsuitable terrain, the tailwind, the inability of the pilot to maintain main rotor RPM, and the inadequate annual inspection by company maintenance personnel.NTSB FTW91LA004Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Lampasas, TXThe failure of a cylinder intake valve spring.NTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW90LA188Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Albany, TXFuel starvation power loss due to the inadvertent movement of the fuel selector valve by the passenger.NTSB FTW90DPA09Accident · Minor injuriesFinal reportMoffitt, William A. Windryder · Mesquite, TXThe power loss due to failure of the ignition system due to improper installation by the operator. A factor was the wire struck during the emerency descent.NTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.NTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.NTSB FTW90FA183Accident · 1 fatalField investigationFinal reportHughes 269A · Kingsville, TXThe fatigue failure of the left flange on the tail boom saddle fitting.NTSB FTW90DRA10Accident · No injuriesFinal reportLockheed PV-2 · Conroe, TXThe engine starter remained engaged after engine start and the electrical system overheat.NTSB FTW90FA181Accident · 1 fatalField investigationFinal reportCessna 152 · Blue Ridge, TXThe pilot's decision to perform buzzing type maneuvers, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB FTW90LA180Accident · No injuriesLimited investigationFinal reportMooney M-10 · Roscoe, TXThe pilot's loss of directional control. A factor was: rough/uneven terrain.NTSB FTW90FA178Accident · 1 fatalField investigationFinal reportBell B206LI · Port O'Connor, TXThe pilot's failure to maintain proper altitude. Factors were the pilot's decision to fly into the known adverse weather and the weather/light conditions.NTSB FTW90FA177Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300T · Addison, TXFatigue failure of the throttle cable. Factors related to the accident were: darkness and objects (fence and utility poles) in the emergency landing area.NTSB FTW90DRA08Accident · No injuriesFinal reportBlaine Laux Pitts S-1 · Edna, TXA power loss due to failure of a connecting rod bolt. A factor was the soft terrain in which the forced landing was performed.NTSB FTW90DPA08Accident · Minor injuriesFinal reportMorris Avid Flyer · Kerens, TXThe pilot's improper compensation for the wind conditions and the resultant inadvertent stall. Factors related to the accident were: the gusty crosswind condition and the pilot's extension of full flaperons before descending to the proper altitude.NTSB FTW90FA176Accident · 2 fatalField investigationFinal reportBeech 36 · Baird, TXThe pilot-in-command failed to maintain control of the airplane while flying in severe weather and instrument meteorological conditions. The adverse weather conditions were a factor.NTSB FTW90LA175Accident · No injuriesLimited investigationFinal reportBeech C55 · Weatherford, TXThe fuel starvation induced power loss to the left engine, which resulted from the improper fuel tank being selected by the PIC.NTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…NTSB FTW90FA171Accident · 1 fatalField investigationFinal reportCessna 320 · Center, TXThe pilot's failure to maintain minimum control speed (VMC) and lack of qualification/training in multi-engine aircraft, which resulted in loss of aircraft control. A factor related to the accident was: failure of the left engine turbocharger, which resulted…NTSB FTW90FA167Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bulverde, TXMismanagement of the fuel supply resulting in fuel starvation. Factors were the pilot's lack of experience in the airplane, the dark night condition, and the trees.NTSB FTW90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denver City, TXThe pilot's improper leaning of the fuel mixture.NTSB DEN90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · League City, TXGround collision with an object during the landing roll during a forced landing following a complete power loss. The reason for the power loss is undetermined.NTSB FTW90LA165Accident · No injuriesLimited investigationFinal reportCessna 150M · Kerrville, TXThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's failure to refuel. Contributing to the accident was the pilot becoming lost.NTSB FTW90IA169Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · College Station, TXPropeller and engine (powerplant) overspeed.NTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.NTSB FTW90MA161Accident · 3 fatalMajor investigationFinal reportGrumman G-159 · Houston, TXPartial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB DEN90DQA03Accident · No injuriesFinal reportPiper PA-25-235 · Fabens, TXEngine failure due to shorting of the magneto's 'p' lead, and failure of the exhaust manifold.NTSB FTW90LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Houston, TXFuel exhaustion due to refueling not performed.NTSB FTW90LA156Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-300 · Corpus Christi, TXThe airplane's unexpected encounter with clear air turbulence.