Skip to content

NTSB investigations, 1975, OH

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 CHI76AC042Accident · 1 fatalClosedPiper J-3 · Hopedale, OHDec 29, 1975 · N3331N · Substantial damage NTSB CHI76FEI17Accident · No injuriesClosedCessna 180H · Fremont, OHDec 28, 1975 · N2467F · Substantial damage NTSB CHI76FEI16Accident · No injuriesClosedCessna 150 · Elyria, OHDec 17, 1975 · N51306 · Substantial damage NTSB CHI76AC039Accident · Serious injuriesClosedAerostar TS600 · Mansfield, OHDec 10, 1975 · N12PB · Destroyed NTSB CHI76FEK09Accident · No injuriesClosedAmer Avco AA1-A · Sidney, OHDec 5, 1975 · N92311 · Substantial damage NTSB CHI76FEK08Accident · No injuriesClosedCessna 150F · Mcconnelsville, OHDec 3, 1975 · N6574F · Substantial damage NTSB CHI76FEI15Accident · Minor injuriesClosedGrum Amer AA-5 · Wadsworth, OHNov 16, 1975 · N7151L · Substantial damage NTSB CHI76DEG07Accident · No injuriesClosedPiper J5A · Batavia, OHNov 2, 1975 · N38721 · Substantial damage NTSB CHI76FEG06Accident · Serious injuriesClosedPitts S2A · Harrison, OHOct 15, 1975 · N80032 · Substantial damage NTSB CHI76DEI14Accident · Minor injuriesClosedBlanik L-13 · Canton, OHOct 12, 1975 · N3467 · Destroyed NTSB CHI76FEK07Accident · No injuriesClosedMooney M20E · Van Wert, OHOct 9, 1975 · N3259F · Substantial damage NTSB CHI76AC029Accident · No injuriesClosedDouglas DC-6B · Cleveland, OHSep 24, 1975 · N3549H · Substantial damage NTSB CHI76FEI13Accident · No injuriesClosedCessna 172M · Toronto, OHSep 16, 1975 · N64221 · Destroyed NTSB CHI76FEI12Accident · Minor injuriesClosedCessna 170 · Burton, OHSep 15, 1975 · N4191V · Substantial damage NTSB CHI76AC026Accident · 2 fatalClosedDouglas DC-3C · Wakeman, OHSep 11, 1975 · N144A · Destroyed NTSB CHI76FEG05Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHSep 5, 1975 · N40820 · Substantial damage NTSB CHI76FEG04Accident · No injuriesClosedLake LA-4 · Batavia, OHSep 2, 1975 · N1082L · Substantial damage NTSB CHI76AC017Accident · 2 fatalClosedPiper PA-28 · Minford, OHAug 25, 1975 · N44323 · Destroyed NTSB CHI76AC016Accident · 1 fatalClosedTaylorcraft BC12-D · Circleville, OHAug 24, 1975 · N43787 · Destroyed NTSB CHI76FEK05Accident · 1 fatalClosedBaby Ace D-C · Warsaw, OHAug 19, 1975 · N2854 · Destroyed NTSB CHI76FEI11Accident · No injuriesClosedPiper PA-28 · West Salem, OHAug 17, 1975 · N1841T · Substantial damage NTSB CHI7LFEI10Accident · Serious injuriesClosedPietenpol GN-1 · Lattasburg, OHAug 10, 1975 · N3148 · Destroyed NTSB CHI76FEK03Accident · Minor injuriesClosedTaylorcraft BC12-D · Georgesville, OHAug 9, 1975 · N95019 · Substantial damage NTSB CHI76FEI09Accident · No injuriesClosedCessna T337G · Youngstown, OHAug 9, 1975 · N8CE · Substantial damage NTSB CHI76FEI08Accident · No injuriesClosedCessna 185 · Elyria, OHAug 9, 1975 · N4548F · Substantial damage NTSB CHI76FEI07Accident · Minor injuriesClosedCessna 172L · Grafton, OHAug 9, 1975 · N19613 · Destroyed NTSB CHI76FEG03Accident · No injuriesClosedLuscombe 8A · Blue Ash, OHAug 9, 1975 · N1201B · Substantial damage NTSB CHI76AC011Accident · 1 fatalClosedCessna 150M · Elyria, OHAug 9, 1975 · N45216 · 2 aircraft · Destroyed NTSB CHI76FEI06Accident · Minor injuriesClosedPiper PA-28 · Chagrin Falls, OHJul 31, 1975 · N5294S · Substantial damage NTSB CHI76FEK02Accident · No injuriesClosedCessna 150M · Hicksville, OHJul 27, 1975 · N66687 · Substantial damage NTSB CHI76FEK01Accident · Minor injuriesClosedBeech D95A · New Knoxville, OHJul 24, 1975 · N1768B · Substantial damage NTSB CHI76FEI05Accident · No injuriesClosedCougar TY-1 · Northfield, OHJul 22, 1975 · N6510D · Substantial damage NTSB CHI76FEI04Accident · No injuriesClosedBell 47G-2 · Celeryville, OHJul 19, 1975 · N5235N · Substantial damage NTSB CHI76DEG02Accident · No injuriesClosedStinson 108 · Batavia, OHJul 12, 1975 · N97706 · Substantial damage NTSB CHI76FEI03Accident · No injuriesClosedErco 415-C · Chardon, OHJul 11, 1975 · N2970H · Substantial damage NTSB CHI76FEI01Accident · Serious injuriesClosedBellanca 7ECA · Oberlin, OHJul 9, 1975 · N68503 · Substantial damage NTSB CHI76AC002Accident · 1 fatalClosedPiper PA-28 · Buena Vista, OHJul 9, 1975 · N4362J · Destroyed NTSB CHI76FEI02Accident · No injuriesClosedStinson 108-1 · East Liverpool, OHJul 5, 1975 · N8145K · Substantial damage NTSB CHI76FEG01Accident · No injuriesClosedCessna 180 · Morrow, OHJul 4, 1975 · N4585B · Substantial damage NTSB CHI75FEK33Accident · No injuriesClosedBellanca 14-19 · Columbus, OHJun 28, 1975 · N7676B · Substantial damage NTSB CHI75AC097Accident · 2 fatalClosedBeech E18S · Toledo, OHJun 26, 1975 · N791A · Destroyed NTSB CHI75FEI59Accident · No injuriesClosedPiper PA-23 · Carrolton, OHJun 23, 1975 · N4232P · Substantial damage NTSB CHI75FEK31Accident · No injuriesClosedPiper PA-22 · Mt Vernon, OHJun 22, 1975 · N3809P · Destroyed NTSB CHI75FEK32Accident · No injuriesClosedBell 47G2 · Paulding, OHJun 19, 1975 · N555D · Substantial damage NTSB CHI75FEI58Accident · No injuriesClosedCessna 140 · Youngstown, OHJun 19, 1975 · N4229N · Substantial damage NTSB CHI75AEG24Accident · No injuriesClosedBeech P35 · Jackson, OHJun 19, 1975 · N1539Z · Substantial damage NTSB CHI75DEK34Accident · No injuriesClosedPiper PA-20 · Chesterville, OHJun 14, 1975 · N3SJ · Substantial damage NTSB CHI75FEK30Accident · No injuriesClosedCessna 150 · Circleville, OHJun 13, 1975 · N1724Q · Substantial damage NTSB CHI75FEI57Accident · No injuriesClosedTaylor Titch · Marlboro, OHJun 10, 1975 · N8216 · Destroyed NTSB CHI75FEI56Accident · Minor injuriesClosedBeech J35 · New Phila, OHJun 1, 1975 · N8256D · Destroyed