Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 CHI70F0386Accident · Serious injuriesClosedPiper PA-28 · Pleasnt Hill, OHDec 30, 1969 · N95194 · Substantial damage NTSB CHI70I0042Incident · No injuriesClosedDehavilland DH114 · Cleveland, OHDec 28, 1969 · N506FW · Minor damage NTSB CHI70D0398Accident · No injuriesClosedCessna 150 · Painesville, OHDec 28, 1969 · N3875J · Substantial damage NTSB CHI70D0376Accident · No injuriesClosedCessna 310K · Miamisburg, OHDec 26, 1969 · N3821X · Substantial damage NTSB CHI70AC040Accident · 5 fatalClosedCessna 401 · Piketon, OHDec 17, 1969 · N8167F · Destroyed NTSB CHI70D0399Accident · Serious injuriesClosedCessna 172 · Wadsworth, OHDec 13, 1969 · N46727 · Substantial damage NTSB CHI70F0356Accident · No injuriesClosedPiper PA-28 · Vandalia, OHDec 6, 1969 · N98017 · Substantial damage NTSB CHI70A0036Accident · 2 fatalClosedCessna 182L · Chardon, OHNov 23, 1969 · N42037 · Destroyed NTSB CHI70F0325Accident · No injuriesClosedAeronca 7AC · Circleville, OHNov 17, 1969 · N85099 · Substantial damage NTSB CHI70F0396Accident · Serious injuriesClosedCessna 172F · Strongsville, OHNov 16, 1969 · N5311R · Substantial damage NTSB CHI70F0345Accident · No injuriesClosedPiper PA-22 · Phillipsburg, OHNov 16, 1969 · N3619P · Substantial damage NTSB CHI70F0380Accident · Serious injuriesClosedCessna 172 · Brookpark, OHNov 14, 1969 · N3688S · Destroyed NTSB CHI70A0033Accident · 2 fatalClosedPiper PA-28 · Blacklick, OHNov 13, 1969 · N12JE · Destroyed NTSB CHI70F0379Accident · No injuriesClosedScheutzow B · Columbia Sta, OHNov 4, 1969 · N592A · Substantial damage NTSB CHI70F0304Accident · Serious injuriesClosedBeech 95-A55 · Grove City, OHOct 19, 1969 · N36900 · Destroyed NTSB CHI70D0382Accident · No injuriesClosedCessna 150 · Salem, OHOct 18, 1969 · N3683S · Substantial damage NTSB CHI70D0275Accident · No injuriesClosedPiper PA-28 · Somerset, OHOct 15, 1969 · N4995Z · Substantial damage NTSB CHI70F0295Accident · Serious injuriesClosedErco 415C · Germantown, OHOct 12, 1969 · N99522 · Substantial damage NTSB CHI70F0280Accident · No injuriesClosedPiper PA-28 · West Milton, OHOct 12, 1969 · N4715L · Substantial damage NTSB CHI70D0381Accident · No injuriesClosedPiper PA-24 · Cleveland, OHOct 6, 1969 · N6104P · Substantial damage NTSB CHI70F0285Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHSep 28, 1969 · N6782J · Substantial damage NTSB CHI70F0264Accident · No injuriesClosedBell 47G-2 · Gallipolis, OHSep 22, 1969 · N6776D · Destroyed NTSB CHI70F0260Accident · No injuriesClosedLuscombe 8A · Columbus, OHSep 19, 1969 · N71492 · Substantial damage NTSB CHI70D0371Accident · No injuriesClosedPiper PA-28 · Lodi, OHSep 19, 1969 · N1741J · Substantial damage NTSB CHI70D0311Accident · No injuriesClosedPiper PA-24 · Port Clinton, OHSep 18, 1969 · N9211P · Substantial damage NTSB CHI70F0384Accident · Minor injuriesClosedWaco AVN-8 · Ravenna, OHSep 14, 1969 · N231E · Substantial damage NTSB CHI70F0248Accident · No injuriesClosedCessna 140 · Columbus, OHSep 14, 1969 · N4255N · Substantial damage NTSB CHI70F0209Accident · No injuriesClosedPiper PA-24 · Middletown, OHSep 12, 1969 · N6895P · Substantial damage NTSB CHI70D0368Accident · No injuriesClosedCessna 172 · Canton, OHSep 10, 1969 · N5741T · Substantial damage NTSB CHI70D0388Accident · Minor injuriesClosedCessna 177 · N.Phldelphia, OHSep 7, 1969 · N2969X · Substantial damage NTSB CHI70F0225Accident · No injuriesClosedCessna 320C · Mc Clure, OHSep 6, 1969 · N3030T · Substantial damage NTSB CHI70DGG09Accident · No injuriesClosedPiper PA-24 · Columbus, OHSep 5, 1969 · N6026P · Substantial damage NTSB CHI70D0367Accident · No injuriesClosedPiper PA-28 · Akron, OHSep 4, 1969 · N7825N · Substantial damage NTSB CHI70F0228Accident · Serious injuriesClosedPiper PA-16 · Sidney, OHSep 1, 1969 · N6868K · Destroyed NTSB CHI70F0203Accident · No injuriesClosedCessna 182 · Ada, OHAug 30, 1969 · N5770B · Substantial damage NTSB CHI70D0233Accident · Minor injuriesClosedCessna 172G · Coshocton, OHAug 30, 1969 · N3883L · Substantial damage NTSB CHI70A0014Accident · 2 fatalClosedGlobe GC-1B · Boardman, OHAug 26, 1969 · N90344 · Destroyed NTSB CHI70F0195Accident · No injuriesClosedPiper PA-22 · Dayton, OHAug 25, 1969 · N7529D · Substantial damage NTSB CHI70D0320Accident · No injuriesClosedChampion 7ECA · Millersburg, OHAug 25, 1969 · N8326V · Substantial damage NTSB CHI70F0312Accident · Serious injuriesClosedBeech D35 · Geneva, OHAug 24, 1969 · N4249B · Destroyed NTSB CHI70D0372Accident · No injuriesClosedCessna 172B · Kirby, OHAug 22, 1969 · N1976C · Substantial damage NTSB CHI70F0255Accident · Minor injuriesClosedPiper PA-28 · Atwater, OHAug 14, 1969 · N1819J · Substantial damage NTSB CHI70D0308Accident · No injuriesClosedCessna 120 · Huron, OHAug 14, 1969 · N77273 · Substantial damage NTSB CHI70F0164Accident · Serious injuriesClosedBeech 95-55 · Waverly, OHAug 13, 1969 · N525S · Destroyed NTSB CHI70F0218Accident · No injuriesClosedPiper PA-24 · Valley City, OHAug 12, 1969 · N7119P · Substantial damage NTSB CHI70F0187Accident · No injuriesClosedBeech 95-B55 · Columbus, OHAug 12, 1969 · N914C · Substantial damage NTSB CHI70D0226Accident · Minor injuriesClosedPiper PA-28 · Columbia Sta, OHAug 3, 1969 · N1842J · Substantial damage NTSB CHI70D0096Accident · No injuriesClosedPiper PA-12 · N Lexington, OHJul 31, 1969 · N3382M · Substantial damage NTSB CHI70D0145Accident · No injuriesClosedCessna 120 · Columbia Sta, OHJul 30, 1969 · N2125V · Substantial damage NTSB CHI70A0011Accident · 2 fatalClosedCessna 177 · Northfield, OHJul 27, 1969 · N29555 · Destroyed