Skip to content

NTSB investigations, 1967, OH

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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

19622026

NTSB investigations, 1967, OH per year, 1962–2026: 4,364 cases
1962	1
1963	1
1964	199
1965	184
1966	193
1967	189
1968	187
1969	129
1970	142
1971	147
1972	121
1973	124
1974	142
1975	101
1976	103
1977	112
1978	99
1979	115
1980	109
1981	81
1982	81
1983	81
1984	84
1985	73
1986	59
1987	69
1988	59
1989	74
1990	52
1991	52
1992	56
1993	46
1994	52
1995	54
1996	44
1997	43
1998	29
1999	38
2000	46
2001	33
2002	39
2003	46
2004	34
2005	37
2006	23
2007	41
2008	43
2009	32
2010	37
2011	43
2012	30
2013	22
2014	29
2015	17
2016	34
2017	33
2018	33
2019	27
2020	22
2021	27
2022	30
2023	19
2024	16
2025	23
2026	23

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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CHI68D0558Accident · No injuriesClosedPiper PA-30 · Willoughby, OHDec 29, 1967 · N7745Y · Substantial damage NTSB CHI68A0057Accident · 1 fatalClosedCessna 172 · Millersburg, OHDec 25, 1967 · N8160X · Destroyed NTSB CHI68F0515Accident · Minor injuriesClosedPiper PA-28 · Jackson, OHDec 23, 1967 · N9910W · Substantial damage NTSB CHI68F0497Accident · No injuriesClosedCessna 310H · Cincinnati, OHDec 19, 1967 · N1068Q · 2 aircraft · Substantial damage NTSB CHI68F0503Accident · Minor injuriesClosedMooney M20C · Shadyside, OHDec 17, 1967 · N79800 · Substantial damage NTSB CHI68D0562Accident · No injuriesClosedPiper PA-23 · Cleveland, OHDec 17, 1967 · N4351P · Substantial damage NTSB CHI68A0054Accident · Serious injuriesClosedVickers 745D · Canton, OHDec 11, 1967 · N7429 · Substantial damage NTSB CHI68F0496Accident · No injuriesClosedCessna 150 · Columbus, OHDec 9, 1967 · N374LA · Substantial damage NTSB CHI68D0455Accident · Minor injuriesClosedCessna 172 · Wellston, OHDec 2, 1967 · N2685L · Destroyed NTSB CHI68F0456Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHNov 27, 1967 · N6575W · Substantial damage NTSB CHI68F0468Accident · No injuriesClosedCessna 150 · Urbana, OHNov 26, 1967 · N3210P · Substantial damage NTSB CHI68D0533Accident · No injuriesClosedCessna 150 · Strongsville, OHNov 26, 1967 · N7881F · Substantial damage NTSB CHI68D0531Accident · No injuriesClosedCessna 172 · Painesville, OHNov 25, 1967 · N3906L · Substantial damage NTSB CHI68F0447Accident · Minor injuriesClosedErco 415-C · Waynesville, OHNov 24, 1967 · N99876 · Substantial damage NTSB CHI68A0048Accident · 2 fatalClosedPiper PA-28 · South Solon, OHNov 22, 1967 · N8427W · Destroyed NTSB CHI68F0433Accident · No injuriesClosedBeech D35 · London, OHNov 20, 1967 · N2987B · Substantial damage NTSB CHI68F0462Accident · Minor injuriesClosedMooney 20C · Columbus, OHNov 19, 1967 · N78912 · Substantial damage NTSB CHI68D0620Accident · No injuriesClosedCessna 180 · Orient, OHNov 19, 1967 · N4920A · Substantial damage NTSB CHI68F0542Accident · Serious injuriesClosedPiper PA-30 · Chagrin Flls, OHNov 17, 1967 · N7704Y · Destroyed NTSB CHI68D0488Accident · No injuriesClosedBeech A23A · Toledo, OHNov 17, 1967 · CF-VMA · Substantial damage NTSB CHI68F0424Accident · No injuriesClosedPiper PA-28 · Columbus, OHNov 14, 1967 · N1405U · Substantial damage NTSB CHI68F0514Accident · Serious injuriesClosedStinson 108 · Wellington, OHNov 10, 1967 · N97319 · Substantial damage NTSB CHI68D0518Accident · Minor injuriesClosedCessna 172 · Painesville, OHNov 10, 1967 · N5465R · Substantial damage NTSB CHI68D0504Accident · No injuriesClosedCessna 150 · Mansfield, OHNov 8, 1967 · N6209S · Substantial damage NTSB NYC68I0071Incident · Minor injuriesClosedDouglas DC-8 · Cleveland, OHNov 7, 1967 · N8015W · Minor damage NTSB CHI68F0457Accident · Minor injuriesClosedCessna 421 · Findlay, OHNov 3, 1967 · N4019L · Destroyed NTSB CHI68F0386Accident · No injuriesClosedBeech H35 · Portsmouth, OHNov 2, 1967 · N7917D · Substantial damage NTSB CHI68F0397Accident · No injuriesClosedPiper PA-23 · Aberdeen, OHNov 1, 1967 · N1258P · Substantial damage NTSB CHI68F0505Accident · No injuriesClosedFairchild 24 · Geneva, OHOct 29, 1967 · N28645 · Substantial damage NTSB CHI68D0486Accident · No injuriesClosedNavion A · Toledo, OHOct 29, 1967 · N4457K · Substantial damage NTSB CHI68F0404Accident · No injuriesClosedStinson 108-1 · Brookville, OHOct 28, 1967 · N97364 · Substantial damage NTSB CHI68F0393Accident · No injuriesClosedMooney M20C · Zanesville, OHOct 28, 1967 · N6001Q · Substantial damage NTSB CHI68D0508Accident · No injuriesClosedPiper PA-28 · Toledo, OHOct 24, 1967 · N9584J · Substantial damage NTSB CHI68F0392Accident · No injuriesClosedPiper PA-28 · Edison, OHOct 22, 1967 · N4202J · Substantial damage NTSB CHI68F0371Accident · No injuriesClosedPiper PA-28 · Athens, OHOct 22, 1967 · N7576W · Substantial damage NTSB CHI68D0487Accident · No injuriesClosedBeech A23 · Wooster, OHOct 22, 1967 · N4768J · Substantial damage NTSB CHI68F0361Accident · Minor injuriesClosedAeronca 7AC · Mt.Sterling, OHOct 15, 1967 · N81403 · Substantial damage NTSB CHI68D0356Accident · No injuriesClosedCessna 172 · Findlay, OHOct 8, 1967 · N6148E · Substantial damage NTSB CHI68F0331Accident · No injuriesClosedPiper PA-28 · Mt.Vernon, OHOct 3, 1967 · N7480R · Substantial damage NTSB CHI68D0432Accident · No injuriesClosedBeech E18S · Cleveland, OHSep 27, 1967 · N403FW · Substantial damage NTSB CHI68A0031Accident · No injuriesClosedBell 47G-2 · Bedford, OHSep 26, 1967 · N46R · Substantial damage NTSB CHI68D0410Accident · No injuriesClosedPiper PA-28 · Salem, OHSep 25, 1967 · N7477R · Substantial damage NTSB CHI68F0345Accident · Serious injuriesClosedScheibe Spatz · Marion, OHSep 23, 1967 · N247RH · Substantial damage NTSB CHI68F0340Accident · Serious injuriesClosedAeronca 7AC · Strongsville, OHSep 23, 1967 · N2733E · Substantial damage NTSB CHI68A0029Accident · No injuriesClosedAir/Space 18A · Zanesville, OHSep 21, 1967 · N6152S · Substantial damage NTSB CHI68F0278Accident · No injuriesClosedBeech 35-33 · Grove City, OHSep 20, 1967 · N607V · Substantial damage NTSB CHI68F0302Accident · No injuriesClosedCessna 172A · Plain City, OHSep 19, 1967 · N7407T · Substantial damage NTSB CHI68F0258Accident · No injuriesClosedSparks D · Marion, OHSep 17, 1967 · N832Z · Substantial damage NTSB CHI68A0026Accident · No injuriesClosedDouglas DC-6 · Vandalia, OHSep 8, 1967 · N37516 · No damage NTSB CHI68F0264Accident · Serious injuriesClosedStinson 108-3 · Lore City, OHSep 7, 1967 · N6421M · Substantial damage