NTSB investigations, 1976, AR
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1976
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") = 1976 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 FTW77DPG12Accident · No injuriesClosedThorp T-18 · Dumas, ARNTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARNTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARNTSB FTW77FPG11Accident · No injuriesClosedBeech A56TC · Ft.Smith, ARNTSB FTW77DPG10Accident · No injuriesClosedPiper PA-28R · Dermott, ARNTSB FTW77FA017Accident · 1 fatalClosedErco 415-C · Little Rock, ARNTSB FTW77DPG09Accident · Minor injuriesClosedPiper PA-23 · Melbourne, ARNTSB FTW77DPG07Accident · Minor injuriesClosedGlobe GC-1B · Blythville, ARNTSB FTW77DPG08Accident · Serious injuriesClosedCessna 170B · Rogers, ARNTSB FTW77DPG06Accident · No injuriesClosedBeech 23 · Paragould, ARNTSB FTW77FPG05Accident · No injuriesClosedPiper PA-28 · Salem, ARNTSB FTW77DPG04Accident · No injuriesClosedGreat Lakes 2T-1A · Van Buren, ARNTSB FTW77FPG03Accident · No injuriesClosedBeech D55 · Hot Springs, ARNTSB FTW77FPG02Accident · No injuriesClosedPiper PA-32 · Mountain Home, ARNTSB FTW76DPG01Accident · No injuriesClosedPiper PA-25 · Manila, ARNTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARNTSB FTW76AF122Accident · 3 fatalClosedCessna 421B · Ashdown, ARNTSB FTW76DPH13Accident · No injuriesClosedBeech 58P · Gurdon, ARNTSB FTW76FPH12Accident · 1 fatalClosedPitts Spcl · El Dorado, ARNTSB FTW76DPH11Accident · No injuriesClosedBellanca 14-132 · Searcy, ARNTSB FTW76DPH10Accident · No injuriesClosedBoeing B75 · Dumas, ARNTSB FTW76DPH09Accident · No injuriesClosedCessna 180 · Walnut Ridge, ARNTSB FTW76DPH04Accident · Serious injuriesClosedPiper J-3 · Lakevillage, ARNTSB FTW76FPH06Accident · No injuriesClosedCessna 172 · Ola, ARNTSB FTW76DPH05Accident · No injuriesClosedLuscombe 8A · Little Rock, ARNTSB FTW76DPH02Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARNTSB FTW76AF116Accident · 2 fatalClosedBeech 58 · Lake Village, ARNTSB FTW76FPH03Accident · No injuriesClosedBell 47H-1 · Tuckerman, ARNTSB FTW76DPH01Accident · No injuriesClosedAero Comdr 600S2R · Eudora, ARNTSB FTW76FPG97Accident · Serious injuriesClosedPiper PA-25 · Altheimer, ARNTSB FTW76DPG99Accident · No injuriesClosedBeech 95-B55 · Van Buren, ARNTSB FTW76DPG96Accident · Minor injuriesClosedCessna 172 · Centerville, ARNTSB FTW76FPG98Accident · Serious injuriesClosedCessna 150J · Batesville, ARNTSB FTW76DPH08Accident · No injuriesClosedHiller Acft FH1100 · Lake City, ARNTSB FTW76DPG95Accident · No injuriesClosedBell 47G-2 · Harrisburg, ARNTSB FTW76DPG94Accident · No injuriesClosedCessna 172 · Augusta, ARNTSB FTW76DPG93Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARNTSB FTW76DPG89Accident · No injuriesClosedGrumman G-164 · Gillett, ARNTSB FTW76FPG87Accident · No injuriesClosedCessna 206 · Fayetteville, ARNTSB FTW76DPG92Accident · No injuriesClosedSnow 600S2R · Garland City, ARNTSB FTW76DPG88Accident · Minor injuriesClosedPiper PA-25 · Marion, ARNTSB FTW76DPG86Accident · No injuriesClosedGrumman G-164A · Wheatley, ARNTSB FTW76DPG90Accident · No injuriesClosedGrumman G-164 · Gibson Switch, ARNTSB FTW76DPG91Accident · No injuriesClosedAeronca 7AC · Searcy, ARNTSB FTW76DPG85Accident · No injuriesClosedAero Comdr 600S2R · Garland, ARNTSB FTW76FPG84Accident · No injuriesClosedLuscombe 8A · Mountain Home, ARNTSB FTW76DPG83Accident · No injuriesClosedPiper PA-28 · Ft.Smith, ARNTSB FTW76FPG79Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARNTSB FTW76FPG82Accident · Serious injuriesClosedQuinn MK-5A · Corning, ARNTSB FTW76DPG81Accident · No injuriesClosedCessna A185E · Jennie, AR