Skip to content

NTSB investigations, 1974, AR

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 FTW75AF045Accident · No injuriesClosedBeech D55 · El Dorado, ARDec 29, 1974 · N318Q · Substantial damage NTSB FTW75AF038Accident · 4 fatalClosedCessna 414 · Pine Bluff, ARDec 6, 1974 · N44JG · Destroyed NTSB FTW75FPG29Accident · Serious injuriesClosedPiper PA-23 · Brickeys, ARNov 27, 1974 · N1375P · Substantial damage NTSB FTW75FPG28Accident · No injuriesClosedBell 47J-2A · Ft.Smith, ARNov 2, 1974 · N8567F · Substantial damage NTSB FTW75FPG26Accident · 1 fatalClosedGrumman G-164A · Lake Village, AROct 22, 1974 · N7995 · Destroyed NTSB FTW75FPG25Accident · No injuriesClosedBeech H35 · Alexander, AROct 20, 1974 · N5416D · Substantial damage NTSB FTW74FRJ18Accident · No injuriesClosedCessna 337 · Texarkana, AROct 19, 1974 · N6318F · Substantial damage NTSB FTW75FPG24Accident · Serious injuriesClosedMccullough J-2 · Brinkley, AROct 12, 1974 · N4352G · Destroyed NTSB FTW75DPG23Accident · No injuriesClosedPiper PA-25 · Cornerstone, AROct 8, 1974 · N7021Z · Substantial damage NTSB FTW75DPG27Accident · Serious injuriesClosedBoeing A75 · Roe, ARSep 29, 1974 · N50070 · Destroyed NTSB FTW74AF025Accident · 1 fatalClosedCessna 310F · West Memphis, ARSep 26, 1974 · N5839X · Destroyed NTSB FTW75AF022Accident · 2 fatalClosedCessna 150L · Parkin, ARSep 19, 1974 · N11958 · Destroyed NTSB FTW75FPG20Accident · Serious injuriesClosedTaylorcraft BC12-D · Jacksonville, ARSep 15, 1974 · N96768 · Destroyed NTSB FTW75DPG19Accident · No injuriesClosedGrumman G-164A · Almyra, ARSep 9, 1974 · N6531 · Substantial damage NTSB FTW75DPG22Accident · No injuriesClosedGrumman G-164 · Newark, ARSep 4, 1974 · N4294 · Substantial damage NTSB FTW75AF010Accident · 4 fatalClosedBeech C50 · Alma, ARAug 27, 1974 · N3713B · Destroyed NTSB FTW75FPG18Accident · No injuriesClosedPiper PA-28 · Seyppel, ARAug 24, 1974 · N15760 · Substantial damage NTSB FTW75FPG16Accident · No injuriesClosedGrumman G-164 · Dewitt, ARAug 24, 1974 · N989X · Substantial damage NTSB FTW75DPG15Accident · No injuriesClosedLake LA-4 · Redfield, ARAug 22, 1974 · N5020L · Substantial damage NTSB FTW75DPG17Accident · No injuriesClosedCessna 310B · West Helena, ARAug 19, 1974 · N3674D · Substantial damage NTSB FTW75DPG21Accident · No injuriesClosedCessna 182J · Cherokee Vlg, ARAug 18, 1974 · N2896F · Substantial damage NTSB FTW75AF007Accident · 4 fatalClosedBeech V35A · Mountain View, ARAug 16, 1974 · N7963R · Destroyed NTSB FTW75FPG13Accident · 1 fatalClosedPiper PA-25 · Fresno, ARAug 13, 1974 · N7411Z · Destroyed NTSB FTW75FPG14Accident · Serious injuriesClosedCessna 188 · Dermott, ARAug 12, 1974 · N9701V · Substantial damage NTSB FTW75DPG12Accident · No injuriesClosedGrumman G-164 · Coy, ARAug 3, 1974 · N586Y · Substantial damage NTSB FTW75FPG10Accident · No injuriesClosedHughes 269A · W.Memphis, ARJul 31, 1974 · N8751F · Destroyed NTSB FTW75DPG09Accident · No injuriesClosedPiper PA-25 · Piggott, ARJul 31, 1974 · N6379Z · Substantial damage NTSB FTW75FPG07Accident · No injuriesClosedAmer Avco AA-5 · Pine Bluff, ARJul 29, 1974 · N5409L · Substantial damage NTSB FTW75DPG08Accident · No injuriesClosedGrumman G-164A · Dumas, ARJul 26, 1974 · N4456 · Substantial damage NTSB FTW75FPG06Accident · Minor injuriesClosedJeanies Teenie · Carlisle, ARJul 24, 1974 · N3708 · Substantial damage NTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARJul 22, 1974 · N5416Q · Substantial damage NTSB FTW75AF003Accident · 2 fatalClosedAeronca 7AC · Stuttgart, ARJul 22, 1974 · N82372 · Destroyed NTSB FTW75DPG04Accident · No injuriesClosedAero Comdr 600S2C · Almyra, ARJul 15, 1974 · N3379 · Destroyed NTSB FTW75DPG02Accident · No injuriesClosedBell 47D-1 · Almyra, ARJul 6, 1974 · N13012 · Substantial damage NTSB FTW75DPG01Accident · No injuriesClosedGrumman G-164A · Walnut Ridge, ARJul 3, 1974 · N7926 · Substantial damage NTSB FTW74FPG79Accident · 1 fatalClosedBoeing E75 · Hazen, ARJun 29, 1974 · N69239 · Destroyed NTSB FTW74DPG82Accident · No injuriesClosedCessna 170B · Fort Smith, ARJun 28, 1974 · N3186B · Substantial damage NTSB FTW74DPG80Accident · No injuriesClosedAero Comdr A-9B · Grady, ARJun 28, 1974 · N7774V · Substantial damage NTSB FTW74FPG81Accident · Serious injuriesClosedCessna 120 · Altheimer, ARJun 27, 1974 · N1769V · Destroyed NTSB FTW74DPG77Accident · Minor injuriesClosedCallair A-6 · Sparkman, ARJun 27, 1974 · N2933G · Substantial damage NTSB FTW74DPG76Accident · No injuriesClosedPiper PA-25 · Pollard, ARJun 27, 1974 · N4798Y · Substantial damage NTSB FTW74FPG75Accident · Minor injuriesClosedCessna 190 · Brinkley, ARJun 24, 1974 · N1515D · Substantial damage NTSB FTW74FPG74Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARJun 21, 1974 · N6899Z · No damage NTSB FTW74DPG78Accident · No injuriesClosedGrumman G-164A · Wheatley, ARJun 20, 1974 · N4859 · Destroyed NTSB FTW74FPG73Accident · Serious injuriesClosedCessna 172 · N.Little Rock, ARJun 16, 1974 · N35520 · Substantial damage NTSB FTW74DPG71Accident · No injuriesClosedGrumman G-164A · West Memphis, ARJun 11, 1974 · N9678 · Substantial damage NTSB FTW74FPG72Accident · No injuriesClosedCessna 206 · Elaine, ARJun 10, 1974 · N50411 · Substantial damage NTSB FTW74DPG70Accident · No injuriesClosedCessna 188B · Mccrory, ARJun 4, 1974 · N9392G · Substantial damage NTSB FTW74FPG69Accident · Serious injuriesClosedPiper PA-28 · Hot Springs, ARJun 2, 1974 · N15889 · Substantial damage NTSB FTW74DPG68Accident · Minor injuriesClosedCessna 172 · Fordyce, ARJun 2, 1974 · N5390R · Substantial damage