Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 CHI78FET06Accident · Minor injuriesClosedCessna 172F · Fort Wayne, INDec 22, 1977 · N7860U · Substantial damage NTSB CHI78FEX07Accident · Minor injuriesClosedPiper PA-23 · St Paul, INDec 17, 1977 · N498HH · Substantial damage NTSB CHI78DEX06Accident · Serious injuriesClosedAerostar 601P · Evansville, INDec 16, 1977 · N9506Q · Minor damage NTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INDec 13, 1977 · N51071 · Destroyed NTSB CHI78FET05Accident · No injuriesClosedCessna 414 · Valparaiso, INDec 8, 1977 · N414BA · Substantial damage NTSB CHI78FET04Accident · No injuriesClosedRockwell 112TC · Gary, INDec 5, 1977 · N4649W · Substantial damage NTSB CHI78FEX05Accident · Serious injuriesClosedHughes 269B · Speedway, INDec 1, 1977 · N9556F · Substantial damage NTSB CHI78FET03Accident · Minor injuriesClosedCessna 340A · Ft Wayne, INNov 27, 1977 · N1388G · Substantial damage NTSB CHI78DEX03Accident · Serious injuriesClosedBeech 36 · Terre Haute, INNov 27, 1977 · N7981R · Substantial damage NTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNov 19, 1977 · N3095R · Destroyed NTSB CHI788A011Accident · 5 fatalClosedBeech P35 · New Salem, INNov 17, 1977 · N9958Y · Destroyed NTSB CHI78FEX02Accident · Minor injuriesClosedBeech B95 · Indianapolis, INNov 7, 1977 · N2048C · Substantial damage NTSB CHI78DEX04Accident · No injuriesClosedCessna 150 · Noblesville, INNov 4, 1977 · N7964F · Substantial damage NTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INOct 30, 1977 · N1555S · 2 aircraft · Destroyed NTSB CHI78FET01Accident · Minor injuriesClosedAmerican AA-1 · South Bend, INOct 22, 1977 · N5604L · Substantial damage NTSB CHI78FA003Accident · 1 fatalClosedBeech 200 · Valparaiso, INOct 19, 1977 · N17530 · Destroyed NTSB CHI78DEX01Accident · Minor injuriesClosedMoore KR-1 · Sheridan, INOct 15, 1977 · N65029 · Destroyed NTSB CHI78FA001Accident · Serious injuriesClosedBeech E18S · Plymouth, INOct 1, 1977 · N5601D · Destroyed NTSB CHI77FEX54Accident · No injuriesClosedCessna 402 · Indianapolis, INSep 29, 1977 · N8437F · Substantial damage NTSB CHI77FEX53Accident · No injuriesClosedBellanca 14-19 · Mccordsville, INSep 27, 1977 · N6555N · Substantial damage NTSB CHI77FEX51Accident · Minor injuriesClosedAcrosport 1 · Indianapolis, INSep 25, 1977 · N15HS · 2 aircraft · Substantial damage NTSB CHI77BEX52Accident · No injuriesClosedCessna 140 · Anderson, INSep 25, 1977 · N76168 · Substantial damage NTSB CHI77FA074Accident · 1 fatalClosedBeech C55 · Farmersburg, INSep 24, 1977 · N3754Q · Destroyed NTSB CHI77DEK50Accident · No injuriesClosedPiper PA-28R · Mount Vernon, INSep 22, 1977 · N32849 · Substantial damage NTSB CHI77FET34Accident · 1 fatalClosedPiper PA-22 · Fort Wayne, INSep 11, 1977 · N3213B · Destroyed NTSB CHI77DEX47Accident · Serious injuriesClosedPiccard AX6 · Wanamaker, INSep 10, 1977 · N3191 · Minor damage NTSB CHI77FEX48Accident · 1 fatalClosedBeech C45 · Richmond, INSep 4, 1977 · N4111A · Substantial damage NTSB CHI77FEX49Accident · Minor injuriesClosedMidget Mustng · Clinton, INSep 3, 1977 · N6141U · Substantial damage NTSB CHI77FEX46Accident · No injuriesClosedTomcat MK5A · Monrovia, INSep 1, 1977 · N9010T · Substantial damage NTSB CHI77FEX45Accident · No injuriesClosedCessna 421B · Sheridan, INAug 28, 1977 · N41114 · Substantial damage NTSB CHI77FET33Accident · No injuriesClosedCessna 150M · Hobart, INAug 24, 1977 · N63155 · Substantial damage NTSB CHI77EEX44Accident · No injuriesClosedMooney M20E · Greenwood, INAug 21, 1977 · N1307W · Substantial damage NTSB CHI77FEX43Accident · Serious injuriesClosedEvans VP-1 · Speedway, INAug 20, 1977 · N65209 · Substantial damage NTSB CHI77DEX42Accident · No injuriesClosedPiper PA-34 · Huntingburg, INAug 9, 1977 · N32174 · Substantial damage NTSB CHI77FET31Accident · 2 fatalClosedTurner T-40A · Valparaiso, INAug 1, 1977 · N278S · Destroyed NTSB CHI77FET28Accident · Serious injuriesClosedCallair A-9 · Winamac, INJul 28, 1977 · N7734V · Destroyed NTSB CHI77DET29Accident · No injuriesClosedBeech BE-19 · Elkhart, INJul 28, 1977 · N1914L · Substantial damage NTSB CHI77FET27Accident · Serious injuriesClosedVolksplane VP-IFD · Chesterton, INJul 27, 1977 · N16655 · Destroyed NTSB CHI77DET24Accident · No injuriesClosedCessna 150 · Milford, INJul 18, 1977 · N7306G · Substantial damage NTSB CHI77DEC45Accident · Serious injuriesClosedDouglas DC-6A · Ft.Wayne, INJul 16, 1977 · N515TY · No damage NTSB CHI77FEX41Accident · No injuriesClosedGrumman G-164A · Shelbyville, INJul 13, 1977 · N4862 · Substantial damage NTSB CHI77DEX40Accident · No injuriesClosedStearman PT-17 · Converse, INJul 13, 1977 · N52014 · Substantial damage NTSB CHI77FEX38Accident · No injuriesClosedBeech S35 · Indianapolis, INJul 12, 1977 · N2015W · Substantial damage NTSB CHI77FET22Accident · 1 fatalClosedPiper PA-28 · Huntington, INJul 8, 1977 · N8091N · Destroyed NTSB CHI77FEX36Accident · Serious injuriesClosedCessna 172M · Spencer, INJul 4, 1977 · N19798 · Destroyed NTSB CHI77DEX35Accident · No injuriesClosedBellanca 7ECA · Lebanon, INJul 1, 1977 · N8337V · Substantial damage NTSB CHI77FET21Accident · No injuriesClosedGrumman G-164B · Hanna, INJun 29, 1977 · N6648Q · Substantial damage NTSB CHI77DET19Accident · No injuriesClosedGrumman G-164A · Hebron, INJun 24, 1977 · N930X · Substantial damage NTSB CHI77FEX34Accident · No injuriesClosedCessna 310Q · W.Lafayette, INJun 16, 1977 · N69584 · Minor damage NTSB CHI77DEX33Accident · No injuriesClosedCessna 150 · Logan, INJun 14, 1977 · N3502J · Substantial damage