Fatal NTSB investigations, 2002, TX
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 1 |
|---|---|
| 1964 | 42 |
| 1965 | 35 |
| 1966 | 37 |
| 1967 | 42 |
| 1968 | 53 |
| 1969 | 40 |
| 1970 | 33 |
| 1971 | 44 |
| 1972 | 45 |
| 1973 | 49 |
| 1974 | 53 |
| 1975 | 50 |
| 1976 | 55 |
| 1977 | 44 |
| 1978 | 46 |
| 1979 | 35 |
| 1980 | 38 |
| 1981 | 62 |
| 1982 | 53 |
| 1983 | 50 |
| 1984 | 41 |
| 1985 | 34 |
| 1986 | 32 |
| 1987 | 30 |
| 1988 | 31 |
| 1989 | 27 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 24 |
| 1993 | 27 |
| 1994 | 19 |
| 1995 | 31 |
| 1996 | 21 |
| 1997 | 15 |
| 1998 | 33 |
| 1999 | 16 |
| 2000 | 31 |
| 2001 | 26 |
| 2002 | 21 |
| 2003 | 20 |
| 2004 | 23 |
| 2005 | 21 |
| 2006 | 13 |
| 2007 | 17 |
| 2008 | 21 |
| 2009 | 20 |
| 2010 | 21 |
| 2011 | 13 |
| 2012 | 26 |
| 2013 | 17 |
| 2014 | 21 |
| 2015 | 20 |
| 2016 | 19 |
| 2017 | 15 |
| 2018 | 15 |
| 2019 | 25 |
| 2020 | 26 |
| 2021 | 15 |
| 2022 | 20 |
| 2023 | 14 |
| 2024 | 16 |
| 2025 | 11 |
| 2026 | 10 |
Where
Latest 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\") = 2002
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2002 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.NTSB FTW03FA067Accident · 1 fatalField investigationFinal reportBeech F-35 · Addison, TXThe pilot's mismanagement of the fuel supply by his failure to switch fuel tank positions which resulted in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar.NTSB FTW03FA054Accident · 1 fatalField investigationFinal reportCessna 402C · Lewisville, TXThe failure of the attitude indicator, and the pilot's failure to maintain aircraft control as a result of spatial disorientation following the failure of the attitude indicator. Contributing factors were a low ceiling, clouds, and dark night conditions.NTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.NTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.NTSB FTW02FA243Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Decatur, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.NTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.NTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.NTSB FTW02FA211Accident · 1 fatalField investigationFinal reportNorth American AT-6A · Albany, TXThe pilot's failure to maintain aircraft control.NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB FTW02FA112Accident · 1 fatalField investigationFinal reportNorth American T-28B · Uvalde, TXThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB ATL02FA058Accident · 1 fatalField investigationFinal reportBeech BE-60 · Mexia, TXThe pilot's failure to remove the control lock before the flight and his failure to follow the checklist.NTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.NTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.