Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MIA80DRQ01Accident · No injuriesClosedBellanca 7GCAA · Belzoni, MSOct 2, 1979 · N86632 · Substantial damage NTSB MIA79FA130Accident · 2 fatalClosedCessna 120 · Vicksburg, MSSep 29, 1979 · N72504 · Destroyed NTSB MIA79DKQ34Accident · No injuriesClosedPiper PA-25 · Duck Hill, MSSep 12, 1979 · N7446Z · Substantial damage NTSB MIA79FKG33Accident · 1 fatalClosedRockwell S2R · Belzoni, MSSep 8, 1979 · N5044X · Substantial damage NTSB MIA79DKQ32Accident · No injuriesClosedCessna A188A · Sidon, MSSep 8, 1979 · N18DS · Destroyed NTSB MIA79DKQ30Accident · Minor injuriesClosedCessa A188B · Crawford, MSSep 6, 1979 · N731BQ · Destroyed NTSB MIA79FKQ31Accident · Minor injuriesClosedEmair MA-1 · Canton, MSSep 4, 1979 · N97063 · Substantial damage NTSB MIA79FKQ28Accident · Minor injuriesClosedAir Tractor AT-301 · Grenada, MSSep 4, 1979 · N8595S · Substantial damage NTSB MIA79DKQ29Accident · No injuriesClosedCessna A188B · Glen Allan, MSSep 4, 1979 · N731EK · Substantial damage NTSB MIA79FKQ27Accident · No injuriesClosedCessna A188B · Sledge, MSAug 29, 1979 · N53196 · Substantial damage NTSB MIA79DKQ26Accident · Minor injuriesClosedCessna A188B · Nitta Yuma, MSAug 28, 1979 · N731VL · Substantial damage NTSB MIA79FKQ25Accident · No injuriesClosedGrumman G-164A · Sunflower, MSAug 27, 1979 · N48437 · Substantial damage NTSB MIA79FKQ23Accident · No injuriesClosedCessna A188B · Shelby, MSAug 24, 1979 · N84284 · Substantial damage NTSB MIA79FKQ24Accident · No injuriesClosedCessna 188 · Water Valley, MSAug 20, 1979 · N1586M · Destroyed NTSB MIA79FKQ22Accident · No injuriesClosedGrumman G-164A · Madison, MSAug 13, 1979 · N8673H · Destroyed NTSB MIA79FKQ21Accident · No injuriesClosedPiper PA-36 · Tutwiler, MSAug 12, 1979 · N56664 · Destroyed NTSB MIA79FKQ20Accident · Minor injuriesClosedNaval Fcty N3N-3 · Petal, MSJul 29, 1979 · N45021 · Substantial damage NTSB MIA79DKQ19Accident · Minor injuriesClosedGrumman G-164A · Minter City, MSJul 26, 1979 · N5258 · Destroyed NTSB MIA79DKQ18Accident · Serious injuriesClosedNavion A · Crosby, MSJul 20, 1979 · N8877H · Destroyed NTSB MIA79DKQ17Accident · Minor injuriesClosedBellanca 7KCAB · Crowder, MSJul 14, 1979 · N7563F · Substantial damage NTSB MIA79FKQ16Accident · No injuriesClosedGrumman G-164A · Batesville, MSJul 13, 1979 · N8881H · Substantial damage NTSB MIA79DKQ15Accident · No injuriesClosedTomcat MK-5A · Lambert, MSJul 10, 1979 · N9099T · Substantial damage NTSB MIA79FKQ14Accident · 1 fatalClosedCessna A188B · Lyman, MSJul 7, 1979 · N4910R · Destroyed NTSB MIA79FKQ13Accident · Serious injuriesClosedCessna 170A · Raymond, MSJun 24, 1979 · N5420C · Substantial damage NTSB MIA79FLT06Accident · 1 fatalClosedPitts S1-C · Southaven, MSJun 17, 1979 · N20JH · Destroyed NTSB MIA79FA097Accident · 2 fatalClosedCessna 150L · Meridian, MSJun 16, 1979 · N19192 · Destroyed NTSB MIA79FKQ12Accident · No injuriesClosedCessna 188 · Bentonia, MSJun 8, 1979 · N731VY · Substantial damage NTSB MIA79FKQ11Accident · No injuriesClosedBell 47D · Parchman, MSJun 8, 1979 · N4227A · Substantial damage NTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSJun 5, 1979 · N9560D · Destroyed NTSB MIA79FKQ04Accident · No injuriesClosedCessna 182 · Greenville, MSMay 25, 1979 · N182CD · Destroyed NTSB MIA79FA087Accident · 2 fatalClosedCessna 152 · Greenville, MSMay 21, 1979 · N25356 · Destroyed NTSB MIA79DKQ10Accident · Minor injuriesClosedHiller UH12D · Drew, MSMay 1, 1979 · N48313 · Substantial damage NTSB MIA79DLT05Accident · Minor injuriesClosedEntwicklung C · Southaven, MSApr 28, 1979 · N11NE · Destroyed NTSB MIA79FKQ09Accident · Minor injuriesClosedPiper PA-22 · Newton, MSApr 19, 1979 · N4805A · Destroyed NTSB MIA79FKQ07Accident · Serious injuriesClosedGrumman G164A · Lucedale, MSApr 18, 1979 · N4573 · Destroyed NTSB MIA79FA073Accident · 1 fatalClosedPiper PA-30 · Rich, MSApr 18, 1979 · N8758Y · Destroyed NTSB MIA79FKQ06Accident · No injuriesClosedCessna 170A · Tupelo, MSApr 7, 1979 · N1256D · Substantial damage NTSB MIA79DKQ05Accident · No injuriesClosedCessna 182 · Tylertown, MSApr 2, 1979 · N21LW · Substantial damage NTSB MIA79FLT04Accident · No injuriesClosedPiper PA-23 · Southaven, MSMar 10, 1979 · N1125P · Substantial damage NTSB DCA79AA011Accident · 8 fatalClosedBeech BE-70 · Gulfport, MSMar 1, 1979 · N777AE · Destroyed NTSB MIA79FA054Accident · 3 fatalClosedBeech 58 · Greenville, MSFeb 26, 1979 · N2055K · 2 aircraft · Destroyed NTSB MIA79FA046Accident · 1 fatalClosedPiper PA-23 · Pascagoula, MSFeb 4, 1979 · N3362P · Destroyed NTSB MIA79FLT03Accident · No injuriesClosedCessna 150 · Booneville, MSJan 25, 1979 · N8357U · Substantial damage NTSB MIA79FA035Accident · 1 fatalClosedCessna 310R · Madison, MSJan 5, 1979 · N303LA · Destroyed