Fatal NTSB investigations, 2016, 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\") = 2016
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") = 2016 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 CEN16LA347Accident · 1 fatalLimited investigationFinal reportHaggenmacher Bensen · Bryant, ARThe pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…NTSB CEN16FA341Accident · 1 fatalField investigationFinal reportBeech A36 · Bentonville, ARThe pilot's failure to monitor and/or transmit his position over the uncontrolled airport's common traffic advisory frequency, and his decision to continue the takeoff when he observed conflicting traffic on the runway.NTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.NTSB CEN16FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Jonesboro, ARThe pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…NTSB CEN16FA210Accident · 1 fatalField investigationFinal reportCessna 175 · Pine Bluff, ARA loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…NTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…NTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…