Fatal NTSB investigations, 2002, OK
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
| 1964 | 12 |
|---|---|
| 1965 | 11 |
| 1966 | 7 |
| 1967 | 14 |
| 1968 | 14 |
| 1969 | 10 |
| 1970 | 10 |
| 1971 | 17 |
| 1972 | 8 |
| 1973 | 16 |
| 1974 | 13 |
| 1975 | 9 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 8 |
| 1979 | 13 |
| 1980 | 16 |
| 1981 | 10 |
| 1982 | 14 |
| 1983 | 18 |
| 1984 | 19 |
| 1985 | 12 |
| 1986 | 10 |
| 1987 | 3 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 9 |
| 1991 | 10 |
| 1992 | 12 |
| 1993 | 7 |
| 1994 | 10 |
| 1995 | 8 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 9 |
| 1999 | 9 |
| 2000 | 7 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 6 |
| 2006 | 6 |
| 2007 | 6 |
| 2008 | 7 |
| 2009 | 6 |
| 2010 | 8 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 9 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 2 |
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\" = 'OK' 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" = 'OK' 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 FTW03FA053Accident · 1 fatalField investigationFinal reportCessna 172N · Lindsay, OKThe in-flight separation of the right wing due to the missing nut that secures the right wing's strut to fuselage fitting to the fuselage.NTSB FTW03FA051Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · McAlester, OKThe pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…NTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.NTSB FTW02LA134Accident · 1 fatalLimited investigationFinal reportRobinson Tierra II · Hooker, OKthe loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.NTSB FTW02LA125Accident · 1 fatalLimited investigationFinal reportHoward Harder Skybolt · Claremore, OKThe failure of the pilot to maintain clearance with terrain for undetermined reasons while conducting aerobatic maneuvers. A factor contributing to the accident was the physical impairment of the pilot.