Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MIA78FKQ04Accident · Minor injuriesClosedCessna 172 · Natchez, MSDec 24, 1977 · N1097U · Substantial damage NTSB MIA78FLT01Accident · No injuriesClosedPiper PA-28 · Arkabutla, MSNov 11, 1977 · N15361 · Substantial damage NTSB MIA78FKQ03Accident · 1 fatalClosedThrush S2R · Poplarville, MSOct 27, 1977 · N8921Q · Destroyed NTSB DCA78AA001Accident · 6 fatalClosedConvair 240 · Gillsburg, MSOct 20, 1977 · N55VM · Destroyed NTSB MIA78DKQ02Accident · No injuriesClosedCessna 188 · Mccomb, MSOct 18, 1977 · N8440G · Substantial damage NTSB MIA77KKQ01Accident · No injuriesClosedGrumman G-164A · Flora, MSOct 7, 1977 · N66020 · Substantial damage NTSB MIA77FA091Accident · 2 fatalClosedAeronca 7DC · Cleveland, MSSep 25, 1977 · N82685 · Destroyed NTSB MIA77FA090Accident · 1 fatalClosedCessna 150 · Water Valley, MSSep 24, 1977 · N6677G · Destroyed NTSB MIA77FA087Accident · 2 fatalClosedPiper PA-28 · Jackson, MSSep 12, 1977 · N98039 · Destroyed NTSB MIA77DKQ36Accident · No injuriesClosedCessna 188B · Sunflower, MSSep 12, 1977 · N731DH · Destroyed NTSB MIA77FKQ42Accident · Minor injuriesClosedCessna A188B · Morton, MSSep 11, 1977 · N21756 · Destroyed NTSB MIA77FKQ40Accident · Minor injuriesClosedPiper PA-22 · Picayune, MSAug 26, 1977 · N4755A · Substantial damage NTSB MIA77PKQ38Accident · No injuriesClosedCessna A188B · Rolling Fork, MSAug 25, 1977 · N91262 · Substantial damage NTSB MIA77FKQ39Accident · 1 fatalClosedCessna A188B · Winona, MSAug 25, 1977 · N79462 · Substantial damage NTSB MIA77FKQ37Accident · No injuriesClosedCessna A188B · Louisville, MSAug 24, 1977 · N5704G · Substantial damage NTSB MIA77FKQ35Accident · Serious injuriesClosedBell MK5-B · Lambert, MSAug 23, 1977 · N4227A · Substantial damage NTSB MIA77FLT05Accident · No injuriesClosedAero Comdr S-2R · Hernando, MSAug 21, 1977 · N5624X · Destroyed NTSB MIA77FKQ33Accident · No injuriesClosedPiper PA-28 · Natchez, MSAug 21, 1977 · N4504X · Substantial damage NTSB MIA77FA082Accident · 2 fatalClosedChampion 7EC · Yazoo City, MSAug 21, 1977 · N9003B · Destroyed NTSB MIA77FKQ32Accident · Serious injuriesClosedAero Comdr 100-18 · Jackson, MSAug 20, 1977 · N4036X · Substantial damage NTSB MIA77DKQ34Accident · No injuriesClosedCessna 188B · Grace, MSAug 19, 1977 · N70124 · Substantial damage NTSB MIA77FKQ31Accident · No injuriesClosedGrumman G164A · Flora, MSAug 18, 1977 · N48426 · Substantial damage NTSB MIA77FKQ25Accident · Serious injuriesClosedCessna A188B · Canton, MSAug 16, 1977 · N9139G · Destroyed NTSB MIA77FK030Accident · No injuriesClosedStinson 108-3 · Quitman, MSAug 14, 1977 · N6509M · Substantial damage NTSB MIA77FA080Accident · 3 fatalClosedBeech 65-80 · Vancleave, MSAug 13, 1977 · N6DG · Destroyed NTSB MIA77FKQ29Accident · No injuriesClosedGrumman G-164B · Houston, MSAug 4, 1977 · N48628 · Substantial damage NTSB MIA77FKQ28Accident · No injuriesClosedCessna A188B · Myrte, MSAug 4, 1977 · N21705 · Substantial damage NTSB MIA77FKQ27Accident · Serious injuriesClosedCessna A188B · Tchula, MSAug 2, 1977 · N53296 · Destroyed NTSB MIA77FKQ26Accident · No injuriesClosedGrumman G-164B · Tchula, MSAug 2, 1977 · N63D · Substantial damage NTSB MIA77FA073Accident · 1 fatalClosedBellanca 7GCBC · Leland, MSAug 2, 1977 · N36379 · Destroyed NTSB MIA77FKQ24Accident · 1 fatalClosedPiper PA-18 · Louisville, MSJul 26, 1977 · N1358C · Destroyed NTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSJul 23, 1977 · N6543 · 2 aircraft · Destroyed NTSB MIA77FKQ23Accident · No injuriesClosedLake LA-4 · Tylertown, MSJul 23, 1977 · N1220L · Substantial damage NTSB MIA77FKQ22Accident · No injuriesClosedCessna A188 · Winterville, MSJul 14, 1977 · N21808 · Substantial damage NTSB MIA77FKQ21Accident · Serious injuriesClosedCessna 188B · Flora, MSJul 12, 1977 · N9143R · Destroyed NTSB MIA77FKQ18Accident · No injuriesClosedCessna 188 · Leland, MSJun 20, 1977 · N79581 · Substantial damage NTSB MIA77FKQ20Accident · Minor injuriesClosedCallair A9A · Holly Bluff, MSJun 17, 1977 · N3576G · Substantial damage NTSB MIA77KK019Accident · No injuriesClosedLuscombe 8A · Louisville, MSJun 14, 1977 · N71127 · Destroyed NTSB MIA77FKQ17Accident · No injuriesClosedCessna A188B · Vicksburg, MSJun 1, 1977 · N91229 · Destroyed NTSB NYC77FNE21Accident · No injuriesClosedSchweizer SGS126 · Sterling, MSMay 28, 1977 · N1106S · Substantial damage NTSB MIA77FKQ16Accident · No injuriesClosedCessna A188B · Lambert, MSMay 27, 1977 · N70389 · Destroyed NTSB MIA77FKQ15Accident · No injuriesClosedGrumman G-164B · Pugh City, MSMay 19, 1977 · N48646 · Destroyed NTSB MIA77FKQ13Accident · Serious injuriesClosedPiper J5A · Hattiesburg, MSMay 15, 1977 · N30947 · Destroyed NTSB MIA77FKQ14Accident · Serious injuriesClosedCessna A188B · Tutwiler, MSMay 13, 1977 · N21654 · Destroyed NTSB MIA77FLT03Accident · Minor injuriesClosedCessna 140 · Walls, MSMay 6, 1977 · N2301V · Destroyed NTSB MIA77FKQ12Accident · Serious injuriesClosedGrumman AA5 · Hattiesburg, MSApr 17, 1977 · N1371R · Destroyed NTSB MIA77DLT02Accident · No injuriesClosedCessna 188 · Holly Spring, MSApr 15, 1977 · N53307 · Substantial damage NTSB MIA77FKQ10Accident · Minor injuriesClosedCessna R172E · Newton, MSApr 8, 1977 · N103RL · Substantial damage NTSB MIA77FKQ07Accident · 1 fatalClosedBellanca 8GCBC · Edwards, MSApr 7, 1977 · N86981 · Destroyed NTSB MIA77DKQ11Accident · No injuriesClosedBeech E33 · Tutwiler, MSApr 5, 1977 · N8409N · Substantial damage