Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 CHI73FEG14Accident · Serious injuriesClosedCessna 195A · Tipp City, OHDec 26, 1972 · N3466V · Substantial damage NTSB CHI73FEK13Accident · Serious injuriesClosedCessna 150G · Coldwater, OHDec 22, 1972 · N2741S · Destroyed NTSB CHI73FEK12Accident · No injuriesClosedPiper PA-30 · St Clairsvle, OHDec 18, 1972 · N7495Y · Substantial damage NTSB CHI73FEG13Accident · No injuriesClosedCessna 172I · W Carrollton, OHDec 18, 1972 · N35456 · Substantial damage NTSB CHI73AC057Accident · Minor injuriesClosedHawker-Sdly DH125 · Findlay, OHDec 12, 1972 · N521M · Destroyed NTSB CHI73AC056Accident · No injuriesClosedHamilton TC-45J · Cleveland, OHDec 12, 1972 · N10AS · Substantial damage NTSB CHI73FEI22Accident · No injuriesClosedBeech C23 · Cleveland, OHDec 3, 1972 · N7675R · Substantial damage NTSB CHI73FEG12Accident · Serious injuriesClosedAmer Avco AA1A · Dayton, OHDec 2, 1972 · N9278L · Destroyed NTSB CHI73DEK11Accident · No injuriesClosedPiper PA-24 · Bryan, OHDec 2, 1972 · N6143P · Substantial damage NTSB CHI73FEI20Accident · No injuriesClosedCessna 150E · Wadsworth, OHNov 29, 1972 · N4045U · Destroyed NTSB CHI73FEI21Accident · No injuriesClosedMooney M20-C · Strongsville, OHNov 22, 1972 · N7101U · Substantial damage NTSB CHI73FEK10Accident · No injuriesClosedBell 47G-2 · Zanesville, OHNov 6, 1972 · N15952 · Destroyed NTSB CHI73DEG11Accident · No injuriesClosedCessna 150G · Oxford, OHNov 6, 1972 · N2682J · Substantial damage NTSB CHI73FEK09Accident · No injuriesClosedCessna 310C · Colombus, OHOct 27, 1972 · N1773H · Substantial damage NTSB CHI73FEG10Accident · No injuriesClosedPiper PA-32 · Blue Creek, OHOct 27, 1972 · N3821W · Substantial damage NTSB CHI73AC044Accident · 2 fatalClosedCessna 150L · Lodi, OHOct 27, 1972 · N5280Q · Destroyed NTSB CHI73FEG09Accident · Serious injuriesClosedCessna 172 · Montgomery, OHOct 25, 1972 · N4123F · Destroyed NTSB CHI73AC042Accident · 1 fatalClosedCessna 140 · Gilmore, OHOct 18, 1972 · N89593 · Destroyed NTSB CHI73FEI16Accident · No injuriesClosedStinson 108-3 · Elyria, OHOct 13, 1972 · N547C · Substantial damage NTSB CHI73DEI17Accident · No injuriesClosedCessna 150G · Minerva, OHOct 9, 1972 · N2217J · Substantial damage NTSB CHI73FEI19Accident · No injuriesClosedCessna 310K · Cleveland, OHOct 8, 1972 · N6929L · Substantial damage NTSB CHI73FEI15Accident · No injuriesClosedCessna 172 · Medina, OHOct 8, 1972 · N7805G · Substantial damage NTSB CHI73FEK08Accident · No injuriesClosedHughes 269C · Grove City, OHOct 3, 1972 · N9604F · Destroyed NTSB CHI73FEK07Accident · No injuriesClosedBell 47G-4 · Cambridge, OHOct 2, 1972 · N73979 · Substantial damage NTSB CHI73DEG08Accident · Minor injuriesClosedPiper PA-22 · Mt Sterling, OHOct 1, 1972 · N1715P · Substantial damage NTSB CHI73AC035Accident · No injuriesClosedCurtis-Wrt C-46 · Toledo, OHOct 1, 1972 · N606SE · Substantial damage NTSB CHI73FEI12Accident · Serious injuriesClosedCessna 182H · Carrollton, OHSep 22, 1972 · N156GR · Destroyed NTSB CHI73FEG06Accident · No injuriesClosedPiper PA-30 · Blue Ash, OHSep 21, 1972 · N126PF · Substantial damage NTSB CHI73FEK06Accident · No injuriesClosedPiper PA-28 · Gahanna, OHSep 20, 1972 · N95111 · Substantial damage NTSB CHI73DEI18Accident · No injuriesClosedCessna 172 · Millersburg, OHSep 19, 1972 · N7107A · Substantial damage NTSB CHI73FEG07Accident · No injuriesClosedCessna 305A · Chesapeake, OHSep 18, 1972 · N5253G · Substantial damage NTSB CHI73DEG05Accident · No injuriesClosedPiper PA-28 · Proctorville, OHSep 17, 1972 · N1828T · Substantial damage NTSB CHI73IC022Incident · Minor injuriesClosedBoeing 707 · Dayton, OHSep 13, 1972 · N7526A · Minor damage NTSB CHI73FEI13Accident · Minor injuriesClosedCessna 182A · Cleveland, OHSep 10, 1972 · N6049B · Destroyed NTSB CHI73FEI11Accident · No injuriesClosedCessna 210 · New Phil, OHSep 10, 1972 · N2349F · Substantial damage NTSB CHI73AC030Accident · No injuriesClosedBeech C-45H · Prt Columbus, OHSep 7, 1972 · N9909Z · Substantial damage NTSB CHI73AC029Accident · 2 fatalClosedCessna 150 · Geneva, OHSep 3, 1972 · N5698E · Destroyed NTSB CHI73DEI14Accident · No injuriesClosedBell 47G · Oregon, OHAug 27, 1972 · N7895B · Substantial damage NTSB CHI73DEI10Accident · No injuriesClosedCessna 177 · Strongsville, OHAug 26, 1972 · N2291Y · Substantial damage NTSB CHI73DEG04Accident · No injuriesClosedPiper PA-28 · West Union, OHAug 24, 1972 · N481P · Substantial damage NTSB CHI73DEK05Accident · No injuriesClosedCessna 150G · Zanesville, OHAug 22, 1972 · N4740X · Substantial damage NTSB CHI73FEI04Accident · 1 fatalClosedCessna 172G · Northfield, OHAug 21, 1972 · N6093R · Destroyed NTSB CHI73AC021Accident · Serious injuriesClosedFord MTR 4-AT-B · Port Clinton, OHAug 21, 1972 · N7684 · Destroyed NTSB CHI73FEI07Accident · Minor injuriesClosedPiper PA-32 · Northfield, OHAug 20, 1972 · N4367T · Substantial damage NTSB CHI73AC020Accident · 2 fatalClosedPiper PA-24 · Ada, OHAug 20, 1972 · N8449P · Destroyed NTSB CHI73FEI05Accident · Minor injuriesClosedMitsubishi MU-2B · Cleveland, OHAug 15, 1972 · N143MA · Substantial damage NTSB CHI73FEK04Accident · No injuriesClosedLuscombe 8A · West Liberty, OHAug 10, 1972 · N28564 · Substantial damage NTSB CHI73DEI06Accident · No injuriesClosedBeech B23-19 · Swanton, OHAug 10, 1972 · N6536T · Substantial damage NTSB CHI73AC014Accident · No injuriesClosedAero Comdr 680-E · Cambridge, OHAug 9, 1972 · N848E · Substantial damage NTSB CHI73FEG03Accident · No injuriesClosedChampion 7GCAA · Lebanon, OHAug 5, 1972 · N2541F · Substantial damage