NTSB investigations, 1964, IN

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1964, 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\") = 1964
    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 UNK65X1114Accident · No injuriesClosedMaule M4 · Zionsville, INDec 24, 1964 · N4704T · Substantial damageNTSB UNK65X1062Accident · No injuriesClosedPiper PA28 · Lisbon, INDec 19, 1964 · N5788W · Substantial damageNTSB UNK65X1058Accident · Serious injuriesClosedPiper PA24 · Indianapolis, INDec 19, 1964 · N8451P · No damageNTSB UNK65X1014Accident · No injuriesClosedBeechraft F35 · Frankfort, INDec 14, 1964 · N4251B · Substantial damageNTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INDec 6, 1964 · N5687Z · Substantial damageNTSB UNK65X0935Accident · No injuriesClosedPiper PA24 · Bedford, INDec 6, 1964 · N6863P · Substantial damageNTSB UNK65X0933Accident · No injuriesClosedPiper PA28 · Hobart, INDec 6, 1964 · N6347W · Substantial damageNTSB UNK65X0847Accident · No injuriesClosedSmith DSA1 · Linton, INNov 26, 1964 · N103R · Substantial damageNTSB UNK65X0765Accident · No injuriesClosedPiper PA24 · Michigan City, INNov 20, 1964 · N6033P · Substantial damageNTSB UNK65X0704Accident · No injuriesClosedLuscombe 8A · Elkhart, INNov 14, 1964 · N45801 · Substantial damageNTSB UNK65X0629Accident · No injuriesClosedCessna 310 · South Bend, INNov 9, 1964 · N222R · Substantial damageNTSB UNK65X0531Accident · No injuriesClosedMooney 20C · Indianapolis, INNov 2, 1964 · N6846U · Substantial damageNTSB UNK65X0521Accident · No injuriesClosedPiper PA28 · Kendallville, INNov 1, 1964 · N5788W · 2 aircraft · No damageNTSB UNK65X0466Accident · Serious injuriesClosedCessna 150 · Schneider, INOct 28, 1964 · N6235T · DestroyedNTSB UNK65X0425Accident · Minor injuriesClosedNavion A · Bloomington, INOct 25, 1964 · N91650 · Substantial damageNTSB UNK65X0373Accident · No injuriesClosedPiper PA16 · Indianapolis, INOct 22, 1964 · N5323H · Substantial damageNTSB UNK65X0349Accident · No injuriesClosedBeechcraft E35 · Ft Wayne, INOct 20, 1964 · N3231C · Substantial damageNTSB UNK65X0235Accident · Minor injuriesClosedTaylorcraft BC123 · Markle, INOct 11, 1964 · N96529 · Substantial damageNTSB UNK65X0203Accident · No injuriesClosedBellanca 1413 · Hartford City, INOct 9, 1964 · N86703 · Substantial damageNTSB UNK65X0137Accident · No injuriesClosedPiper PA28 · Hobart, INOct 4, 1964 · N7731W · Substantial damageNTSB UNK65X0127Accident · No injuriesClosedPiper PA28 · Franklin, INOct 3, 1964 · N7249W · Substantial damageNTSB UNK64X4149Accident · Serious injuriesClosedCessna 175 · Culver, INSep 25, 1964 · N7196M · DestroyedNTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INSep 20, 1964 · N34132 · Substantial damageNTSB UNK64X4075Accident · No injuriesClosedMooney M20B · Logansport, INSep 20, 1964 · N74707 · Substantial damageNTSB UNK64X4029Incident · No injuriesClosedDouglas DC-3 · Indianapolis, INSep 18, 1964 · N21914 · No damageNTSB UNK64X3968Accident · No injuriesClosedCessna 182E · Greenfield, INSep 13, 1964 · N2860Y · Substantial damageNTSB UNK64X3893Accident · No injuriesClosedErcoupe 415C · Anderson, INSep 10, 1964 · N2700H · Substantial damageNTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, INSep 7, 1964 · N44569 · 2 aircraft · Minor damageNTSB UNK64X3862Accident · No injuriesClosedCessna 120 · South Bend, INSep 7, 1964 · N1791N · Substantial damageNTSB UNK64X3855Accident · No injuriesClosedCessna 182 · Griffith, INSep 7, 1964 · N3548U · Substantial damageNTSB UNK64X3851Accident · No injuriesClosedBellanca 14132 · Valparaiso, INSep 7, 1964 · N74388 · Substantial damageNTSB UNK64X3850Accident · No injuriesClosedMaule M4 · Ft Wayne, INSep 7, 1964 · N4709T · Substantial damageNTSB UNK64X3803Accident · 1 fatalClosedErcoupe 415C · Columbus, INSep 5, 1964 · N2120H · Substantial damageNTSB UNK64X3792Accident · No injuriesClosedPiper PA30 · Muncie, INSep 5, 1964 · N7406Y · Substantial damageNTSB UNK64X3734Accident · No injuriesClosedBeechcraft D18 · Marion, INSep 2, 1964 · N2008H · Substantial damageNTSB UNK64X3710Accident · No injuriesClosedSwift GC1B · Tipton, INAug 31, 1964 · N3208K · Substantial damageNTSB UNK64X3649Accident · No injuriesClosedNo American TF51D · Laporte, INAug 28, 1964 · N6362T · Substantial damageNTSB UNK64X3646Accident · No injuriesClosedNavion G · Rushville, INAug 28, 1964 · N1622T · Substantial damageNTSB UNK64X3624Accident · No injuriesClosedCessna 172 · Lafayette, INAug 27, 1964 · N3020U · Substantial damageNTSB UNK64X3605Accident · No injuriesClosedStinson 108-3 · Gary, INAug 26, 1964 · N6459M · Substantial damageNTSB UNK64X3570Accident · Serious injuriesClosedCessna 170A · Paoli, INAug 23, 1964 · N1374D · DestroyedNTSB UNK64X3511Accident · No injuriesClosedPiper PA28 · Noblesville, INAug 21, 1964 · N5633W · Substantial damageNTSB UNK64X3467Accident · No injuriesClosedBeechcraft H35 · Bronnsburg, INAug 19, 1964 · N5542D · Substantial damageNTSB UNK64X3447Accident · No injuriesClosedPiper PA22 · Marion, INAug 18, 1964 · N5348Z · Substantial damageNTSB UNK64X3390Accident · No injuriesClosedPiper J3 · Linn Grove, INAug 15, 1964 · N33053 · Substantial damageNTSB UNK64X3244Accident · Minor injuriesClosedBrantly B2B · Borden, INAug 6, 1964 · N2190U · Substantial damageNTSB UNK64X3199Accident · No injuriesClosedSchweizer 222E · Jefferson, INAug 3, 1964 · N8679R · Substantial damageNTSB UNK64X3184Accident · Serious injuriesClosedCessna 120 · Danville, INAug 2, 1964 · N1764V · DestroyedNTSB UNK64X3085Accident · No injuriesClosedLuscombe 11A · Indianapolis, INJul 28, 1964 · N1666B · Substantial damageNTSB UNK64X3030Accident · No injuriesClosedCessna 172 · Rushville, INJul 25, 1964 · N2390U · Substantial damage