Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 FTW79DPG13Accident · No injuriesClosedGrumman AA1-C · Strong, ARDec 28, 1978 · N9633U · Substantial damage NTSB FTW79FPG12Accident · No injuriesClosedBellanca 17-30 · Little Rock, ARDec 22, 1978 · N7382V · Substantial damage NTSB FTW79FA032Accident · 1 fatalClosedCessna 140A · Ferndale, ARDec 18, 1978 · N777RN · Destroyed NTSB FTW79FA024Accident · 3 fatalClosedPiper PA-28 · Texarkana, ARDec 15, 1978 · N6902J · Destroyed NTSB FTW79DPG11Accident · No injuriesClosedCessna 177RG · Jonesboro, ARDec 5, 1978 · N2109Q · Substantial damage NTSB FTW79DPG10Accident · No injuriesClosedCessna 310H · Little Rock, ARDec 1, 1978 · N1018Q · Substantial damage NTSB FTW79DPG09Accident · No injuriesClosedCessna 150 · Benton, ARNov 19, 1978 · N11485 · Substantial damage NTSB FTW79FPG06Accident · Serious injuriesClosedTaylorcraft F19 · Sulphur City, ARNov 5, 1978 · N3559T · Substantial damage NTSB FTW79DPG08Accident · No injuriesClosedCessna 150F · Mt.Ida, ARNov 5, 1978 · N2200W · Substantial damage NTSB FTW79FPG07Accident · No injuriesClosedPiper PA-12 · West Memphis, ARNov 4, 1978 · N4064M · Substantial damage NTSB FTW79FPG05Accident · No injuriesClosedBeech J35 · Newport, AROct 15, 1978 · N7221B · Substantial damage NTSB FTW78DPG03Accident · No injuriesClosedBeech C55 · Carlisle, AROct 5, 1978 · N9214 · Substantial damage NTSB FTW79DPG04Accident · No injuriesClosedCessna 310Q · De Queen, AROct 3, 1978 · N7707Q · Substantial damage NTSB FTW79FPG01Accident · Serious injuriesClosedCessna TU206 · Kirby, AROct 2, 1978 · N1492M · Substantial damage NTSB FTW78FPG02Accident · No injuriesClosedPiper PA-23E · Little Rock, AROct 2, 1978 · N63951 · Substantial damage NTSB FTW78DPG89Accident · No injuriesClosedThorp T-18 · N.Little Rock, ARSep 10, 1978 · N18Z · Substantial damage NTSB FTW78DPG88Accident · Minor injuriesClosedGrumman G-164A · Bald Knob, ARSep 10, 1978 · N9652 · Destroyed NTSB FTW78DPG84Accident · No injuriesClosedCessna 188 · West Point, ARSep 5, 1978 · N8277G · Substantial damage NTSB FTW78FPG85Accident · 1 fatalClosedPiper PA-18A · Lonoke, ARSep 4, 1978 · N2572P · Destroyed NTSB FTW78FPG83Accident · 1 fatalClosedWeatherly 201C · Elaine, ARAug 28, 1978 · N9002W · Destroyed NTSB FTW78DPG82Accident · No injuriesClosedPiper PA-24 · Clarksville, ARAug 28, 1978 · N7338P · Substantial damage NTSB FTW78DPG80Accident · No injuriesClosedCessna 150 · Springdale, ARAug 24, 1978 · N9320U · Substantial damage NTSB FTW78DPG81Accident · No injuriesClosedGrumman G-164A · Dermott, ARAug 23, 1978 · N8519H · Destroyed NTSB FTW78FPG79Accident · Minor injuriesClosedAero Comdr S-2R · Lunsford, ARAug 22, 1978 · N39765 · Destroyed NTSB FTW78FPG78Accident · 1 fatalClosedPiper PA-25 · Sherrill, ARAug 19, 1978 · N7383Z · Destroyed NTSB FTW78DPG77Accident · No injuriesClosedPiper PA-25 · Augusta, ARAug 16, 1978 · N9771P · Destroyed NTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARAug 13, 1978 · N5969G · Destroyed NTSB FTW78DPG75Accident · No injuriesClosedGrumman G-164A · Crawfordsville, ARAug 12, 1978 · N8379 · Substantial damage NTSB FTW78DPG76Accident · No injuriesClosedCessna 188 · Weiner, ARAug 11, 1978 · N3517Q · Substantial damage NTSB FTW78DPG74Accident · No injuriesClosedGrumman G-164A · Okean, ARAug 10, 1978 · N470Y · Destroyed NTSB FTW78FPG73Accident · No injuriesClosedDyke Delta JD-2 · N.Little Rock, ARAug 6, 1978 · N443B · Substantial damage NTSB FTW78FPG72Accident · No injuriesClosedCessna 337 · Marshall, ARAug 3, 1978 · N2646S · Substantial damage NTSB FTW78DPG71Accident · Minor injuriesClosedMaule M-5 · West Helena, ARAug 1, 1978 · N779EB · Substantial damage NTSB FTW78DPG70Accident · No injuriesClosedCessna 150 · Lakeview, ARJul 29, 1978 · N7143S · Destroyed NTSB FTW78FPG69Accident · Serious injuriesClosedGrumman G-164A · Dumas, ARJul 28, 1978 · N7443 · Destroyed NTSB FTW78PPG68Accident · Minor injuriesClosedGrumman G-164A · Pickens, ARJul 24, 1978 · N5388 · Destroyed NTSB FTW78DPG67Accident · No injuriesClosedGrumman G-164B · Walnut Ridge, ARJul 20, 1978 · N6653K · Destroyed NTSB FTW78FPG66Accident · 1 fatalClosedCessna 172L · Durham, ARJul 19, 1978 · N7940G · Substantial damage NTSB FTW78DPG65Accident · No injuriesClosedGrumman G-164A · Beedeville, ARJul 15, 1978 · N6640 · Destroyed NTSB FTW78DPG64Accident · Minor injuriesClosedCessna 152 · Fort Smith, ARJul 15, 1978 · N49856 · Substantial damage NTSB FTW78DPG62Accident · No injuriesClosedBeech 35 · Wynne, ARJul 14, 1978 · N2791V · Substantial damage NTSB FTW78DPG63Accident · No injuriesClosedGrumman G-164A · Beedeville, ARJul 13, 1978 · N8658H · Substantial damage NTSB FTW78DPG61Accident · No injuriesClosedGrumman G-164A · Trumann, ARJul 13, 1978 · N8555H · Substantial damage NTSB FTW78FPG60Accident · Minor injuriesClosedPiper PA-31 · Mena, ARJul 12, 1978 · N404RC · Destroyed NTSB FTW78DPG59Accident · No injuriesClosedCallair A-9B · Ashdown, ARJul 9, 1978 · N7759V · Substantial damage NTSB FTW78FPG57Accident · No injuriesClosedPiper PA-23 · N.Little Rock, ARJul 4, 1978 · N3416P · Substantial damage NTSB FTW78DPG58Accident · No injuriesClosedPiper PA-28 · Summers, ARJul 3, 1978 · N4174F · Substantial damage NTSB FTW78DPG56Accident · No injuriesClosedBeech A36 · Searcy, ARJul 2, 1978 · N710JT · Substantial damage NTSB FTW78DPG55Accident · No injuriesClosedPiper PA-28R · Dermott, ARJul 2, 1978 · N8539C · Substantial damage NTSB FTW78DPG48Accident · No injuriesClosedBellanca 8KCAB · Tupelo, ARJun 30, 1978 · N1159E · Substantial damage