NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 CHI67F0433Accident · No injuriesClosedBellanca 14-13 · Warsaw, INDec 30, 1966 · N86771 · Substantial damageNTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INDec 26, 1966 · N2558U · Substantial damageNTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damageNTSB CHI67F0438Accident · Serious injuriesClosedAero Comdr 680F · Elkhart, INDec 19, 1966 · N342WS · DestroyedNTSB CHI67F0405Accident · No injuriesClosedCessna 175A · Martinsville, INDec 17, 1966 · N6997E · Substantial damageNTSB CHI67D0373Accident · No injuriesClosedCessna 182 · Indianapolis, INNov 29, 1966 · N3006F · Substantial damageNTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNov 28, 1966 · N4054P · Substantial damageNTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNov 26, 1966 · N6497T · DestroyedNTSB CHI67D0364Accident · No injuriesClosedPiper PA-32 · Richmond, INNov 26, 1966 · N3342N · Substantial damageNTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNov 26, 1966 · N1439L · DestroyedNTSB CHI67F0383Accident · No injuriesClosedN.American 265-40 · Evansville, INNov 23, 1966 · N355MJ · Substantial damageNTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNov 12, 1966 · N3769J · Substantial damageNTSB CHI67F0391Accident · No injuriesClosedCessna 310D · Griffith, INNov 5, 1966 · N664R · Substantial damageNTSB CHI67I0059Incident · No injuriesClosedDouglas DC-6B · Ft.Wayne, INNov 2, 1966 · N37575 · Minor damageNTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INOct 25, 1966 · N4563R · Substantial damageNTSB CHI67A0054Accident · Serious injuriesClosedBensen B7MC · French Lick, INOct 23, 1966 · N12059 · Substantial damageNTSB CHI67A0051Accident · 3 fatalClosedPiper PA-24 · Danville, INOct 13, 1966 · N8715P · DestroyedNTSB CHI67A0047Accident · Minor injuriesClosedBell 47G · Milford, INOct 5, 1966 · N2802B · DestroyedNTSB CHI67F0277Accident · No injuriesClosedCessna 182E · Anderson, INOct 2, 1966 · N3230Y · Substantial damageNTSB CHI67A0045Accident · 3 fatalClosedPiper PA-22 · Knox, INOct 2, 1966 · N3135Z · DestroyedNTSB CHI67D0278Accident · No injuriesClosedMooney M20E · Richmond, INSep 30, 1966 · N3368X · Substantial damageNTSB CHI67A0046Accident · Serious injuriesClosedLockheed L-188 · Indianapolis, INSep 30, 1966 · N120 · No damageNTSB CHI67F0221Accident · No injuriesClosedCessna 210 · Indianapolis, INSep 12, 1966 · N9605T · Substantial damageNTSB CHI67F0291Accident · No injuriesClosedPiper PA-24 · Indianapolis, INSep 8, 1966 · N8911P · Substantial damageNTSB CHI67D0257Accident · No injuriesClosedSailplane BG-12 · Rising Sun, INSep 7, 1966 · N8711R · Substantial damageNTSB CHI67F0152Accident · No injuriesClosedBeech D18S · Kokomo, INSep 4, 1966 · N35X · Substantial damageNTSB CHI67A0032Accident · 3 fatalClosedPiper PA-24 · Fort Wayne, INSep 1, 1966 · N8115P · DestroyedNTSB CHI67F0187Accident · No injuriesClosedWaco INF · Mishawaka, INAug 29, 1966 · N12453 · Substantial damageNTSB CHI67F0235Accident · No injuriesClosedBeech C35 · Elkhart, INAug 27, 1966 · N764D · Substantial damageNTSB CHI67A0027Accident · 3 fatalClosedNavion NAV-4 · Terre Haute, INAug 26, 1966 · N91F · DestroyedNTSB CHI67D0139Accident · No injuriesClosedErcoupe 415-D · Cloverdale, INAug 24, 1966 · N93745 · Substantial damageNTSB CHI67D0158Accident · No injuriesClosedPiper PA-22 · Mooresville, INAug 20, 1966 · N879A · Substantial damageNTSB CHI67F0116Accident · No injuriesClosedCessna 320 · Michigan City, INAug 17, 1966 · N4148T · Substantial damageNTSB CHI67F0167Accident · No injuriesClosedGlobe GC-1B · Lafayette, INAug 15, 1966 · N78119 · Substantial damageNTSB CHI67F0240Accident · Serious injuriesClosedAero Comdr 520 · Gary, INAug 14, 1966 · N1914 · DestroyedNTSB CHI67F0236Accident · No injuriesClosedPiper PA-28 · Hobart, INAug 14, 1966 · N6347W · Substantial damageNTSB CHI67F0143Accident · No injuriesClosedWaco YKC-S · Muncie, INAug 14, 1966 · N726 · Substantial damageNTSB CHI67F0126Accident · Serious injuriesClosedNavion A · Whiteland, INAug 12, 1966 · N4198K · DestroyedNTSB CHI67D0137Accident · No injuriesClosedCessna 172 · Muncie, INAug 6, 1966 · N2558U · Substantial damageNTSB CHI67F0183Accident · No injuriesClosedN.American P-51D · Fort Wayne, INAug 4, 1966 · N6327T · 2 aircraft · Substantial damageNTSB CHI67F0243Accident · Serious injuriesClosedGrumman G-44 · Kendallville, INJul 31, 1966 · N132X · DestroyedNTSB CHI67F0133Accident · Serious injuriesClosedScheibe L-55 · Whitestown, INJul 31, 1966 · N1172 · Substantial damageNTSB CHI67D0153Accident · No injuriesClosedCessna 150 · Bloomington, INJul 30, 1966 · N8289F · Substantial damageNTSB CHI67F0140Accident · No injuriesClosedPiper PA-24 · Culver, INJul 26, 1966 · N8451P · Substantial damageNTSB CHI67F0200Accident · No injuriesClosedPiper PA-16 · South Bend, INJul 24, 1966 · N5677H · Substantial damageNTSB CHI67F0170Accident · No injuriesClosedPiper PA-24 · Untington, INJul 24, 1966 · N7218P · Substantial damageNTSB CHI67A0012Accident · 4 fatalClosedBeech H50 · Munster, INJul 24, 1966 · N538B · DestroyedNTSB CHI67F0108Accident · No injuriesClosedPiper PA-28 · Columbia City, INJul 23, 1966 · N9022J · Substantial damageNTSB CHI66A0011Accident · 1 fatalClosedBoeing IB75A · Valparaiso, INJul 23, 1966 · N53234 · DestroyedNTSB CHI67D0132Accident · No injuriesClosedPiper PA-32 · Richmond, INJul 13, 1966 · N3342W · Substantial damage