Skip to content

NTSB investigations, 1974, MS

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 MIA75AM036Accident · 1 fatalClosedAeronca 7BCM · Senatobia, MSDec 20, 1974 · N10549 · Destroyed NTSB MIA75FKQ25Accident · No injuriesClosedPiper PA-28 · Pascagula, MSDec 16, 1974 · N95408 · Substantial damage NTSB MIA75AM031Accident · 5 fatalClosedCessna 210L · Brandon, MSDec 11, 1974 · N93242 · Destroyed NTSB MIA75FKQ24Accident · Minor injuriesClosedAmer Avco AA-5 · Jackson, MSNov 27, 1974 · N9590L · Substantial damage NTSB MIA75KKQ23Accident · No injuriesClosedCessna 172 · Greenville, MSNov 13, 1974 · N9747 · Substantial damage NTSB MIA75DKQ22Accident · No injuriesClosedChampion 7GBC · Cleveland, MSNov 9, 1974 · N9151L · Substantial damage NTSB MIA75FKQ21Accident · Minor injuriesClosedCavalier Kellum · Raymond, MSOct 26, 1974 · N4335 · Substantial damage NTSB MIA75FKQ20Accident · Serious injuriesClosedCessna 188 · Philadelphia, MSOct 23, 1974 · N9787V · Destroyed NTSB MIA75FKQ19Accident · Minor injuriesClosedBoeing A75 · Merigold, MSOct 22, 1974 · N69389 · Substantial damage NTSB MIA75FLT04Accident · No injuriesClosedBellanca 300 · Southaven, MSOct 19, 1974 · N6699V · Substantial damage NTSB MIA75FKQ18Accident · Minor injuriesClosedCessna A188B · Glen Allen, MSOct 11, 1974 · N53214 · Destroyed NTSB MIA75DKQ17Accident · No injuriesClosedGrumman G-164 · Cleveland, MSOct 2, 1974 · N468Y · Destroyed NTSB MIA75FKQ16Accident · No injuriesClosedCessna 310Q · Hattiesburg, MSSep 28, 1974 · N69717 · Substantial damage NTSB MIA75FKQ15Accident · Serious injuriesClosedCessna 320C · Natchez, MSSep 27, 1974 · N3005T · Destroyed NTSB MIA75FLT03Accident · No injuriesClosedCessna A188B · Thyatira, MSSep 16, 1974 · N4468Q · Destroyed NTSB MIA75FKQ14Accident · Serious injuriesClosedCessna 188A · Anguilla, MSSep 15, 1974 · N9395G · Destroyed NTSB MIA75DLT02Accident · Minor injuriesClosedCessna 182 · Booneville, MSSep 15, 1974 · N6073B · Substantial damage NTSB MIA75DKQ13Accident · No injuriesClosedPiper PA-22 · Bay St Louis, MSSep 15, 1974 · N2165A · Substantial damage NTSB FTW75AF014Accident · Serious injuriesClosedDouglas DC-9 · Meridian, MSSep 1, 1974 · N8962E · No damage NTSB MIA75FKQ10Accident · 1 fatalClosedBoeing B75 · Eagle Lake, MSAug 28, 1974 · N96X · Destroyed NTSB MIA75DKQ12Accident · No injuriesClosedPiper PA-25 · Beulah, MSAug 28, 1974 · N6581Z · Substantial damage NTSB MIA74FKQ11Accident · No injuriesClosedAero Comdr 600S2R · Onward, MSAug 28, 1974 · N1741S · Destroyed NTSB MIA75FKQ09Accident · Serious injuriesClosedPiper PA-25 · Charleston, MSAug 20, 1974 · N7327Z · Destroyed NTSB MIA75DKQ08Accident · No injuriesClosedPiper PA-25 · Doddsville, MSAug 17, 1974 · N8617L · Substantial damage NTSB MIA75DKQ07Accident · Minor injuriesClosedBoeing A75N1 · Leland, MSAug 14, 1974 · N48761 · Destroyed NTSB MIA75DKQ06Accident · No injuriesClosedGrumman G-164 · Rolling Fork, MSAug 14, 1974 · N462Y · Destroyed NTSB MIA75DKQ05Accident · No injuriesClosedBoeing A75N1 · Greenville, MSAug 6, 1974 · N65951 · Substantial damage NTSB MIA75FKQ04Accident · No injuriesClosedCessna 188B · Bruce, MSAug 5, 1974 · N5704G · Destroyed NTSB MIA75FKQ03Accident · 2 fatalClosedBoeing A75N1 · Greenville, MSJul 20, 1974 · N55374 · 2 aircraft · Destroyed NTSB MIA75FKQ02Accident · Minor injuriesClosedBell 47G-2 · Raleigh, MSJul 11, 1974 · N4823 · Substantial damage NTSB MIA74FKQ01Accident · Serious injuriesClosedBell 47J-2 · Edwards, MSJul 10, 1974 · N55CG · Destroyed NTSB MIA75DLT01Accident · No injuriesClosedCessna 177 · Coldwater, MSJul 4, 1974 · N3315T · Substantial damage NTSB MIA74FKQ26Accident · Serious injuriesClosedPiper PA-24 · Tylertown, MSJun 21, 1974 · N5276P · Substantial damage NTSB MIA74FKQ24Accident · No injuriesClosedCessna A188B · Batesville, MSJun 17, 1974 · N53200 · Destroyed NTSB MIA74DKQ25Accident · No injuriesClosedCessna A188B · Benoit, MSJun 17, 1974 · N8098G · Substantial damage NTSB MIA74FLT05Accident · No injuriesClosedHughes 269A · Walls, MSJun 4, 1974 · N8885F · Substantial damage NTSB MIA74FKQ22Accident · No injuriesClosedCessna 172B · Indianola, MSJun 1, 1974 · N8148X · Substantial damage NTSB MIA74DKQ23Accident · No injuriesClosedCessna A188B · Ruleville, MSMay 30, 1974 · N4498Q · Substantial damage NTSB MIA74DKQ21Accident · No injuriesClosedCessna A188A · Duncan, MSMay 13, 1974 · N99356 · Substantial damage NTSB MIA74DKQ20Accident · No injuriesClosedBellanca 7KCAB · Sunflower, MSMay 9, 1974 · N57654 · Substantial damage NTSB MIA74AM089Accident · 4 fatalClosedPiper PA-28R · Bay St Louis, MSMay 4, 1974 · N54413 · Destroyed NTSB MIA74DKQ19Accident · No injuriesClosedCessna 150G · Bolton, MSMay 1, 1974 · N3623J · Substantial damage NTSB MIA74FKQ18Accident · Serious injuriesClosedCessna 150L · Hattiesburg, MSApr 28, 1974 · N1777Q · Destroyed NTSB MIA74FKQ17Accident · No injuriesClosedAmer Avco AA-1B · Jackson, MSApr 18, 1974 · N6268L · Substantial damage NTSB MIA74FKQ16Accident · No injuriesClosedSwearingen SA226T · Jackson, MSApr 5, 1974 · N3335G · Substantial damage NTSB MIA74DKQ15Accident · No injuriesClosedCessna 172 · Gunnison, MSMar 17, 1974 · N35469 · Substantial damage NTSB MIA74FKQ14Accident · Serious injuriesClosedPiper PA-28 · Collinsville, MSMar 15, 1974 · N3964K · Destroyed NTSB MIA74FKQ13Accident · Serious injuriesClosedPiper PA-25 · Crawford, MSMar 11, 1974 · N8901L · Destroyed NTSB MIA74FKQ12Accident · Minor injuriesClosedCessna 150F · Batesville, MSMar 7, 1974 · N3538L · Substantial damage NTSB MIA74DLT04Accident · Minor injuriesClosedCessna 150 · Corinth, MSFeb 9, 1974 · N5260Q · Substantial damage