NTSB investigations, 1965, MI

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

19622026
NTSB investigations, 1965, MI per year, 1962–2026: 4,705 cases
19621
19631
1964145
1965153
1966169
1967193
1968174
1969182
1970176
1971159
1972150
1973149
1974141
1975115
1976131
1977106
1978121
1979118
198098
1981116
198287
1983101
198491
198582
198686
198757
198863
198969
199086
199165
199266
199360
199452
199556
199658
199752
199851
199950
200046
200162
200244
200350
200439
200543
200648
200736
200832
200935
201030
201134
201238
201329
201431
201526
201624
201722
201828
201923
202022
202129
202217
202321
202421
202526
202619

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\" = 'MI' 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 CHI66F0486Accident · No injuriesClosedCessna 210E · Reed City, MIDec 27, 1965 · N2336F · Substantial damageNTSB CHI66F0483Accident · No injuriesClosedPiper PA-28 · Iron Mt, MIDec 19, 1965 · N8340W · Substantial damageNTSB CHI66F0477Accident · No injuriesClosedCessna 182 · Pontiac, MIDec 19, 1965 · N2156G · Substantial damageNTSB CHI66A0059Accident · No injuriesClosedCurtiss-Wrt C-46 · Detroit, MIDec 16, 1965 · N53594 · No damageNTSB CHI66F0449Accident · No injuriesClosedPiper PA-24 · Fraser, MIDec 9, 1965 · N5404P · Substantial damageNTSB CHI66F0458Accident · No injuriesClosedLuscombe 8E · Willis, MIDec 8, 1965 · N2668K · Substantial damageNTSB CHI66F0454Accident · No injuriesClosedCessna 150 · Kalamazoo, MIDec 7, 1965 · N3056J · Substantial damageNTSB CHI66F0467Accident · No injuriesClosedBeechcraft B35 · Cadillac, MIDec 6, 1965 · N5205C · Substantial damageNTSB CHI66A0055Accident · No injuriesClosedPiper PA-23 · Detroit, MIDec 6, 1965 · N5700Y · Substantial damageNTSB CHI66F0448Accident · No injuriesClosedCessna 172 · Freeland, MIDec 1, 1965 · N8861U · Substantial damageNTSB CHI66F0455Accident · No injuriesClosedPiper PA-23 · Ionia, MINov 29, 1965 · N3169P · Substantial damageNTSB CHI66F0459Accident · No injuriesClosedCessna 310B · Ypsilanti, MINov 27, 1965 · N5370A · Substantial damageNTSB CHI66F0421Accident · No injuriesClosedPiper PA-23 · Houghton Lak, MINov 27, 1965 · CF-SUY · Substantial damageNTSB CHI66F0420Accident · No injuriesClosedBeechcraft A23 · Howell, MINov 24, 1965 · N1405L · Substantial damageNTSB CHI66F0406Accident · No injuriesClosedCessna 182 · Salem, MINov 14, 1965 · N5970B · Substantial damageNTSB CHI66D0394Accident · No injuriesClosedBeechcraft 23 · Deckerville, MINov 12, 1965 · N2362Z · DestroyedNTSB CHI66F0401Accident · Serious injuriesClosedLuscombe 8A · Salem, MINov 11, 1965 · N28484 · Substantial damageNTSB CHI66F0422Accident · No injuriesClosedPiper J-3 · Laurium, MINov 7, 1965 · N40854 · Substantial damageNTSB CHI66A0045Accident · 1 fatalClosedCessna 172E · St.Joseph, MINov 7, 1965 · N3573S · DestroyedNTSB CHI66F0402Accident · No injuriesClosedPiper PA-23 · Lansing, MIOct 31, 1965 · N3138P · Substantial damageNTSB CHI66F0408Accident · No injuriesClosedCessna 140 · Houghton, MIOct 29, 1965 · N72856 · Substantial damageNTSB CHI66D0395Accident · No injuriesClosedBeechcraft D-35 · Lake Angelus, MIOct 29, 1965 · N3446B · Substantial damageNTSB CHI66F0419Accident · No injuriesClosedErcoupe 415C · Three Oaks, MIOct 26, 1965 · N2980H · Substantial damageNTSB CHI66A0042Accident · 2 fatalClosedCessna 140 · Ralph, MIOct 24, 1965 · N72146 · DestroyedNTSB CHI66F0366Accident · No injuriesClosedBeechcraft B35 · Lansing, MIOct 22, 1965 · N5233C · Substantial damageNTSB CHI66D0412Accident · No injuriesClosedCessna 210 · Detroit, MIOct 22, 1965 · N9648X · Substantial damageNTSB CHI66A0041Accident · 2 fatalClosedLear Jet 23 · Jackson, MIOct 21, 1965 · N804LJ · DestroyedNTSB CHI66F0380Accident · No injuriesClosedPiper PA-16 · Blissfield, MIOct 19, 1965 · N5900H · Substantial damageNTSB CHI66F0377Accident · 1 fatalClosedPiper J3C-65 · Saline, MIOct 16, 1965 · N30575 · DestroyedNTSB CHI66F0352Accident · No injuriesClosedCessna 182 · Pontiac, MIOct 13, 1965 · N5173D · Substantial damageNTSB CHI66F0333Accident · Minor injuriesClosedPiper PA-22 · Wixom, MIOct 10, 1965 · N8749C · Substantial damageNTSB CHI66A0034Accident · 2 fatalClosedNavion A · Beaver Isle, MIOct 9, 1965 · N8887H · DestroyedNTSB CHI66F0344Accident · No injuriesClosedNavion A · Freeland, MIOct 6, 1965 · N8574H · Substantial damageNTSB CHI66F0343Accident · No injuriesClosedPiper PA-22 · Lawrence, MIOct 5, 1965 · N834A · Substantial damageNTSB CHI66F0321Accident · No injuriesClosedAircoupe A-2 · Freeland, MIOct 5, 1965 · N6358V · Substantial damageNTSB CHI66D0365Accident · Minor injuriesClosedCessna 195 · Fraser, MIOct 2, 1965 · N9300A · Substantial damageNTSB CHI66A0031Accident · 3 fatalClosedCessna 172 · White Cloud, MISep 30, 1965 · N8413U · DestroyedNTSB CHI66F0339Accident · No injuriesClosedBeechcraft A23 · East Lansing, MISep 29, 1965 · N3530R · Substantial damageNTSB CHI66F0329Accident · No injuriesClosedStinson 108-1 · Grand Rapids, MISep 28, 1965 · N8220K · Substantial damageNTSB CHI66F0303Accident · No injuriesClosedPiper PA-28 · Muskegon, MISep 26, 1965 · N7452W · Substantial damageNTSB CHI66F0328Accident · Serious injuriesClosedPiper PA-16 · White Cloud, MISep 23, 1965 · N5668H · DestroyedNTSB CHI66F0309Accident · No injuriesClosedBeechcraft D-50 · Detroit, MISep 23, 1965 · N4948B · Substantial damageNTSB CHI66F0336Accident · No injuriesClosedAeronca 7AC · Grand Ledge, MISep 20, 1965 · N81656 · Substantial damageNTSB CHI66F0222Accident · Minor injuriesClosedPiper PA-28 · Owosso, MISep 17, 1965 · N8629W · Substantial damageNTSB CHI66F0224Accident · No injuriesClosedBeechcraft D-18S · Detroit, MISep 16, 1965 · N321D · Substantial damageNTSB CHI66F0220Accident · No injuriesClosedChampion 7FC · Flushing, MISep 16, 1965 · N8531E · Substantial damageNTSB CHI66F0196Accident · No injuriesClosedBeechcraft M-23 · White Cloud, MISep 14, 1965 · N2324Q · Substantial damageNTSB CHI66F0311Accident · Minor injuriesClosedPiper PA-28 · Saginaw, MISep 12, 1965 · N8200W · Substantial damageNTSB CHI66F0207Accident · No injuriesClosedPiper PA-22 · Flushing, MISep 6, 1965 · N2418A · 2 aircraft · Substantial damageNTSB CHI66F0304Accident · Serious injuriesClosedLuscombe 8C · Vicksburg, MISep 5, 1965 · N41908 · Substantial damage