NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARDec 29, 1966 · N8009A · Substantial damageNTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · DestroyedNTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARDec 5, 1966 · N5393E · DestroyedNTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNov 29, 1966 · N77565 · Substantial damageNTSB FTW67F0316Accident · No injuriesClosedCessna 210 · Little Rock, ARNov 16, 1966 · N9543T · Substantial damageNTSB FTW67F0313Accident · Serious injuriesClosedBeech 95 · Little Rock, ARNov 12, 1966 · N2767Y · Substantial damageNTSB FTW67D0308Accident · No injuriesClosedBeech S35 · Little Rock, AROct 23, 1966 · N5806K · Substantial damageNTSB FTW67D0279Accident · No injuriesClosedAlon A-2 · Corning, AROct 22, 1966 · N5655F · Substantial damageNTSB FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, AROct 15, 1966 · N7852F · Substantial damageNTSB FTW67F0245Accident · Serious injuriesClosedPiper PA-25 · Eudora, AROct 11, 1966 · N6804Z · DestroyedNTSB FTW67D0244Accident · No injuriesClosedGrumman G-164 · Leavchville, AROct 7, 1966 · N10237 · Substantial damageNTSB FTW67D0238Accident · No injuriesClosedCessna 140A · Mc Gehee, ARSep 25, 1966 · N5605C · Substantial damageNTSB FTW67D0237Accident · No injuriesClosedCessna 172 · Berryville, ARSep 24, 1966 · N6942X · Substantial damageNTSB FTW67D0220Accident · No injuriesClosedBeech 23 · Augusta, ARSep 24, 1966 · N5983S · Substantial damageNTSB FTW67D0202Accident · No injuriesClosedChampion 7GCB · Black Oak, ARSep 12, 1966 · N9940Y · Substantial damageNTSB FTW67F0214Accident · Minor injuriesClosedGrumman G-164 · Tupelo, ARSep 8, 1966 · N466Y · Substantial damageNTSB FTW67F0213Accident · No injuriesClosedAeronca 7AC · Gurdon, ARSep 8, 1966 · N85695 · Substantial damageNTSB FTW67F0197Accident · No injuriesClosedPiper PA-28 · Hot Springs, ARSep 5, 1966 · N8157W · Substantial damageNTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARAug 30, 1966 · N1408U · Substantial damageNTSB FTW67D0207Accident · No injuriesClosedBeech G35 · El Dorado, ARAug 30, 1966 · N4508D · Substantial damageNTSB FTW67F0233Accident · No injuriesClosedSnow 600S2C · Bay, ARAug 29, 1966 · N1670S · Substantial damageNTSB FTW67F0189Accident · No injuriesClosedRepublic RC-3 · Benton, ARAug 28, 1966 · N87515 · Substantial damageNTSB FTW67F0133Accident · No injuriesClosedPiper PA-28 · Pine Bluff, ARAug 28, 1966 · N6990W · Substantial damageNTSB FTW67F0231Accident · Serious injuriesClosedPiper PA-25 · Parkin, ARAug 19, 1966 · N7319Z · DestroyedNTSB FTW67D0141Accident · No injuriesClosedBeech J35 · Willisville, ARAug 13, 1966 · N523B · Substantial damageNTSB FTW67F0170Accident · Serious injuriesClosedCessna T50 · Pocahontas, ARAug 6, 1966 · N5584N · DestroyedNTSB FTW67F0152Accident · No injuriesClosedPiper PA-25 · Success, ARAug 4, 1966 · N7358Z · Substantial damageNTSB FTW67D0130Accident · No injuriesClosedCessna 172 · Bull Shoals, ARAug 3, 1966 · N8340U · Substantial damageNTSB FTW6MD0120Accident · No injuriesClosedMooney M20C · Midway, ARJul 30, 1966 · N2632W · Substantial damageNTSB FTW67F0121Accident · No injuriesClosedBoeing A75 · Brinkley, ARJul 29, 1966 · N75641 · DestroyedNTSB FTW67A0019Accident · Serious injuriesClosedHughes 269A · Brookland, ARJul 28, 1966 · N8898F · DestroyedNTSB FTW67A0017Accident · Serious injuriesClosedBell 47D1 · Stuttgart, ARJul 25, 1966 · N3655F · Substantial damageNTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARJul 24, 1966 · N3192N · DestroyedNTSB FTW67F0128Accident · Minor injuriesClosedPiper PA-28 · Berryville, ARJul 24, 1966 · N8038W · Substantial damageNTSB FTW67F0112Accident · No injuriesClosedBeech A23 · Lead Hill, ARJul 24, 1966 · N8779M · DestroyedNTSB FTW67A0016Accident · 1 fatalClosedBoeing A75N1 · Hazen, ARJul 23, 1966 · N38958 · DestroyedNTSB FTW67D0105Accident · No injuriesClosedPiper PA-24 · Keo, ARJul 21, 1966 · N6048P · Substantial damageNTSB FTW67F0077Accident · No injuriesClosedPiper PA-23 · Stuttgart, ARJul 15, 1966 · N5220Y · Substantial damageNTSB FTW67D0073Accident · No injuriesClosedCessna 182 · Flippin, ARJul 15, 1966 · N3467S · Substantial damageNTSB FTW67D0071Accident · No injuriesClosedBeech 65 · Hope, ARJul 14, 1966 · N5828K · Substantial damageNTSB FTW67A0010Accident · No injuriesClosedHughes 269A · Little Rock, ARJul 14, 1966 · N8893F · Minor damageNTSB FTW67F0092Accident · No injuriesClosedBoeing A75 · Swan Lake, ARJul 11, 1966 · N63711 · Substantial damageNTSB FTW67D0065Accident · No injuriesClosedPiper PA18 · Stuttgart, ARJul 6, 1966 · N3800Z · Substantial damageNTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARJul 6, 1966 · N42418 · DestroyedNTSB FTW67D0051Accident · No injuriesClosedPiper PA30 · Springdale, ARJul 1, 1966 · N7164Y · Substantial damageNTSB FTW67A0001Accident · No injuriesClosedHughes 269B · Little Rock, ARJul 1, 1966 · N9303F · Substantial damageNTSB FTW66A0121Accident · No injuriesClosedPiper PA-25 · Garland, ARJun 28, 1966 · N7331Z · Substantial damageNTSB FTW66A0120Accident · Serious injuriesClosedConvair 600 · Hot Spring, ARJun 27, 1966 · N74856 · No damageNTSB FTW66I0118Incident · No injuriesClosedDouglas DC-3 · El Dorado, ARJun 22, 1966 · N28364 · Minor damageNTSB FTW67D0015Accident · No injuriesClosedCessna 172 · Colt, ARJun 13, 1966 · N8340U · Substantial damage