Skip to content

NTSB investigations, 1967, IN

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 CHI68F0519Accident · Minor injuriesClosedCessna 182 · Greencastle, INDec 27, 1967 · N5081D · Destroyed NTSB CHI68A0056Accident · 3 fatalClosedMooney M20F · Knox, INDec 22, 1967 · N2779W · Destroyed NTSB CHI68D0510Accident · No injuriesClosedCessna 172 · Greenwood, INDec 20, 1967 · N4033F · Substantial damage NTSB CHI68D0521Accident · No injuriesClosedLuscombe 8E · Richmond, INDec 19, 1967 · N2632K · Substantial damage NTSB CHI68A0052Accident · 2 fatalClosedHughes 269B · Evansville, INDec 9, 1967 · N9454F · Destroyed NTSB CHI68F0493Accident · No injuriesClosedBeech M35 · Pierceton, INDec 4, 1967 · N9329Y · Destroyed NTSB CHI68D0474Accident · No injuriesClosedCessna 150E · Indianapolis, INNov 28, 1967 · N4063U · No damage NTSB CHI68F0438Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNov 23, 1967 · N9600D · Substantial damage NTSB CHI68I0454Accident · No injuriesClosedBeech 35 · Griffith, INNov 14, 1967 · N4555V · Substantial damage NTSB CHI67F0460Accident · No injuriesClosedAero Comdr 500 · Ft Wayne, INNov 8, 1967 · N135M · Substantial damage NTSB CHI68A0044Accident · 1 fatalClosedPiper PA-25 · Sullivan, INNov 7, 1967 · N9100D · Destroyed NTSB CHI68F0430Accident · No injuriesClosedCessna 320E · Valparaiso, INNov 4, 1967 · N3430Q · Substantial damage NTSB CHI68A0042Accident · 3 fatalClosedBrantly 305 · Taswell, INNov 3, 1967 · N2208U · Destroyed NTSB CHI68D0399Accident · No injuriesClosedPiper PA-22 · English, INOct 30, 1967 · N5797Z · Destroyed NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB CHI68F0426Accident · No injuriesClosedBeech G35 · Indianapolis, INOct 21, 1967 · N4222D · Substantial damage NTSB CHI68F0441Accident · Minor injuriesClosedCessna 337 · South Bend, INOct 18, 1967 · N6324F · Substantial damage NTSB CHI68F0425Accident · No injuriesClosedCessna 172 · Salem, INOct 14, 1967 · N4140F · Substantial damage NTSB CHI68F0394Accident · No injuriesClosedCessna 310 · South Bend, INOct 14, 1967 · N6777T · Substantial damage NTSB CHI68D0407Accident · No injuriesClosedCessna 182 · South Bend, INOct 14, 1967 · N3079Q · Substantial damage NTSB CHI68F0350Accident · No injuriesClosedBeech A23 · Woodburn, INOct 8, 1967 · N1423L · Substantial damage NTSB CHI68F0429Accident · No injuriesClosedCessna 210 · Indianapolis, INOct 5, 1967 · N9590X · Substantial damage NTSB CHI68F0395Accident · No injuriesClosedPiper PA-28 · Knox, INOct 2, 1967 · N7946W · Substantial damage NTSB CHI68D0382Accident · No injuriesClosedNavion F · Hartford City, INOct 1, 1967 · N238 · Substantial damage NTSB CHI68D0365Accident · No injuriesClosedPiper PA-28 · Muncie, INOct 1, 1967 · N9770W · Substantial damage NTSB CHI68D0349Accident · No injuriesClosedPiper PA-16 · Noblesville, INOct 1, 1967 · N5224H · Substantial damage NTSB CHI68F0378Accident · No injuriesClosedNavion F · Crawfordsvlle, INSep 30, 1967 · N91774 · Substantial damage NTSB CHI68D0405Accident · No injuriesClosedStinson V-77 · Lebanon, INSep 30, 1967 · N69874 · Substantial damage NTSB CHI68A0032Accident · No injuriesClosedCessna 310L · Plymouth, INSep 27, 1967 · N3282X · Substantial damage NTSB CHI68F0338Accident · No injuriesClosedCessna 150 · Fort Wayne, INSep 25, 1967 · N8394G · Substantial damage NTSB CHI68F0578Accident · No injuriesClosedGlobe Swift GC-1B · W Lafayette, INSep 24, 1967 · N80792 · Substantial damage NTSB CHI68F0328Accident · No injuriesClosedPiper PA-22 · Wabash, INSep 24, 1967 · N6999B · Substantial damage NTSB CHI68F0337Accident · No injuriesClosedLuscombe 8A · Muncie, INSep 23, 1967 · N2136K · Substantial damage NTSB CHI68D0485Accident · No injuriesClosedPiper PA-22 · Greenwood, INSep 23, 1967 · N3656P · Substantial damage NTSB CHI68D0359Accident · No injuriesClosedBeech 95 · Clermont, INSep 23, 1967 · N659T · Substantial damage NTSB CHI68F0304Accident · No injuriesClosedCessna 320E · Indianapolis, INSep 17, 1967 · N394AJ · Substantial damage NTSB CHI68F0428Accident · No injuriesClosedCessna 210 · Evansville, INSep 16, 1967 · N9658T · Substantial damage NTSB CHI68F0352Accident · Minor injuriesClosedPiper PA-22 · Jamestown, INSep 10, 1967 · N8711D · Substantial damage NTSB CHI68F0336Accident · Serious injuriesClosedPiper PA-22 · Greenfield, INSep 10, 1967 · N3740P · 2 aircraft · Substantial damage NTSB CHI68A0024Accident · 2 fatalClosedPiper PA-30 · Crawfordsvle, INSep 6, 1967 · N8411Y · Destroyed NTSB CHI68D0250Accident · No injuriesClosedLuscombe 8A · Richmond, INSep 5, 1967 · N77841 · Substantial damage NTSB CHI68F0308Accident · No injuriesClosedTaylorcraft BC12-D · Chesterton, INSep 3, 1967 · N36047 · Substantial damage NTSB CHI68D0348Accident · No injuriesClosedCessna 140 · Brownsburg, INSep 3, 1967 · N2848N · Substantial damage NTSB CHI68F0229Accident · No injuriesClosedN.American P-51D · Auburn, INSep 2, 1967 · N6836C · Substantial damage NTSB CHI68D0281Accident · Minor injuriesClosedCessna 205 · Princeton, INAug 26, 1967 · N8150Z · Substantial damage NTSB CHI68F0300Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INAug 23, 1967 · N8247W · Substantial damage NTSB CHI68F0182Accident · No injuriesClosedBeech A35 · Mishawaka, INAug 17, 1967 · N8643A · Substantial damage NTSB CHI68F0157Accident · No injuriesClosedCessna 172C · Greenwood, INAug 13, 1967 · N1642Y · Substantial damage NTSB CHI68F0231Accident · No injuriesClosedPiper PA-28 · Muncie, INAug 12, 1967 · N9770W · Substantial damage NTSB CHI68D0232Accident · Minor injuriesClosedCessna 210 · Greencastle, INAug 12, 1967 · N9490T · Substantial damage