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

Cases per year

19632026
NTSB investigations, 1979, 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\") = 1979
    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 CHI80FEX03Accident · Minor injuriesClosedBeech B35 · Fairmount, INDec 30, 1979 · N8811A · Substantial damageNTSB CHI80FET05Accident · Serious injuriesClosedErco 415-CD · Lake Village, INDec 16, 1979 · N3857H · Substantial damageNTSB CHI80FA013Accident · 1 fatalClosedCessna 177 · Gary, INDec 1, 1979 · N10412 · DestroyedNTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNov 25, 1979 · N2034S · DestroyedNTSB CHI80FET04Accident · No injuriesClosedPiper PA-32 · Laporte, INNov 22, 1979 · N44503 · Substantial damageNTSB CHI80FET03Accident · No injuriesClosedCessna 172M · Mentone, INNov 13, 1979 · N5111Q · Substantial damageNTSB CHI80FEX02Accident · Serious injuriesClosedCessna 206 · Noblesville, INNov 11, 1979 · N756LA · DestroyedNTSB CHI80FEX01Accident · No injuriesClosedCessna 210E · Fairbanks, INNov 2, 1979 · N232F · Substantial damageNTSB CHI80FET02Accident · Minor injuriesClosedCessna 172N · Munster, INOct 28, 1979 · N738FU · Substantial damageNTSB CHI80FA007Accident · 2 fatalClosedCessna 310 · Bloomington, INOct 22, 1979 · N1320G · DestroyedNTSB CHI80FA001Accident · 1 fatalClosedBellanca 17-31 · North Manchest, INOct 1, 1979 · N170EE · DestroyedNTSB CHI80DA003Accident · 1 fatalClosedCessna 152 · Syracuse, INOct 1, 1979 · N89179 · DestroyedNTSB CHI79FET34Accident · No injuriesClosedCessna 182P · South Bend, INSep 29, 1979 · N21121 · Substantial damageNTSB CHI79AA082Accident · 5 fatalClosedPiper PA-32R · Indianapolis, INSep 28, 1979 · N8425C · DestroyedNTSB CHI79FET33Accident · No injuriesClosedPiper PA-22 · Peru, INSep 19, 1979 · N3384A · Substantial damageNTSB CHI79FET32Accident · Minor injuriesClosedPiper PA-28 · Bluffton, INSep 16, 1979 · N5198W · Substantial damageNTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INSep 9, 1979 · N24489 · Substantial damageNTSB CHI79DET29Accident · No injuriesClosedGrumman AA1C · Roselawn, INSep 8, 1979 · N9585U · Substantial damageNTSB CHI79FEX41Accident · No injuriesClosedGrumman G-164A · Versailles, INSep 7, 1979 · N8571H · Substantial damageNTSB CHI79DEX40Accident · No injuriesClosedCessna 172 · Delphi, INAug 30, 1979 · N5230R · Substantial damageNTSB CHI79DEX39Accident · No injuriesClosedCessna 177 · Indianapolis, INAug 30, 1979 · N3108T · Substantial damageNTSB CHI79FA079Accident · 2 fatalClosedCessna 310 · Blue Ridge, INAug 29, 1979 · N69618 · DestroyedNTSB CHI79DA068Accident · 1 fatalClosedCessna 177B · Bloomington, INAug 28, 1979 · N34457 · DestroyedNTSB CHI79FEX38Accident · No injuriesClosedPiper PA-28 · Evansville, INAug 24, 1979 · N2088M · DestroyedNTSB CHI79DEX37Accident · No injuriesClosedRaven RX-7 · Shelbyville, INAug 15, 1979 · N5554S · DestroyedNTSB CHI79FEX36Accident · No injuriesClosedCessna 150M · Richmond, INAug 12, 1979 · N714MC · Substantial damageNTSB CHI79FET28Accident · No injuriesClosedPiper PA-28 · Crown Point, INAug 12, 1979 · N1981T · Substantial damageNTSB CHI79FEX35Accident · No injuriesClosedPiper PA-28 · Indianapolis, INAug 5, 1979 · N6155H · Substantial damageNTSB CHI79FEX34Accident · No injuriesClosedPiper PA-25 · Danville, INAug 5, 1979 · N6209Z · Substantial damageNTSB CHI79FA065Accident · 1 fatalClosedBeech C-90 · Indianapolis, INAug 5, 1979 · N6040M · DestroyedNTSB CHI79DET27Accident · No injuriesClosedBreezy DDJ-1 · Roselawn, INAug 4, 1979 · N2780 · Substantial damageNTSB CHI79FET26Accident · Serious injuriesClosedN American SNJ-5 · Elkhart, INJul 27, 1979 · N2023 · Substantial damageNTSB CHI79FET25Accident · Minor injuriesClosedCessna 180 · Craigville, INJul 23, 1979 · N1684C · Substantial damageNTSB CHI79FEX33Accident · 1 fatalClosedTexas Heli OH-13 · Solitude, INJul 20, 1979 · N51847 · DestroyedNTSB CHI79DEX42Accident · No injuriesClosedLuscombe 8A · Brownsburg, INJul 15, 1979 · N1364K · Substantial damageNTSB CHI79FET24Accident · Serious injuriesClosedPiper PA-23 · Hobart, INJul 14, 1979 · N4402P · Substantial damageNTSB CHI79FEX32Accident · Minor injuriesClosedCessna 172 · Terra Haute, INJul 10, 1979 · N738YH · Substantial damageNTSB CHI79DEX30Accident · Minor injuriesClosedCessna 172 · Anderson, INJun 13, 1979 · N80519 · Substantial damageNTSB CHI79FEX28Accident · Minor injuriesClosedBoeing A75N1 · Indianapolis, INJun 5, 1979 · N469RH · Substantial damageNTSB CHI79FET23Accident · No injuriesClosedGrumman AA5 · Elkhart, INMay 29, 1979 · N81169 · Substantial damageNTSB CHI79FEX27Accident · Minor injuriesClosedBellanca 7ECA · Indianapolis, INMay 28, 1979 · N5039Y · Substantial damageNTSB CHI79FEX26Accident · No injuriesClosedBell 206-11 · Indianapolis, INMay 28, 1979 · N27554 · Substantial damageNTSB CHI79FEX31Accident · Minor injuriesClosedCessna 172 · Martinsville, INMay 21, 1979 · N46202 · Substantial damageNTSB CHI79FEX25Accident · No injuriesClosedBell 47J2 · Westfield, INMay 17, 1979 · N51711 · Substantial damageNTSB CHI79DEX29Accident · No injuriesClosedPiper PA-28 · Hagertown, INMay 5, 1979 · N15425 · Substantial damageNTSB CHI79FEX23Accident · Minor injuriesClosedLuscombe 8E · Lanesville, INApr 21, 1979 · N2698K · Substantial damageNTSB CHI79FEX22Accident · No injuriesClosedCessna 340 · Columbus, INApr 21, 1979 · N69546 · Substantial damageNTSB CHI79FEX21Accident · Serious injuriesClosedBeech C-23 · Fishers, INApr 17, 1979 · N2064L · Substantial damageNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INApr 17, 1979 · N1895T · 2 aircraft · DestroyedNTSB CHI79DEX20Accident · No injuriesClosedPiper PA-28 · Lafayette, INApr 17, 1979 · N3661R · Substantial damage