Skip to content

NTSB investigations, 1973, MS

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 MIA74FKQ11Accident · Minor injuriesClosedBoeing E75 · Jackson, MSDec 3, 1973 · N131J · Destroyed NTSB MIA74AM040Accident · 1 fatalClosedPiper PA-28 · Columbus, MSNov 7, 1973 · N9508W · Destroyed NTSB MIA74AM030Accident · 1 fatalClosedLuscombe 8A · Natchez, MSOct 10, 1973 · N45915 · Destroyed NTSB MIA74AM028Accident · 2 fatalClosedCessna 150H · Gulfport, MSOct 3, 1973 · N23286 · Destroyed NTSB MIA74DKQ10Accident · No injuriesClosedCessna 188 · Lambert, MSSep 15, 1973 · N4468Q · Substantial damage NTSB MIA74AM022Accident · 4 fatalClosedCessna TU206C · Laurel, MSSep 11, 1973 · 8R-GDF · Destroyed NTSB MIA74FK608Accident · Serious injuriesClosedAeronca 7AC · Belzoni, MSSep 8, 1973 · N84703 · Destroyed NTSB MIA74DKQ09Accident · No injuriesClosedPiper PA-25 · Rosedale, MSSep 8, 1973 · N7498Z · Substantial damage NTSB MIA74FLT02Accident · No injuriesClosedCallair A-9 · Coldwater, MSSep 5, 1973 · N9655Z · Substantial damage NTSB MIA74FLT01Accident · No injuriesClosedGrumman G-164A · Ripley, MSSep 3, 1973 · N4562 · Substantial damage NTSB MIA74FKQ06Accident · 1 fatalClosedCessna A188B · Vaiden, MSAug 20, 1973 · N4492Q · Destroyed NTSB MIA74FKQ07Accident · No injuriesClosedAero Comdr A-9B · Yazoo City, MSAug 19, 1973 · N7745V · Destroyed NTSB MIA74DKQ05Accident · No injuriesClosedAero Comdr A9-B · Edwards, MSAug 17, 1973 · N7691V · Substantial damage NTSB MIA74AM014Accident · 4 fatalClosedPiper PA-24 · Gulfport, MSAug 12, 1973 · N6993P · Destroyed NTSB MIA74FKQ04Accident · Minor injuriesClosedTaylorcraft BC12-D · Amory, MSJul 31, 1973 · N96145 · Substantial damage NTSB MIA74AM010Accident · 2 fatalClosedAlon A-2 · Blue Springs, MSJul 28, 1973 · N6371V · Destroyed NTSB MIA74FKQ03Accident · Serious injuriesClosedCessna A188A · Marks, MSJul 24, 1973 · N9942G · Substantial damage NTSB MIA74AM005Accident · 1 fatalClosedAeronca 7AC · Oxford, MSJul 18, 1973 · N3603E · Destroyed NTSB MIA73FKQ02Accident · Serious injuriesClosedGrumman G-164A · Charleston, MSJul 13, 1973 · N4642 · Destroyed NTSB MIA74DKQ01Accident · Serious injuriesClosedBoeing B75NI · Rolling Fork, MSJul 5, 1973 · N1352M · Destroyed NTSB MIA73FKQ33Accident · No injuriesClosedGrumman G-164A · Boyle, MSJun 27, 1973 · N8389 · Destroyed NTSB MIA73FKQ30Accident · No injuriesClosedBell 47G2-2 · Grenada, MSJun 25, 1973 · N4823 · Substantial damage NTSB MIA73FKQ32Accident · No injuriesClosedCessna A188A · Crowder, MSJun 23, 1973 · N99156 · Destroyed NTSB MIA73FKQ31Accident · No injuriesClosedHughes 269B · Madison, MSJun 19, 1973 · N9357F · Substantial damage NTSB MIA73AM107Accident · 1 fatalClosedChampion 7GCAA · Walls, MSJun 10, 1973 · N2758G · Destroyed NTSB MIA73FKQ29Accident · No injuriesClosedGrumman G-164A · Minter City, MSJun 4, 1973 · N5333 · Destroyed NTSB MIA73FKQ28Accident · No injuriesClosedCessna 150 · Wiggins, MSMay 10, 1973 · N7821F · Substantial damage NTSB MIA73FKQ27Accident · Serious injuriesClosedAero Comdr A-9 · Flora, MSMay 4, 1973 · N8410V · Destroyed NTSB MIA73DKQ26Accident · No injuriesClosedCessna 177 · Clarksdale, MSMay 3, 1973 · N29668 · Destroyed NTSB MIA73FKQ25Accident · Serious injuriesClosedCessna 150 · Avon, MSMar 8, 1973 · N2611J · Substantial damage NTSB MIA73FKQ24Accident · No injuriesClosedCessna A188 · Lexington, MSFeb 27, 1973 · N21886 · Substantial damage NTSB MIA73AM070Accident · 2 fatalClosedCessna 150 · Meridian, MSJan 5, 1973 · N6884G · Destroyed