Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 CHI71FGD33Accident · Minor injuriesClosedCessna 150H · Akron, OHDec 29, 1970 · N6493S · Substantial damage NTSB CHI71FGD31Accident · No injuriesClosedBellanca 17-31 · Richmond Hts, OHDec 21, 1970 · N6595V · Substantial damage NTSB CHI71FGA15Accident · Minor injuriesClosedCessna 150 · Xenia, OHDec 15, 1970 · N22818 · Destroyed NTSB CHI71DGD36Accident · No injuriesClosedBeech C-23 · Orwell, OHDec 5, 1970 · N7696R · Substantial damage NTSB CHI71DGD29Accident · No injuriesClosedCessna 172 · Toledo, OHDec 5, 1970 · N35300 · Substantial damage NTSB CHI71FGA14Accident · No injuriesClosedCessna 150 · Washingtn, OHDec 3, 1970 · N23218 · Substantial damage NTSB CHI71DGD38Accident · No injuriesClosedCessna 182C · Willard, OHDec 3, 1970 · N8609T · Substantial damage NTSB CHI71FGA13Accident · No injuriesClosedCessna 310Q · Cincinnati, OHDec 2, 1970 · N7546Q · Substantial damage NTSB CHI71AC036Accident · 4 fatalClosedBeech B95A · Bergholz, OHNov 29, 1970 · N1552Z · Destroyed NTSB CHI71FGG21Accident · No injuriesClosedMooney M20C · Van Wert, OHNov 26, 1970 · N5547Q · Substantial damage NTSB CHI71FGG20Accident · No injuriesClosedBeech A23A · Hicksville, OHNov 25, 1970 · N4760J · Substantial damage NTSB CHI71FGA12Accident · No injuriesClosedChampion 7ECA · Dayton, OHNov 18, 1970 · N522JE · Substantial damage NTSB CHI71FGG19Accident · No injuriesClosedChampion 7GCB · Urbana, OHNov 1, 1970 · N9911Y · Substantial damage NTSB CHI71DGD26Accident · No injuriesClosedBrantly B2 · Akron, OHNov 1, 1970 · N2127U · Substantial damage NTSB CHI71DGD24Accident · No injuriesClosedLake LA-4 · Sandusky, OHNov 1, 1970 · N1130L · Substantial damage NTSB CHI71DGA11Accident · Serious injuriesClosedBeech 35 · Harrison, OHOct 25, 1970 · N3317V · No damage NTSB CHI71DGD25Accident · No injuriesClosedCessna 150 · Ravenna, OHOct 23, 1970 · N51247 · Substantial damage NTSB CHI71DGD27Accident · No injuriesClosedPiper PA-28 · Shelby, OHOct 19, 1970 · N8182N · Substantial damage NTSB CHI71FGG18Accident · No injuriesClosedBeech G35 · Bluffton, OHOct 18, 1970 · N187B · Substantial damage NTSB CHI71FGG17Accident · No injuriesClosedNavion NAV4 · Findlay, OHOct 18, 1970 · N8569H · Substantial damage NTSB CHI71FGG16Accident · Minor injuriesClosedStinson 108 · Nelsonville, OHOct 18, 1970 · N97212 · Substantial damage NTSB CHI71FGD22Accident · Serious injuriesClosedMitsubishi MU-2B · Northfield, OHOct 13, 1970 · N549LK · Destroyed NTSB CHI71FGG15Accident · No injuriesClosedPiper PA-28 · Columbus, OHOct 4, 1970 · N8731N · Substantial damage NTSB CHI71DGD23Accident · Minor injuriesClosedAeronca L-3B · Toledo, OHSep 30, 1970 · N47189 · Substantial damage NTSB CHI71FGG14Accident · No injuriesClosedGlobe GC-1B · Lima, OHSep 27, 1970 · N3760K · Substantial damage NTSB CHI71FGA09Accident · No injuriesClosedCessna 172I · Harrison, OHSep 20, 1970 · N35802 · Substantial damage NTSB CHI71DGD20Accident · No injuriesClosedLuscombe 8C · Fremont, OHSep 20, 1970 · N28619 · Substantial damage NTSB CHI71FGD15Accident · Serious injuriesClosedCessna 177 · Painesville, OHSep 19, 1970 · N2936E · Destroyed NTSB CHI71DGG12Accident · No injuriesClosedCessna 150K · Columbus, OHSep 14, 1970 · N5900G · Substantial damage NTSB CHI71FGA07Accident · No injuriesClosedBeech 35-C33 · Cincinnati, OHSep 12, 1970 · N7993M · Substantial damage NTSB CHI71DGA08Accident · No injuriesClosedPiper PA-23 · Friendship, OHSep 12, 1970 · N6827Y · Substantial damage NTSB CHI71FGD16Accident · Minor injuriesClosedPiper PA-28 · Willoughby, OHSep 7, 1970 · N5032W · Destroyed NTSB CHI71DGG11Accident · No injuriesClosedPiper PA-28 · Columbus Grv, OHSep 6, 1970 · N8542W · Substantial damage NTSB CHI71FGG10Accident · No injuriesClosedErco 415-C · Findlay, OHSep 5, 1970 · N94002 · Substantial damage NTSB CHI71DGG13Accident · No injuriesClosedCessna 182 · St Clairsvle, OHSep 5, 1970 · N3482U · Substantial damage NTSB CHI71FGD14Accident · Minor injuriesClosedCessna 177 · Northfield, OHAug 30, 1970 · N30037 · Destroyed NTSB CHI71DGD13Accident · Minor injuriesClosedCessna 150 · Minerva, OHAug 29, 1970 · N3271J · Substantial damage NTSB CHI71FGG09Accident · Minor injuriesClosedNavion G · Coshocton, OHAug 22, 1970 · N2440T · Destroyed NTSB CHI71DGD10Accident · Minor injuriesClosedSnow 600S2D · Maumee, OHAug 20, 1970 · N1719S · Substantial damage NTSB CHI71DGD05Accident · No injuriesClosedN.American Navion · Cleveland, OHAug 18, 1970 · N91467 · Substantial damage NTSB CHI71AC014Accident · 2 fatalClosedAero Comdr 560F · Latham, OHAug 16, 1970 · N560F · Destroyed NTSB CHI71FGD12Accident · No injuriesClosedCessna 150 · Tiffin, OHAug 14, 1970 · N23301 · 2 aircraft · Minor damage NTSB CHI71DGD19Accident · Minor injuriesClosedCessna 185 · Bowlng Green, OHAug 13, 1970 · N9938B · Substantial damage NTSB CHI71FGG07Accident · No injuriesClosedPiper PA-32 · Findlay, OHAug 12, 1970 · N3325W · Substantial damage NTSB CHI71FGA05Accident · No injuriesClosedCessna 150 · Oxford, OHAug 6, 1970 · N22980 · Substantial damage NTSB CHI71AC011Accident · 1 fatalClosedCessna 172 · Wooster, OHAug 6, 1970 · N16HP · Destroyed NTSB CHI71FGD07Accident · Minor injuriesClosedPiper PA-28 · Bowlng Green, OHAug 3, 1970 · N1890J · Destroyed NTSB CHI71FGD18Accident · No injuriesClosedCessna 177A · Toledo, OHJul 31, 1970 · N30332 · Substantial damage NTSB CHI71DGD34Accident · No injuriesClosedPiper PA-28 · Shelby, OHJul 26, 1970 · N5293L · Substantial damage NTSB CHI71DGD09Accident · Serious injuriesClosedCessna 140 · Brecksville, OHJul 26, 1970 · N2107N · Substantial damage