Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72FKQ27Accident · No injuriesClosedHiller Acft FH1100 · Hattiesburg, MSDec 22, 1971 · N5035F · Substantial damage NTSB MIA72FKQ26Accident · No injuriesClosedCessna 175 · Duck Hill, MSNov 28, 1971 · N9259B · Substantial damage NTSB MIA72AM045Accident · 4 fatalClosedPiper PA-31 · Iuka, MSNov 17, 1971 · N780JM · Destroyed NTSB MIA72FKQ25Accident · No injuriesClosedPiper PA-23 · Sledge, MSOct 23, 1971 · N7673Z · Substantial damage NTSB MIA72AM025Accident · 5 fatalClosedAero Comdr 560-A · Jackson, MSSep 15, 1971 · N2779B · Destroyed NTSB MIA72FKQ24Accident · Serious injuriesClosedPiper PA-25 · Vaiden, MSSep 13, 1971 · N6968Z · Destroyed NTSB MIA72FKQ21Accident · No injuriesClosedCessna 150 · Pascagoula, MSSep 10, 1971 · N8381G · Substantial damage NTSB MIA72DKQ20Accident · No injuriesClosedBoeing E75 · Grenada, MSSep 7, 1971 · N9055H · Destroyed NTSB MIA72FKQ18Accident · No injuriesClosedGrumman G-164A · Oakland, MSSep 4, 1971 · N980X · Destroyed NTSB MIA72FKQ16Accident · No injuriesClosedCessna 188 · Chatham, MSSep 4, 1971 · N8100V · Substantial damage NTSB MIA72DKQ17Accident · No injuriesClosedCessna 188 · Sumner, MSSep 4, 1971 · N8134V · Substantial damage NTSB MIA72FKQ19Accident · Minor injuriesClosedCessna 177 · Vicksburg, MSSep 3, 1971 · N30344 · Substantial damage NTSB MIA72DKQ15Accident · No injuriesClosedPiper PA-18 · Edwards, MSSep 2, 1971 · N3864Z · Destroyed NTSB MIA72FKQ13Accident · No injuriesClosedCessna 150J · Brookhaven, MSAug 28, 1971 · N60677 · Substantial damage NTSB MIA72FKQ14Accident · No injuriesClosedPiper PA-23 · Jackson, MSAug 27, 1971 · N13852 · Substantial damage NTSB MIA72FKQ12Accident · No injuriesClosedBell 47D-1 · Mt Olive, MSAug 27, 1971 · N2794A · Substantial damage NTSB MIA72FLT05Accident · No injuriesClosedCessna 188 · Tunica, MSAug 26, 1971 · N8196V · Substantial damage NTSB MIA72FKQ11Accident · Minor injuriesClosedAeronca 7FC · Collins, MSAug 26, 1971 · N9832Y · Substantial damage NTSB MIA72FKQ10Accident · No injuriesClosedCessna 188 · Indianola, MSAug 26, 1971 · N3517Q · Destroyed NTSB MIA72DLT06Accident · No injuriesClosedBoeing A75 · Hernando, MSAug 26, 1971 · N55065 · Substantial damage NTSB MIA72FKQ08Accident · Minor injuriesClosedCessna 188A · Hollandale, MSAug 24, 1971 · N5687J · Destroyed NTSB MIA72DKQ22Accident · No injuriesClosedBoeing B75N1 · Nitta Yuma, MSAug 23, 1971 · N1758M · Substantial damage NTSB MIA72AM018Accident · 3 fatalClosedMooney M20 · Ashland, MSAug 22, 1971 · N5222B · Destroyed NTSB MIA72DKQ07Accident · No injuriesClosedPiper PA-25 · Merigold, MSAug 16, 1971 · N7229Z · Substantial damage NTSB MIA72FKQ06Accident · No injuriesClosedPiper PA-28 · Fulton, MSAug 15, 1971 · N9778J · Substantial damage NTSB MIA72FKQ09Accident · No injuriesClosedGrumman G-164A · Swan Lake, MSAug 12, 1971 · N7843 · Substantial damage NTSB MIA72FKQ05Accident · No injuriesClosedCessna 188 · Shaw, MSAug 12, 1971 · N3536Q · Substantial damage NTSB MIA72DKQ04Accident · Minor injuriesClosedCessna 172 · Biloxi, MSAug 7, 1971 · N3004U · Substantial damage NTSB MIA72FKQ03Accident · Serious injuriesClosedAerostar 600 · Greenwood, MSAug 1, 1971 · N600AS · Substantial damage NTSB MIA72DLT02Accident · No injuriesClosedMooney M20C · Holly Sprngs, MSJul 31, 1971 · N5573Q · Substantial damage NTSB FTW72FRD03Accident · No injuriesClosedCessna 150 · Poplarville, MSJul 31, 1971 · N6654S · Substantial damage NTSB MIA72FLT01Accident · Minor injuriesClosedCessna 172K · Coldwater, MSJul 24, 1971 · N46484 · Substantial damage NTSB MIA72FKQ20Accident · No injuriesClosedPiper PA-30 · Moorhead, MSJul 14, 1971 · N8070Y · Substantial damage NTSB MIA72FKQ01Accident · No injuriesClosedPiper PA-25 · Mc Comb, MSJul 10, 1971 · N4582Y · Substantial damage NTSB MIA71DLT19Accident · No injuriesClosedCessna 150 · Coldwater, MSJun 23, 1971 · N22314 · Substantial damage NTSB MIA71FLT18Accident · No injuriesClosedBellanca 17-30 · New Albany, MSJun 22, 1971 · N7354V · Destroyed NTSB MIA71FKQ38Accident · Serious injuriesClosedBoeing A75N1 · Greenwood, MSJun 18, 1971 · N57810 · Destroyed NTSB MIA71FKQ37Accident · No injuriesClosedAmer Avco AA1-A · Jackson, MSJun 3, 1971 · N9339L · Substantial damage NTSB MIA71FKQ36Accident · No injuriesClosedStearman A75 · Cleveland, MSMay 31, 1971 · N4878N · Substantial damage NTSB MIA71FKQ35Accident · 1 fatalClosedSnow S2C · Tutwiler, MSMay 21, 1971 · N9488R · Destroyed NTSB MIA71AM097Accident · 2 fatalClosedCessna 337A · Jackson, MSMay 16, 1971 · N5388S · Destroyed NTSB MIA71FKQ34Accident · Minor injuriesClosedPiper J3C · Minter City, MSMay 14, 1971 · N33598 · Substantial damage NTSB MIA71FLT13Accident · No injuriesClosedCessna 172 · Holly Spgs, MSApr 25, 1971 · N8181B · Substantial damage NTSB MIA71FKQ31Accident · No injuriesClosedCessna 182C · Leaf, MSApr 16, 1971 · N189S · Substantial damage NTSB MIA71FKQ30Accident · Serious injuriesClosedAero Comdr A-9B · Purvis, MSApr 16, 1971 · N7966V · Destroyed NTSB MIA71FKQ29Accident · 1 fatalClosedPiper PA-25 · Gunnison, MSApr 13, 1971 · N7310Z · Destroyed NTSB MIA71DKQ28Accident · No injuriesClosedPiper PA-22 · Hernando, MSApr 9, 1971 · N7336D · Substantial damage NTSB MIA71DKQ33Accident · No injuriesClosedCessna 150 · Lucedale, MSApr 4, 1971 · N7087S · Substantial damage NTSB MIA71DKQ32Accident · No injuriesClosedPiper PA-18A · Quitman, MSMar 31, 1971 · N9088D · Substantial damage NTSB MIA71FKQ27Accident · Serious injuriesClosedCessna A188A · Carrollton, MSMar 11, 1971 · N2168U · Substantial damage