NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARNTSB UNK65X1152Accident · No injuriesClosedBeech 23 · Rogers, ARNTSB UNK65X1138Accident · No injuriesClosedBeechraft 35-33 · Almyra, ARNTSB UNK65X0998Accident · No injuriesClosedBeechraft C35 · Pine Bluff, ARNTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARNTSB UNK65X0842Accident · 1 fatalClosedPiper PA-24 · El Dorado, ARNTSB UNK65X0770Accident · Minor injuriesClosedBeechraft AT-11 · Fayetteville, ARNTSB UNK65X0501Accident · No injuriesClosedPiper PA30 · Little Rock, ARNTSB UNK65X0422Accident · No injuriesClosedCessna 182 · Luxora, ARNTSB UNK65X0352Accident · No injuriesClosedMooney M18C · Heber Spring, ARNTSB UNK65X0307Accident · No injuriesClosedCessna 180 · Fayetteville, ARNTSB UNK65X0117Accident · No injuriesClosedCessna 180 · West Memphis, ARNTSB UNK64X4218Accident · No injuriesClosedBoeing B75N1 · Pocahontas, ARNTSB UNK64X4085Accident · No injuriesClosedCessna 182 · Dequeen, ARNTSB UNK64X4045Accident · No injuriesClosedBoeing 75N1 · Lepanto, ARNTSB UNK64X3907Accident · 1 fatalClosedBoeing A75 · Fulton, ARNTSB UNK64X3901Accident · No injuriesClosedBeechcraft B35 · Camden, ARNTSB UNK64X3884Accident · Minor injuriesClosedPiper PA22 · Melbourne, ARNTSB UNK64X3882Accident · No injuriesClosedBoeing A75 · Hickory Ridge, ARNTSB UNK64X3857Accident · Minor injuriesClosedBoeing B75N1 · Olyphant, ARNTSB UNK64X3815Accident · No injuriesClosedCessna 172E · Flippin, ARNTSB UNK64X3776Accident · 1 fatalClosedChampion 7GCB · Clarendon, ARNTSB UNK64X3775Accident · 1 fatalClosedPiper PA-18A · Winchester, ARNTSB UNK64X3733Accident · No injuriesClosedBoeing E75N1 · Hazen, ARNTSB UNK64X3721Accident · No injuriesClosedCallair A9 · Dewitt, ARNTSB UNK64X3703Accident · No injuriesClosedBell 47G · Stuttgart, ARNTSB UNK64X3700Accident · No injuriesClosedGrumman G164 · Hickory Ridge, ARNTSB UNK64X3696Accident · No injuriesClosedBoeing B75N1 · W Helena, ARNTSB UNK64X3533Accident · No injuriesClosedAeronca 7AC · Fayetteville, ARNTSB UNK64X3508Accident · No injuriesClosedCessna 175 · Pettigrew, ARNTSB UNK64X3486Accident · No injuriesClosedBeechcraft H35 · Walnut Ridge, ARNTSB UNK64X3463Accident · No injuriesClosedBoeing A75N1 · W Memphis, ARNTSB UNK64X3448Accident · Serious injuriesClosedAeronca 7AC · Mcdougal, ARNTSB UNK64X3440Accident · No injuriesClosedPiper PA18A · Scott, ARNTSB UNK64X3359Accident · No injuriesClosedBeechcraft M23 · Little Rock, ARNTSB UNK64X3354Accident · Minor injuriesClosedPiper PA28 · Dequeen, ARNTSB UNK64X3308Accident · Serious injuriesClosedPiper J3C · Gould, ARNTSB UNK64X3269Accident · No injuriesClosedBeech 35 · Pine Bluff, ARNTSB UNK64X3124Accident · No injuriesClosedBeechcraft K35 · Siloam Spring, ARNTSB UNK64X3116Accident · Minor injuriesClosedPiper J3C · Pine Bluff, ARNTSB UNK64X3098Accident · Minor injuriesClosedBoeing A75N1 · Humnoke, ARNTSB UNK64X2980Accident · No injuriesClosedLuscombe 8E · Caraway, ARNTSB UNK64X2953Accident · Serious injuriesClosedPiper PA18A · Pettus, ARNTSB UNK64X2894Accident · No injuriesClosedCessna 170A · Benton, ARNTSB UNK64X2807Accident · No injuriesClosedPiper PA25 · Fair Oaks, ARNTSB UNK64X2732Accident · No injuriesClosedPiper PA24 · Lake Village, ARNTSB UNK64X2692Accident · 1 fatalClosedConvair BT13 · Jonesboro, ARNTSB UNK64X2685Accident · No injuriesClosedBoeing A75N1 · Brinkley, ARNTSB UNK64X2668Accident · No injuriesClosedBeechcraft 35 · Springdale, ARNTSB UNK64X2607Accident · No injuriesClosedCessna 170 · Ft Smith, AR