Skip to content

NTSB investigations, 1972, MS

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73FRQ23Accident · Minor injuriesClosedCessna 182E · Mccomb, MSDec 26, 1972 · N3288Y · Destroyed NTSB MIA73FLT14Accident · No injuriesClosedBeech D18S · Tunica, MSDec 14, 1972 · TG-HIH · Destroyed NTSB MIA73AM073Accident · 1 fatalClosedCessna 172 · Biloxi, MSDec 12, 1972 · N8015B · Destroyed NTSB MIA73AM061Accident · 1 fatalClosedAero Comdr 560-E · Tupelo, MSDec 11, 1972 · N2690B · Destroyed NTSB MIA73FKQ22Accident · No injuriesClosedCessna 172K · Picayune, MSDec 9, 1972 · N7027G · Substantial damage NTSB MIA73FKQ21Accident · No injuriesClosedCessna 172 · Gulfport, MSOct 21, 1972 · N2429U · Substantial damage NTSB MIA73FKQ19Accident · 2 fatalClosedPientonpol Camper · Ocean Sprngs, MSOct 1, 1972 · N1074Z · Destroyed NTSB MIA73FKQ20Accident · No injuriesClosedPiper J3C-65 · Pascagoula, MSSep 27, 1972 · N32806 · Destroyed NTSB MIA73FKQ17Accident · 1 fatalClosedCessna A188B · Alligator, MSSep 27, 1972 · N21605 · Destroyed NTSB MIA73DLT09Accident · No injuriesClosedPiper PA-25 · Holly Sprngs, MSSep 27, 1972 · N4993Y · Substantial damage NTSB MIA73DKQ16Accident · No injuriesClosedGrumman G-164 · Monticello, MSSep 26, 1972 · N10245 · Substantial damage NTSB MIA73DLT06Accident · No injuriesClosedCessna 188A · Dundee, MSSep 23, 1972 · N5624J · Substantial damage NTSB MIA73AM045Accident · 1 fatalClosedCessna 177 · Natchez, MSSep 20, 1972 · N30245 · Destroyed NTSB MIA73IM034Incident · Minor injuriesClosedDouglas DC-8 · Meridian, MSSep 17, 1972 · N806E · No damage NTSB MIA73FKQ16Accident · Serious injuriesClosedCessna 172 · Columbus, MSSep 13, 1972 · N3934R · Substantial damage NTSB MIA73AM026Accident · 6 fatalClosedPiper PA-31 · Columbus, MSSep 7, 1972 · N9261Y · Destroyed NTSB MIA73FKQ12Accident · No injuriesClosedCessna A188A · Calhoun City, MSSep 6, 1972 · N9966G · Destroyed NTSB MIA73DKQ14Accident · Serious injuriesClosedCessna A188A · Rulville, MSSep 6, 1972 · N4406Q · Destroyed NTSB MIA73DLT03Accident · No injuriesClosedCessna 150 · Olive Branch, MSSep 5, 1972 · N1294Q · Substantial damage NTSB MIA73DKQ13Accident · Minor injuriesClosedCallair A-9 · Edwards, MSSep 5, 1972 · N9620Z · Substantial damage NTSB MIA73DKQ11Accident · No injuriesClosedGrumman G-164A · Woodville, MSSep 3, 1972 · N8372 · Substantial damage NTSB MIA73DKQ10Accident · No injuriesClosedPiper PA-25 · Bobo, MSAug 31, 1972 · N7257Z · Destroyed NTSB MIA73FKQ09Accident · No injuriesClosedPiper PA-30 · Greenwood, MSAug 30, 1972 · N7805Y · Substantial damage NTSB MIA73FKQ07Accident · Serious injuriesClosedCessna A188 · Arcola, MSAug 29, 1972 · N3508Q · Substantial damage NTSB MIA73DKQ08Accident · Serious injuriesClosedBoeing E75 · Greenwood, MSAug 29, 1972 · N65872 · Destroyed NTSB MIA73FKQ05Accident · No injuriesClosedCessna 188 · Webb, MSAug 21, 1972 · N8075V · Destroyed NTSB MIA73FKQ06Accident · No injuriesClosedBoeing B75N1 · Minter City, MSAug 18, 1972 · N64387 · Substantial damage NTSB MIA73FKQ04Accident · No injuriesClosedChampion 7ECA · Ocean Sprngs, MSAug 18, 1972 · N6325N · Substantial damage NTSB MIA73FKQ03Accident · No injuriesClosedFleet Acft 16B · Mccomb, MSAug 14, 1972 · N162V · Substantial damage NTSB MIA73AM015Accident · 1 fatalClosedCessna 177 · Jackson, MSAug 9, 1972 · N3217T · Destroyed NTSB MIA73FKQ02Accident · No injuriesClosedGrumman G-164 · Philipp, MSAug 7, 1972 · N745Y · Substantial damage NTSB MIA73DLT02Accident · No injuriesClosedCessna A188A · Olive Branch, MSAug 6, 1972 · N9905G · Substantial damage NTSB MIA73AM009Accident · No injuriesClosedCessna 206 · Jackson, MSJul 13, 1972 · N5016U · Substantial damage NTSB MKC73AK004Accident · 1 fatalClosedCessna 172 · Tunica, MSJul 6, 1972 · N3965L · Destroyed NTSB MIA72FLT15Accident · No injuriesClosedBellanca 17-31A · Walls, MSJun 20, 1972 · N8211R · Substantial damage NTSB MIA72DKQ36Accident · No injuriesClosedCessna 172K · Boyle, MSJun 17, 1972 · N78249 · Substantial damage NTSB MIA72DLT14Accident · No injuriesClosedCessna 188A · Olive Branch, MSJun 16, 1972 · N9945G · Destroyed NTSB MIA72FKQ35Accident · Serious injuriesClosedAero Comdr 560-A · Greenwood, MSJun 10, 1972 · N2754B · Destroyed NTSB MIA72AM128Accident · 2 fatalClosedFairchild M-62A · Madison, MSJun 2, 1972 · N54112 · Destroyed NTSB MIA72FLT13Accident · Minor injuriesClosedCessna 182 · Southaven, MSMay 26, 1972 · N91516 · Substantial damage NTSB MIA72FKQ34Accident · Minor injuriesClosedLuscombe 8E · Laurel, MSMay 26, 1972 · N1499K · Substantial damage NTSB MIA72AM118Accident · 1 fatalClosedBeech A23 · Leakesville, MSMay 7, 1972 · N3888Q · Destroyed NTSB MIA72AM115Accident · Minor injuriesClosedCessna 411 · Monticello, MSApr 30, 1972 · N7399U · Substantial damage NTSB MIA72FKQ33Accident · No injuriesClosedGillam Star SA300 · Picayune, MSMar 31, 1972 · N2462 · Substantial damage NTSB MIA72AM098Accident · 1 fatalClosedPiper J3C-65 · Ocean Sprngs, MSMar 23, 1972 · N42193 · Destroyed NTSB MIA72DKQ32Accident · No injuriesClosedCallair A-9 · Avon, MSMar 18, 1972 · N7601V · Substantial damage NTSB MIA72AM091Accident · 3 fatalClosedCessna 182H · Wiggins, MSMar 14, 1972 · N8428S · Destroyed NTSB MIA72IM084Incident · No injuriesClosedMartin 404 · Columbus, MSFeb 21, 1972 · N259S · Minor damage NTSB MIA72FKQ29Accident · No injuriesClosedCessna 310K · Tupelo, MSFeb 15, 1972 · N6996L · Destroyed NTSB MIA72FKQ30Accident · No injuriesClosedPiper PA-30 · Greenwood, MSFeb 14, 1972 · N7026Y · Substantial damage