NTSB investigations, 1980, AR
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 85 |
|---|---|
| 1965 | 80 |
| 1966 | 87 |
| 1967 | 109 |
| 1968 | 81 |
| 1969 | 89 |
| 1970 | 76 |
| 1971 | 92 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 81 |
| 1975 | 107 |
| 1976 | 101 |
| 1977 | 91 |
| 1978 | 96 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 72 |
| 1982 | 68 |
| 1983 | 46 |
| 1984 | 89 |
| 1985 | 49 |
| 1986 | 48 |
| 1987 | 46 |
| 1988 | 61 |
| 1989 | 48 |
| 1990 | 65 |
| 1991 | 53 |
| 1992 | 57 |
| 1993 | 55 |
| 1994 | 54 |
| 1995 | 58 |
| 1996 | 44 |
| 1997 | 40 |
| 1998 | 44 |
| 1999 | 49 |
| 2000 | 23 |
| 2001 | 21 |
| 2002 | 37 |
| 2003 | 37 |
| 2004 | 31 |
| 2005 | 37 |
| 2006 | 28 |
| 2007 | 17 |
| 2008 | 22 |
| 2009 | 21 |
| 2010 | 32 |
| 2011 | 22 |
| 2012 | 23 |
| 2013 | 21 |
| 2014 | 17 |
| 2015 | 21 |
| 2016 | 22 |
| 2017 | 16 |
| 2018 | 20 |
| 2019 | 14 |
| 2020 | 16 |
| 2021 | 19 |
| 2022 | 21 |
| 2023 | 23 |
| 2024 | 14 |
| 2025 | 20 |
| 2026 | 13 |
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\") = 1980
AND c.\"eventStateOrRegion\" = 'AR' 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") = 1980 AND c."eventStateOrRegion" = 'AR' 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 FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARNTSB FTW81FPG07Accident · 1 fatalClosedBensen B8M · Sherrill, ARNTSB FTW81FPG06Accident · Serious injuriesClosedCessna 152 · Jasper, ARNTSB FTW81DPG08Accident · No injuriesClosedPiper PA-28R · Mountain Home, ARNTSB FTW81FPG03Accident · Serious injuriesClosedCessna 170B · Lakeview, ARNTSB FTW81FPG04Accident · Serious injuriesClosedPiper PA-28 · Benton, ARNTSB FTW81FPG02Accident · No injuriesClosedCessna 320D · N Little Rock, ARNTSB FTW81FA002Accident · Serious injuriesClosedCessna U206F · Lonoke, ARNTSB FTW81DPG01Accident · No injuriesClosedGrumman G-164A · Sherrill, ARNTSB FTW80FA126Accident · 4 fatalClosedPiper PA-24 · Hot Springs, ARNTSB FTW80DPG69Accident · No injuriesClosedPitts S-1 · Dumas, ARNTSB FTW80DPG68Accident · No injuriesClosedCessna 172I · Marianna, ARNTSB FTW80DA119Accident · No injuriesClosedPiper PA-28R · Mountain View, ARNTSB FTW80DA115Accident · No injuriesClosedPiper PA-32 · Shedidan, ARNTSB FTW80DPG66Accident · No injuriesClosedAero Comdr S2R · Swifton, ARNTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARNTSB FTW80DPG64Accident · No injuriesClosedCessna T210M · Cotter, ARNTSB FTW80FPG65Accident · Serious injuriesClosedCessna 150L · Clarksville, ARNTSB FTW80DPG62Accident · No injuriesClosedCessna 150H · Monticello, ARNTSB FTW80DPG61Accident · No injuriesClosedCessna 310G · Helena, ARNTSB FTW80DPG60Accident · Minor injuriesClosedCessna 188 · Marvell, ARNTSB FTW80DPG59Accident · Minor injuriesClosedSnow S2R · Cherry Valley, ARNTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARNTSB FTW80FPG58Accident · No injuriesClosedPiper PA-24 · Little Rock, ARNTSB FTW80FPG57Accident · Serious injuriesClosedPiper PA-25 · Humphrey, ARNTSB FTW80DPG56Accident · No injuriesClosedCessna 188 · Bradley, ARNTSB FTW80DPG55Accident · No injuriesClosedCessna 188 · Mcgehee, ARNTSB FTW80DPG54Accident · No injuriesClosedSnow S2R · Hickory Ridge, ARNTSB FTW80DPG52Accident · Minor injuriesClosedCessna 177 · O'Neal, ARNTSB FTW80DPG53Accident · No injuriesClosedAyres S2R · Winchester, ARNTSB FTW80DPG49Accident · No injuriesClosedPiper PA-25 · Grady, ARNTSB FTW80DPG50Accident · No injuriesClosedGrumman G-164A · Tuckerman, ARNTSB FTW80DPG48Accident · No injuriesClosedCessna 188 · Paragould, ARNTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARNTSB FTW80DPG47Accident · No injuriesClosedAeronca 7BCM · Bono, ARNTSB FTW80DPG45Accident · No injuriesClosedCessna A188B · Tyronza, ARNTSB FTW80DPG44Accident · No injuriesClosedGrumman G-164 · Heth, ARNTSB FTW80DPG43Accident · No injuriesClosedPiper PA-11 · Hazen, ARNTSB FTW80FPG41Accident · No injuriesClosedCessna 175 · Sherrill, ARNTSB FTW80DPG42Accident · Minor injuriesClosedPiper PA-18 · Hazen, ARNTSB FTW80DPG40Accident · No injuriesClosedGrumman G-164A · Cash, ARNTSB FTW80DPG51Accident · Minor injuriesClosedGrumman G-164B · Blythevl Afb, ARNTSB FTW80DPG39Accident · No injuriesClosedCessna 310 · Paris, ARNTSB FTW80DPG38Accident · No injuriesClosedGrumman G-164 · Hazen, ARNTSB FTW80FPG37Accident · No injuriesClosedBoeing PT-13D · N Little Rock, ARNTSB FTW80DPG36Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARNTSB FTW80DPG34Accident · No injuriesClosedGrumman G-164A · Conway, ARNTSB FTW80DPG33Accident · No injuriesClosedCessna 172F · Benton, ARNTSB FTW80DPG32Accident · No injuriesClosedCessna A188B · Evening Star, ARNTSB FTW80FPG30Accident · Serious injuriesClosedGlobe GC-1B · Carbon City, AR