Skip to content

NTSB investigations, 1975, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations, 1975, MS per year, 1964–2026: 1,742 cases
1964	54
1965	69
1966	62
1967	58
1968	50
1969	54
1970	40
1971	58
1972	52
1973	32
1974	51
1975	44
1976	36
1977	56
1978	49
1979	44
1980	43
1981	45
1982	36
1983	21
1984	29
1985	23
1986	26
1987	34
1988	26
1989	36
1990	20
1991	25
1992	20
1993	26
1994	20
1995	35
1996	22
1997	22
1998	25
1999	38
2000	24
2001	23
2002	16
2003	19
2004	18
2005	19
2006	12
2007	20
2008	16
2009	19
2010	8
2011	16
2012	19
2013	13
2014	12
2015	10
2016	7
2017	11
2018	6
2019	13
2020	7
2021	11
2022	9
2023	8
2024	8
2025	10
2026	7

Where

Latest cases

Query with SQL

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") = 1975 AND c."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1975
    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.

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") = 1975
  AND c."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA76AM042Accident · 1 fatalClosedBeech J35 · Columbus, MSNov 14, 1975 · N8296D · Destroyed NTSB MIA76FLT02Accident · No injuriesClosedPiper J3C · Southhaven, MSNov 10, 1975 · N98453 · Substantial damage NTSB MIA76FKQ24Accident · Serious injuriesClosedCessna 182P · Mccomb, MSOct 24, 1975 · N8183G · Destroyed NTSB MIA76FKQ22Accident · Minor injuriesClosedCessna 140 · Philip, MSOct 21, 1975 · N76515 · Destroyed NTSB MIA75FKQ21Accident · Minor injuriesClosedCessna A188B · Drew, MSOct 21, 1975 · N4480Q · Substantial damage NTSB MIA76FKQ23Accident · No injuriesClosedGrumman G-164A · Holly Bluff, MSOct 14, 1975 · N959X · Substantial damage NTSB MIA76FKQ20Accident · No injuriesClosedCessna A188B · Inverness, MSOct 14, 1975 · N79215 · Substantial damage NTSB MIA76FKQ19Accident · No injuriesClosedBell 47G2 · Sumner, MSSep 27, 1975 · N993B · Substantial damage NTSB MIA76DKQ18Accident · No injuriesClosedCessna A188B · Georgetown, MSSep 26, 1975 · N4700R · Substantial damage NTSB MIA76AM025Accident · 2 fatalClosedPiper PA-28R · Grenada, MSSep 17, 1975 · N934PA · Destroyed NTSB MIA76FKQ14Accident · 1 fatalClosedBell 47G3B1 · Magnolia, MSSep 15, 1975 · N216AC · Destroyed NTSB MIA76DKQ17Accident · No injuriesClosedAeronca 7AC · Hollandale, MSSep 14, 1975 · N83946 · Substantial damage NTSB MIA76FKQ13Accident · 1 fatalClosedGrumman G164A · Clarksdale, MSSep 6, 1975 · N4920 · Destroyed NTSB MIA76DLT01Accident · No injuriesClosedPiper PA-28 · Coldwater, MSSep 6, 1975 · N1339T · Substantial damage NTSB MIA76FKQ12Accident · No injuriesClosedCessna A188B · Edwards, MSAug 30, 1975 · N53287 · Substantial damage NTSB MIA76FKQ11Accident · No injuriesClosedCessna A188B · Minter City, MSAug 29, 1975 · N9746G · Substantial damage NTSB MIA76FKQ10Accident · No injuriesClosedAero Cmdr S2R · Belzoni, MSAug 27, 1975 · N5586X · Substantial damage NTSB MIA76AM018Accident · 3 fatalClosedPiper PA-23 · Decatur, MSAug 24, 1975 · N2019P · Destroyed NTSB MIA76FKQ09Accident · Minor injuriesClosedGrum Amer AA1-B · Lexington, MSAug 21, 1975 · N9607L · Substantial damage NTSB MIA76FKQ08Accident · No injuriesClosedPiper PA-18 · Madison, MSAug 20, 1975 · N4686Y · Substantial damage NTSB MIA76FKQ07Accident · Serious injuriesClosedBell 47G-2 · Itta Bena, MSAug 14, 1975 · N4823 · Substantial damage NTSB MIA76FKQ06Accident · No injuriesClosedPiper PA-28 · Greenwood, MSAug 11, 1975 · N3656R · Substantial damage NTSB MIA7LFKQ05Accident · Serious injuriesClosedCessna 150G · Okolona, MSJul 28, 1975 · N4050J · Substantial damage NTSB MIA76FKQ04Accident · Minor injuriesClosedCessna 150 · West Point, MSJul 27, 1975 · N66124 · Destroyed NTSB MIA76AM008Accident · 3 fatalClosedPiper PA-28R · Dekalb, MSJul 25, 1975 · N56778 · Destroyed NTSB MIA76FK003Accident · No injuriesClosedBoeing B75N1 · Merigold, MSJul 23, 1975 · N9478H · Substantial damage NTSB MIA76FKQ02Accident · No injuriesClosedBell 47G3BI · Bay St Louis, MSJul 15, 1975 · N54HP · Substantial damage NTSB MIA76FKQ01Accident · No injuriesClosedHughes 269C · Columbus, MSJul 2, 1975 · N9293F · Substantial damage NTSB MIA75FLT07Accident · Minor injuriesClosedBellanca 17-30A · Olive Branch, MSJun 24, 1975 · N39848 · Substantial damage NTSB MIA75FKQ36Accident · No injuriesClosedPiper PA-28R · Jackson, MSJun 21, 1975 · N33322 · Substantial damage NTSB MIA75DKQ35Accident · No injuriesClosedCessna 172 · Forest, MSJun 14, 1975 · N4125F · Substantial damage NTSB MIA75FKQ34Accident · Minor injuriesClosedBeech 35-C33 · Petal, MSJun 8, 1975 · N6134V · Substantial damage NTSB MIA75FKQ33Accident · Minor injuriesClosedPitts S1S · Clarksdale, MSMay 25, 1975 · N1NN · 2 aircraft · Minor damage NTSB MIA75FKQ32Accident · Minor injuriesClosedBell 47G4 · Jackson, MSMay 14, 1975 · N1198W · Substantial damage NTSB MIA75FKQ31Accident · No injuriesClosedCessna A188B · Morgan City, MSMay 5, 1975 · N4482Q · Substantial damage NTSB MIA75FLT06Accident · No injuriesClosedGrum Amer AA-5 · Coldwater, MSMay 2, 1975 · N9582L · Substantial damage NTSB MIA75FKQ30Accident · No injuriesClosedCessna 210L · Itta Bena, MSApr 29, 1975 · N93009 · Substantial damage NTSB MIA75FKQ29Accident · 1 fatalClosedCorbin ACE-D · Columbia, MSApr 26, 1975 · N4295 · Substantial damage NTSB MIA75FKQ28Accident · Minor injuriesClosedPiper PA-28 · Marks, MSApr 23, 1975 · N3879R · Substantial damage NTSB MIA75FKQ27Accident · No injuriesClosedGrumman G-164A · Edwards, MSApr 16, 1975 · N961X · Substantial damage NTSB MIA75AM073Accident · 2 fatalClosedPiper PA-22 · Valley Park, MSMar 31, 1975 · N1700P · Destroyed NTSB MIA75FKQ26Accident · 1 fatalClosedCessna A188B · Stewart, MSMar 20, 1975 · N53205 · Destroyed NTSB MIA75AM059Accident · 2 fatalClosedCessna 172H · Olive Branch, MSFeb 17, 1975 · N2497L · Destroyed NTSB MIA75FLT05Accident · Serious injuriesClosedCessna 182P · Frankston, MSFeb 8, 1975 · N58995 · Destroyed