NTSB investigations, 1980, 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.

Cases per year

19632026
NTSB investigations, 1980, IN per year, 1963–2026: 2,978 cases
19631
1964107
1965116
1966119
1967132
1968106
196988
197083
197181
197288
197377
197466
197586
197678
197790
197895
197970
198076
198152
198255
198354
198455
198554
198658
198753
198866
198945
199042
199133
199229
199335
199438
199533
199631
199736
199835
199922
200034
200129
200225
200320
200426
200520
200628
200723
200822
200930
201027
201126
201226
201322
201416
201519
201623
201722
201819
201922
202017
202121
202221
202316
202417
202513
20269

Latest cases

Query with SQL
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\") = 1980
    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.

NTSB CHI81FA016Accident · 2 fatalClosedPiper PA-28R · Elkhart, INDec 31, 1980 · N8708E · DestroyedNTSB CHI81FEX06Accident · Serious injuriesClosedCessna 150H · Kokomo, INDec 7, 1980 · N6475S · DestroyedNTSB CHI81FA011Accident · 4 fatalClosedBeech E90 · Michigan City, INDec 7, 1980 · N2181L · DestroyedNTSB CHI81FA009Accident · 3 fatalClosedCessna 210H · Hagerstown, INDec 5, 1980 · N5951F · DestroyedNTSB CHI81FA007Accident · Serious injuriesClosedBeech V35A · Pimento, INNov 18, 1980 · N2532A · DestroyedNTSB CHI81FEX05Accident · No injuriesClosedCessna 152 · Noblesville, INNov 6, 1980 · N69178 · Substantial damageNTSB CHI81FET02Accident · No injuriesClosedCessna 150 · Griffin, INNov 1, 1980 · N1744Q · Substantial damageNTSB CHI81DEX04Accident · No injuriesClosedBell 206B · Kokomo, INOct 25, 1980 · N98HH · Substantial damageNTSB CHI81FEX03Accident · Minor injuriesClosedBeech F33A · Indianapolis, INOct 24, 1980 · N3133W · Substantial damageNTSB CHI81DEX02Accident · Minor injuriesClosedPitts S-1C · Centerton, INOct 23, 1980 · N10RY · Substantial damageNTSB CHI81FET01Accident · No injuriesClosedCessna 172 · Gary, INOct 19, 1980 · N6445D · Substantial damageNTSB CHI81FEX01Accident · No injuriesClosedCessna 170 · Pendleton, INOct 1, 1980 · N4240V · Substantial damageNTSB CHI80FEX37Accident · 1 fatalClosedPietenpol GN-1 · Marion, INSep 28, 1980 · N4933 · DestroyedNTSB CHI80DET03Accident · No injuriesClosedBede BD-5B · Goshen, INSep 23, 1980 · N78MJ · Substantial damageNTSB CHI80DET30Accident · No injuriesClosedCessna R182 · Roanoke, INSep 22, 1980 · N3132C · Substantial damageNTSB CHI80FEX35Accident · No injuriesClosedBell 47G-4 · Carmel, INSep 17, 1980 · N12PE · Substantial damageNTSB CHI81FET29Accident · No injuriesClosedBellanca 7ECA · Gary, INSep 13, 1980 · N90915 · Substantial damageNTSB CHI80FEX34Accident · Minor injuriesClosedGrumman AA-5A · Jeffersonville, INSep 12, 1980 · N9895U · Substantial damageNTSB CHI80FEX36Accident · No injuriesClosedCessna 172M · Brownsburg, INSep 9, 1980 · N20095 · Substantial damageNTSB CHI80DEX33Accident · No injuriesClosedBeech E18S · Columbus, INAug 30, 1980 · N666X · Substantial damageNTSB CHI80FET27Accident · 1 fatalClosedDi Stasi Bowers · Ligonier, INAug 25, 1980 · N3392 · Substantial damageNTSB CHI80FEX31Accident · No injuriesClosedHiller Acft UH-12E · Milan, INAug 19, 1980 · N492HS · Substantial damageNTSB CHI80FET26Accident · No injuriesClosedPiper PA-32R · Syracuse, INAug 18, 1980 · N1321H · Substantial damageNTSB CHI80DEX30Accident · No injuriesClosedGrumman AA-1B · Mooresville, INAug 17, 1980 · N89631 · Substantial damageNTSB CHI80DEX32Accident · No injuriesClosedTaylorcraft F19 · Deer Creek, INAug 16, 1980 · N3728T · Substantial damageNTSB CHI80FET25Accident · No injuriesClosedBeech A-35 · Hobart, INAug 15, 1980 · N8654A · Substantial damageNTSB CHI80FET24Accident · No injuriesClosedGrumman G-164 · Howe, INAug 15, 1980 · N48348 · Substantial damageNTSB CHI80FET23Accident · Minor injuriesClosedCessna 172M · Woodburn, INAug 10, 1980 · N9050H · Substantial damageNTSB CHI80FA062Accident · 1 fatalClosedCessna 150 · Mishawaka, INAug 8, 1980 · N3118J · DestroyedNTSB CHI80FEX29Accident · No injuriesClosedHiller Acft UH-12E · Elrod, INAug 6, 1980 · N62421 · Substantial damageNTSB CHI80DA061Accident · 1 fatalClosedAeronca C-3 · Luray, INAug 1, 1980 · N16291 · Substantial damageNTSB CHI80FEX28Accident · No injuriesClosedGrumman AA-5A · Indianapolis, INJul 25, 1980 · N26774 · Substantial damageNTSB CHI80FET22Accident · No injuriesClosedPiper PA-28 · Peru, INJul 23, 1980 · N44245 · Substantial damageNTSB CHI80FEX25Accident · No injuriesClosedCessna 150F · Jeffersonville, INJul 20, 1980 · N7988F · Substantial damageNTSB CHI80FET21Accident · 1 fatalClosedFaulkner MS-1 · Ft Wayne, INJul 20, 1980 · N23AS · DestroyedNTSB CHI80FEX27Accident · No injuriesClosedSchweizer SGS126 · Lafayette, INJul 17, 1980 · N10356 · Substantial damageNTSB CHI80FEX26Accident · No injuriesClosedBeech C-23 · Martinsville, INJul 17, 1980 · N1917L · Substantial damageNTSB CHI80FET20Accident · No injuriesClosedAeronca 65C · Ft.Wayne, INJul 15, 1980 · N23547 · Substantial damageNTSB CHI80DEX24Accident · No injuriesClosedAeronca 7AC · Morristown, INJul 13, 1980 · N3687E · Substantial damageNTSB CHI80DEX23Accident · No injuriesClosedCessna 188B · Saluda, INJul 11, 1980 · N9621G · Substantial damageNTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, INJul 7, 1980 · N3547V · Substantial damageNTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INJun 22, 1980 · N74CA · DestroyedNTSB CHI80FEX21Accident · Minor injuriesClosedRand KR-1 · Sheridan, INJun 12, 1980 · N9999A · DestroyedNTSB CHI80FEX20Accident · No injuriesClosedCessna 172M · Bloomington, INJun 12, 1980 · N61548 · Substantial damageNTSB CHI80FA046Accident · No injuriesClosedDouglas DC-6 · Indianapolis, INJun 10, 1980 · N111AS · Substantial damageNTSB CHI80FA045Accident · 1 fatalClosedPiper PA32RT · South Bend, INJun 6, 1980 · N36839 · DestroyedNTSB CHI80FEX19Accident · Minor injuriesClosedBeech B-19 · Frankfort, INMay 28, 1980 · N1994W · Substantial damageNTSB CHI80FEX17Accident · 1 fatalClosedGR Lakes X2T-1T · Lizton, INMay 10, 1980 · N6187L · DestroyedNTSB CHI80FEX16Accident · No injuriesClosedCessna 320E · Indianapolis, INMay 10, 1980 · N2JF · Substantial damageNTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, INMay 10, 1980 · N3912F · Destroyed