NTSB investigations, 1965, MS

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, MS per year, 1964–2026: 1,742 cases
196454
196569
196662
196758
196850
196954
197040
197158
197252
197332
197451
197544
197636
197756
197849
197944
198043
198145
198236
198321
198429
198523
198626
198734
198826
198936
199020
199125
199220
199326
199420
199535
199622
199722
199825
199938
200024
200123
200216
200319
200418
200519
200612
200720
200816
200919
20108
201116
201219
201313
201412
201510
20167
201711
20186
201913
20207
202111
20229
20238
20248
202510
20267

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\" = 'MS' 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 MIA66F0350Accident · No injuriesClosedCessna 150 · Waynesboro, MSDec 24, 1965 · N8005S · Substantial damageNTSB MIA66F0348Accident · No injuriesClosedPiper PA-28 · Picayune, MSDec 22, 1965 · N6757W · Substantial damageNTSB MIA66F0346Accident · 1 fatalClosedPiper J4A · Greenville, MSDec 4, 1965 · N24563 · DestroyedNTSB MIA66D0333Accident · No injuriesClosedAero Cmdr 680 · Picayune, MSNov 21, 1965 · N200V · Substantial damageNTSB MIA66A0057Accident · 1 fatalClosedErco 415C · Washington, MSNov 19, 1965 · N132V · DestroyedNTSB MIA66A0054Accident · Serious injuriesClosedBell 204-B · Baxterville, MSNov 8, 1965 · N1175W · DestroyedNTSB MIA66F0317Accident · No injuriesClosedBeech J35 · Ripley, MSNov 2, 1965 · N7266B · Substantial damageNTSB MIA66F0312Accident · No injuriesClosedPiper J-3 · Louisville, MSOct 30, 1965 · N42853 · Substantial damageNTSB MIA66A0040Accident · No injuriesClosedLockheed PV-2 · Tupelo, MSOct 11, 1965 · N7254C · Substantial damageNTSB MIA66F0279Accident · Minor injuriesClosedCessna 170B · Mattson, MSOct 4, 1965 · N4519C · Substantial damageNTSB MIA66F0264Accident · No injuriesClosedBeechcraft 35-33 · Greenville, MSOct 4, 1965 · N653V · Substantial damageNTSB MIA66F0285Accident · No injuriesClosedBoeing B-75N1 · Webb, MSSep 30, 1965 · N68W · Substantial damageNTSB MIA66F0266Accident · No injuriesClosedNavion B · Golden, MSSep 24, 1965 · N8635H · Substantial damageNTSB MIA66F0255Accident · No injuriesClosedPiper PA-23 · Hollandale, MSSep 23, 1965 · N5534Y · Substantial damageNTSB MIA66F0254Accident · No injuriesClosedBoeing B-75M · Belzoni, MSSep 19, 1965 · N10571 · Substantial damageNTSB MIA66F0215Accident · No injuriesClosedCessna 310B · Vicksburg, MSSep 15, 1965 · N6661B · Substantial damageNTSB MIA66F0214Accident · Serious injuriesClosedAeronca 7AC · Columbus, MSSep 14, 1965 · N84400 · DestroyedNTSB MIA66D0223Accident · No injuriesClosedPiper PA-18 · Pearlington, MSSep 14, 1965 · N2890Z · Substantial damageNTSB MIA66D0231Accident · No injuriesClosedCessna 172 · Rural Hill, MSSep 11, 1965 · N2464U · Substantial damageNTSB MIA66A0028Accident · 1 fatalClosedPiper PA-18A · Clarksdale, MSSep 8, 1965 · N1981A · DestroyedNTSB MIA66F0233Accident · No injuriesClosedCessna 172E · Crowder, MSSep 7, 1965 · N7749U · Substantial damageNTSB MIA66F0218Accident · No injuriesClosedCessna 140 · Meridian, MSSep 4, 1965 · N2020V · Substantial damageNTSB MIA66A0026Accident · 1 fatalClosedPiper PA-18 · Inverness, MSSep 2, 1965 · N7504K · DestroyedNTSB MIA66A0025Accident · 1 fatalClosedPiper PA-18 · Pace, MSSep 1, 1965 · N3881Z · DestroyedNTSB MIA66D0239Accident · No injuriesClosedCessna 172 · Tchula, MSAug 29, 1965 · N7987U · Substantial damageNTSB NYC66D0185Accident · No injuriesClosedCessna 182 · Leland, MSAug 26, 1965 · N2S · Substantial damageNTSB MIA66D0209Accident · No injuriesClosedPiper PA-22 · Greenville, MSAug 26, 1965 · N3803P · Substantial damageNTSB MIA66F0208Accident · Minor injuriesClosedBoeing A-75 · Mattson, MSAug 25, 1965 · N5820N · Substantial damageNTSB MIA66A0023Accident · 4 fatalClosedCessna 182B · Logtown, MSAug 19, 1965 · N2345G · DestroyedNTSB MIA66F0194Accident · No injuriesClosedGrumman T-G164 · Charleston, MSAug 17, 1965 · N10278 · Substantial damageNTSB MIA66A0021Accident · 1 fatalClosedPiper PA-18 · Leland, MSAug 16, 1965 · N3883Z · DestroyedNTSB MIA66F0182Accident · No injuriesClosedPiper PA-18A · Louisville, MSAug 10, 1965 · N8189C · Substantial damageNTSB MIA66F0192Accident · No injuriesClosedPiper PA-24 · Meridian, MSAug 9, 1965 · N8763P · Substantial damageNTSB MIA66F0167Accident · No injuriesClosedPiper PA-18A · Tupelo, MSAug 6, 1965 · N6776B · Substantial damageNTSB MIA66A0018Accident · 4 fatalClosedBeechcraft A35 · Mathiston, MSAug 5, 1965 · N615B · DestroyedNTSB MIA66F0091Accident · No injuriesClosedBoeing A-75N1 · Avalon, MSJul 31, 1965 · N1922M · Substantial damageNTSB MIA66F0090Accident · No injuriesClosedGlobe GC-1B · Forest, MSJul 24, 1965 · N78088 · Substantial damageNTSB MIA66D0069Accident · No injuriesClosedCessna 150D · Gillsburg, MSJul 24, 1965 · N4323U · Substantial damageNTSB MIA66F0066Accident · No injuriesClosedBeechcraft 35 · Madison, MSJul 20, 1965 · N2886V · Substantial damageNTSB MIA66F0065Accident · No injuriesClosedPiper PA-22 · Gulfport, MSJul 18, 1965 · N8729D · Substantial damageNTSB MIA66F0050Accident · No injuriesClosedPiper PA-24 · Meridian, MSJul 18, 1965 · N6336P · Substantial damageNTSB MIA66A0008Accident · No injuriesClosedBell Tomcat · Skene, MSJul 12, 1965 · N73871 · Substantial damageNTSB MIA66F0086Accident · No injuriesClosedPiper PA-25 · Batesville, MSJul 11, 1965 · N7507Z · Substantial damageNTSB MIA65A0126Accident · 1 fatalClosedBoeing 75N1 · Sunflower, MSJun 26, 1965 · N4936C · Substantial damageNTSB MIA65A0125Accident · 1 fatalClosedPiper PA-12 · Tutwiler, MSJun 25, 1965 · N7555H · DestroyedNTSB MIA66D0044Accident · Minor injuriesClosedCessna 172B · Starkville, MSJun 21, 1965 · N7552X · DestroyedNTSB MIA66F0041Accident · No injuriesClosedCallair A-9 · Moorhead, MSJun 20, 1965 · N9666Z · Substantial damageNTSB MIA66D0040Accident · No injuriesClosedCessna 172 · Wayside, MSJun 18, 1965 · N6417B · Substantial damageNTSB MIA65A0119Accident · 1 fatalClosedPiper PA-18A · Lambert, MSJun 17, 1965 · N8169C · DestroyedNTSB MIA66F0019Accident · Serious injuriesClosedCallair A-9 · Doddsville, MSJun 2, 1965 · N3568G · Substantial damage