NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARDec 29, 1965 · N6469T · Substantial damageNTSB FTW66F0484Accident · No injuriesClosedBeechcraft 65 · Tuckerman, ARDec 28, 1965 · N68950 · Substantial damageNTSB FTW66D0462Accident · No injuriesClosedCessna 170B · Magnolia, ARDec 24, 1965 · N3522C · Substantial damageNTSB FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARDec 12, 1965 · N58603 · Substantial damageNTSB FTW66F0480Accident · No injuriesClosedCessna 182 · Hot Springs, ARDec 10, 1965 · N9073T · Substantial damageNTSB UNK66X0110Accident · 2 fatalClosedPiper PA-22 · Ogeman, ARNov 22, 1965 · N8950D · DestroyedNTSB FTW66A0049Accident · 2 fatalClosedPiper PA-28 · West Fork, ARNov 21, 1965 · N5525W · DestroyedNTSB FTW66D0424Accident · No injuriesClosedPiper PA-22 · Waldo, ARNov 20, 1965 · N1940P · Substantial damageNTSB FTW66A0047Accident · 1 fatalClosedCessna 150F · Holly Grove, ARNov 19, 1965 · N3503L · DestroyedNTSB FTW66F0470Accident · No injuriesClosedBeechcraft K35 · Camden, ARNov 7, 1965 · N821B · Substantial damageNTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, ARNov 4, 1965 · N5836Y · Substantial damageNTSB FTW66F0372Accident · No injuriesClosedMooney M20E · Newport, AROct 31, 1965 · N1242X · Substantial damageNTSB FTW66D0371Accident · No injuriesClosedPiper PA-28 · Cotton Plant, AROct 29, 1965 · N9023W · Substantial damageNTSB FTW66F0415Accident · No injuriesClosedCessna 195 · Hot Springs, ARSep 29, 1965 · N4453C · Substantial damageNTSB FTW66F0469Accident · No injuriesClosedPiper PA-30 · Nashville, ARSep 28, 1965 · N501RE · Substantial damageNTSB FTW66D0364Accident · No injuriesClosedBoeing PT-13 · Tucker, ARSep 27, 1965 · N50072 · Substantial damageNTSB FTW66F0321Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARSep 17, 1965 · N6899Z · Substantial damageNTSB FTW66D0281Accident · No injuriesClosedPiper PA-18A · England, ARSep 12, 1965 · N7164D · Substantial damageNTSB FTW66F0279Accident · Minor injuriesClosedBoeing IB75A · Dumas, ARSep 8, 1965 · N9970H · Substantial damageNTSB FTW66F0478Accident · No injuriesClosedGrumman G-164 · Portland, ARSep 4, 1965 · N523Y · Substantial damageNTSB FTW66D0319Accident · No injuriesClosedBriegleb BG8-K2 · Manila, ARSep 3, 1965 · N33531 · Substantial damageNTSB FTW66F0303Accident · No injuriesClosedCessna 150 · Mena, ARAug 31, 1965 · N7908E · Substantial damageNTSB FTW66D0305Accident · No injuriesClosedPiper PA-28 · Swan Lake, ARAug 31, 1965 · N6328W · Substantial damageNTSB FTW66F0273Accident · No injuriesClosedBoeing A75N1 · Dumas, ARAug 28, 1965 · N59879 · Substantial damageNTSB FTW66F0250Accident · No injuriesClosedPiper PA-25 · Bradford, ARAug 26, 1965 · N6907Z · Substantial damageNTSB FTW66F0248Accident · No injuriesClosedPiper PA-22 · Spring Hill, ARAug 22, 1965 · N1840A · Substantial damageNTSB FTW66F0468Accident · No injuriesClosedGrumman G-164 · Gould, ARAug 21, 1965 · N464Y · Substantial damageNTSB FTW66F0477Accident · No injuriesClosedGrumman G-164 · Helena, ARAug 19, 1965 · N464RF · Substantial damageNTSB FTW66I0019Incident · No injuriesClosedBoeing B-727 · Little Rock, ARAug 18, 1965 · N1995 · 2 aircraft · Minor damageNTSB FTW66F0199Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARAug 15, 1965 · N6083Z · DestroyedNTSB FTW66D0223Accident · No injuriesClosedPiper PA-25 · Parkin, ARAug 14, 1965 · N7264Z · Substantial damageNTSB FTW66A0017Accident · No injuriesClosedHughes 300AG · Briscoe, ARAug 13, 1965 · N9392F · Substantial damageNTSB FTW66F0222Accident · Serious injuriesClosedPiper PA-25 · Jerome, ARAug 9, 1965 · N7464Z · DestroyedNTSB FTW66F0197Accident · Serious injuriesClosedPiper PA-18 · Keo, ARAug 9, 1965 · N3894Z · DestroyedNTSB FTW66A0014Accident · 1 fatalClosedPiper PA-24 · Mcalmont, ARAug 9, 1965 · N6643P · DestroyedNTSB FTW66F0191Accident · No injuriesClosedCessna 150 · West Helena, ARAug 5, 1965 · N4063U · Substantial damageNTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damageNTSB FTW66F0218Accident · Minor injuriesClosedPiper PA-25 · Boydell, ARAug 2, 1965 · N7256Z · DestroyedNTSB FTW66F0169Accident · Minor injuriesClosedPiper PA-22 · Springdale, ARJul 27, 1965 · N641A · Substantial damageNTSB FTW66A0009Accident · 3 fatalClosedBeechcraft G35 · Morrow, ARJul 25, 1965 · N169B · DestroyedNTSB FTW66F0212Accident · No injuriesClosedPiper PA-23 · Mena, ARJul 23, 1965 · N3090P · Substantial damageNTSB FTW66D0177Accident · No injuriesClosedGruman G-164 · Hunter, ARJul 13, 1965 · N714Y · Substantial damageNTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARJul 7, 1965 · N88371 · Substantial damageNTSB FTW66A0001Accident · No injuriesClosedBoeing 707 123B · Texarkana, ARJul 5, 1965 · N7507A · Substantial damageNTSB FTW66D0123Accident · No injuriesClosedMooney M21 · Gould, ARJul 2, 1965 · N78866 · Substantial damageNTSB FTW66D0104Accident · No injuriesClosedPiper PA-23 · Herber Springs, ARJun 20, 1965 · N5247Y · Substantial damageNTSB FTW66F0476Accident · No injuriesClosedCessna TL-19D · Almyra, ARJun 15, 1965 · N1175D · Substantial damageNTSB FTW66F0098Accident · No injuriesClosedMooney M20C · Hope, ARJun 12, 1965 · N79806 · Substantial damageNTSB FTW66F0096Accident · No injuriesClosedMooney M20D · West Fordyce, ARJun 9, 1965 · N1963Y · Substantial damageNTSB FTW65A0122Accident · 1 fatalClosedPiper PA-18A · Gillett, ARJun 3, 1965 · N8750C · Destroyed