Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 CHI76FET25Accident · No injuriesClosedCessna 150M · Fort Wayne, INDec 24, 1975 · N45540 · Substantial damage NTSB CHI76FET24Accident · Serious injuriesClosedCessna 210B · Fort Wayne, INDec 24, 1975 · N9590X · Substantial damage NTSB CHI76DEA21Accident · No injuriesClosedPiper PA-28 · Zionsville, INDec 22, 1975 · N1334T · Substantial damage NTSB CHI76AC040Accident · 2 fatalClosedPiper PA-30 · Monrovia, INDec 20, 1975 · N7785Y · Destroyed NTSB CHI76FEA19Accident · Serious injuriesClosedCessna 170B · Lebanon, INDec 17, 1975 · N8198H · Substantial damage NTSB CHI76FEA20Accident · Serious injuriesClosedPiper PA-23 · Tennyson, INDec 16, 1975 · N4115P · Destroyed NTSB CHI76FEA16Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNov 28, 1975 · N4440A · Substantial damage NTSB CHI76AC036Accident · Minor injuriesClosedBeech E18S · Fort Wayne, INNov 24, 1975 · N14VH · Substantial damage NTSB CHI76FET21Accident · No injuriesClosedCessna 140 · Peru, INNov 23, 1975 · N2300N · Substantial damage NTSB CHI76FEA17Accident · No injuriesClosedCessna 172 · Carthage, INNov 23, 1975 · N8441U · Substantial damage NTSB CHI76DET22Accident · No injuriesClosedLake LA-4 · Angola, INNov 23, 1975 · N2036L · Substantial damage NTSB CHI76FET23Accident · No injuriesClosedBeech A36 · Valparaiso, INNov 21, 1975 · N36BP · Substantial damage NTSB CHI76FEA18Accident · No injuriesClosedCessna T337G · Bloomington, INNov 21, 1975 · N3CU · Substantial damage NTSB CHI76DEA15Accident · No injuriesClosedCessna 140 · Reynolds, INNov 15, 1975 · N4000N · Substantial damage NTSB CHI76AC035Accident · 2 fatalClosedCessna 210 · Lynnville, INNov 6, 1975 · N7422E · Destroyed NTSB CHI76FET20Accident · No injuriesClosedAero Comdr 500B · New Haven, INNov 2, 1975 · N6210X · Substantial damage NTSB MIA76FET19Accident · No injuriesClosedCessna 150 · Lake Village, INOct 30, 1975 · N45DB · Substantial damage NTSB CHI76FEA14Accident · No injuriesClosedMooney M20A · Tennyson, INOct 18, 1975 · N1086B · Substantial damage NTSB CHI76FEA13Accident · Serious injuriesClosedPiper PA-28 · Attica, INOct 17, 1975 · N7739W · Substantial damage NTSB CHI76DEA12Accident · No injuriesClosedPiper PA-28 · Versailles, INOct 11, 1975 · N5539U · Substantial damage NTSB CHI76DEA11Accident · Minor injuriesClosedStarduster S-A300 · Sheridan, INOct 11, 1975 · N9738 · Substantial damage NTSB CHI76FET18Accident · No injuriesClosedCessna 150L · Schneider, INOct 10, 1975 · N6818G · Substantial damage NTSB CHI76AC031Accident · Serious injuriesClosedGrum Amer AA1-B · Roachdale, INOct 9, 1975 · N9924L · Destroyed NTSB CHI76DET32Accident · No injuriesClosedPiper PA-18 · Valparaiso, INOct 4, 1975 · N269T · Substantial damage NTSB CHI76FET16Accident · No injuriesClosedGrum Amer AA5 · Roanoke, INOct 1, 1975 · N1334R · Substantial damage NTSB CHI76FEA08Accident · Minor injuriesClosedGrum Amer AA1B · Eden, INSep 27, 1975 · N8893L · Substantial damage NTSB CHI76DET15Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INSep 23, 1975 · N4782T · Substantial damage NTSB CHI76DEA09Accident · No injuriesClosedAmer Avco AA1-A · Anderson, INSep 20, 1975 · N9288L · Substantial damage NTSB CHI76FET14Accident · Minor injuriesClosedCessna A188B · Nappanee, INSep 8, 1975 · N86547 · Substantial damage NTSB CHI76FEA10Accident · No injuriesClosedWoody Pushr WAS-2 · Holton, INSep 7, 1975 · N411BZ · Substantial damage NTSB CHI76DET12Accident · Minor injuriesClosedPiper PA-28 · Hanna, INAug 28, 1975 · N7325W · Substantial damage NTSB CHI76DET11Accident · No injuriesClosedCallair A9 · Kewanna, INAug 28, 1975 · N7734V · Substantial damage NTSB CHI76FET13Accident · No injuriesClosedPiper PA-25 · Wawaka, INAug 27, 1975 · N7748Z · Substantial damage NTSB CHI76FET09Accident · Serious injuriesClosedCessna 150L · New Elliott, INAug 21, 1975 · N66014 · Substantial damage NTSB CHI76FET07Accident · Minor injuriesClosedPiper PA-28 · Lacrosse, INAug 18, 1975 · N33002 · Substantial damage NTSB CHI76FET06Accident · No injuriesClosedCessna 172D · Valparaiso, INAug 16, 1975 · N2910U · Destroyed NTSB CHI76AC014Accident · 5 fatalClosedPiper PA-32 · Fort Wayne, INAug 15, 1975 · N3821W · Destroyed NTSB MKC76AK038Accident · Serious injuriesClosedBoeing 707 · Bloomington, INAug 13, 1975 · N6726 · No damage NTSB CHI76DEA07Accident · No injuriesClosedPiper PA-28 · Madison, INAug 12, 1975 · N15569 · Substantial damage NTSB CHI76DEA06Accident · No injuriesClosedLuscombe 8F · Vallonia, INAug 12, 1975 · N1115B · Substantial damage NTSB CHI76FET05Accident · No injuriesClosedPiper PA-16 · Lake Village, INAug 9, 1975 · N5298H · Substantial damage NTSB CHI76DET10Accident · No injuriesClosedAlon A2 · Logansport, INAug 9, 1975 · N5491E · Substantial damage NTSB CHI76FET04Accident · No injuriesClosedCreamer TWO · Wabash, INAug 8, 1975 · N16AS · Substantial damage NTSB CHI7LDEA05Accident · No injuriesClosedCessna 170B · New Castle, INAug 4, 1975 · N2857C · Substantial damage NTSB CHI76DET03Accident · No injuriesClosedPiper PA-28 · Auburn, INAug 4, 1975 · N5219T · Substantial damage NTSB CHI76AC009Accident · 1 fatalClosedPitts S-1S · New Castle, INAug 2, 1975 · N3R · Destroyed NTSB CHI76AC006Accident · 2 fatalClosedAero Comdr 500A · Valparaiso, INJul 28, 1975 · N78378 · Destroyed NTSB CHI76FEA04Accident · Minor injuriesClosedPiper PA-28 · Indianapolis, INJul 26, 1975 · N1874T · Substantial damage NTSB CHI76DEM04Accident · No injuriesClosedBell 206B · Hillsdale, INJul 24, 1975 · N59449 · Substantial damage NTSB CHI76DET08Accident · No injuriesClosedCessna 185 · New Carlisle, INJul 20, 1975 · N1092F · Substantial damage