Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MIA68F0308Accident · No injuriesClosedPiper J-3 · Prentiss, MSDec 2, 1967 · N3235N · Substantial damage NTSB MIA68D0293Accident · No injuriesClosedPiper J3C-65 · Benoit, MSNov 26, 1967 · N6681H · Substantial damage NTSB MIA68F0294Accident · Minor injuriesClosedCessna 172 · Cleveland, MSNov 24, 1967 · N6321E · Substantial damage NTSB MIA68F0303Accident · No injuriesClosedAeronca 7DC · Sanford, MSNov 19, 1967 · N4651E · Substantial damage NTSB MIA68F0295Accident · No injuriesClosedCessna 172 · Yazoo City, MSNov 18, 1967 · N4070F · Substantial damage NTSB MIA68F0280Accident · No injuriesClosedCessna 310F · Gulfport, MSNov 11, 1967 · N6799X · Substantial damage NTSB MIA68D0264Accident · No injuriesClosedBoeing B75N1 · Belzoni, MSNov 2, 1967 · N52598 · Substantial damage NTSB MIA68F0262Accident · Minor injuriesClosedCessna 120 · Newton, MSOct 26, 1967 · N1850N · Substantial damage NTSB MIA68D0248Accident · No injuriesClosedCessna 150 · Mccomb, MSOct 23, 1967 · N8846G · Substantial damage NTSB MIA68F0259Accident · No injuriesClosedBoeing A75N1 · Tchula, MSOct 13, 1967 · N50149 · 2 aircraft · Substantial damage NTSB MIA68A0037Accident · No injuriesClosedHughes 269A · Lula, MSOct 12, 1967 · N8718F · Substantial damage NTSB MIA68F0210Accident · No injuriesClosedCessna 175 · Jackson, MSOct 10, 1967 · N6993E · Substantial damage NTSB MIA68F0228Accident · No injuriesClosedPiper PA-25 · Houston, MSOct 6, 1967 · N7361Z · Substantial damage NTSB MIA68F0199Accident · No injuriesClosedPiper PA-18 · Inverness, MSSep 25, 1967 · N5379Y · Substantial damage NTSB MIA68D0181Accident · No injuriesClosedCessna 150 · Batesville, MSSep 16, 1967 · N2744S · Substantial damage NTSB MIA68D0135Accident · No injuriesClosedPiper PA-25 · Silver City, MSSep 10, 1967 · N6717Z · Destroyed NTSB MIA68D0177Accident · No injuriesClosedPiper PA-25 · Shaw, MSSep 7, 1967 · N6098Z · Substantial damage NTSB MIA68F0167Accident · No injuriesClosedBoeing A75N1 · Redwood, MSSep 4, 1967 · N60309 · Substantial damage NTSB MIA68D0147Accident · No injuriesClosedBeech 35-B33 · Picayune, MSAug 31, 1967 · N8580M · Substantial damage NTSB MIA68D0150Accident · No injuriesClosedPiper PA-28 · Doloroso, MSAug 27, 1967 · N7258W · Substantial damage NTSB MIA68F0141Accident · Minor injuriesClosedCessna 172 · Lucedale, MSAug 26, 1967 · N3994S · Substantial damage NTSB MIA68F0148Accident · Serious injuriesClosedPiper J3C-65 · Hollandale, MSAug 23, 1967 · N7009H · Destroyed NTSB MIA68F0129Accident · No injuriesClosedPiper PA-22 · Taylorsville, MSAug 23, 1967 · N8434D · Substantial damage NTSB MIA68D0130Accident · Minor injuriesClosedPiper PA-25 · Coffeeville, MSAug 22, 1967 · N6967Z · Destroyed NTSB MIA68A0022Accident · No injuriesClosedBell 47D1 · Glen Allan, MSAug 22, 1967 · N8282E · Substantial damage NTSB MIA68F0111Accident · No injuriesClosedPiper PA-18 · Randolph, MSAug 21, 1967 · N5447Z · Destroyed NTSB MIA68F0102Accident · No injuriesClosedCessna 182B · Meadville, MSAug 20, 1967 · N7183E · Substantial damage NTSB MIA68F0118Accident · No injuriesClosedCessna 172 · Bruce, MSAug 16, 1967 · N2580Y · Substantial damage NTSB MIA68F0091Accident · No injuriesClosedCessna 182 · Madison, MSAug 14, 1967 · N3701U · Substantial damage NTSB MIA68F0103Accident · No injuriesClosedPiper PA-25 · Bruce, MSAug 11, 1967 · N7337Z · Destroyed NTSB MIA68F0128Accident · No injuriesClosedAeronca 7AC · Baldwyn, MSAug 10, 1967 · N82556 · Substantial damage NTSB MIA68A0017Accident · 1 fatalClosedPiper PA-18 · Macon, MSAug 7, 1967 · N2676P · Destroyed NTSB MIA68D0087Accident · No injuriesClosedCallair A-9 · Barton, MSAug 6, 1967 · N8283H · Destroyed NTSB MIA68F0117Accident · No injuriesClosedCessna 140 · State Coll., MSAug 3, 1967 · N76151 · Substantial damage NTSB MIA68F0058Accident · No injuriesClosedBurns BA-42 · Starkville, MSJul 27, 1967 · N4604S · Substantial damage NTSB MIA68D0060Accident · No injuriesClosedPiper PA-28 · Biloxi, MSJul 22, 1967 · N4635R · Substantial damage NTSB MIA68D0059Accident · No injuriesClosedBoeing A75N1 · Tomnolen, MSJul 10, 1967 · N75690 · Substantial damage NTSB MIA68D0019Accident · No injuriesClosedAeronca 7AC · Pascagoula, MSJul 3, 1967 · N84047 · Destroyed NTSB MIA68F0020Accident · No injuriesClosedBeech 95 · Jackson, MSJun 29, 1967 · N2725Y · Substantial damage NTSB MIA68F0030Accident · No injuriesClosedBeech A45 · Picayune, MSJun 25, 1967 · N4178A · Substantial damage NTSB MIA67F0577Accident · No injuriesClosedCessna 170 · Columbus, MSJun 18, 1967 · N2773C · Substantial damage NTSB MIA68F0013Accident · No injuriesClosedPiper PA-24 · Gulfport, MSJun 13, 1967 · N6138P · Substantial damage NTSB MIA68F0006Accident · No injuriesClosedSnow Comdr 600S2D · Starkville, MSJun 7, 1967 · N1710S · Substantial damage NTSB MIA67D0581Accident · No injuriesClosedPiper PA-25 · Smithville, MSMay 26, 1967 · N7674Z · Substantial damage NTSB MIA67D0576Accident · Minor injuriesClosedBoeing A75N1 · Batesville, MSMay 25, 1967 · N50093 · Destroyed NTSB MIA67F0562Accident · Minor injuriesClosedCessna 150 · Onward, MSMay 10, 1967 · N6637T · Substantial damage NTSB MIA67D0525Accident · No injuriesClosedGrumman G-164 · Shelby, MSMay 10, 1967 · N645U · Substantial damage NTSB MIA67A0113Accident · 1 fatalClosedAero Comdr 500 · Hazlehurst, MSApr 27, 1967 · N6231B · Destroyed NTSB MIA67A0106Accident · 2 fatalClosedMooney M20F · Lyon, MSApr 8, 1967 · N2727W · Destroyed NTSB MIA67A0103Accident · 3 fatalClosedBeech A23 · Hattiesburg, MSMar 31, 1967 · N2345W · Destroyed