Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 FTW80FPG09Accident · Minor injuriesClosedPiper PA-28 · N Little Rock, ARDec 27, 1979 · N5931W · Substantial damage NTSB UNK80X0103Accident · No injuriesClosedBeech A23 · Pocahontas, ARDec 21, 1979 · N5678S · Substantial damage NTSB FTW80FA025Accident · 1 fatalClosedCessna 182 · Story, ARDec 21, 1979 · N5393B · Destroyed NTSB FTW80FA024Accident · 4 fatalClosedCessna 421B · Locust Grove, ARDec 21, 1979 · N5428J · Destroyed NTSB FTW80DPG08Accident · No injuriesClosedBeech 76 · Hot Springs, ARDec 17, 1979 · N6014E · Substantial damage NTSB FTW80DPG06Accident · No injuriesClosedPitts S-1C · N.Little Rock, ARDec 2, 1979 · N77CK · Substantial damage NTSB FTW80DPG05Accident · No injuriesClosedPiper PA-28 · Cherokee Vlg, ARNov 26, 1979 · N9681K · Substantial damage NTSB FTW80DPG04Accident · Minor injuriesClosedPiper PA-12 · Pine Bluff, ARNov 23, 1979 · N2315M · Destroyed NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB FTW80FA008Accident · 1 fatalClosedBeech C55 · Fordyce, AROct 25, 1979 · N9466S · Destroyed NTSB FTW80DPG03Accident · No injuriesClosedBellanca 7ECA · Batesville, AROct 16, 1979 · N6308N · Substantial damage NTSB FTW80DPD01Accident · No injuriesClosedBellanca 7GCBC · Little Rock, AROct 3, 1979 · N31272 · Substantial damage NTSB FTW79FPG84Accident · No injuriesClosedCessna 150L · Cass, ARSep 30, 1979 · N10734 · Substantial damage NTSB FTW79DPG83Accident · Minor injuriesClosedGrumman G-164B · Marion, ARSep 11, 1979 · N6944K · Destroyed NTSB FTW79DPG82Accident · Minor injuriesClosedGreat Lakes 2T-1A · Alpin, ARSep 8, 1979 · N3703F · Substantial damage NTSB FTW79DPG81Accident · No injuriesClosedRockwell IN S-2R · Wilmont, ARSep 6, 1979 · N8474V · Substantial damage NTSB FTW79DPG80Accident · Minor injuriesClosedPiper PA-22 · Harrisburg, ARAug 31, 1979 · N3337A · Substantial damage NTSB FTW79DPG79Accident · No injuriesClosedPiper J-3 · Fresno, ARAug 28, 1979 · N20886 · Substantial damage NTSB FTW79DPG78Accident · No injuriesClosedCessna 172N · Crossett, ARAug 24, 1979 · N2754E · Substantial damage NTSB FTW79DPG77Accident · No injuriesClosedCessna A188B · Wabbaseka, ARAug 23, 1979 · N731YL · Substantial damage NTSB FTW79FPG76Accident · No injuriesClosedCessna 182Q · El Dorado, ARAug 12, 1979 · N7580S · Destroyed NTSB FTW79DPG75Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARAug 7, 1979 · N7605Z · Substantial damage NTSB FTW79FPG73Accident · Serious injuriesClosedGrumman G-164A · Kensett, ARAug 6, 1979 · N9715 · Destroyed NTSB FTW79FPG72Accident · No injuriesClosedGrumman G-164B · Amagon, ARAug 3, 1979 · N4563 · Destroyed NTSB FTW79DPG71Accident · No injuriesClosedPiper PA-20 · Red Star, ARAug 3, 1979 · N7646K · Substantial damage NTSB FTW79DPG74Accident · No injuriesClosedPiper PA-30 · Keo, ARAug 2, 1979 · N291R · Substantial damage NTSB FTW79DPG69Accident · No injuriesClosedGrumman G-164 · Griffithville, ARAug 2, 1979 · N5213 · Substantial damage NTSB FTW79FPG70Accident · No injuriesClosedMooney M20C · Conway, ARAug 1, 1979 · N79392 · Substantial damage NTSB FTW79DPG68Accident · No injuriesClosedGrumman G-164B · Hunter, ARAug 1, 1979 · N6823K · Substantial damage NTSB FTW79DPG67Accident · No injuriesClosedCessna 340 · Flippin, ARJul 20, 1979 · N5931M · Substantial damage NTSB FTW79DPG66Accident · No injuriesClosedGrumman G-164A · Tichnor, ARJul 19, 1979 · N7219 · Substantial damage NTSB FTW79DPG65Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARJul 13, 1979 · N9845P · Destroyed NTSB FTW79DPG64Accident · No injuriesClosedGrumman G-164A · Pollard, ARJul 13, 1979 · N4643 · Destroyed NTSB FTW79FA094Accident · 2 fatalClosedCessna 172M · Little Rock, ARJul 11, 1979 · N5471H · Destroyed NTSB FTW79FPG63Accident · Serious injuriesClosedAero Cmdr 600S-2 · Crawfordsville, ARJul 9, 1979 · N8416V · Substantial damage NTSB FTW79DPG62Accident · No injuriesClosedPiper PA-25 · Cash, ARJul 8, 1979 · N4969Y · Destroyed NTSB FTW79DPG61Accident · No injuriesClosedCessna 172 · El Dorado, ARJul 8, 1979 · N75625 · Substantial damage NTSB FTW79FPG60Accident · Minor injuriesClosedCessna 172M · Newport, ARJul 4, 1979 · N12588 · Substantial damage NTSB FTW79FA092Accident · 7 fatalClosedCessna 340 · Ashdown, ARJul 3, 1979 · N345B · 2 aircraft · Destroyed NTSB FTW79DPG57Accident · No injuriesClosedGruman G-164 · Bono, ARJun 27, 1979 · N6785K · Substantial damage NTSB FTW79DPG59Accident · No injuriesClosedRockwell S-2R · Waldenburg, ARJun 23, 1979 · N8871Q · Destroyed NTSB FTW79DPG58Accident · No injuriesClosedSnow S-2R · Light, ARJun 23, 1979 · N5643X · Destroyed NTSB FTW79DRJ14Accident · No injuriesClosedRockwell S2R · Garland, ARJun 19, 1979 · N4168X · Substantial damage NTSB FTW79DPG55Accident · No injuriesClosedBell 47G-2 · Earle, ARJun 19, 1979 · N3550 · Substantial damage NTSB FTW79DPG56Accident · No injuriesClosedAero Comdr S2R · Montrose, ARJun 18, 1979 · N4895X · Substantial damage NTSB FTW79FPG54Accident · Serious injuriesClosedAeronca 11AC · Mountain Home, ARJun 17, 1979 · N31959 · Destroyed NTSB FTW79FPG53Accident · No injuriesClosedCessna 172 · Redfield, ARJun 13, 1979 · N20076 · Substantial damage NTSB FTW79FPG50Accident · No injuriesClosedNa Rockwell S2R · Marked Tree, ARJun 12, 1979 · N5647X · Substantial damage NTSB FTW79DPG48Accident · No injuriesClosedGrumman G-164A · Piggout, ARJun 11, 1979 · N8370 · Substantial damage NTSB FTW79FPG51Accident · 1 fatalClosedPiper PA-36 · Tupelo, ARJun 9, 1979 · N59673 · Destroyed