Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 FTW69F0402Accident · No injuriesClosedBeech B35 · Little Rock, ARDec 5, 1968 · N8724A · Substantial damage NTSB FTW69F0299Accident · No injuriesClosedBeech P35 · Little Rock, ARDec 4, 1968 · N8687M · Substantial damage NTSB FTW69D0297Accident · No injuriesClosedCessna 182 · Hope, ARNov 30, 1968 · N2621R · Substantial damage NTSB FTW69F0336Accident · Minor injuriesClosedCessna 150 · Wynne, ARNov 28, 1968 · N3603J · Substantial damage NTSB FTW69D0280Accident · No injuriesClosedCessna 172 · Fort Smith, ARNov 10, 1968 · N8382L · Substantial damage NTSB FTW69D0281Accident · No injuriesClosedCessna 310R · Mena, ARNov 9, 1968 · N2000S · Substantial damage NTSB FTW69F0302Accident · Serious injuriesClosedPiper J-3 · Hazen, ARNov 5, 1968 · N33206 · Substantial damage NTSB FTW69F0301Accident · No injuriesClosedNavion A · Walnut Ridge, AROct 31, 1968 · N5139K · Substantial damage NTSB FTW69A0029Accident · No injuriesClosedBeech E18S · Fayetteville, AROct 23, 1968 · N152JB · Substantial damage NTSB FTW69A0022Accident · 4 fatalClosedCessna 172 · Hot Springs, AROct 7, 1968 · N8225U · Destroyed NTSB FTW69F0245Accident · No injuriesClosedCessna U206 · Blytheville, AROct 2, 1968 · N3949G · Substantial damage NTSB FTW69F0223Accident · No injuriesClosedCessna 177 · Jonesboro, ARSep 28, 1968 · N2899X · Substantial damage NTSB FTW69F0239Accident · Minor injuriesClosedPiper PA-22 · Roe, ARSep 19, 1968 · N6710B · Substantial damage NTSB FTW69D0238Accident · No injuriesClosedCessna 140 · Van Buren, ARSep 18, 1968 · N89173 · Substantial damage NTSB FTW69A0018Accident · 3 fatalClosedBeech J35 · Little Rock, ARSep 16, 1968 · N605T · Destroyed NTSB FTW69F0236Accident · Minor injuriesClosedCessna 177 · Valley Sprngs, ARSep 13, 1968 · N2393Y · Substantial damage NTSB FTW69D0205Accident · No injuriesClosedBoeing A75 · Bradley, ARSep 12, 1968 · N151J · Destroyed NTSB FTW69F0203Accident · Minor injuriesClosedCessna 150 · Little Rock, ARSep 8, 1968 · N22713 · Substantial damage NTSB FTW69F0202Accident · No injuriesClosedBoeing A75 · Monette, ARSep 7, 1968 · N63624 · Substantial damage NTSB FTW69F0201Accident · Minor injuriesClosedCessna 172 · Batesville, ARSep 7, 1968 · N46574 · Destroyed NTSB FTW69D0185Accident · No injuriesClosedBoeing M75 · Marvell, ARSep 6, 1968 · N52297 · Substantial damage NTSB FTW69F0163Accident · No injuriesClosedCessna 150 · Hattieville, ARSep 3, 1968 · N4040J · Destroyed NTSB FTW69A0015Accident · 3 fatalClosedBeech E35 · Lake Village, ARSep 2, 1968 · N3319C · Destroyed NTSB FTW69F0150Accident · 1 fatalClosedPiper PA-18 · N.Little Rock, ARSep 1, 1968 · N1492C · Destroyed NTSB FTW69D0198Accident · No injuriesClosedPiper PA-25 · Augusta, ARAug 28, 1968 · N7718Z · Substantial damage NTSB FTW69F0121Accident · No injuriesClosedCessna 150F · Jacksonville, ARAug 15, 1968 · N8818S · Substantial damage NTSB FTW69F0143Accident · No injuriesClosedPiper PA-24 · Eudora, ARAug 10, 1968 · N8757P · Substantial damage NTSB FTW69A0007Accident · 2 fatalClosedCessna 310 · Mena, ARAug 9, 1968 · N440X · Destroyed NTSB FTW69F0152Accident · No injuriesClosedPiper PA-25 · Parkin, ARAug 6, 1968 · N6421Z · Substantial damage NTSB FTW69F0147Accident · No injuriesClosedBeech B95A · Little Rock, ARAug 2, 1968 · N1727G · Substantial damage NTSB FTW69D0148Accident · No injuriesClosedCessna 170 · Hot Springs, ARAug 2, 1968 · N2480D · Substantial damage NTSB FTW69F0102Accident · Serious injuriesClosedBeech A35 · Waveland, ARJul 28, 1968 · N8762A · Substantial damage NTSB FTW69A0031Accident · 1 fatalClosedPiper PA-24 · Fayetteville, ARJul 28, 1968 · N8948P · Destroyed NTSB FTW69D0146Accident · Minor injuriesClosedGrumman G-164 · Brinkley, ARJul 18, 1968 · N10294 · Destroyed NTSB FTW69F0104Accident · Minor injuriesClosedMooney M20C · Lakeview, ARJul 16, 1968 · N6596U · Substantial damage NTSB FTW69F0118Accident · No injuriesClosedPiper PA-25 · Arkadelphia, ARJul 15, 1968 · N6318Z · Destroyed NTSB FTW69F0076Accident · No injuriesClosedPiper PA-30 · Texarkana, ARJul 14, 1968 · N7258Y · Substantial damage NTSB FTW69F0106Accident · No injuriesClosedPiper PA-25 · Mccrory, ARJul 12, 1968 · N7089Z · Substantial damage NTSB FTW69F0105Accident · Minor injuriesClosedPiper PA-25 · N.Little Rock, ARJul 11, 1968 · N6032Z · Substantial damage NTSB FTW69D0101Accident · No injuriesClosedBoeing A75 · Walnut Ridge, ARJul 6, 1968 · N53414 · Substantial damage NTSB FTW69F0103Accident · Minor injuriesClosedGrumman G-164A · Balch, ARJul 5, 1968 · N942X · Destroyed NTSB FTW69F0122Accident · No injuriesClosedPiper PA-25 · Coy, ARJul 2, 1968 · N4759Y · Substantial damage NTSB FTW69A0001Accident · 1 fatalClosedAero Comdr 1121 · Fayetteville, ARJul 1, 1968 · N196KC · Destroyed NTSB FTW69D0048Accident · Minor injuriesClosedCessna 210 · Mountain Home, ARJun 30, 1968 · N6101R · Substantial damage NTSB FTW69F0100Accident · No injuriesClosedCessna 172H · N.Little Rock, ARJun 27, 1968 · N2543L · Substantial damage NTSB FTW69D0033Accident · Minor injuriesClosedMaule M-4 · Waldron, ARJun 25, 1968 · N4742T · Destroyed NTSB FTW69F0554Accident · No injuriesClosedCessna 411 · Texarkana, ARJun 22, 1968 · N7382U · Substantial damage NTSB FTW69D0056Accident · No injuriesClosedGrumman G-164 · Dierks, ARJun 17, 1968 · N603U · Substantial damage NTSB FTW69D0026Accident · No injuriesClosedCessna 172 · Holly Grove, ARJun 11, 1968 · N5738A · Substantial damage NTSB FTW69F0013Accident · Serious injuriesClosedCessna 305A · Stuttgart, ARJun 10, 1968 · N1170D · Destroyed