NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 CHI66F0501Accident · No injuriesClosedPiper PA-24 · Wabash, INDec 26, 1965 · N5242P · Substantial damageNTSB CHI66F0475Accident · No injuriesClosedPiper PA-23 · Muncie, INDec 26, 1965 · N5655Y · Substantial damageNTSB CHI66F0500Accident · No injuriesClosedMooney M-20E · Indianapolis, INDec 25, 1965 · N59240 · Substantial damageNTSB CHI66F0492Accident · No injuriesClosedBeechcraft N35 · Mishawaka, INDec 19, 1965 · N1241Z · Substantial damageNTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · DestroyedNTSB CHI66D0504Accident · No injuriesClosedPiper PA-24 · Indianapolis, INDec 18, 1965 · N8451P · Substantial damageNTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INDec 10, 1965 · N8072S · DestroyedNTSB CHI66D0473Accident · No injuriesClosedMooney M20B · Indianapolis, INDec 5, 1965 · N7890Z · Substantial damageNTSB CHI66A0054Accident · No injuriesClosedBell 47G-4 · Indianapolis, INNov 29, 1965 · N8507F · Substantial damageNTSB CHI66D0487Accident · No injuriesClosedCessna 175 · Syracuse, INNov 26, 1965 · N6558E · Substantial damageNTSB CHI66D0484Accident · No injuriesClosedPiper PA-28 · Auburn, INNov 17, 1965 · N6764W · Substantial damageNTSB CHI66F0433Accident · No injuriesClosedCessna 182 · South Bend, INNov 7, 1965 · N3458S · Substantial damageNTSB CHI66F0413Accident · Minor injuriesClosedPiper J3C-65 · Greenfield, INNov 7, 1965 · N87851 · Substantial damageNTSB CHI66F0405Accident · No injuriesClosedLuscombe 8A · Kempton, INNov 7, 1965 · N77826 · Substantial damageNTSB CHI66F0399Accident · Minor injuriesClosedPiper PA-16 · Ladoga, INNov 7, 1965 · N5634H · Substantial damageNTSB CHI66F0378Accident · No injuriesClosedPiper PA-30 · Muncie, INNov 7, 1965 · N7807Y · Substantial damageNTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNov 1, 1965 · N7227T · 2 aircraft · Substantial damageNTSB CHI66F0418Accident · No injuriesClosedBeechcraft D18S · Valparaiso, INOct 31, 1965 · N5882C · Substantial damageNTSB CHI66F0407Accident · 1 fatalClosedSchweizer SGS126 · Ramsey, INOct 31, 1965 · N8633R · Substantial damageNTSB CHI66D0439Accident · No injuriesClosedPiper PA-28 · Franklin, INOct 22, 1965 · N6104W · Substantial damageNTSB CHI66D0456Accident · No injuriesClosedBeechcraft D-18S · Ft Wayne, INOct 21, 1965 · N935TX · Substantial damageNTSB CHI66A0044Accident · 1 fatalClosedCessna 172 · Liberty, INOct 21, 1965 · N2736A · DestroyedNTSB CHI66D0432Accident · No injuriesClosedPiper PA-20 · Ft Wayne, INOct 19, 1965 · N7667K · Substantial damageNTSB CHI66F0619Accident · No injuriesClosedBeechcraft 23 · Fort Wayne, INOct 18, 1965 · N2381Z · Substantial damageNTSB CHI66F0400Accident · Serious injuriesClosedPiper PA-28 · Portage, INOct 17, 1965 · N5964Z · DestroyedNTSB CHI66D0379Accident · No injuriesClosedCessna 172 · Greenwood, INOct 17, 1965 · N6105E · Substantial damageNTSB CHI66A0037Accident · 2 fatalClosedNavion A · Spencer, INOct 17, 1965 · N4954K · DestroyedNTSB CHI66F0434Accident · No injuriesClosedAero Cmdr 560-A · Valparaiso, INOct 12, 1965 · N2764B · Substantial damageNTSB CHI66A0032Accident · 1 fatalClosedAir Space 18A · Muncie, INOct 7, 1965 · N6138S · DestroyedNTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INSep 25, 1965 · N7743H · Substantial damageNTSB CHI66D0319Accident · No injuriesClosedCessna 150 · Crawfordsville, INSep 24, 1965 · N1160Y · Substantial damageNTSB CHI66D0438Accident · Minor injuriesClosedTaylorcraft BC12-D · Cedar Grove, INSep 23, 1965 · N5182M · Substantial damageNTSB CHI66F0351Accident · No injuriesClosedCessna 172 · Roselawn, INSep 19, 1965 · N5533R · Substantial damageNTSB CHI66F0318Accident · No injuriesClosedPiper PA-30 · Madison, INSep 17, 1965 · N70594 · Substantial damageNTSB CHI66A0027Accident · Serious injuriesClosedAir Space 18A · Hobart, INSep 15, 1965 · N6114S · Substantial damageNTSB CHI66D0312Accident · No injuriesClosedCessna 172 · Nft Wayne, INSep 14, 1965 · N5708R · Substantial damageNTSB CHI66F0308Accident · No injuriesClosedBeechcraft C-18S · Jamestown, INSep 8, 1965 · N4723C · Substantial damageNTSB CHI66D0198Accident · No injuriesClosedAero Cmdr 680F · Indianapolis, INSep 7, 1965 · N6144X · Substantial damageNTSB CHI66F0313Accident · No injuriesClosedPiper PA-22 · Clermont, INSep 6, 1965 · N8502C · Substantial damageNTSB CHI66F0338Accident · Minor injuriesClosedBeechcraft D-17S · Evansville, INSep 2, 1965 · N67426 · Substantial damageNTSB CHI66F0385Accident · No injuriesClosedPiper PA-28 · Kendallville, INAug 29, 1965 · N5831W · Substantial damageNTSB CHI66F0221Accident · Serious injuriesClosedBeech H35 · Dunkirk, INAug 29, 1965 · N7918D · Substantial damageNTSB CHI66D0228Accident · No injuriesClosedPiper PA-28 · Chesterton, INAug 25, 1965 · N8606W · Substantial damageNTSB CHI66A0020Accident · No injuriesClosedBrantly B2 · Williamsport, INAug 24, 1965 · CFNGR · Substantial damageNTSB CHI66F0185Accident · No injuriesClosedPiper PA-28 · Culver, INAug 18, 1965 · N9060W · Substantial damageNTSB CHI66D0192Accident · No injuriesClosedCessna 172 · Milan, INAug 17, 1965 · N8207X · Substantial damageNTSB CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INAug 14, 1965 · N3627V · Substantial damageNTSB CHI66D0176Accident · No injuriesClosedCessna 170B · Valpariso, INAug 13, 1965 · N43F · Substantial damageNTSB CHI66F0154Accident · No injuriesClosedPiper PA-22 · Indianapolis, INAug 7, 1965 · N9636D · Substantial damageNTSB CHI66F0124Accident · No injuriesClosedMooney M20D · Woodburn, INAug 5, 1965 · N6617U · Substantial damage