Skip to content

NTSB investigations, 1969, IN

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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

19632026

NTSB investigations, 1969, IN per year, 1963–2026: 2,978 cases
1963	1
1964	107
1965	116
1966	119
1967	132
1968	106
1969	88
1970	83
1971	81
1972	88
1973	77
1974	66
1975	86
1976	78
1977	90
1978	95
1979	70
1980	76
1981	52
1982	55
1983	54
1984	55
1985	54
1986	58
1987	53
1988	66
1989	45
1990	42
1991	33
1992	29
1993	35
1994	38
1995	33
1996	31
1997	36
1998	35
1999	22
2000	34
2001	29
2002	25
2003	20
2004	26
2005	20
2006	28
2007	23
2008	22
2009	30
2010	27
2011	26
2012	26
2013	22
2014	16
2015	19
2016	23
2017	22
2018	19
2019	22
2020	17
2021	21
2022	21
2023	16
2024	17
2025	13
2026	9

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI70F0389Accident · Minor injuriesClosedBeech B50 · Terre Haute, INDec 30, 1969 · N3678B · Substantial damage NTSB CHI70D0394Accident · No injuriesClosedCessna 177 · Wakarusa, INDec 21, 1969 · N30578 · Substantial damage NTSB CHI70A0041Accident · 2 fatalClosedPiper PA-28 · Franklin, INDec 21, 1969 · N7738N · 2 aircraft · Substantial damage NTSB CHI70F0373Accident · No injuriesClosedCessna 310F · Evansville, INDec 16, 1969 · N5822X · Substantial damage NTSB CHI70F0362Accident · No injuriesClosedCessna 182M · New Albany, INDec 12, 1969 · N71886 · Substantial damage NTSB CHI70D0365Accident · No injuriesClosedCessna 150G · Logansport, INNov 7, 1969 · N3879J · Substantial damage NTSB CHI70D0302Accident · No injuriesClosedPiper PA-28 · Hartford City, INNov 6, 1969 · N8587W · Substantial damage NTSB CHI70F0313Accident · Minor injuriesClosedCessna U206 · Bloomington, INOct 31, 1969 · N3905G · Substantial damage NTSB CHI70F0324Accident · No injuriesClosedPiper PA-24 · Mccordsville, INOct 29, 1969 · N5302P · Substantial damage NTSB CHI70F0297Accident · No injuriesClosedPiper PA-28 · Rushville, INOct 26, 1969 · N5656U · Substantial damage NTSB CHI70F0337Accident · No injuriesClosedPiper PA-28 · Nappanee, INOct 19, 1969 · N7397J · Substantial damage NTSB CHI70D0303Accident · No injuriesClosedCessna 170 · Muncie, INOct 18, 1969 · N5459C · Substantial damage NTSB CHI70F0301Accident · No injuriesClosedPiper PA-24 · Indianapolis, INOct 10, 1969 · N8951P · Substantial damage NTSB CHI70A0020Accident · No injuriesClosedCessna U206 · Paoli, INOct 8, 1969 · N8030Z · Destroyed NTSB CHI70F0331Accident · Serious injuriesClosedPiper J3C-65 · Rising Sun, INSep 28, 1969 · N26833 · Destroyed NTSB CHI70F0249Accident · No injuriesClosedPiper PA-24 · Putnamville, INSep 27, 1969 · N7570P · Substantial damage NTSB CHI70D0250Accident · No injuriesClosedCessna 150 · Romney, INSep 21, 1969 · N8309G · Substantial damage NTSB CHI70F0261Accident · 1 fatalClosedSMJ Mavrick I · Mooresville, INSep 20, 1969 · N6417 · Destroyed NTSB CHI70D0289Accident · No injuriesClosedPiper PA-22 · Loogootee, INSep 14, 1969 · N3276Z · Substantial damage NTSB DCA70A0004Accident · 83 fatalClosedPiper PA-28 · Fairland, INSep 9, 1969 · N7374J · 2 aircraft · Destroyed NTSB CHI70F0197Accident · No injuriesClosedJeane Tenie · Lafayette, INSep 5, 1969 · N8513 · Substantial damage NTSB CHI70F0184Accident · No injuriesClosedBellanca 14-13 · Linton, INAug 30, 1969 · N86858 · Substantial damage NTSB CHI70F0175Accident · No injuriesClosedChampion 7ECA · Greenwood, INAug 29, 1969 · N8337V · Minor damage NTSB CHI70F0262Accident · 1 fatalClosedBarrett Cassut · Mccordsville, INAug 28, 1969 · N3431 · Destroyed NTSB CHI70F0159Accident · No injuriesClosedPiper PA-24 · Mt Vernon, INAug 20, 1969 · N5582P · Substantial damage NTSB CHI70D0231Accident · No injuriesClosedCessna 150F · Elkhart, INAug 16, 1969 · N6718F · Substantial damage NTSB CHI70F0148Accident · No injuriesClosedChampion 7ECA · Mooresville, INAug 14, 1969 · N5114X · Substantial damage NTSB CHI70F0168Accident · Minor injuriesClosedPiper PA-23 · Seymour, INAug 10, 1969 · N3267P · Destroyed NTSB CHI70D0154Accident · Minor injuriesClosedCessna 175 · Dillsboro, INAug 10, 1969 · N7342M · Substantial damage NTSB CHI70F0254Accident · Minor injuriesClosedCessna 172 · Hobart, INAug 3, 1969 · N6654A · Substantial damage NTSB CHI70D0150Accident · No injuriesClosedPiper PA-28R · Richmond, INAug 3, 1969 · N9967T · Substantial damage NTSB CHI70D0108Accident · No injuriesClosedPiper PA-23 · Brownsburg, INAug 2, 1969 · N2219P · Destroyed NTSB CHI70F0208Accident · 2 fatalClosedSport-Aire 11 · Glen Park, INJul 30, 1969 · CF-WQF · Destroyed NTSB CHI70A0010Accident · 2 fatalClosedChampion 7GCAA · Salem, INJul 26, 1969 · N9625S · Destroyed NTSB CHI70D0182Accident · No injuriesClosedGlobe GC-1B · Lafayette, INJul 21, 1969 · N80990 · Substantial damage NTSB CHI70D0198Accident · Minor injuriesClosedTaylorcraft BC1265 · Granger, INJul 16, 1969 · N29753 · Substantial damage NTSB CHI70D0117Accident · No injuriesClosedTaylorcraft BC12-D · Tell City, INJul 15, 1969 · N95026 · Substantial damage NTSB CHI70F0112Accident · No injuriesClosedCessna 140 · Breman, INJul 8, 1969 · N4209N · Substantial damage NTSB CHI70A0003Accident · No injuriesClosedPiper PA-32 · Madison, INJul 4, 1969 · N7704J · Substantial damage NTSB CHI70F0063Accident · No injuriesClosedNavion A · Hartford City, INJul 3, 1969 · N91512 · Substantial damage NTSB CHI70D0115Accident · No injuriesClosedCessna 150H · Marion, INJul 3, 1969 · N6427F · Substantial damage NTSB CHI70F0192Accident · Serious injuriesClosedCessna 150 · Plymouth, INJun 28, 1969 · N3451J · Destroyed NTSB CHI70D0123Accident · No injuriesClosedCallair A-9 · Hobart, INJun 28, 1969 · N3603G · Substantial damage NTSB CHI70F0058Accident · No injuriesClosedLuscombe 8E · Southport, INJun 17, 1969 · N39013 · Substantial damage NTSB CHI70F0069Accident · No injuriesClosedPlaymate II · Angola, INJun 12, 1969 · N1093Z · Substantial damage NTSB CHI70F0118Accident · Minor injuriesClosedPiper PA-30 · Gary, INJun 9, 1969 · N7492Y · Destroyed NTSB CHI70D0141Accident · No injuriesClosedPiper J-3 · Mentone, INJun 7, 1969 · N24643 · Substantial damage NTSB CHI70D0082Accident · No injuriesClosedPiper J-3 · Richmond, INMay 31, 1969 · N70430 · No damage NTSB CHI70D0044Accident · No injuriesClosedCessna 172H · Hobart, INMay 30, 1969 · N8260L · Substantial damage NTSB CHI70D0039Accident · No injuriesClosedCessna 182 · Lafayette, INMay 30, 1969 · N3143Q · Substantial damage