NTSB investigations, 1964, 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.

Cases per year

19642026
NTSB investigations, 1964, AR per year, 1964–2026: 3,153 cases
196485
196580
196687
1967109
196881
196989
197076
197192
197276
197382
197481
1975107
1976101
197791
197896
197990
198076
198172
198268
198346
198489
198549
198648
198746
198861
198948
199065
199153
199257
199355
199454
199558
199644
199740
199844
199949
200023
200121
200237
200337
200431
200537
200628
200717
200822
200921
201032
201122
201223
201321
201417
201521
201622
201716
201820
201914
202016
202119
202221
202323
202414
202520
202613

Latest cases

Query with SQL
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\") = 1964
    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.

NTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARDec 29, 1964 · N80942 · DestroyedNTSB UNK65X1152Accident · No injuriesClosedBeech 23 · Rogers, ARDec 27, 1964 · N2364Q · Substantial damageNTSB UNK65X1138Accident · No injuriesClosedBeechraft 35-33 · Almyra, ARDec 26, 1964 · N940T · Substantial damageNTSB UNK65X0998Accident · No injuriesClosedBeechraft C35 · Pine Bluff, ARDec 13, 1964 · N2029D · Substantial damageNTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARDec 4, 1964 · N5089U · DestroyedNTSB UNK65X0842Accident · 1 fatalClosedPiper PA-24 · El Dorado, ARNov 26, 1964 · N8171P · DestroyedNTSB UNK65X0770Accident · Minor injuriesClosedBeechraft AT-11 · Fayetteville, ARNov 21, 1964 · N57140 · Substantial damageNTSB UNK65X0501Accident · No injuriesClosedPiper PA30 · Little Rock, AROct 31, 1964 · N7114Y · Substantial damageNTSB UNK65X0422Accident · No injuriesClosedCessna 182 · Luxora, AROct 25, 1964 · N6130B · Substantial damageNTSB UNK65X0352Accident · No injuriesClosedMooney M18C · Heber Spring, AROct 20, 1964 · N4073 · Substantial damageNTSB UNK65X0307Accident · No injuriesClosedCessna 180 · Fayetteville, AROct 17, 1964 · N1731C · Minor damageNTSB UNK65X0117Accident · No injuriesClosedCessna 180 · West Memphis, AROct 2, 1964 · N4724B · 2 aircraft · Substantial damageNTSB UNK64X4218Accident · No injuriesClosedBoeing B75N1 · Pocahontas, ARSep 30, 1964 · N9751H · DestroyedNTSB UNK64X4085Accident · No injuriesClosedCessna 182 · Dequeen, ARSep 21, 1964 · N9041X · Substantial damageNTSB UNK64X4045Accident · No injuriesClosedBoeing 75N1 · Lepanto, ARSep 19, 1964 · N79536 · Substantial damageNTSB UNK64X3907Accident · 1 fatalClosedBoeing A75 · Fulton, ARSep 10, 1964 · N4961N · DestroyedNTSB UNK64X3901Accident · No injuriesClosedBeechcraft B35 · Camden, ARSep 10, 1964 · N5021C · Substantial damageNTSB UNK64X3884Accident · Minor injuriesClosedPiper PA22 · Melbourne, ARSep 9, 1964 · N678A · Substantial damageNTSB UNK64X3882Accident · No injuriesClosedBoeing A75 · Hickory Ridge, ARSep 9, 1964 · N65877 · Substantial damageNTSB UNK64X3857Accident · Minor injuriesClosedBoeing B75N1 · Olyphant, ARSep 7, 1964 · N60955 · Substantial damageNTSB UNK64X3815Accident · No injuriesClosedCessna 172E · Flippin, ARSep 6, 1964 · N5427T · Substantial damageNTSB UNK64X3776Accident · 1 fatalClosedChampion 7GCB · Clarendon, ARSep 4, 1964 · N9891Y · DestroyedNTSB UNK64X3775Accident · 1 fatalClosedPiper PA-18A · Winchester, ARSep 4, 1964 · N7491D · DestroyedNTSB UNK64X3733Accident · No injuriesClosedBoeing E75N1 · Hazen, ARSep 2, 1964 · N69858 · Substantial damageNTSB UNK64X3721Accident · No injuriesClosedCallair A9 · Dewitt, ARSep 1, 1964 · N9672Z · Substantial damageNTSB UNK64X3703Accident · No injuriesClosedBell 47G · Stuttgart, ARAug 31, 1964 · N9168R · Substantial damageNTSB UNK64X3700Accident · No injuriesClosedGrumman G164 · Hickory Ridge, ARAug 31, 1964 · N10272 · Substantial damageNTSB UNK64X3696Accident · No injuriesClosedBoeing B75N1 · W Helena, ARAug 31, 1964 · N57943 · Substantial damageNTSB UNK64X3533Accident · No injuriesClosedAeronca 7AC · Fayetteville, ARAug 22, 1964 · N81560 · Substantial damageNTSB UNK64X3508Accident · No injuriesClosedCessna 175 · Pettigrew, ARAug 21, 1964 · N7276M · Substantial damageNTSB UNK64X3486Accident · No injuriesClosedBeechcraft H35 · Walnut Ridge, ARAug 20, 1964 · N5471D · Substantial damageNTSB UNK64X3463Accident · No injuriesClosedBoeing A75N1 · W Memphis, ARAug 18, 1964 · N52545 · Substantial damageNTSB UNK64X3448Accident · Serious injuriesClosedAeronca 7AC · Mcdougal, ARAug 18, 1964 · N83306 · DestroyedNTSB UNK64X3440Accident · No injuriesClosedPiper PA18A · Scott, ARAug 17, 1964 · N9693D · Substantial damageNTSB UNK64X3359Accident · No injuriesClosedBeechcraft M23 · Little Rock, ARAug 13, 1964 · N2300Q · DestroyedNTSB UNK64X3354Accident · Minor injuriesClosedPiper PA28 · Dequeen, ARAug 13, 1964 · N7467W · DestroyedNTSB UNK64X3308Accident · Serious injuriesClosedPiper J3C · Gould, ARAug 9, 1964 · N6879H · Substantial damageNTSB UNK64X3269Accident · No injuriesClosedBeech 35 · Pine Bluff, ARAug 8, 1964 · N4464V · Substantial damageNTSB UNK64X3124Accident · No injuriesClosedBeechcraft K35 · Siloam Spring, ARJul 30, 1964 · N5393E · Substantial damageNTSB UNK64X3116Accident · Minor injuriesClosedPiper J3C · Pine Bluff, ARJul 30, 1964 · N98561 · Substantial damageNTSB UNK64X3098Accident · Minor injuriesClosedBoeing A75N1 · Humnoke, ARJul 29, 1964 · N1861N · Substantial damageNTSB UNK64X2980Accident · No injuriesClosedLuscombe 8E · Caraway, ARJul 22, 1964 · N2433K · DestroyedNTSB UNK64X2953Accident · Serious injuriesClosedPiper PA18A · Pettus, ARJul 21, 1964 · N4899A · DestroyedNTSB UNK64X2894Accident · No injuriesClosedCessna 170A · Benton, ARJul 18, 1964 · N5465C · Substantial damageNTSB UNK64X2807Accident · No injuriesClosedPiper PA25 · Fair Oaks, ARJul 13, 1964 · N6778Z · DestroyedNTSB UNK64X2732Accident · No injuriesClosedPiper PA24 · Lake Village, ARJul 9, 1964 · N8312P · Substantial damageNTSB UNK64X2692Accident · 1 fatalClosedConvair BT13 · Jonesboro, ARJul 6, 1964 · N63938 · DestroyedNTSB UNK64X2685Accident · No injuriesClosedBoeing A75N1 · Brinkley, ARJul 6, 1964 · N49600 · Substantial damageNTSB UNK64X2668Accident · No injuriesClosedBeechcraft 35 · Springdale, ARJul 5, 1964 · N3348V · Substantial damageNTSB UNK64X2607Accident · No injuriesClosedCessna 170 · Ft Smith, ARJul 2, 1964 · N4H · Substantial damage