Skip to content

NTSB investigations, 1968, OH

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

19622026

NTSB investigations, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 CHI69F0405Accident · No injuriesClosedCessna 172 · Columbus, OHDec 28, 1968 · N186HP · Substantial damage NTSB CHI69D0527Accident · No injuriesClosedCessna 337 · Cleveland, OHDec 28, 1968 · N5487S · Substantial damage NTSB CHI69I0064Incident · No injuriesClosedN.American NA-265 · Richmond Hts, OHDec 22, 1968 · N7509V · Minor damage NTSB CHI69D0432Accident · No injuriesClosedPiper PA-28 · Akron, OHDec 21, 1968 · N1749J · Substantial damage NTSB CHI69I0063Incident · No injuriesClosedBeech C-45H · Youngstown, OHDec 18, 1968 · N431P · Minor damage NTSB CHI69D0418Accident · No injuriesClosedCessna 177 · Hillsboro, OHDec 18, 1968 · N3384T · Substantial damage NTSB CHI69F0620Accident · 1 fatalClosedGrumman F8F-2 · Willoughby, OHDec 12, 1968 · N212KA · Destroyed NTSB CHI69A0059Accident · 1 fatalClosedBeech 23 · Marion, OHDec 10, 1968 · N2314Q · Destroyed NTSB CHI69D0525Accident · No injuriesClosedCessna 310D · Vienna, OHDec 8, 1968 · N3056D · Destroyed NTSB CHI69F0427Accident · Minor injuriesClosedErco 415-C · Clyde, OHDec 1, 1968 · N93538 · Substantial damage NTSB CHI69D0376Accident · No injuriesClosedCessna 172H · Fairborn, OHNov 28, 1968 · N1407F · Substantial damage NTSB CHI69D0421Accident · No injuriesClosedPiper PA-23 · Bowling Grn, OHNov 26, 1968 · N3200P · Substantial damage NTSB CHI69F0355Accident · No injuriesClosedCessna 172C · Plain City, OHNov 24, 1968 · N1584Y · Substantial damage NTSB CHI69D0408Accident · No injuriesClosedPiper PA-28 · Mansfield, OHNov 21, 1968 · N1811J · Substantial damage NTSB CHI69F0341Accident · No injuriesClosedPiper PA-28 · Wilmington, OHNov 17, 1968 · N9505J · Substantial damage NTSB CHI69F0349Accident · No injuriesClosedCessna 140 · Elyria, OHNov 13, 1968 · N4268N · Substantial damage NTSB CHI69A0049Accident · No injuriesClosedPiper PA-28 · Bucyrus, OHNov 9, 1968 · N8998J · Substantial damage NTSB CHI69F0344Accident · Serious injuriesClosedPiper PA-22 · Darby Dale, OHNov 8, 1968 · N8895C · Substantial damage NTSB CHI69F0335Accident · No injuriesClosedBeech P35 · Columbus, OHNov 3, 1968 · N1781G · Substantial damage NTSB CHI69D0416Accident · No injuriesClosedBeech 35 · Stillwell, OHNov 3, 1968 · N312VL · Substantial damage NTSB CHI69D0370Accident · No injuriesClosedBellanca 14-19 · Middlefield, OHNov 3, 1968 · N8844R · Substantial damage NTSB CHI69F0326Accident · No injuriesClosedCessna 180 · Lebanon, OHOct 30, 1968 · N6416X · Substantial damage NTSB CHI69F0336Accident · No injuriesClosedCessna 310B · Zanesville, OHOct 27, 1968 · N6625B · Substantial damage NTSB CHI69A0045Accident · 1 fatalClosedNardi FN-333 · Akron, OHOct 25, 1968 · N625 · Destroyed NTSB CHI69A0041Accident · 7 fatalClosedBeech 65-A90 · Cleveland, OHOct 18, 1968 · N703WC · Destroyed NTSB CHI69A0043Accident · 2 fatalClosedRepublic RC-3 · Lake Erie, OHOct 17, 1968 · N6194K · Destroyed NTSB CHI69F0404Accident · No injuriesClosedBeech A23 · Cleveland, OHOct 14, 1968 · N5761V · Substantial damage NTSB CHI69F0338Accident · No injuriesClosedPiper PA-23 · Painesville, OHOct 9, 1968 · N3297P · Substantial damage NTSB CHI69D0334Accident · No injuriesClosedCessna 150 · Carrollton, OHOct 5, 1968 · N8506J · Substantial damage NTSB CHI69D0266Accident · No injuriesClosedBeech A23 · Defiance, OHOct 2, 1968 · N5776V · Substantial damage NTSB CHI69D0406Accident · No injuriesClosedCessna 310B · Waterville, OHOct 1, 1968 · N900S · Substantial damage NTSB CHI69F0283Accident · No injuriesClosedCessna 140 · Marysville, OHSep 29, 1968 · N76083 · Substantial damage NTSB CHI69F0299Accident · No injuriesClosedCessna 177 · Xenia, OHSep 27, 1968 · N2910X · Substantial damage NTSB CHI69D0337Accident · No injuriesClosedBeech A-24 · Toledo, OHSep 27, 1968 · N5699S · Substantial damage NTSB CHI69F0264Accident · No injuriesClosedGlobe GC-1B · Wapakoneta, OHSep 22, 1968 · N80514 · Substantial damage NTSB CHI69D0251Accident · No injuriesClosedCessna 172 · New Lexingtn, OHSep 22, 1968 · N380LA · Substantial damage NTSB CHI69D0255Accident · No injuriesClosedErco 415-C · Brookville, OHSep 21, 1968 · N93590 · Substantial damage NTSB CHI69A0033Accident · 2 fatalClosedDehavilland 104 · Richmond, OHSep 21, 1968 · N6533D · Destroyed NTSB CHI69D0329Accident · No injuriesClosedCessna 140 · Painesville, OHSep 20, 1968 · N72489 · Substantial damage NTSB CHI69A0032Accident · 1 fatalClosedHughes 269A · Camp Denison, OHSep 19, 1968 · N8930F · Destroyed NTSB CHI69D0410Accident · No injuriesClosedBeech 35-B33 · Birmingham, OHSep 17, 1968 · N9563Y · Substantial damage NTSB CHI69A0030Accident · No injuriesClosedCessna 150 · Hamilton, OHSep 15, 1968 · N3314J · 2 aircraft · Substantial damage NTSB CHI69F0235Accident · No injuriesClosedCessna 170 · Williamsburg, OHSep 14, 1968 · N2948D · Substantial damage NTSB CHI69D0297Accident · No injuriesClosedTaylorcraft BC12-D · Up.Sandusky, OHSep 14, 1968 · N96399 · Substantial damage NTSB CHI69A0029Accident · 1 fatalClosedAeronca 65-CA · New London, OHSep 14, 1968 · N36659 · Destroyed NTSB CHI69D0348Accident · Minor injuriesClosedLuscombe 8F · Walbridge, OHSep 12, 1968 · N1847B · Substantial damage NTSB CHI69D0321Accident · No injuriesClosedPiper J-3 · Wooster, OHSep 6, 1968 · N9649H · Substantial damage NTSB CHI69D0298Accident · No injuriesClosedStinson 108-1 · Northfield, OHSep 6, 1968 · N8409K · Substantial damage NTSB CHI69A0027Accident · No injuriesClosedLockheed L-188 · Cleveland, OHSep 6, 1968 · N6121 · 2 aircraft · Substantial damage NTSB CHI69F0200Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHSep 5, 1968 · N7258J · Substantial damage