NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 ATL81FA030Accident · 6 fatalClosedCessna 172M · Aberdeen, MSDec 24, 1980 · N64222 · DestroyedNTSB ATL81FA025Accident · 1 fatalClosedCessna 152 · Ft Adams, MSDec 9, 1980 · N5331M · DestroyedNTSB ATL80DLT01Accident · No injuriesClosedVolksplane 2 · Ripley, MSDec 3, 1980 · N37922 · Substantial damageNTSB ATL81IA009Incident · No injuriesClosedBeech A60 · Leaksville, MSOct 29, 1980 · N7578D · Minor damageNTSB ATL81FKQ02Accident · No injuriesClosedAir Tractor AT-301 · Canton, MSOct 21, 1980 · N78MH · Substantial damageNTSB ATL81FKQ01Accident · Minor injuriesClosedPiper 601P · Greenwood, MSOct 13, 1980 · N3634F · Substantial damageNTSB ATL80DKQ23Accident · No injuriesClosedCessna 188B · Ovett, MSSep 2, 1980 · N4778Q · DestroyedNTSB ATL80FKQ22Accident · No injuriesClosedGrumman G-164 · Clarksdale, MSAug 26, 1980 · N48461 · Substantial damageNTSB ATL80DKQ21Accident · No injuriesClosedCessna A188B · Hurley, MSAug 26, 1980 · N731FB · DestroyedNTSB ATL80DKQ20Accident · Minor injuriesClosedBeech 23 · Collins, MSAug 24, 1980 · N2373Q · DestroyedNTSB ATL80FKQ19Accident · No injuriesClosedCessna A188B · Merigold, MSAug 5, 1980 · N9118R · Substantial damageNTSB ATL80FLT10Accident · No injuriesClosedBeech 23 · Holly Springs, MSJul 29, 1980 · N24045 · Substantial damageNTSB ATL80FKQ18Accident · Serious injuriesClosedCessna A188B · Yazoo City, MSJul 24, 1980 · N53117 · Substantial damageNTSB ATL80FA077Accident · 1 fatalClosedBellanca 8GCBC · Banks, MSJul 24, 1980 · N8652V · DestroyedNTSB ATL80DKQ17Accident · No injuriesClosedCessna 188B · Belzoni, MSJul 18, 1980 · N8789G · Substantial damageNTSB ATL80FKQ16Accident · Minor injuriesClosedTomcat Mark 5 · Tutwiler, MSJul 13, 1980 · N9099T · Substantial damageNTSB ATL80FKQ15Accident · No injuriesClosedCessna 152 · Ocean Springs, MSJul 12, 1980 · N5387B · Substantial damageNTSB ATL80FLT09Accident · No injuriesClosedGrumman G-164 · Olive Branch, MSJul 9, 1980 · N582Y · DestroyedNTSB ATL80FKQ13Accident · No injuriesClosedCessna 188 · Charleston, MSJul 8, 1980 · N53307 · Substantial damageNTSB ATL80DKQ14Accident · No injuriesClosedCessna T188C · Tutwiler, MSJul 8, 1980 · N3155J · Substantial damageNTSB ATL80FA070Accident · 1 fatalClosedAero Comdr 680V · Jackson, MSJul 7, 1980 · N2755H · DestroyedNTSB ATL80FKQ12Accident · Minor injuriesClosedCessna A188B · Hollandale, MSJul 5, 1980 · N4883Q · Substantial damageNTSB ATL80DKQ11Accident · No injuriesClosedAeronca 7AC · Leland, MSJun 27, 1980 · N2942E · Substantial damageNTSB ATL80DKQ10Accident · No injuriesClosedCessna 188B · Leland, MSJun 26, 1980 · N91494 · Substantial damageNTSB ATL80FKQ09Accident · No injuriesClosedGrumman G-164B · Clarksdale, MSJun 19, 1980 · N6765Q · Substantial damageNTSB ATL80DKQ08Accident · Minor injuriesClosedCessna A188B · Philipp, MSJun 16, 1980 · N731NL · DestroyedNTSB ATL80FA053Accident · 2 fatalClosedGrumman AA-1C · Delisle, MSJun 14, 1980 · N9754U · DestroyedNTSB ATL80FKQ07Accident · Minor injuriesClosedPiper PA-22 · Brookhaven, MSJun 7, 1980 · N3567A · Substantial damageNTSB ATL80FKQ06Accident · Minor injuriesClosedAir Tractor AT301 · Flora, MSJun 4, 1980 · N3648Y · DestroyedNTSB ATL80DKQ05Accident · No injuriesClosedCessna 188T · Hollandale, MSMay 30, 1980 · N2198J · Substantial damageNTSB ATL80FKQ04Accident · No injuriesClosedGrumman G-164A · Boyle, MSMay 25, 1980 · N9734 · Substantial damageNTSB ATL80FKQ03Accident · No injuriesClosedGrumman G-164A · Clarksdale, MSMay 23, 1980 · N7867 · Substantial damageNTSB ATL80FA047Accident · 1 fatalClosedPiper PA-34 · Enterprise, MSMay 16, 1980 · N812DM · DestroyedNTSB ATL80DKQ02Accident · No injuriesClosedCessna T188T · Belzoni, MSMay 8, 1980 · N2321J · Substantial damageNTSB ATL80FKQ01Accident · Serious injuriesClosedCessna 150 · Prentiss, MSMay 6, 1980 · N7921F · Substantial damageNTSB MIA80FA052Accident · Serious injuriesClosedCessna 414 · Gulfport, MSApr 2, 1980 · N1659T · DestroyedNTSB MIA80FKQ06Accident · Minor injuriesClosedCessna 337 · Madison, MSApr 1, 1980 · N112DH · Substantial damageNTSB MIA80FKQ05Accident · Serious injuriesClosedAmateur PDQ-2 · Greenville, MSMar 31, 1980 · N635MC · Substantial damageNTSB MIA80FKQ04Accident · No injuriesClosedCessna 140 · Drew, MSMar 23, 1980 · N76653 · Substantial damageNTSB MIA80FKQ03Accident · Minor injuriesClosedGrumman G-164A · Flora, MSMar 14, 1980 · N48507 · DestroyedNTSB MIA80FLT02Accident · Minor injuriesClosedAero Comdr S2R · Eudora, MSMar 11, 1980 · N5601X · Substantial damageNTSB MIA80FLT01Accident · 1 fatalClosedCessna 188 · Tunica, MSFeb 27, 1980 · N8148V · DestroyedNTSB MIA80FKQ02Accident · 1 fatalClosedErco 415-C · Mooreville, MSJan 5, 1980 · N87156 · Substantial damage