Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 CHI80FEK06Accident · No injuriesClosedGrumman AA1-B · Lima, OHDec 29, 1979 · N1445R · Substantial damage NTSB CHI80FA015Accident · 1 fatalClosedPiper PA-28 · Mansfield, OHDec 16, 1979 · N5515F · Destroyed NTSB CHI80FA014Accident · 1 fatalClosedHughes 269C · West Milton, OHDec 15, 1979 · N7483F · Destroyed NTSB CHI80FEI09Accident · No injuriesClosedPiper PA-34 · Youngstown, OHDec 6, 1979 · N29257 · Substantial damage NTSB CHI80FEI08Accident · No injuriesClosedAeronca 7AC · Canfield, OHDec 3, 1979 · N81743 · Substantial damage NTSB CHI80FEG05Accident · No injuriesClosedPiper PA-32 · Batavia, OHNov 29, 1979 · N15588 · Substantial damage NTSB CHI80DEG06Accident · No injuriesClosedCessna 172N · Hillsboro, OHNov 27, 1979 · N733QJ · Substantial damage NTSB LAX80FA011Accident · 3 fatalClosedBeech V35B · Delta, OHNov 25, 1979 · N3949A · Destroyed NTSB CHI80FA010Accident · 1 fatalClosedCessna 150 · Wilmington, OHNov 25, 1979 · N8820S · Destroyed NTSB CHI80FEK05Accident · No injuriesClosedCessna 170A · Columbus, OHNov 18, 1979 · N9032A · Substantial damage NTSB CHI80FEI07Accident · Minor injuriesClosedCessna 150 · Ravenna, OHNov 18, 1979 · N63252 · 2 aircraft · Substantial damage NTSB CHI80FEG04Accident · No injuriesClosedBell 47G5 · Dayton, OHNov 16, 1979 · N2271W · Substantial damage NTSB CHI80FEG03Accident · No injuriesClosedCessna 182 · West Milton, OHNov 9, 1979 · N1907X · Substantial damage NTSB CHI80FEI06Accident · Minor injuriesClosedCessna 205 · Mansfield, OHNov 6, 1979 · N8173Z · Substantial damage NTSB CHI80FEK04Accident · No injuriesClosedCessna 172N · Zanesville, OHOct 29, 1979 · N1956F · Substantial damage NTSB CHI80FEK03Accident · No injuriesClosedPiper PA-38 · Marion, OHOct 29, 1979 · N9281T · Substantial damage NTSB CHI80FEI05Accident · No injuriesClosedCessna 152 · Carrollton, OHOct 27, 1979 · N49410 · Substantial damage NTSB CHI80DEG02Accident · No injuriesClosedBellanca 7ECA · Dayton, OHOct 22, 1979 · N53969 · Substantial damage NTSB CHI80FEI03Accident · Minor injuriesClosedPiper PA-28 · Mantua, OHOct 21, 1979 · N5351W · Substantial damage NTSB CHI80FEI04Accident · No injuriesClosedCessna 172 · Warren, OHOct 20, 1979 · N2442L · Substantial damage NTSB CHI80FA005Accident · 1 fatalClosedCessna 150 · Albany, OHOct 17, 1979 · N1800D · 2 aircraft · Destroyed NTSB CHI80DEG01Accident · No injuriesClosedMitsubishi MU-2B · Piqua, OHOct 17, 1979 · N855Q · Substantial damage NTSB CHI80FEI02Accident · Minor injuriesClosedWalton JD1 · Salem, OHOct 14, 1979 · N7WW · Substantial damage NTSB CHI80FEI01Accident · Minor injuriesClosedMooney M20F · Magnolia, OHOct 7, 1979 · N6449Q · Destroyed NTSB CHI80FEK02Accident · No injuriesClosedGrum-Amer AA1-B · Fredericktown, OHOct 5, 1979 · N1650R · Substantial damage NTSB CHI80FEK01Accident · No injuriesClosedAero Comdr 690 · Columbus, OHOct 1, 1979 · N57233 · Destroyed NTSB CHI79FA083Accident · 4 fatalClosedGrum Amer AA-5A · Urbana, OHSep 28, 1979 · N26755 · Destroyed NTSB CHI79FEK24Accident · No injuriesClosedHughes 269B · New Knoxville, OHSep 27, 1979 · N62402 · Substantial damage NTSB CHI79FEI44Accident · No injuriesClosedPiper PA-31 · Sandusky, OHSep 13, 1979 · N930JM · Substantial damage NTSB CHI79FEI45Accident · No injuriesClosedPiper PA-24 · Steubenville, OHSep 12, 1979 · N5349P · Substantial damage NTSB CHI79DA075Accident · 1 fatalClosedEnstrom F-28A · Kings Mills, OHSep 12, 1979 · N244Q · Destroyed NTSB CHI79FEG25Accident · Serious injuriesClosedBeech A36 · Cincinnati, OHSep 10, 1979 · N936V · Substantial damage NTSB CHI79FEI43Accident · No injuriesClosedCessna 150 · Richmond Hts, OHSep 9, 1979 · N9200U · Substantial damage NTSB CHI79FEK23Accident · No injuriesClosedPiper PA-38 · Chesterville, OHSep 7, 1979 · N2457G · Substantial damage NTSB CHI79FEI41Accident · 1 fatalClosedOsprey 2 · Medina, OHSep 6, 1979 · N96JR · Destroyed NTSB CHI79IA073Incident · No injuriesClosedCessna 206 · Van Wert, OHSep 5, 1979 · N756DF · No damage NTSB CHI79FEI42Accident · Serious injuriesClosedAvion Falcn 2 · Barberton, OHSep 4, 1979 · N63AV · Substantial damage NTSB CHI79DEG24Accident · No injuriesClosedCessna 152 · Camden, OHAug 27, 1979 · N46758 · Substantial damage NTSB CHI79DA066Accident · 1 fatalClosedPiper PA-31 · Bluffton, OHAug 23, 1979 · N27715 · Destroyed NTSB CHI79FEK21Accident · Minor injuriesClosedCessna 120 · Fredericktown, OHAug 17, 1979 · N1891N · Substantial damage NTSB CHI79FEI40Accident · Serious injuriesClosedGeronimo PA-23 · Middlefield, OHAug 16, 1979 · N2292P · Destroyed NTSB CHI79DEG23Accident · Minor injuriesClosedCessna 172 · Troy, OHAug 15, 1979 · N7149G · Substantial damage NTSB CHI79FEK20Accident · No injuriesClosedCessna 150L · Columbus, OHAug 13, 1979 · N5488Q · Substantial damage NTSB CHI79FEI39Accident · Minor injuriesClosedPiper PA-32 · Port Clinton, OHAug 10, 1979 · N4016W · Substantial damage NTSB CHI79DEI38Accident · No injuriesClosedCessna 177 · Sandusky, OHAug 7, 1979 · N30409 · Substantial damage NTSB CHI79FEK19Accident · Serious injuriesClosedPiper PA-28 · Danville, OHAug 5, 1979 · N75132 · Substantial damage NTSB CHI79FEI37Accident · No injuriesClosedPiper PA-22 · Kirby, OHAug 5, 1979 · N7351D · Substantial damage NTSB CHI79DEI36Accident · No injuriesClosedPiper PA-28 · Painesville, OHAug 4, 1979 · N2925Q · Substantial damage NTSB CHI79FA064Accident · 1 fatalField investigationClosedCessna 501 · Canton, OHthe pilot's failure to recognize the need for, and to take action to maintain, sufficient airspeed to prevent a stall into the ground during an attempted landing. The pilot also failed to recognize the need for timely and sufficient power application to…Aug 2, 1979 · N15NY · Destroyed NTSB CHI79FEG21Accident · Serious injuriesClosedSikorsky S-55C · Chillicothe, OHJul 30, 1979 · N509Y · Destroyed