Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69F0290Accident · 1 fatalClosedAero Comdr A-9B · Newton, MSDec 20, 1968 · N7696V · Destroyed NTSB MIA69F0276Accident · Serious injuriesClosedCessna 150H · Madison, MSDec 2, 1968 · N22370 · Destroyed NTSB MIA69F0225Accident · No injuriesClosedCessna 182L · Meridian, MSNov 16, 1968 · N42855 · Substantial damage NTSB MIA69F0201Accident · Serious injuriesClosedGlobe GC-1B · Gulfport, MSOct 9, 1968 · N2323B · Destroyed NTSB MIA69F0169Accident · Serious injuriesClosedAeronca 7AC · Schlater, MSOct 2, 1968 · N82181 · Substantial damage NTSB MIA69F0181Accident · 1 fatalClosedBeech A23-19 · Utica, MSSep 29, 1968 · N7919L · Destroyed NTSB MIA69D0187Accident · Serious injuriesClosedPiper PA-25 · Batesville, MSSep 28, 1968 · N7331Z · Destroyed NTSB MIA69D0154Accident · No injuriesClosedCessna 150F · Jackson, MSSep 20, 1968 · N8665S · Substantial damage NTSB MIA69F0166Accident · 1 fatalClosedPiper PA-25 · Marks, MSSep 10, 1968 · N6133Z · Substantial damage NTSB MIA69D0135Accident · No injuriesClosedPiper PA-25 · Greenville, MSSep 6, 1968 · N4704Y · Substantial damage NTSB MIA69F0149Accident · 1 fatalClosedBell 47G · Merigold, MSSep 2, 1968 · N10175 · Destroyed NTSB MIA69F0125Accident · Serious injuriesClosedCessna 140 · Oakland, MSAug 30, 1968 · N76997 · Destroyed NTSB MIA69F0105Accident · No injuriesClosedLuscombe 8E · Itta Bena, MSAug 30, 1968 · N9125R · Destroyed NTSB MIA69F0134Accident · No injuriesClosedPiper PA-25 · Ruleville, MSAug 26, 1968 · N7633Z · Substantial damage NTSB MIA69F0107Accident · No injuriesClosedAero Comdr 520 · New Albany, MSAug 24, 1968 · N4170B · Substantial damage NTSB MIA69D0124Accident · Minor injuriesClosedPiper PA-25 · Learned, MSAug 24, 1968 · N4548Y · Substantial damage NTSB MIA69F0126Accident · Minor injuriesClosedPiper PA-24 · Jackson, MSAug 23, 1968 · N5371P · Substantial damage NTSB MIA69F0120Accident · No injuriesClosedPiper PA-25 · Eupora, MSAug 21, 1968 · N7008Z · Destroyed NTSB MIA69F0117Accident · 1 fatalClosedPiper PA-25 · Cadarette, MSAug 21, 1968 · N7254Z · Destroyed NTSB MIA69D0112Accident · Serious injuriesClosedPiper PA-25 · Clarksdale, MSAug 10, 1968 · N6545Z · Destroyed NTSB MIA69A0009Accident · 1 fatalClosedPiper PA-22 · Independence, MSAug 8, 1968 · N5834Z · Destroyed NTSB MIA69A0008Accident · No injuriesClosedDouglas DC-3C · Walls, MSAug 3, 1968 · N52935 · Substantial damage NTSB MIA69F0083Accident · Minor injuriesClosedPiper PA-25 · Blaine, MSAug 2, 1968 · N7471Z · Substantial damage NTSB MIA69F0081Accident · No injuriesClosedAero Comdr 600S2R · Greenville, MSJul 30, 1968 · N1721S · Substantial damage NTSB FTW69D0078Accident · No injuriesClosedCessna 177 · Gulfport, MSJul 26, 1968 · N2356Y · Substantial damage NTSB FTW69D0098Accident · No injuriesClosedPiper PA-18 · Gulfport, MSJul 13, 1968 · N4191Z · Substantial damage NTSB MIA69D0023Accident · No injuriesClosedCessna 170 · Monticello, MSJul 7, 1968 · N2848C · Substantial damage NTSB MIA69D0013Accident · No injuriesClosedSikorsky S-51 · Gulfport, MSJul 4, 1968 · N13183 · Substantial damage NTSB MIA69D0027Accident · No injuriesClosedCessna 150 · Brandon, MSJun 29, 1968 · N23235 · Substantial damage NTSB MIA69F0010Accident · No injuriesClosedPiper PA-18A · Louisville, MSJun 28, 1968 · N8189C · Substantial damage NTSB MIA69D0024Accident · Minor injuriesClosedPiper J-3 · Shelby, MSJun 28, 1968 · N49594 · Substantial damage NTSB MIA68F0548Accident · No injuriesClosedCessna 172G · Bay St.Louis, MSJun 12, 1968 · N4192L · Substantial damage NTSB MIA68F0015Accident · Minor injuriesClosedHughes 269B · Gulfport, MSJun 11, 1968 · N9393F · Substantial damage NTSB MIA68F0549Accident · Serious injuriesClosedPiper PA-28 · Corinth, MSJun 8, 1968 · N7459R · Destroyed NTSB MIA69D0007Accident · No injuriesClosedCessna 170B · Natchez, MSJun 5, 1968 · N2764D · Substantial damage NTSB MIA68D0536Accident · No injuriesClosedCessna 182H · Hattiesburg, MSMay 27, 1968 · N8448S · Substantial damage NTSB MIA68D0158Accident · No injuriesClosedPiper PA-25 · Rosedale, MSMay 22, 1968 · N7222Z · Substantial damage NTSB MIA68F0537Accident · Serious injuriesClosedPiper J3C-65 · Glen Allen, MSMay 20, 1968 · N70734 · Destroyed NTSB MIA68F0512Accident · Serious injuriesClosedBoeing A75N1 · Merigold, MSMay 13, 1968 · N69389 · Substantial damage NTSB MIA68D0515Accident · No injuriesClosedCessna 172 · Tutwiler, MSMay 12, 1968 · N8229B · Substantial damage NTSB MIA68A0091Accident · 2 fatalClosedCessna 172H · Belmont, MSMay 2, 1968 · N1789F · Destroyed NTSB MIA68D0480Accident · No injuriesClosedCessna 150 · Horn Lake, MSApr 24, 1968 · N6748S · Substantial damage NTSB MIA68D0498Accident · No injuriesClosedPiper PA-20 · Picayune, MSApr 21, 1968 · N7472K · Substantial damage NTSB MIA68A0086Accident · 1 fatalClosedPiper PA-18A · Pascagoula, MSApr 13, 1968 · N7771D · 2 aircraft · Destroyed NTSB MIA68F0449Accident · No injuriesClosedPiper PA-25 · Eupora, MSMar 14, 1968 · N7367Z · Substantial damage NTSB MIA68F0440Accident · No injuriesClosedBoeing A75N1 · Leland, MSMar 4, 1968 · N59759 · Substantial damage NTSB MIA68A0071Accident · No injuriesClosedBell 206A · Walls, MSFeb 24, 1968 · N7876S · Substantial damage NTSB MIA68D0420Accident · No injuriesClosedCessna 310K · Tupelo, MSFeb 17, 1968 · N7043L · Substantial damage NTSB MKC68D0438Accident · No injuriesClosedCessna 206 · E Prairie, MSFeb 8, 1968 · N5106U · Destroyed NTSB MIA68A0060Accident · No injuriesClosedMartin 404 · Oxford Miss, MSJan 1, 1968 · N251S · Destroyed