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

Cases per year

19642026
NTSB investigations, 1967, 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\") = 1967
    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 FTW68A0067Accident · Minor injuriesClosedAero Cmdr 500-B · Mena, ARDec 30, 1967 · N6369U · Substantial damageNTSB FTW68D0403Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARDec 29, 1967 · N6417W · Substantial damageNTSB FTW68F0404Accident · No injuriesClosedCessna 210E · Searcy, ARDec 28, 1967 · N2322F · Substantial damageNTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARDec 20, 1967 · N5904Y · Substantial damageNTSB FTW68D0406Accident · No injuriesClosedCessna 172 · Springdale, ARDec 20, 1967 · N3724R · Substantial damageNTSB FTW68D0398Accident · No injuriesClosedBeech A23 · Conway, ARDec 12, 1967 · N3621Q · Substantial damageNTSB FTW68A0060Accident · Serious injuriesClosedHughes 300 · Fayetteville, ARDec 9, 1967 · N9335F · DestroyedNTSB FTW68A0059Accident · 1 fatalClosedPiper PA-24 · Black Oak, ARDec 9, 1967 · N7657P · DestroyedNTSB FTW68F0432Accident · No injuriesClosedPiper PA-24 · Hindsville, ARDec 2, 1967 · N8091P · Substantial damageNTSB FTW68D0390Accident · No injuriesClosedNavion A · Little Rock, ARDec 2, 1967 · N4961C · Substantial damageNTSB FTW68F0371Accident · No injuriesClosedMooney M20D · Fayetteville, ARDec 1, 1967 · N6659U · Substantial damageNTSB FTW68D0365Accident · No injuriesClosedBeech 35 · Booneville, ARNov 22, 1967 · N3878N · Substantial damageNTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNov 13, 1967 · N3232D · Substantial damageNTSB FTW69A0004Accident · 1 fatalClosedBeech 35-B33 · Mount Ida, AROct 13, 1967 · N7992K · DestroyedNTSB FTW68A0043Accident · 4 fatalClosedBeech N35 · Camden, AROct 13, 1967 · N396Z · DestroyedNTSB FTW68F0293Accident · No injuriesClosedBeech 35-C33 · Fayetteville, AROct 9, 1967 · N7963M · Substantial damageNTSB FTW68D0267Accident · No injuriesClosedPiper PA-22 · Manila, AROct 4, 1967 · N5031Z · Substantial damageNTSB FTW68D0266Accident · No injuriesClosedBeech A23 · Pine Bluff, AROct 1, 1967 · N4740J · Substantial damageNTSB FTW68F0264Accident · Minor injuriesClosedAeronca 11AC · Benton, ARSep 30, 1967 · N3294E · Substantial damageNTSB FTW68F0262Accident · Minor injuriesClosedBeech E18S · Walnut Ridge, ARSep 21, 1967 · N21X · Substantial damageNTSB FTW68F0226Accident · Serious injuriesClosedSnow S2C · Harrisburg, ARSep 21, 1967 · N1602S · DestroyedNTSB FTW68A0032Accident · No injuriesClosedBell 47D1 · Russellville, ARSep 18, 1967 · N903B · Substantial damageNTSB FTW68F0260Accident · No injuriesClosedCallair A9 · Howell, ARSep 12, 1967 · N9669Z · Substantial damageNTSB FTW68F0290Accident · Serious injuriesClosedPietenpol Scout · Van Buren, ARSep 10, 1967 · N2830J · DestroyedNTSB FTW68F0235Accident · Minor injuriesClosedBoeing E75N1 · Marvell, ARSep 9, 1967 · N75650 · Substantial damageNTSB FTW68F0231Accident · No injuriesClosedCessna 150F · Tinsman, ARSep 2, 1967 · N8545G · Substantial damageNTSB FTW68F0214Accident · Minor injuriesClosedBeech 35-B33 · West Memphis, ARAug 27, 1967 · N872R · Substantial damageNTSB FTW68F0256Accident · No injuriesClosedCallair A-9 · Mcgehee, ARAug 26, 1967 · N8249H · Substantial damageNTSB FTW68D0210Accident · No injuriesClosedBeech 23 · West Memphis, ARAug 22, 1967 · N2393Z · Substantial damageNTSB FTW68D0175Accident · No injuriesClosedPiper PA-23 · Gurdon, ARAug 22, 1967 · N5595Y · Substantial damageNTSB FTW68F0174Accident · No injuriesClosedCessna 175 · Little Rock, ARAug 21, 1967 · N6695E · Substantial damageNTSB FTW68D0155Accident · No injuriesClosedBoeing A75N1 · Dumas, ARAug 21, 1967 · N91098 · Substantial damageNTSB FTW68D0207Accident · No injuriesClosedBeech H35 · West Memphis, ARAug 19, 1967 · N621Q · Substantial damageNTSB FTW68D0170Accident · No injuriesClosedBeech V35 · Clarksville, ARAug 19, 1967 · N315LH · Substantial damageNTSB FTW68F0205Accident · No injuriesClosedCessna 180A · Almyra, ARAug 16, 1967 · N5248D · Substantial damageNTSB FTW68A0020Accident · 1 fatalClosedCallair A-9 · Knobel, ARAug 16, 1967 · N8242H · DestroyedNTSB FTW68D0167Accident · No injuriesClosedBeech B35 · Malvern, ARAug 15, 1967 · N5164C · Substantial damageNTSB FTW68F0255Accident · No injuriesClosedGrumman G-164 · Eudora, ARAug 14, 1967 · N651Y · Substantial damageNTSB FTW68F0164Accident · Minor injuriesClosedPiper PA-25 · Etowah, ARAug 10, 1967 · N6245Z · Substantial damageNTSB FTW68F0227Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARAug 5, 1967 · N477Y · Substantial damageNTSB FTW68D0148Accident · No injuriesClosedBoeing E75 · Osceola, ARAug 5, 1967 · N1544M · Substantial damageNTSB FTW68F0142Accident · No injuriesClosedCessna 150 · Walnut Ridge, ARJul 26, 1967 · N3857J · Substantial damageNTSB FTW68D0099Accident · No injuriesClosedBeech 23 · Weiner, ARJul 26, 1967 · N2392Z · Substantial damageNTSB FTW68D0141Accident · No injuriesClosedPiper PA-18A · Lewisville, ARJul 24, 1967 · N9858D · Substantial damageNTSB FTW68D0121Accident · No injuriesClosedGrumman G-164 · Hickory Ridge, ARJul 24, 1967 · N521Y · Substantial damageNTSB FTW68F0097Accident · No injuriesClosedCessna 150 · Dumas, ARJul 23, 1967 · N6217R · Substantial damageNTSB FTW68D0140Accident · Minor injuriesClosedCessna 170 · Waldron, ARJul 22, 1967 · N1741D · Substantial damageNTSB FTW68A0007Accident · 1 fatalClosedPiper J-3C · Parkin, ARJul 17, 1967 · N3511N · DestroyedNTSB FTW68D0139Accident · Minor injuriesClosedBoeing A75 · Reydel, ARJul 16, 1967 · N63711 · Substantial damageNTSB FTW68D0113Accident · No injuriesClosedBeech M35 · Blytheville, ARJul 14, 1967 · N669V · Substantial damage