NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 MIA67F0340Accident · Serious injuriesClosedCessna 180 · Vicksburg, MSDec 30, 1966 · N3191D · DestroyedNTSB MIA67F0320Accident · No injuriesClosedPiper PA-22 · Starkville, MSDec 12, 1966 · N4989Z · Substantial damageNTSB MIA67F0326Accident · No injuriesClosedAero Comdr 500 · Vicksburg, MSDec 7, 1966 · N6231B · Substantial damageNTSB MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSDec 3, 1966 · N7860Z · Substantial damageNTSB MIA67F0307Accident · No injuriesClosedN.American SNJ-5 · Picayune, MSNov 26, 1966 · N7987C · Substantial damageNTSB MIA67F0301Accident · No injuriesClosedTemco GC-1B · Agricola, MSNov 17, 1966 · N3856K · Substantial damageNTSB MIA67F0294Accident · No injuriesClosedChampion 7EC · Picayune, MSNov 10, 1966 · N7506B · Substantial damageNTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNov 10, 1966 · N7044F · Substantial damageNTSB MIA67F0245Accident · No injuriesClosedCessna 210D · Jackson, MSNov 10, 1966 · N3740Y · Substantial damageNTSB MIA67A0050Accident · 2 fatalClosedBell 47J-2A · Leland, MSOct 20, 1966 · N8582F · DestroyedNTSB MIA67F0213Accident · No injuriesClosedCessna 170B · Shelby, MSOct 13, 1966 · N8387A · Substantial damageNTSB MIA67F0215Accident · No injuriesClosedSnow S2C · Independence, MSOct 10, 1966 · N9488R · DestroyedNTSB MIA67A0045Accident · 3 fatalClosedPiper PA-24 · Stringer, MSOct 9, 1966 · N9048P · DestroyedNTSB MIA67D0217Accident · No injuriesClosedPiper PA-24 · Macon, MSOct 2, 1966 · N5756P · Substantial damageNTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSOct 1, 1966 · N92627 · Substantial damageNTSB MIA67A0041Accident · 2 fatalClosedPiper PA-28 · Senatobia, MSSep 28, 1966 · N7878W · DestroyedNTSB MIA67D0182Accident · No injuriesClosedCessna 150 · Lambert, MSSep 22, 1966 · N7018F · DestroyedNTSB MIA67F0144Accident · No injuriesClosedBeech S35 · Vicksburg, MSSep 7, 1966 · N6852Q · Substantial damageNTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSAug 31, 1966 · N78405 · Substantial damageNTSB MIA67D0148Accident · No injuriesClosedPiper PA-28 · Meridian, MSAug 31, 1966 · N7246W · Substantial damageNTSB MIA67F0142Accident · No injuriesClosedPiper PA-28 · Bruce, MSAug 27, 1966 · N7382W · Substantial damageNTSB MIA67A0029Accident · 1 fatalClosedPiper PA-18 · Cliftonville, MSAug 27, 1966 · N9280D · DestroyedNTSB MIA67F0129Accident · No injuriesClosedPiper PA-24 · Jackson, MSAug 26, 1966 · N7937P · Substantial damageNTSB MIA67F0139Accident · Minor injuriesClosedPiper PA-25 · Corinth, MSAug 22, 1966 · N6123Z · DestroyedNTSB MIA67F0110Accident · No injuriesClosedGrumman G-164 · Lodi, MSAug 18, 1966 · N597Y · Substantial damageNTSB MIA67F0108Accident · No injuriesClosedBoeing A-75 · Raymond, MSAug 18, 1966 · N4998N · Substantial damageNTSB MIA67F0112Accident · No injuriesClosedGrumman G-164 · Sand Hill, MSAug 13, 1966 · N10229 · Substantial damageNTSB MIA67F0111Accident · Serious injuriesClosedCessna 150 · Hernando, MSAug 6, 1966 · N7978Z · Substantial damageNTSB MIA67D0064Accident · No injuriesClosedLuscombe 8F · Picayune, MSJul 23, 1966 · N2925K · Substantial damageNTSB MIA67A0013Accident · 1 fatalClosedPiper J-3 · Hernando, MSJul 22, 1966 · N35162 · DestroyedNTSB MIA67F0090Accident · No injuriesClosedPiper PA-24 · Jackson, MSJul 15, 1966 · N8965P · Substantial damageNTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damageNTSB MIA67F0002Accident · No injuriesClosedCessna 180 · Grace, MSJul 6, 1966 · N2425F · Substantial damageNTSB MIA67F0004Accident · No injuriesClosedPiper PA-25 · Brookhaven, MSJul 4, 1966 · N7503Z · Substantial damageNTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damageNTSB MIA66D0629Accident · No injuriesClosedChampion 7FC · Pascagoula, MSJun 27, 1966 · N9849Y · Substantial damageNTSB MIA66A0150Accident · 2 fatalClosedDouglas DC-3 · Long Beach, MSJun 27, 1966 · N17337 · DestroyedNTSB MIA66A0147Accident · Minor injuriesClosedBell 47G2A · Lakeshore, MSJun 23, 1966 · N73211 · DestroyedNTSB MIA66F0610Accident · No injuriesClosedLuscombe 8A · Meridian, MSJun 20, 1966 · N1057K · Substantial damageNTSB MIA66F0592Accident · No injuriesClosedGrumman G164A · Exingtom, MSJun 20, 1966 · N671U · Substantial damageNTSB MIA66A0142Accident · 1 fatalClosedAero Comdr 680F · South Haven, MSJun 10, 1966 · N209PP · DestroyedNTSB MIA66F0566Accident · Minor injuriesClosedPiper PA-18A · Amory, MSJun 8, 1966 · N4196Z · DestroyedNTSB MIA66F0595Accident · Minor injuriesClosedMooney MK20C · Pascagoula, MSJun 3, 1966 · N5555Q · DestroyedNTSB MIA66A0140Accident · No injuriesClosedCessna 310A · Amory, MSMay 30, 1966 · N5255A · DestroyedNTSB MIA66F0596Accident · No injuriesClosedSpiper PA24 · Nsilver Creek, MSMay 26, 1966 · N8251P · Substantial damageNTSB MIA66F0567Accident · No injuriesClosedBeech A45 · Ocean Sprngs, MSMay 26, 1966 · N8239E · Substantial damageNTSB MIA66D0583Accident · No injuriesClosedPiper PA24 · Laurel, MSMay 26, 1966 · N7323P · Substantial damageNTSB MIA66D0582Accident · No injuriesClosedPiper PA-24 · Walls, MSMay 18, 1966 · N5110P · Substantial damageNTSB MIA66A0130Accident · Minor injuriesClosedHughes 269B · Pascagoula, MSMay 9, 1966 · N9453F · Substantial damageNTSB MIA66D0533Accident · No injuriesClosedCessna 170B · Raymond, MSMay 8, 1966 · N3482C · Substantial damage