NTSB investigations, 1977, AR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1977
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") = 1977 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 FTW78FPG11Accident · Minor injuriesClosedCessna 170A · Heber Springs, ARNTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARNTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARNTSB FTW78FPG09Accident · No injuriesClosedBeech 95-B55 · Siloam Springs, ARNTSB FTW78DPG08Accident · No injuriesClosedGrumman G-164A · Hazen, ARNTSB FTW78FRJ09Accident · Serious injuriesClosedCessna 150G · Texarkana, ARNTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNTSB FTW78DPG07Accident · No injuriesClosedPiper PA-28 · West Helena, ARNTSB FTW78FPG05Accident · No injuriesClosedPiper PA-24 · Booneville, ARNTSB FTW78FPG04Accident · No injuriesClosedBenson B8M · Rogers, ARNTSB FTW78DPG03Accident · No injuriesClosedBellanca 8GCBC · Marianna, ARNTSB FTW77FPG01Accident · No injuriesClosedPiper PA-34 · Little Rock, ARNTSB FTW77FPG90Accident · No injuriesClosedPiper PA-25 · Caraway, ARNTSB FTW77DPG89Accident · No injuriesClosedGrumman G-164 · Hughes, ARNTSB FTW77DPG88Accident · No injuriesClosedPiper PA-25 · Paragould, ARNTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARNTSB FTW77FPG87Accident · No injuriesClosedBeech D18S · Pine Bluff, ARNTSB FTW77FPG86Accident · No injuriesClosedBell 47G2H1 · Mountain View, ARNTSB FTW77FPG85Accident · No injuriesClosedCessna 188B · Portland, ARNTSB FTW77DPG84Accident · Serious injuriesClosedPiper PA-25 · Gregory, ARNTSB FTW77DPG82Accident · No injuriesClosedCessna 170A · West Helena, ARNTSB FTW77DPG81Accident · No injuriesClosedPiper PA-25 · Piggott, ARNTSB FTW77DPG83Accident · No injuriesClosedPiper PA-25 · Leachville, ARNTSB FTW77DPG80Accident · No injuriesClosedAero Commdr S-2R · Reydell, ARNTSB FTW77FPG78Accident · No injuriesClosedSnow S-2R · Wilmot, ARNTSB FTW77FPG79Accident · No injuriesClosedFairchild M-62 · Jonesboro, ARNTSB FTW77FPG77Accident · 1 fatalClosedWeatherly 201B · Cornerstone, ARNTSB FTW77DPG75Accident · No injuriesClosedGrumman G-164A · De Valls, ARNTSB FTW77FPG76Accident · No injuriesClosedGrumman G-164A · Tillar, ARNTSB FTW77DPG74Accident · No injuriesClosedPiper PA-28 · Lead Hill, ARNTSB FTW77FPG73Accident · Serious injuriesClosedPiper PA-24 · Garfield, ARNTSB FTW77DPG72Accident · No injuriesClosedGrumman G-164A · England, ARNTSB FTW77DPG70Accident · No injuriesClosedCessna 188 · Mcgehee, ARNTSB FTW77FPG71Accident · No injuriesClosedGrumman G-164A · Stuttgart, ARNTSB FTW77FPG68Accident · No injuriesClosedGrumman G-164 · Keo, ARNTSB FTW77FPG69Accident · Minor injuriesClosedCessna 411 · Paragould, ARNTSB FTW77FPG67Accident · No injuriesClosedCessna 310 · El Dorado, ARNTSB FTW77DPG65Accident · No injuriesClosedPiper PA-25 · Manila, ARNTSB FTW77FPG66Accident · No injuriesClosedCessna 188 · Brookland, ARNTSB FTW77FPG64Accident · No injuriesClosedPiper PA-25 · Coy, ARNTSB FTW77DPG63Accident · No injuriesClosedGrumman G-164A · Clarendon, ARNTSB FTW77DPG62Accident · No injuriesClosedGrumman G-164A · Jonesboro, ARNTSB FTW77DPG61Accident · No injuriesClosedGrumman G-164A · Hunter, ARNTSB FTW77FPG58Accident · Serious injuriesClosedAeronca 7AC · Almond, ARNTSB FTW77DPG57Accident · No injuriesClosedAero Comdr S-2R · Beedeville, ARNTSB FTW77FPG55Accident · Serious injuriesClosedPiper PA-25 · Des Arc, ARNTSB FTW77FPG60Accident · No injuriesClosedPiper PA-24 · Russellville, ARNTSB FTW77DPG56Accident · No injuriesClosedPiper PA-28R · Mt.Olive, ARNTSB FTW77DPG54Accident · No injuriesClosedCessna A188B · Parkin, AR