Skip to content

NTSB investigations, 1970, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations, 1970, AR per year, 1964–2026: 3,153 cases
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

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") = 1970 AND c."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1970
    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") = 1970
  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 FTW71FPG31Accident · No injuriesClosedBeech A23-24 · Arkadelphia, ARDec 24, 1970 · N6922Q · Substantial damage NTSB FTW71FPG30Accident · Minor injuriesClosedCessna 172H · Almyra, ARDec 14, 1970 · N3723R · Substantial damage NTSB FTW71FPG28Accident · No injuriesClosedAeronca 7AC · Smackover, ARNov 29, 1970 · N82324 · Substantial damage NTSB FTW71FPG29Accident · No injuriesClosedSport Acft Teenie · Jonesboro, ARNov 19, 1970 · N2168 · Substantial damage NTSB FTW71FPG27Accident · No injuriesClosedCessna 210D · Mansfield, AROct 22, 1970 · N3808Y · Substantial damage NTSB FTW71FPG26Accident · No injuriesClosedGrumman G-164A · Lonoke, AROct 20, 1970 · N5302 · Destroyed NTSB FTW71AF014Accident · 4 fatalClosedBeech C35 · Fayetteville, ARSep 26, 1970 · N5810C · Destroyed NTSB FTW71DPG25Accident · No injuriesClosedPiper PA-25 · Eudora, ARSep 25, 1970 · N4659Y · Substantial damage NTSB FTW71FPG24Accident · No injuriesClosedBeech A23 · Carlisle, ARSep 24, 1970 · N4797J · Substantial damage NTSB FTW71FPG23Accident · Minor injuriesClosedPiper PA-25 · Keo, ARSep 21, 1970 · N7299Z · Substantial damage NTSB FTW71FPG22Accident · No injuriesClosedPiper PA-25 · Grady, ARSep 18, 1970 · N6634Z · Destroyed NTSB FTW71FPG21Accident · No injuriesClosedPiper PA-22 · N Little Rock, ARSep 14, 1970 · N7026B · Substantial damage NTSB MKC71DCA15Accident · No injuriesClosedCessna 150 · Paragould, ARSep 12, 1970 · N3544J · Substantial damage NTSB FTW71DPG20Accident · No injuriesClosedCessna 188 · Marvell, ARSep 8, 1970 · N5526S · Substantial damage NTSB FTW71FPG18Accident · Minor injuriesClosedCessna 150 · Brinkley, ARSep 6, 1970 · N6797S · Substantial damage NTSB FTW71FPG19Accident · Serious injuriesClosedPiper PA-18 · Walnut Corner, ARSep 4, 1970 · N6188D · Destroyed NTSB FTW71FPG17Accident · No injuriesClosedGrumman G-164 · Gould, ARSep 3, 1970 · N464Y · Substantial damage NTSB FTW71AF009Accident · No injuriesClosedDassault M-20 · Jonesboro, ARSep 3, 1970 · N514T · Substantial damage NTSB FTW71FPG15Accident · Serious injuriesClosedBoeing E75 · Pickens, ARAug 31, 1970 · N64756 · Destroyed NTSB FTW71DPG16Accident · No injuriesClosedPiper PA-25 · Tuckerman, ARAug 31, 1970 · N8770L · Substantial damage NTSB FTW71FPG13Accident · No injuriesClosedPiper PA-25 · Cash, ARAug 20, 1970 · N4567Y · Substantial damage NTSB FTW71DPG14Accident · No injuriesClosedPiper PA-25 · Widener, ARAug 20, 1970 · N8644L · Substantial damage NTSB FTW71FPG12Accident · No injuriesClosedPiper PA-25 · Newport, ARAug 19, 1970 · N7545Z · Substantial damage NTSB FTW71DPG11Accident · Minor injuriesClosedCessna 150H · Hatfield, ARAug 16, 1970 · N23496 · Substantial damage NTSB FTW71FPG10Accident · 1 fatalClosedPiper PA-25 · Heth, ARAug 8, 1970 · N4930Y · Destroyed NTSB FTW71FPG08Accident · No injuriesClosedCallair A-9B · Grady, ARAug 5, 1970 · N7602V · Substantial damage NTSB FTW71FPG07Accident · 1 fatalClosedCallair A-9B · Coy, ARAug 3, 1970 · N7632V · Destroyed NTSB FTW71DPG02Accident · No injuriesClosedBell 47G-2 · Norfork, ARJul 30, 1970 · N6744D · Substantial damage NTSB FTW71FPG03Accident · No injuriesClosedPiper PA-25 · Wynne, ARJul 29, 1970 · N4861Y · Destroyed NTSB FTW71DPG05Accident · No injuriesClosedBoeing E75N1 · Wabash, ARJul 29, 1970 · N75676 · Substantial damage NTSB FTW71FPG01Accident · Minor injuriesClosedBell 47G · Weiner, ARJul 5, 1970 · N73873 · Destroyed NTSB FTW70FPG39Accident · No injuriesClosedBeech C-45-H · Nashville, ARJun 30, 1970 · N481E · Substantial damage NTSB FTW71DPG04Accident · No injuriesClosedAero Comdr S-2R · Eudora, ARJun 27, 1970 · N8877Q · Substantial damage NTSB FTW70FPG37Accident · No injuriesClosedBoeing A75 · Brinkley, ARJun 18, 1970 · N50056 · Substantial damage NTSB FTW70DPG38Accident · Minor injuriesClosedCessna T210H · Dequeen, ARJun 17, 1970 · N2210R · Substantial damage NTSB FTW70DPG34Accident · Minor injuriesClosedPiper PA-25 · Chicot, ARJun 12, 1970 · N7704Z · Destroyed NTSB FTW70FPG35Accident · Serious injuriesClosedCallair A9B · Newport, ARJun 10, 1970 · N7749V · Substantial damage NTSB FTW70DPG32Accident · No injuriesClosedCessna 140 · Springdale, ARJun 8, 1970 · N89846 · Substantial damage NTSB FTW70FPG30Accident · Serious injuriesClosedBeech B95 · Harrison, ARMay 31, 1970 · N9635R · Destroyed NTSB FTW70DPG33Accident · No injuriesClosedCessna 150 · Ravenden Spgs, ARMay 28, 1970 · N5734G · Substantial damage NTSB FTW70FPG36Accident · No injuriesClosedBeech T-34A · Clinton, ARMay 27, 1970 · N4937E · Substantial damage NTSB FTW70FPG31Accident · Minor injuriesClosedDowner 14-19 · Fort Smith, ARMay 24, 1970 · N416MB · Substantial damage NTSB FTW70DPG27Accident · Minor injuriesClosedCallair A-9 · Bradley, ARMay 22, 1970 · N3561G · Substantial damage NTSB FTW70FPG29Accident · No injuriesClosedGrumman G-164 · Forrest City, ARMay 20, 1970 · N471Y · Substantial damage NTSB FTW70FPG24Accident · No injuriesClosedCessna 310 · Fort Smith, ARMay 20, 1970 · N68E · Substantial damage NTSB FTW70FPG26Accident · No injuriesClosedPiper PA-28 · Nelsonville, ARMay 17, 1970 · N4307J · Substantial damage NTSB FTW70DRA19Accident · No injuriesClosedCessna 182B · Berryville, ARMay 16, 1970 · N71187 · Substantial damage NTSB FTW70AF074Accident · 5 fatalClosedCessna 170 · Nashville, ARMay 16, 1970 · N4119V · Destroyed NTSB FTW70FPG28Accident · Serious injuriesClosedKaman H-43A · Mountain View, ARMay 15, 1970 · N2843J · Destroyed NTSB FTW70FPG25Accident · No injuriesClosedGrumman G-164A · Amagon, ARMay 4, 1970 · N5309 · Substantial damage