Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 CHI72DEI26Accident · No injuriesClosedBellanca 14-193 · Painesville, OHDec 29, 1971 · N6553N · Substantial damage NTSB CHI72AC053Accident · 2 fatalClosedPiper PA-30 · Bowlng Green, OHDec 18, 1971 · N8083Y · Destroyed NTSB CHI72DEI25Accident · No injuriesClosedCessna 206 · Cleveland, OHDec 15, 1971 · N8755Z · Substantial damage NTSB CHI72FEG26Accident · No injuriesClosedBeech A23A · Harrison, OHDec 11, 1971 · N3602Q · Substantial damage NTSB CHI72FEG25Accident · No injuriesClosedPiper PA-22 · S Lebanon, OHDec 11, 1971 · N1773P · Substantial damage NTSB CHI72DEI24Accident · No injuriesClosedCessna 172H · Painesville, OHDec 9, 1971 · N2872L · Substantial damage NTSB CHI72AC049Accident · 2 fatalClosedCessna 175A · New Lebanon, OHDec 7, 1971 · N6820E · Destroyed NTSB CHI72DEI22Accident · No injuriesClosedCessna 150 · Chagrin Fals, OHDec 4, 1971 · N6967S · Substantial damage NTSB CHI72FEG24Accident · No injuriesClosedPiper PA-23 · Lebanon, OHNov 26, 1971 · N4175P · Substantial damage NTSB CHI72FEK07Accident · No injuriesClosedPiper PA-28R · Columbus, OHNov 25, 1971 · N7441J · Substantial damage NTSB CHI72FEI23Accident · No injuriesClosedHelio Acft H-295 · Medina, OHNov 24, 1971 · N6469V · Substantial damage NTSB CHI72FEK09Accident · No injuriesClosedCessna 150F · Zanesville, OHNov 23, 1971 · N6561F · Substantial damage NTSB CHI72FEK08Accident · No injuriesClosedCessna 172A · Columbus, OHNov 18, 1971 · N7841T · Substantial damage NTSB CHI72DEI21Accident · No injuriesClosedCessna 150 · Fremont, OHNov 18, 1971 · N6457S · Substantial damage NTSB CHI72AC046Accident · 4 fatalClosedCessna 320E · No.Madison, OHNov 18, 1971 · N3414Q · Destroyed NTSB CHI72DEG23Accident · No injuriesClosedBeech A24R · Jamestown, OHNov 12, 1971 · N104GD · Substantial damage NTSB CHI72FEG22Accident · No injuriesClosedPiper PA-23 · Miamisburg, OHNov 5, 1971 · N3129P · Substantial damage NTSB CHI72AC042Accident · No injuriesClosedBeech 99 · Cleveland, OHNov 3, 1971 · N1031S · Substantial damage NTSB CHI72IC041Incident · No injuriesClosedTed Smith 601 · Cleveland, OHNov 2, 1971 · N711ED · Minor damage NTSB CHI72AC040Accident · 2 fatalClosedCessna A150K · Franklin, OHOct 30, 1971 · N8425M · Destroyed NTSB CHI72AC039Accident · 4 fatalClosedCessna 320D · Orrville, OHOct 24, 1971 · N4149T · Destroyed NTSB CHI72FEG18Accident · No injuriesClosedPiper PA-24 · Piqua, OHOct 20, 1971 · N6920P · Substantial damage NTSB CHI72DEG21Accident · No injuriesClosedLuscombe 8A · Mcarthur, OHOct 20, 1971 · N1246B · Substantial damage NTSB CHI72AC038Accident · 1 fatalClosedCessna 150H · Aberdeen, OHOct 12, 1971 · N23477 · Destroyed NTSB CHI72FEG20Accident · No injuriesClosedAmer Avco AA1 · Cincinnati, OHOct 10, 1971 · N5728L · Substantial damage NTSB CHI72AC035Accident · 5 fatalClosedPiper PA-28 · Pemberton, OHOct 10, 1971 · N8833J · Destroyed NTSB CHI72DEI20Accident · No injuriesClosedBeech A23-19 · Northfield, OHOct 9, 1971 · N5989S · Substantial damage NTSB CHI72FEK06Accident · No injuriesClosedN.American AT-6D · Columbus, OHOct 8, 1971 · N7418C · Substantial damage NTSB CHI72FEG19Accident · Minor injuriesClosedTaylorcraft BC-65 · Troy, OHOct 3, 1971 · N24049 · Substantial damage NTSB CHI72DEI19Accident · Minor injuriesClosedCessna 120 · Milan, OHOct 3, 1971 · N77293 · Destroyed NTSB CHI72FEI18Accident · No injuriesClosedCessna 175A · Montville, OHSep 30, 1971 · N6890E · Substantial damage NTSB CHI72FEG17Accident · No injuriesClosedCessna 210 · Versailles, OHSep 27, 1971 · N6126R · Substantial damage NTSB CHI72FEK05Accident · No injuriesClosedCessna 150L · Athens, OHSep 25, 1971 · N1600U · Substantial damage NTSB CHI72FEG15Accident · Serious injuriesClosedStinson 10A · Phillipsburg, OHSep 19, 1971 · N34698 · Destroyed NTSB CHI72FEG16Accident · Minor injuriesClosedPiper PA-22 · Peebles, OHSep 15, 1971 · N7016D · Substantial damage NTSB CHI72DEG14Accident · No injuriesClosedChampion 7ECA · Dayton, OHSep 15, 1971 · N1839G · Substantial damage NTSB CHI72FEG13Accident · Minor injuriesClosedPiper PA-30 · Tipp City, OHSep 9, 1971 · N7714Y · Destroyed NTSB CHI72AC024Accident · 2 fatalClosedAmer Avco AA1A · Litchfield, OHSep 9, 1971 · N9258L · Destroyed NTSB CHI72FEK04Accident · Serious injuriesClosedNavion A · Coshocton, OHSep 8, 1971 · N4483K · Destroyed NTSB CHI72FEG12Accident · Minor injuriesClosedAmer Avco AA1-A · Manchester, OHSep 8, 1971 · N9361L · Substantial damage NTSB CHI72AC022Accident · 2 fatalClosedPiper PA-32 · Minford, OHSep 8, 1971 · N4026W · Destroyed NTSB CHI72FEK03Accident · No injuriesClosedCessna 180 · Paulding, OHSep 5, 1971 · N1684C · Substantial damage NTSB CHI72FEI16Accident · No injuriesClosedAmer Avco AA1A · Ashland, OHSep 4, 1971 · N9397L · Substantial damage NTSB CHI72FEG11Accident · No injuriesClosedChampion 7ECA · Dayton, OHSep 1, 1971 · N7515F · Substantial damage NTSB CHI72FEI14Accident · No injuriesClosedPiper PA-22 · Richmond Hts, OHAug 30, 1971 · N5986D · Substantial damage NTSB CHI72FEG10Accident · No injuriesClosedCessna 140 · Greenville, OHAug 30, 1971 · N89163 · Substantial damage NTSB CHI72FEI11Accident · Minor injuriesClosedCessna 150K · Lorain, OHAug 29, 1971 · N6182G · Substantial damage NTSB CHI72FEG09Accident · No injuriesClosedPazmany PL-1 · Hillsboro, OHAug 29, 1971 · N60SP · Substantial damage NTSB CHI72AC016Accident · 1 fatalClosedVolpar 8T · Fairview Prk, OHAug 27, 1971 · N351V · Destroyed NTSB CHI72FEG08Accident · Minor injuriesClosedAeronca 7AC · Martinsville, OHAug 25, 1971 · N85598 · Substantial damage