NTSB investigations, 1964, MI

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

19622026
NTSB investigations, 1964, 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\") = 1964
    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 UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MIDec 30, 1964 · N608Z · DestroyedNTSB UNK65X1169Accident · No injuriesClosedBeechraft P35 · Allegan, MIDec 28, 1964 · N9532Y · Substantial damageNTSB UNK65X1155Accident · Minor injuriesClosedBeechraft 35 · Waterford, MIDec 27, 1964 · N2741V · DestroyedNTSB UNK65X1150Accident · 4 fatalClosedBellanca 14-13 · Detroit, MIDec 26, 1964 · N86878 · DestroyedNTSB UNK65X1145Accident · Serious injuriesClosedLuscombe 8A · Grand Haven, MIDec 26, 1964 · N1038K · DestroyedNTSB UNK65X1051Accident · No injuriesClosedBeechraft C45H · Harbor Sprgs, MIDec 19, 1964 · N431P · Substantial damageNTSB UNK65X1040Accident · No injuriesClosedTaylorcraft BC12D · Charlotte, MIDec 18, 1964 · N5066M · Substantial damageNTSB UNK65X1037Accident · No injuriesClosedBeechraft D18S · Muskegon, MIDec 17, 1964 · N57G · Substantial damageNTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MIDec 8, 1964 · N5673E · Substantial damageNTSB UNK65X0891Accident · No injuriesClosedErcoupe 415C · Big Rapids, MINov 30, 1964 · N99710 · Substantial damageNTSB UNK65X0873Accident · No injuriesClosedBeechcraft 35-B33 · Pontiac, MINov 28, 1964 · N7960K · Substantial damageNTSB UNK65X0838Accident · No injuriesClosedPiper J3 · Clinton, MINov 26, 1964 · N87749 · DestroyedNTSB UNK65X0832Accident · No injuriesClosedPiper PA24 · Hillsdale, MINov 25, 1964 · N8183P · Substantial damageNTSB UNK65X0791Accident · No injuriesClosedPiper PA22 · Allegan, MINov 22, 1964 · N1525P · Substantial damageNTSB UNK65X0768Accident · No injuriesClosedCurtiss C-46A · Inkster, MINov 20, 1964 · N3971B · DestroyedNTSB UNK65X0762Accident · No injuriesClosedCessna 172 · Cedar Lake, MINov 20, 1964 · N5769A · DestroyedNTSB UNK65X0757Accident · No injuriesClosedArgosy AW-650 · Gwinn, MINov 19, 1964 · N660Z · Substantial damageNTSB UNK65X0747Accident · No injuriesClosedCessna 150 · Detroit, MINov 17, 1964 · N1222Y · Substantial damageNTSB UNK65X0727Accident · 4 fatalClosedPiper PA22 · Beaverton, MINov 15, 1964 · N2553P · DestroyedNTSB UNK65X0714Accident · No injuriesClosedAeronca 11AC · Ontanagon, MINov 15, 1964 · N3264E · Substantial damageNTSB UNK65X0679Accident · No injuriesClosedCanadair CL-44 · Detroit, MINov 12, 1964 · N454T · Substantial damageNTSB UNK65X0676Accident · No injuriesClosedCessna 172E · Detroit, MINov 12, 1964 · CF-PUP · Substantial damageNTSB UNK65X0674Accident · Minor injuriesClosedStinson 108-1 · Greenville, MINov 12, 1964 · N8945K · Substantial damageNTSB UNK65X0568Accident · No injuriesClosedStinson 10 · Troy, MINov 5, 1964 · N26216 · Substantial damageNTSB UNK65X0520Accident · Serious injuriesClosedChampion 7AC · Schoolcraft, MINov 1, 1964 · N85282 · Substantial damageNTSB UNK65X0512Accident · No injuriesClosedMooney M20C · Lansing, MINov 1, 1964 · N6480U · Substantial damageNTSB UNK65X0505Accident · Serious injuriesClosedPiper PA22 · Plymouth, MIOct 31, 1964 · N8844C · Substantial damageNTSB UNK65X0453Accident · No injuriesClosedMooney M2OC · Bay City, MIOct 27, 1964 · N6214U · Substantial damageNTSB UNK65X0446Accident · No injuriesClosedPiper PA24 · Detroit, MIOct 26, 1964 · N5978P · Substantial damageNTSB UNK65X0416Accident · No injuriesClosedBeechraft D18S · Ypsilanti, MIOct 25, 1964 · N29X · Substantial damageNTSB UNK65X0410Accident · No injuriesClosedBeechcraft G35 · Ann Arbor, MIOct 24, 1964 · N934D · Substantial damageNTSB UNK65X0402Accident · No injuriesClosedCessna 175 · East Tawas, MIOct 24, 1964 · N6646E · Substantial damageNTSB UNK65X0382Accident · Serious injuriesClosedBell 47G2A · Battle Creek, MIOct 22, 1964 · N8458E · DestroyedNTSB UNK65X0329Accident · No injuriesClosedCessna 140 · Houghton, MIOct 18, 1964 · N72856 · Substantial damageNTSB UNK65X0301Accident · Serious injuriesClosedMooney M20C · Birmingham, MIOct 16, 1964 · N6542U · DestroyedNTSB UNK65X0273Accident · No injuriesClosedGrumman G164 · Milan, MIOct 14, 1964 · N10239 · Substantial damageNTSB UNK65X0229Accident · No injuriesClosedMaule M4 · Plymouth, MIOct 11, 1964 · N4704T · Substantial damageNTSB UNK65X0175Accident · No injuriesClosedPiper PA22 · Plymouth, MIOct 7, 1964 · N7412D · Substantial damageNTSB UNK64X4159Accident · Minor injuriesClosedNavion · Tawas City, MISep 26, 1964 · N85408 · Substantial damageNTSB UNK64X4037Accident · No injuriesClosedBeechcraft B95 · Sault St Marie, MISep 18, 1964 · N169Y · Substantial damageNTSB UNK64X3965Accident · No injuriesClosedMooney M20E · Reed City, MISep 13, 1964 · N6532U · Substantial damageNTSB UNK64X3957Accident · 3 fatalClosedMooney M20 · Waterford, MISep 13, 1964 · N6521B · DestroyedNTSB UNK64X3900Accident · No injuriesClosedCessna 172 · Detroit, MISep 10, 1964 · N3661S · Substantial damageNTSB UNK64X3797Accident · Minor injuriesClosedPiper PA22 · Saline, MISep 5, 1964 · N5506Z · DestroyedNTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MIAug 29, 1964 · N2981N · Substantial damageNTSB UNK64X3627Accident · No injuriesClosedCessna 172 · Birmingham, MIAug 27, 1964 · N9174B · Substantial damageNTSB UNK64X3613Accident · No injuriesClosedArgosy AW-650 · Oscoda, MIAug 26, 1964 · N600Z · Substantial damageNTSB UNK64X3610Accident · No injuriesClosedNavion B · Grand Haven, MIAug 26, 1964 · N5275K · Substantial damageNTSB UNK64X3604Accident · No injuriesClosedPiper PA12 · Marenisco, MIAug 26, 1964 · N78565 · Substantial damageNTSB UNK64X3575Accident · No injuriesClosedPiper PA12 · Plymouth, MIAug 24, 1964 · N3719M · Substantial damage