Skip to content

NTSB investigations, 1972, IN

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 CHI73FEA23Accident · Minor injuriesClosedCessna 210G · Chrisney, INDec 28, 1972 · N5864F · Substantial damage NTSB CHI73AC060Accident · 2 fatalClosedPiper PA-28 · Paragon, INDec 25, 1972 · N8885N · Destroyed NTSB CHI73FEA21Accident · Serious injuriesClosedBellanca 17-30A · Marion, INDec 22, 1972 · N8243R · Destroyed NTSB CHI73FET12Accident · No injuriesClosedBeech 35-B33 · South Bend, INDec 4, 1972 · N8948M · Substantial damage NTSB CHI73DET11Incident · Minor injuriesClosedPiper PA-28 · Culver, INDec 3, 1972 · N673FL · Minor damage NTSB CHI73DEA29Accident · No injuriesClosedCessna 336 · Greenwood, INNov 16, 1972 · N1702Z · Substantial damage NTSB CHI73ACO48Accident · No injuriesClosedCessna 310A · Lafayette, INNov 16, 1972 · N347P · 2 aircraft · Substantial damage NTSB CHI73FET10Accident · Minor injuriesClosedPiper PA-28 · Ft Wayne, INNov 6, 1972 · N4683T · 2 aircraft · Substantial damage NTSB CHI73DEA20Accident · Serious injuriesClosedPiper PA-32 · Muncie, INNov 5, 1972 · N5588J · Substantial damage NTSB CHI73FET09Accident · No injuriesClosedHughes 269A · Gary, INNov 1, 1972 · N8790F · Substantial damage NTSB CHI73DEA19Accident · No injuriesClosedPiper PA-30 · Franklin, INOct 27, 1972 · N8461Y · Substantial damage NTSB CHI73FET07Accident · Serious injuriesClosedCessna 172G · Howe, INOct 15, 1972 · N4490L · Substantial damage NTSB CHI73DEA18Accident · No injuriesClosedCessna 150 · Greencastle, INOct 14, 1972 · N60602 · Substantial damage NTSB CHI73AC038Accident · 3 fatalClosedBeech 95-B55 · Danville, INOct 8, 1972 · N9285Q · Destroyed NTSB CHI73DEA16Accident · No injuriesClosedPiper PA-22 · New Point, INSep 30, 1972 · N6085D · Substantial damage NTSB CHI73DEA15Accident · No injuriesClosedErco 415-C · Greentown, INSep 21, 1972 · N93498 · Substantial damage NTSB CHI73FEA17Accident · No injuriesClosedCessna 150G · Jeffersonvile, INSep 19, 1972 · N4070J · Substantial damage NTSB CHI73FEA12Accident · Minor injuriesClosedCessna A188 · Ellettsville, INSep 13, 1972 · N21718 · Destroyed NTSB CHI73DEA13Accident · No injuriesClosedCessna 140 · Evansville, INSep 10, 1972 · N2174V · Substantial damage NTSB CHI73DEA11Accident · Minor injuriesClosedPiper PA-28 · Mccordsville, INSep 10, 1972 · N1225T · Substantial damage NTSB CHI73FEA14Accident · No injuriesClosedCessna 182 · Tipton, INSep 9, 1972 · N6284A · Substantial damage NTSB CHI73FEA09Accident · Minor injuriesClosedPiper PA-28 · Danville, INAug 30, 1972 · N6541J · Destroyed NTSB CHI73DEA08Accident · No injuriesClosedPiper PA-28 · W.Lafayette, INAug 25, 1972 · N553PA · Substantial damage NTSB CHI73AC027Accident · 1 fatalClosedCessna 150H · Grovertown, INAug 25, 1972 · N22402 · Destroyed NTSB CHI73AC025Accident · 1 fatalClosedCessna 172 · Martinsville, INAug 24, 1972 · N5745A · Destroyed NTSB CHI73FEA06Accident · No injuriesClosedPiper PA-32 · Kokomo, INAug 23, 1972 · N3209W · Substantial damage NTSB CHI73FEA07Accident · Minor injuriesClosedAmer Avco AA1 · W.Lafayette, INAug 22, 1972 · N6115L · Substantial damage NTSB CHI73FEA05Accident · Serious injuriesClosedRyan ST-3KR · Shelbyville, INAug 18, 1972 · N46706 · Minor damage NTSB CHI73AC018Accident · 5 fatalClosedCessna 182M · Brownsburg, INAug 15, 1972 · N92004 · Destroyed NTSB CHI73AC013Accident · 1 fatalClosedChampion 7ECA · Mccordsville, INAug 7, 1972 · N1623G · Destroyed NTSB CHI73AC012Accident · 3 fatalClosedPiper PA-24 · Nappanee, INAug 7, 1972 · N6378P · Destroyed NTSB CHI73DEA10Accident · No injuriesClosedAmer Avco AA-5 · Bedford, INAug 5, 1972 · N5839L · Substantial damage NTSB CHI72FEA04Accident · Minor injuriesClosedMooney M-20C · Watson, INAug 2, 1972 · N9289V · Substantial damage NTSB CHI73DET03Accident · No injuriesClosedBeech 23 · Crown Point, INJul 25, 1972 · N2324L · Substantial damage NTSB CHI73FEE09Accident · No injuriesClosedBellanca 17-30 · Gary, INJul 24, 1972 · N7394V · Substantial damage NTSB CHI73FEA03Accident · Minor injuriesClosedPiper PA-24 · Seymour, INJul 24, 1972 · N5156P · Destroyed NTSB CHI73FEA02Accident · No injuriesClosedPiper PA-28 · Ramsey, INJul 15, 1972 · N6361J · Substantial damage NTSB CHI73AC004Accident · 4 fatalClosedPiper PA-24 · Kewanna, INJul 15, 1972 · N5491P · Destroyed NTSB CHI73FET01Accident · No injuriesClosedCessna 150K · Valparaiso, INJul 11, 1972 · N5979G · Substantial damage NTSB CHI73AC003Accident · 1 fatalClosedPiper PA-23 · Knox, INJul 7, 1972 · N4241P · Destroyed NTSB CHI73DEA01Accident · No injuriesClosedCessna 182 · Indianapolis, INJul 3, 1972 · N8416S · Substantial damage NTSB CHI73FET02Accident · No injuriesClosedCessna 150J · South Bend, INJul 2, 1972 · N1014M · Substantial damage NTSB CHI72DEA49Accident · Minor injuriesClosedChampion 7ECA · Connersville, INJun 30, 1972 · N9042L · Substantial damage NTSB CHI72AC103Accident · Serious injuriesClosedBoeing 727 · Gary, INJun 28, 1972 · N54336 · No damage NTSB CHI72FET35Accident · No injuriesClosedCessna 206 · Rochester, INJun 16, 1972 · N5265U · Substantial damage NTSB CHI73FET04Accident · No injuriesClosedCessna 150 · Valparaiso, INJun 10, 1972 · N6608T · Substantial damage NTSB CHI72FET34Accident · Minor injuriesClosedDowner RC-3 · Ligonier, INJun 3, 1972 · N6097K · Substantial damage NTSB CHI72FET33Accident · 1 fatalClosedCessna 188A · South Bend, INJun 3, 1972 · N9936G · Substantial damage NTSB CHI72DEA47Accident · No injuriesClosedBeech A23 · Huntingburg, INJun 3, 1972 · N5666S · Substantial damage NTSB CHI72FEA46Accident · No injuriesClosedBell 47D-1 · Haubstadt, INJun 1, 1972 · N3087G · Destroyed