Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 CHI78FEK06Accident · Minor injuriesClosedCessna 150 · Clairsville, OHDec 31, 1977 · N714GE · Substantial damage NTSB CHI78FEI08Accident · Serious injuriesClosedCessna 172E · Louisville, OHDec 31, 1977 · N3586S · Substantial damage NTSB CHI78FEI07Accident · Serious injuriesClosedPiper PA-28 · Walbridge, OHDec 26, 1977 · N6875J · Substantial damage NTSB CHI78FEI06Accident · Minor injuriesClosedCessna T337C · Akron, OHDec 23, 1977 · N99SB · Substantial damage NTSB CHI78FEI05Accident · No injuriesClosedPiper PA-18 · Smithville, OHDec 18, 1977 · N46891 · Substantial damage NTSB CHI78FA012Accident · 1 fatalClosedCessna U206F · Garrettsville, OHDec 17, 1977 · N1045V · Destroyed NTSB CHI78FEI04Accident · Minor injuriesClosedCessna T310 · Jefferson, OHDec 14, 1977 · N98857 · Substantial damage NTSB CHI78FEK05Accident · No injuriesClosedAmer Avco AA-1C · Van Wert, OHDec 11, 1977 · N9633U · Substantial damage NTSB CHI78FEI03Accident · No injuriesClosedCessna 210 · Vienna, OHNov 25, 1977 · N22220 · Substantial damage NTSB CHI78FEG03Accident · Serious injuriesClosedCessna 210L · Washington Ch, OHNov 23, 1977 · N1644X · Substantial damage NTSB CHI78FEK04Accident · No injuriesClosedCessna 210G · Sidney, OHNov 9, 1977 · N5931F · Substantial damage NTSB CHI78FEK03Accident · No injuriesClosedPiper PA-31 · Delaware, OHNov 5, 1977 · N9208Y · Substantial damage NTSB CHI78FA006Accident · 2 fatalClosedCessna 150G · Columbus, OHNov 4, 1977 · N6221S · Destroyed NTSB CHI78FEI02Accident · No injuriesClosedBeech G-18S · Cleveland, OHNov 1, 1977 · N120ZZ · Substantial damage NTSB CHI78FA004Accident · 5 fatalClosedCessna 180 · Bidwell, OHOct 29, 1977 · N51GC · Destroyed NTSB CHI78FEK02Accident · No injuriesClosedCessna 172 · Quincy, OHOct 21, 1977 · N7183T · Substantial damage NTSB CHI78FEK01Accident · No injuriesClosedCessna 182N · Lima, OHOct 17, 1977 · N92542 · Substantial damage NTSB CHI78FEG02Accident · No injuriesClosedBeech G-35 · Xenia, OHOct 17, 1977 · N4483D · Substantial damage NTSB CHI78FEI01Accident · Minor injuriesClosedCessna 172N · Shelby, OHOct 8, 1977 · N75791 · Substantial damage NTSB IAD78FLQ01Accident · No injuriesClosedLake LA-4 · Moscow, OHOct 5, 1977 · N1233L · Substantial damage NTSB CHI77FEG01Accident · Serious injuriesClosedCessna 172 · Portsmouth, OHOct 3, 1977 · N6050R · Substantial damage NTSB CHI77FEK34Accident · No injuriesClosedStolp Starle · Irwin, OHSep 29, 1977 · N2300 · Substantial damage NTSB CHI77FEK33Accident · No injuriesClosedBell 47G-2A · Big Plaines, OHSep 28, 1977 · N9526 · Substantial damage NTSB CHI77FEI43Accident · Minor injuriesClosedPiper PA-25 · N.Fairfield, OHSep 22, 1977 · N4835Y · Substantial damage NTSB CHI77FEI41Accident · No injuriesClosedCessna 188B · Bloomville, OHSep 21, 1977 · N9032R · Substantial damage NTSB CHI77FEI40Accident · Minor injuriesClosedCessna 150 · Kelleys Is, OHSep 18, 1977 · N714SK · Substantial damage NTSB CHI77FEK32Accident · No injuriesClosedPiper PA-28 · Columbus, OHSep 15, 1977 · N180SU · Substantial damage NTSB CHI77FEI39Accident · No injuriesClosedCessna 15OM · Stow, OHSep 15, 1977 · N704EV · Substantial damage NTSB CHI77FEI38Accident · No injuriesClosedPiper PA-23 · Painesville, OHSep 14, 1977 · N2428U · Substantial damage NTSB CHI77FEK31Accident · No injuriesClosedCessna 170 · Marion, OHSep 11, 1977 · N2856C · Substantial damage NTSB CHI77FEK30Accident · Minor injuriesClosedHughes 269C · Urbana, OHSep 6, 1977 · N7459F · Substantial damage NTSB CHI77FEK29Accident · No injuriesClosedStarduster SA-300 · Columbus, OHSep 5, 1977 · N10RB · Substantial damage NTSB CHI77FEI42Accident · 1 fatalClosedFalck Spec · Cleveland, OHSep 3, 1977 · N60089 · Destroyed NTSB CHI77DEG28Accident · No injuriesClosedCessna 180 · Xenia, OHSep 2, 1977 · N3143C · Substantial damage NTSB CHI77FEI37Accident · No injuriesClosedCessna 150 · Wellington, OHAug 28, 1977 · N66647 · Substantial damage NTSB CHI77FEG25Accident · No injuriesClosedPiper PA-28 · Union City, OHAug 23, 1977 · N723FL · Substantial damage NTSB CHI77FEK27Accident · No injuriesClosedChampion 7FC · Columbus, OHAug 20, 1977 · N9039B · Substantial damage NTSB CHI77FEG24Accident · No injuriesClosedCessna 210 · Cincinnati, OHAug 20, 1977 · N5913F · Substantial damage NTSB CHI77FA066Accident · Minor injuriesClosedBeech E18S · Buckeye Lake, OHAug 17, 1977 · N3616B · Substantial damage NTSB CHI77FEK26Accident · No injuriesClosedSchleicher K-7 · Montpelier, OHAug 14, 1977 · N6380T · Substantial damage NTSB CHI77FEI36Accident · No injuriesClosedPiper PA-22 · Woodville, OHAug 12, 1977 · N1967A · Substantial damage NTSB CHI77FEK28Accident · No injuriesClosedPiper PA-28 · Lima, OHAug 8, 1977 · N4782L · Substantial damage NTSB CHI77FEI35Accident · Minor injuriesClosedMooney M20B · Youngstown, OHAug 5, 1977 · N74753 · Substantial damage NTSB CHI77FEG22Accident · Serious injuriesClosedPiper PA-28 · Piqua, OHJul 31, 1977 · N2873R · Substantial damage NTSB CHI77FEI34Accident · Minor injuriesClosedPiper PA-28 · Fremont, OHJul 30, 1977 · N9705W · Substantial damage NTSB CHI77FEK24Accident · No injuriesClosedStarduster SA-300 · Barnesville, OHJul 29, 1977 · N72TD · Substantial damage NTSB CHI77FEI33Accident · Minor injuriesClosedCessna 172 · Port Clinton, OHJul 26, 1977 · N734EK · Substantial damage NTSB CHI77DEG23Accident · No injuriesClosedCessna 310 · Batavia, OHJul 19, 1977 · N1310 · Substantial damage NTSB CHI77FEI32Accident · No injuriesClosedCessna 172 · Rittman, OHJul 17, 1977 · N7938G · Substantial damage NTSB CHI77FEK23Accident · Minor injuriesClosedCessna 150 · Nelsonville, OHJul 1, 1977 · N13086 · Substantial damage