Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 CHI79FEK03Accident · Serious injuriesClosedPiper PA-28R · Zanesville, OHDec 26, 1978 · N9367N · Destroyed NTSB CHI79FA020Accident · Minor injuriesClosedDehavilland 114-2X · Cleveland, OHDec 18, 1978 · N3FB · Substantial damage NTSB CHI79FEG08Accident · Serious injuriesClosedPiper PA-28 · Chesapeake, OHDec 10, 1978 · N32541 · Substantial damage NTSB CHI79DEG07Accident · No injuriesClosedStinson 108 · Cincinnati, OHDec 1, 1978 · N97343 · Substantial damage NTSB CHI79FEK02Accident · Minor injuriesClosedStitts Plby SA3B · St. Marys, OHNov 26, 1978 · N1020G · Substantial damage NTSB CHI79FEG06Accident · No injuriesClosedCessna 150L · West Union, OHNov 25, 1978 · N18202 · Substantial damage NTSB CHI79FEI07Accident · Minor injuriesClosedPiper PA-32 · North Canton, OHNov 21, 1978 · N8967N · Substantial damage NTSB CHI79FEG05Accident · No injuriesClosedCessna 421B · Dayton, OHNov 21, 1978 · N502SC · Substantial damage NTSB CHI79FEG04Accident · No injuriesClosedBeech C45H · Dayton, OHNov 21, 1978 · N9863Z · Substantial damage NTSB CHI79FEI06Accident · Serious injuriesClosedGrumman AA-5A · Middlefield, OHNov 19, 1978 · N26317 · Destroyed NTSB CHI79DA016Accident · No injuriesClosedConvair 600 · Wilmington, OHNov 18, 1978 · N74853 · Substantial damage NTSB CHI79FEK01Accident · 1 fatalClosedGrum Amer AA-5 · Reno, OHNov 12, 1978 · N7187L · Destroyed NTSB CHI79FEI05Accident · No injuriesClosedChampion 7ECA · Auburn Corners, OHNov 6, 1978 · N9665S · Substantial damage NTSB CHI79FEG02Accident · No injuriesClosedBeech 58 · Cincinnati, OHOct 31, 1978 · N788CF · Substantial damage NTSB CHI79FEI08Accident · Minor injuriesClosedRepublic RC-3 · Sandusky Bay, OHOct 29, 1978 · N12LS · Substantial damage NTSB CHI79FEG03Accident · Minor injuriesClosedCessna 150F · Hillsboro, OHOct 29, 1978 · N6723F · Destroyed NTSB CHI79FEI03Accident · No injuriesClosedCessna 150M · Cleveland, OHOct 28, 1978 · N704PR · Substantial damage NTSB CHI79IA013Incident · No injuriesClosedBoeing 737 · Cleveland, OHOct 27, 1978 · N9029U · Minor damage NTSB CHI79FA012Accident · 1 fatalClosedCessna 172M · Gallipolis, OHOct 27, 1978 · N5131H · 2 aircraft · Destroyed NTSB CHI79FEI04Accident · Minor injuriesClosedCessna 172M · Salem, OHOct 25, 1978 · N20221 · Destroyed NTSB CHI79DEG01Accident · No injuriesClosedLake LA-4 · Hamilton, OHOct 16, 1978 · N1201L · Substantial damage NTSB CHI79FEI02Accident · No injuriesClosedPiper PA-34 · Chargin Falls, OHOct 14, 1978 · N1050X · Substantial damage NTSB CHI79FA007Accident · Serious injuriesClosedBeech G18 · Cleveland, OHOct 11, 1978 · N11Z · Destroyed NTSB CHI79FEI01Accident · No injuriesClosedPiper PA-32R · Strongsville, OHOct 5, 1978 · N23BD · Substantial damage NTSB CHI79DA001Incident · No injuriesClosedConvair CV-600 · Cleveland, OHOct 3, 1978 · N74855 · Minor damage NTSB CHI78IA002Incident · No injuriesClosedCessna 421B · Mt Vernon, OHOct 3, 1978 · N5965M · No damage NTSB CHI78FEG18Accident · No injuriesClosedAeronca 11AC · Lebanon, OHSep 23, 1978 · N9636E · Substantial damage NTSB CHI78FEG17Accident · No injuriesClosedCessna 150 · Germantown, OHSep 23, 1978 · N19244 · Destroyed NTSB CHI78FEI38Accident · No injuriesClosedCessna 170A · Strongsville, OHSep 20, 1978 · N9936A · Substantial damage NTSB CHI78FEG15Accident · No injuriesClosedPiper PA-38 · Dayton, OHSep 15, 1978 · N4225E · Substantial damage NTSB CHI78FE137Accident · No injuriesClosedCessna 172M · Elyria, OHSep 4, 1978 · N73131 · Substantial damage NTSB CHI78FEG16Accident · Minor injuriesClosedPiper PA-28 · Newton, OHSep 3, 1978 · N6977J · Substantial damage NTSB CHI78FEK27Accident · No injuriesClosedHiller UH12E · Findlay, OHAug 25, 1978 · N9759C · Substantial damage NTSB CHI78DEG19Accident · No injuriesClosedCessna 172M · Franklin Furn, OHAug 23, 1978 · N9651Q · Substantial damage NTSB CHI78FEI35Accident · No injuriesClosedCessna 182 · Bucyrus, OHAug 17, 1978 · N7473S · Substantial damage NTSB CHI78FEI36Accident · No injuriesClosedBeech J35 · Elmore, OHAug 16, 1978 · N101HP · Substantial damage NTSB CHI78FEI34Accident · Serious injuriesClosedBeech V35 · Aurora, OHAug 6, 1978 · N7000N · Destroyed NTSB CHI78FA053Accident · 2 fatalClosedCessna 177RG · Jefferson, OHAug 6, 1978 · N45369 · Destroyed NTSB CHI78FEI33Accident · Minor injuriesClosedCessna 210 · Brimfield, OHAug 2, 1978 · N234CA · Destroyed NTSB CHI78FEI32Accident · 2 fatalClosedLockheed P38L · Whitehouse, OHAug 1, 1978 · N3005 · Destroyed NTSB CHI78FEI31Accident · No injuriesClosedPiper PA-20 · Cadiz, OHJul 28, 1978 · N7606K · Substantial damage NTSB CHI78FE130Accident · No injuriesClosedCessna 150F · Northfield, OHJul 26, 1978 · N7726F · Substantial damage NTSB CHI78FEK26Accident · No injuriesClosedCessna 150F · Marysville, OHJul 17, 1978 · N6299R · Substantial damage NTSB CHI78FEG14Accident · No injuriesClosedCessna 150M · Cleves, OHJul 17, 1978 · N714NN · Substantial damage NTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHJul 16, 1978 · N66382 · Destroyed NTSB CHI78FEK25Accident · Minor injuriesClosedSchleicher K8B · Montpelier, OHJul 14, 1978 · N885D · Substantial damage NTSB CHI78FEK23Accident · No injuriesClosedCessna 172M · Columbus, OHJul 13, 1978 · N20123 · Substantial damage NTSB CHI78FEI29Accident · No injuriesClosedBell 476-2 · Jeromesville, OHJul 11, 1978 · N54522 · Substantial damage NTSB CHI78DEI28Accident · Serious injuriesClosedHughes 269C · Chesterland, OHJul 3, 1978 · N9587F · No damage NTSB CHI78FEI27Accident · Minor injuriesClosedBeech M-35 · Riveredge, OHJul 2, 1978 · N9751R · Substantial damage