NTSB investigations, 1964, MS

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 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\") = 1964
    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 UNK65X1178Accident · Serious injuriesClosedTempco D-16 · Madison, MSDec 28, 1964 · N4366K · Substantial damageNTSB UNK65X1129Accident · No injuriesClosedMooney M21 · Jackson, MSDec 25, 1964 · N1299X · Substantial damageNTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSDec 13, 1964 · N7091K · DestroyedNTSB UNK65X0948Accident · Serious injuriesClosedCessna 182 · Belzoni, MSDec 7, 1964 · N3062Y · DestroyedNTSB UNK65X0524Accident · 2 fatalClosedAeronca 7AC · Greenville, MSNov 1, 1964 · N81481 · Substantial damageNTSB UNK65X0515Accident · No injuriesClosedBeechcraft 23 · Greenville, MSNov 1, 1964 · N2332Q · Substantial damageNTSB UNK65X0393Accident · No injuriesClosedCessna 172 · Marks, MSOct 24, 1964 · N3864S · Substantial damageNTSB UNK65X0351Accident · No injuriesClosedPiper PA30 · Columbus, MSOct 20, 1964 · N7354Y · Substantial damageNTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSOct 20, 1964 · N2274N · Substantial damageNTSB UNK65X0318Accident · Serious injuriesClosedBell 47G · Walls, MSOct 18, 1964 · N2467B · Substantial damageNTSB UNK65X0216Accident · No injuriesClosedBoeing A75N1 · Yazoo City, MSOct 10, 1964 · N61042 · Substantial damageNTSB UNK64X4086Accident · No injuriesClosedBellanca 1419 · Madison, MSSep 21, 1964 · N132M · Substantial damageNTSB UNK64X4032Accident · No injuriesClosedBoeing B75N1 · Belizoni, MSSep 18, 1964 · N10571 · Substantial damageNTSB UNK64X3881Accident · Minor injuriesClosedPiper PA25 · Avalon, MSSep 9, 1964 · N6781Z · Substantial damageNTSB UNK64X3877Accident · No injuriesClosedBell 47G4 · Canton, MSSep 8, 1964 · N3082G · Substantial damageNTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSSep 8, 1964 · N7991B · Substantial damageNTSB UNK64X3821Accident · Minor injuriesClosedPiper PA25 · Lambert, MSSep 6, 1964 · N6842Z · DestroyedNTSB UNK64X3795Accident · No injuriesClosedPiper PA30 · Wiggins, MSSep 5, 1964 · N7299Y · Substantial damageNTSB UNK64X3782Accident · Minor injuriesClosedCessna 150 · Madison, MSSep 5, 1964 · N7960Z · Substantial damageNTSB UNK64X3768Accident · No injuriesClosedBeechcraft G35 · Fayette, MSSep 4, 1964 · N4241D · Substantial damageNTSB UNK64X3757Accident · Minor injuriesClosedPiper PA18A · Midnight, MSSep 3, 1964 · N8992D · DestroyedNTSB UNK64X3716Accident · 1 fatalClosedPiper PA-18A · Greenwood, MSSep 1, 1964 · N8784D · Substantial damageNTSB UNK64X3673Accident · No injuriesClosedPiper PA28 · Laurel, MSAug 29, 1964 · N5357W · Substantial damageNTSB UNK64X3654Accident · Serious injuriesClosedBoeing B75N1 · Nitta Yuma, MSAug 28, 1964 · N50737 · Substantial damageNTSB UNK64X3592Accident · 1 fatalClosedPiper PA18A · Yazoo, MSAug 25, 1964 · N3887P · DestroyedNTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSAug 15, 1964 · N7022X · DestroyedNTSB UNK64X3212Accident · No injuriesClosedBoeing A75 · Yazoo City, MSAug 4, 1964 · N52532 · DestroyedNTSB UNK64X3100Accident · No injuriesClosedLuscombe 8E · Amory, MSJul 29, 1964 · N1941K · Substantial damageNTSB UNK64X3055Accident · Serious injuriesClosedSwift GC1B · Meridian Colo, MSJul 26, 1964 · N2346B · DestroyedNTSB UNK64X3013Accident · Serious injuriesClosedBoeing A75 · Inverness, MSJul 24, 1964 · N66519 · DestroyedNTSB UNK64X2911Accident · No injuriesClosedMooney MK20C · Bay Spings, MSJul 19, 1964 · N6888U · Substantial damageNTSB UNK64X2873Accident · No injuriesClosedBoeing A75 · Webb, MSJul 17, 1964 · N51420 · Substantial damageNTSB UNK64X2706Accident · Serious injuriesClosedCntl Copter G47 · Glen Allan, MSJul 7, 1964 · N73871 · Substantial damageNTSB UNK64X2673Accident · 1 fatalClosedCessna 172 · Gulfport, MSJul 5, 1964 · N7430X · DestroyedNTSB UNK64X2389Accident · Minor injuriesClosedCallair A9 · Vance, MSJun 20, 1964 · N3560G · Substantial damageNTSB UNK64X2239Accident · No injuriesClosedBoeing A75N1 · Minter City, MSJun 12, 1964 · N1656M · Substantial damageNTSB UNK64X2146Accident · No injuriesClosedSmith DSA1 · Madison, MSJun 6, 1964 · N1711 · Minor damageNTSB UNK64X2102Accident · No injuriesClosedCessna 172E · Canton, MSJun 4, 1964 · N3805S · Substantial damageNTSB UNK64X2090Accident · No injuriesClosedRiviera FN333 · Brookhaven, MSJun 3, 1964 · N623 · Substantial damageNTSB UNK64X2073Accident · No injuriesClosedAeronca 7AC · Mantee, MSJun 2, 1964 · N3600E · Substantial damageNTSB UNK64X2062Accident · Minor injuriesClosedPiper PA18 · New Albany, MSJun 1, 1964 · N8753C · Substantial damageNTSB UNK64X1858Accident · No injuriesClosedPiper PA22 · Belzoni, MSMay 20, 1964 · N5834Z · Substantial damageNTSB UNK64X1507Accident · No injuriesClosedCessna 172 · Picayune, MSApr 29, 1964 · N3980S · Substantial damageNTSB UNK64X1446Accident · No injuriesClosedCessna 182B · Horn Lake, MSApr 25, 1964 · N2286G · Substantial damageNTSB UNK64X1359Accident · No injuriesClosedCessna 120 · Macon, MSApr 18, 1964 · N89901 · Substantial damageNTSB UNK64X1256Accident · No injuriesClosedPiper PA28 · Hattiesburg, MSApr 11, 1964 · N5043W · Substantial damageNTSB UNK64X1221Accident · No injuriesClosedBeechcraft E18S · Columbia, MSApr 8, 1964 · N153J · Substantial damageNTSB UNK64X0799Accident · No injuriesClosedDouglas DC-3 · Tupelo, MSMar 4, 1964 · N62S · Substantial damageNTSB UNK64X0681Accident · 2 fatalClosedPiper J3 · Greenville, MSFeb 23, 1964 · N2069M · DestroyedNTSB UNK64X0616Accident · No injuriesClosedBeechcraft E35 · Picayune, MSFeb 19, 1964 · N3550B · Substantial damage