Skip to content

NTSB investigations, 1969, AR

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 FTW70F0333Accident · Minor injuriesClosedCessna 182 · Newark, ARDec 16, 1969 · N8417T · Substantial damage NTSB FTW70F0367Accident · No injuriesClosedCessna 172H · Tyronza, ARDec 7, 1969 · N2420L · Substantial damage NTSB FTW70F0315Accident · Minor injuriesClosedBeech H35 · Augusta, ARDec 1, 1969 · N167D · Substantial damage NTSB FTW70F0323Accident · No injuriesClosedCessna 172 · El Dorado, ARNov 30, 1969 · N5072A · Substantial damage NTSB FTW70A0035Accident · 1 fatalClosedCessna 150 · Marianna, ARNov 25, 1969 · N4581U · Destroyed NTSB FTW70A0034Accident · 1 fatalClosedCessna 150 · Lake Village, ARNov 22, 1969 · N6375S · Destroyed NTSB FTW70F0301Accident · Minor injuriesClosedCessna 120 · Mena, ARNov 15, 1969 · N1958V · Substantial damage NTSB FTW70A0031Accident · 1 fatalClosedCessna 172 · Mena, ARNov 11, 1969 · N7180T · Destroyed NTSB FTW70F0285Accident · No injuriesClosedPiper PA-28 · Dermott, ARNov 8, 1969 · N6048W · Substantial damage NTSB FTW70A0030Accident · 1 fatalClosedCessna 182K · Little Rock, ARNov 8, 1969 · N2430Q · Destroyed NTSB FTW70F0288Accident · No injuriesClosedPiper PA-24 · Little Rock, ARNov 2, 1969 · N7994P · Substantial damage NTSB FTW70D0282Accident · No injuriesClosedStinson 108-2 · Fayetteville, AROct 27, 1969 · N444C · Substantial damage NTSB FTW70F0269Accident · Serious injuriesClosedGlobe GC-1A · N.Little Rock, AROct 19, 1969 · N80853 · Substantial damage NTSB FTW70F0258Accident · No injuriesClosedBeech S35 · Pine Bluff, AROct 16, 1969 · N5620K · Substantial damage NTSB FTW70F0255Accident · No injuriesClosedTaylorcraft BL · Springdale, AROct 16, 1969 · N26554 · 2 aircraft · Substantial damage NTSB FTW70A0027Accident · 3 fatalClosedCessna 172C · Allison, AROct 8, 1969 · N1869Y · Destroyed NTSB FTW70F0257Accident · No injuriesClosedPiper PA-25 · Newport, AROct 3, 1969 · N6767Z · Substantial damage NTSB FTW70F0224Accident · Minor injuriesClosedCessna 205 · Lake Village, AROct 2, 1969 · N8296Z · Substantial damage NTSB FTW70F0278Accident · Minor injuriesClosedCessna 140 · Pineville, ARSep 30, 1969 · N90017 · Substantial damage NTSB FTW70D0232Accident · Minor injuriesClosedGrumman G-164 · Hughes, ARSep 29, 1969 · N587Y · Substantial damage NTSB FTW70F0231Accident · No injuriesClosedAeronca 65-CA · Mabelville, ARSep 27, 1969 · N39574 · Substantial damage NTSB FTW70F0223Accident · Minor injuriesClosedPiper PA-28 · Magnolia, ARSep 25, 1969 · N6408R · Substantial damage NTSB FTW70F0252Accident · No injuriesClosedChampion 7ECA · Alicia, ARSep 23, 1969 · N2880G · Substantial damage NTSB FTW70F0369Accident · No injuriesClosedPiper PA-28 · Van Buren, ARSep 22, 1969 · N4298J · Substantial damage NTSB FTW70F0236Accident · Serious injuriesClosedAeronca 7AC · Menifee, ARSep 20, 1969 · N2607E · Substantial damage NTSB MKC70A0011Accident · 1 fatalClosedAero Comdr 100 · Brentwood, ARSep 17, 1969 · N3796X · Destroyed NTSB FTW70F0222Accident · No injuriesClosedCessna 150 · Camden, ARSep 14, 1969 · N23444 · Substantial damage NTSB FTW70F0206Accident · No injuriesClosedPiper PA-12 · Humphrey, ARSep 13, 1969 · N7852H · Substantial damage NTSB FTW70F0215Accident · 1 fatalClosedPiper PA-25 · Hughes, ARSep 11, 1969 · N4538Y · Destroyed NTSB FTW70F0219Accident · No injuriesClosedPiper PA-24 · Tuckerman, ARSep 9, 1969 · N8690P · Substantial damage NTSB FTW70F0217Accident · Serious injuriesClosedPiper PA-25 · Elaine, ARSep 9, 1969 · N7441Z · Destroyed NTSB FTW70F0205Accident · No injuriesClosedPiper PA-25 · Coy, ARSep 9, 1969 · N4870Y · Substantial damage NTSB FTW70F0228Accident · No injuriesClosedPiper PA-18 · Barton, ARSep 7, 1969 · N9855D · Substantial damage NTSB FTW70D0213Accident · No injuriesClosedBoeing A75N1 · Elaine, ARSep 7, 1969 · N61554 · Destroyed NTSB FTW70F0183Accident · No injuriesClosedAeronca 7BCM · Conway, ARSep 6, 1969 · N3973B · Substantial damage NTSB FTW70F0186Accident · No injuriesClosedBeech 95-B55 · Jonesboro, ARAug 27, 1969 · N7712R · Substantial damage NTSB FTW70D0177Accident · No injuriesClosedPiper PA-28 · Pettus, ARAug 21, 1969 · N7548R · Substantial damage NTSB FTW70D0180Accident · No injuriesClosedChampion 7FC · Pine Bluff, ARAug 20, 1969 · N8932R · Substantial damage NTSB FTW70F0159Accident · Serious injuriesClosedMooney M20B · Quitman, ARAug 16, 1969 · N74575 · Destroyed NTSB FTW70F0179Accident · No injuriesClosedCessna 172 · Foreman, ARAug 13, 1969 · N46421 · Substantial damage NTSB FTW70D0175Accident · Minor injuriesClosedCessna 210F · Dequeen, ARAug 13, 1969 · N1833F · Substantial damage NTSB FTW70D0146Accident · Minor injuriesClosedCessna 180 · Helena, ARAug 12, 1969 · N76F · Substantial damage NTSB FTW70D0174Accident · No injuriesClosedPiper PA-28 · Augusta, ARAug 8, 1969 · N9061W · Substantial damage NTSB FTW70F0158Accident · No injuriesClosedMooney M20E · Benton, ARAug 4, 1969 · N1247X · Substantial damage NTSB FTW70F0143Accident · Serious injuriesClosedCessna 120 · Osceola, ARJul 30, 1969 · N1769V · Substantial damage NTSB FTW70F0101Accident · No injuriesClosedGrumman G-164A · Lonoke, ARJul 14, 1969 · N5287 · Substantial damage NTSB FTW70F0100Accident · Serious injuriesClosedCessna 150 · Pine Bluff, ARJul 13, 1969 · N8398G · Substantial damage NTSB FTW70F0070Accident · Minor injuriesClosedCessna 175 · N Little Rock, ARJul 12, 1969 · N7925T · Substantial damage NTSB FTW70F0092Accident · 1 fatalClosedSnow S2C · Coy, ARJul 10, 1969 · N1852S · Destroyed NTSB FTW70F0099Accident · No injuriesClosedAero Comdr 560 · Benton, ARJul 9, 1969 · N2657B · Substantial damage