Fatal NTSB investigations, 2002, AR
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 | 13 |
|---|---|
| 1965 | 11 |
| 1966 | 10 |
| 1967 | 7 |
| 1968 | 8 |
| 1969 | 19 |
| 1970 | 7 |
| 1971 | 8 |
| 1972 | 11 |
| 1973 | 8 |
| 1974 | 13 |
| 1975 | 11 |
| 1976 | 11 |
| 1977 | 9 |
| 1978 | 14 |
| 1979 | 9 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 11 |
| 1983 | 7 |
| 1984 | 14 |
| 1985 | 13 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 10 |
| 1990 | 8 |
| 1991 | 12 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 5 |
| 1997 | 8 |
| 1998 | 10 |
| 1999 | 10 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 10 |
| 2003 | 4 |
| 2004 | 8 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 2 |
| 2010 | 8 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 8 |
| 2022 | 3 |
| 2023 | 6 |
| 2024 | 3 |
| 2025 | 5 |
| 2026 | 1 |
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\" = 'AR' 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" = 'AR' 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 FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.NTSB DEN03FA023Accident · 1 fatalField investigationFinal reportRockwell Commander 114 · Hot Springs, ARthe loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown…NTSB FTW03FA057Accident · 1 fatalField investigationFinal reportCessna 210L · Harrison, ARThe pilot's failure to maintain control of the aircraft and the exceedance of the manufactured limits, which resulted in an in flight break-up. Contributing factors were the dark night conditions and the clouds.NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB FTW03FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Lakeview, ARthe pilot's failure to maintain clearance with the terrain while maneuvering.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB FTW02LA264Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Edmondson, ARThe pilot's failure to maintain clearance from the high voltage power lines.NTSB FTW02LA151Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Jonesboro, ARThe loss of engine power for an undetermined reason.NTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.