Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71DKQ22Accident · Serious injuriesClosedPiper PA-22 · Coldwater, MSDec 23, 1970 · N4891Z · Destroyed NTSB MIA71AM048Accident · 3 fatalClosedPiper PA-23 · Belzoni, MSDec 11, 1970 · N6486Y · Destroyed NTSB MIA71DKQ21Accident · No injuriesClosedPiper PA-28 · Picayune, MSNov 26, 1970 · N7134W · Substantial damage NTSB MIA71DKQ20Accident · No injuriesClosedCessna 150 · Edinburg, MSNov 19, 1970 · N8194S · Substantial damage NTSB MIA71DKQ19Accident · Minor injuriesClosedPiper J-3 · Batesville, MSNov 7, 1970 · N23404 · Destroyed NTSB MIA71FKQ18Accident · Minor injuriesClosedPiper PA-25 · Vicksburg, MSOct 17, 1970 · N6505Z · Substantial damage NTSB MIA71FKQ16Accident · No injuriesClosedBellanca 17-31 · Brandon, MSOct 12, 1970 · N7351V · Substantial damage NTSB MIA71FKQ17Accident · No injuriesClosedCessna 172F · Valley Park, MSOct 3, 1970 · N8594U · Substantial damage NTSB MIA71FKQ15Accident · 1 fatalClosedPiper PA-25 · Carpenter, MSSep 21, 1970 · N7508Z · Destroyed NTSB MIA71DKD09Accident · No injuriesClosedBeech B35 · Walls, MSSep 20, 1970 · N5219C · Substantial damage NTSB MIA71FKQ14Accident · Minor injuriesClosedPiper PA-22 · Quitman, MSSep 19, 1970 · N4406A · Substantial damage NTSB MIA71FKQ13Accident · No injuriesClosedCessna 170B · Jackson, MSSep 19, 1970 · N2635D · Substantial damage NTSB MIA71FKQ12Accident · No injuriesClosedPiper PA-25 · Inverness, MSSep 16, 1970 · N7565Z · Substantial damage NTSB MIA71FKQ11Accident · 1 fatalClosedPiper PA-25 · Georgetown, MSSep 14, 1970 · N6420Z · Destroyed NTSB MIA71AM025Accident · 2 fatalClosedLake LA-4 · Hernando, MSSep 11, 1970 · N7603L · Destroyed NTSB MIA71KKQ10Accident · 1 fatalClosedPiper PA-18A · Lucedale, MSSep 1, 1970 · N6364D · Destroyed NTSB MIA71FKQ09Accident · Serious injuriesClosedPiper PA-25 · Stringer, MSAug 20, 1970 · N6346Z · Destroyed NTSB MIA71FKQ08Accident · No injuriesClosedPiper PA-25 · Greenville, MSAug 15, 1970 · N4441Y · Substantial damage NTSB MIA71FKQ07Accident · Minor injuriesClosedPiper PA-25 · Bolton, MSAug 13, 1970 · N4383Y · Destroyed NTSB MIA71FKQ06Accident · No injuriesClosedPiper PA-25 · Ruleville, MSAug 8, 1970 · N4835Y · Substantial damage NTSB MIA71FKQ05Accident · No injuriesClosedPiper PA-25 · Quitman, MSAug 7, 1970 · N4462Y · Destroyed NTSB MIA71FKQ04Accident · Minor injuriesClosedAeronca 7AC · Pascagoula, MSAug 6, 1970 · N85083 · Substantial damage NTSB MIA71FKQ03Accident · 1 fatalClosedBoeing B75N1 · Glendora, MSAug 3, 1970 · N91074 · Destroyed NTSB FTW71FRJ03Accident · No injuriesClosedCessna U206 · Vicksburg, MSJul 31, 1970 · N269D · Destroyed NTSB MIA71FKQ01Accident · 1 fatalClosedBoeing A75N1 · Clarksdale, MSJul 25, 1970 · N9013H · Destroyed NTSB MIA71FKQ02Accident · No injuriesClosedBoeing B75N1 · Nitta Yuma, MSJul 23, 1970 · N65695 · Destroyed NTSB MIA70FKQ12Accident · No injuriesClosedCessna 401 · Brookhaven, MSJun 23, 1970 · N8083F · Substantial damage NTSB MIA70FKQ11Accident · No injuriesClosedCessna 150 · Clarksdale, MSJun 19, 1970 · N3609C · Substantial damage NTSB MIA70FKQ10Accident · Minor injuriesClosedCessna 170 · Bude, MSJun 3, 1970 · N4421B · Destroyed NTSB MIA70FKQ09Accident · No injuriesClosedPiper PA-22 · Roxie, MSMay 30, 1970 · N3351Z · Substantial damage NTSB MIA70FKQ08Accident · No injuriesClosedCessna 188 · Shelby, MSMay 13, 1970 · N3575Q · Destroyed NTSB MIA70FKQ07Accident · No injuriesClosedCallair A9B · Fitler, MSMay 7, 1970 · N7781V · Substantial damage NTSB MIA70FKQ06Accident · No injuriesClosedPiper PA-25 · Flora, MSMay 1, 1970 · N8547L · Substantial damage NTSB MIA70FKQ05Accident · No injuriesClosedCessna 172G · Purvis, MSApr 21, 1970 · N3728L · Substantial damage NTSB MIA70FKQ04Accident · No injuriesClosedSikorsky H-19G · Waveland, MSApr 17, 1970 · N17377 · Destroyed NTSB MIA70FKQ03Accident · No injuriesClosedPiper PA-22 · Carthage, MSApr 12, 1970 · N8414D · Substantial damage NTSB MIA70FKQ02Accident · No injuriesClosedCessna 150E · Picayune, MSApr 5, 1970 · N3999U · Substantial damage NTSB MIA70AM069Accident · 6 fatalClosedCessna 310P · Philadelphia, MSFeb 12, 1970 · N5930M · Destroyed NTSB MIA70FKQ01Accident · No injuriesClosedCessna 150J · Southaven, MSJan 17, 1970 · N61192 · Substantial damage NTSB MIA70AM057Accident · 2 fatalClosedGlobe GC-1B · Hickory, MSJan 16, 1970 · N521C · Destroyed