NTSB investigations, 1973, AR
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1973
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") = 1973 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 FTW74DPG41Accident · No injuriesClosedPiper PA-32 · Mena, ARNTSB FTW74FPG40Accident · No injuriesClosedBeech E55 · Fort Smith, ARNTSB FTW74DPG38Accident · Minor injuriesClosedBeech B19 · Oxford, ARNTSB FTW74DPG39Accident · No injuriesClosedCessna 172 · Carlisle, ARNTSB FTW74FPG37Accident · Serious injuriesClosedCessna 182N · Brookland, ARNTSB FTW74FPG35Accident · Serious injuriesClosedCessna 172E · Mt Home, ARNTSB FTW74DPG36Accident · Minor injuriesClosedBeech A23-19 · Salem, ARNTSB FTW74FPG34Accident · No injuriesClosedBeech 65-90 · De Queen, ARNTSB FTW74FPG33Accident · No injuriesClosedPiper PA-28 · Mena, ARNTSB FTW74FPG32Accident · Serious injuriesClosedPiper J3C-65 · Lepanto, ARNTSB FTW74DPG31Accident · Minor injuriesClosedMooney M20C · Lakeview, ARNTSB FTW74FPG29Accident · Serious injuriesClosedCessna 172H · Carlisle, ARNTSB FTW74DPG30Accident · No injuriesClosedAero Comdr S-2R · Fisher, ARNTSB FTW74AF020Accident · No injuriesClosedPiper PA-34 · Pocahontas, ARNTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, ARNTSB FTW74FPG27Accident · Minor injuriesClosedPiper PA-25 · Rohwer, ARNTSB FTW74FPG26Accident · No injuriesClosedBell 47G2A1 · Little Rock, ARNTSB DCA74AZ006Accident · 11 fatalClosedConvair 600 · Mena, ARNTSB FTW74FPG25Accident · No injuriesClosedCessna 180 · Hot Springs, ARNTSB FTW74FPG24Accident · Serious injuriesClosedAeronca 7BC · Lake Village, ARNTSB FTW74AF018Accident · 2 fatalClosedChampion 7KCAB · Jacksonville, ARNTSB FTW74DPG22Accident · No injuriesClosedN.American SNJ-5 · W Memphis, ARNTSB FTW74FPG23Accident · Serious injuriesClosedBell 47G2 · Viola, ARNTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARNTSB FTW74FPG21Accident · No injuriesClosedLuscombe 8A · Van Buren, ARNTSB FTW74FPG19Accident · Serious injuriesClosedCessna 188 · Marvell, ARNTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARNTSB FTW74DPG17Accident · No injuriesClosedPiper J-3 · Stuttgart, ARNTSB FTW74DPG16Accident · No injuriesClosedGrumman G-164 · Clarkedale, ARNTSB FTW74FPG15Accident · No injuriesClosedCessna 182 · Arkadelphia, ARNTSB FTW74DPG14Accident · Minor injuriesClosedPiper PA-18 · Barton, ARNTSB FTW74DPG20Accident · Minor injuriesClosedCessna 172 · West Memphis, ARNTSB FTW74FPG12Accident · 1 fatalClosedPiper PA-25 · Wabbaseka, ARNTSB FTW74DPG11Accident · No injuriesClosedGrumman G-164A · Dewitt, ARNTSB FTW74DPG10Accident · No injuriesClosedBell 47G · Black Rock, ARNTSB FTW74AF007Accident · 4 fatalClosedCessna 180 · Monticello, ARNTSB FTW74DPG07Accident · No injuriesClosedPiper PA-31 · West Helena, ARNTSB FTW74DPG09Accident · No injuriesClosedPiper J-3 · Arkadelphia, ARNTSB FTW74DPG08Accident · No injuriesClosedBoeing A75 · Conway, ARNTSB FTW74DPG06Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARNTSB FTW74FPG04Accident · No injuriesClosedCessna 172I · Mena, ARNTSB FTW74FPG05Accident · No injuriesClosedCallair A-5 · Arkadelphia, ARNTSB FTW74FPG03Accident · No injuriesClosedBeech A23A · N.Little Rock, ARNTSB FTW74FPG02Accident · No injuriesClosedCessna 337 · Hot Springs, ARNTSB FTW74FPG01Accident · No injuriesClosedPiper PA-11 · Lewisville, ARNTSB FTW73DPG66Accident · No injuriesClosedCessna 305 · Almyra, ARNTSB FTW73DPG64Accident · No injuriesClosedBeech B55 · Pine Bluff, ARNTSB FTW73DPG63Accident · No injuriesClosedCessna 188 · Mcgehee, ARNTSB FTW73DPG62Accident · No injuriesClosedCessna A188B · Tucker, ARNTSB FTW73FPG57Accident · No injuriesClosedCessna 170A · Conway, AR