NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 CHI67A0082Accident · Minor injuriesClosedBeech C-45G · Detroit, MIDec 29, 1966 · N21454 · Substantial damageNTSB CHI67F0401Accident · No injuriesClosedPiper PA-22 · Onsted, MIDec 26, 1966 · N4849Z · Substantial damageNTSB CHI67F0413Accident · No injuriesClosedBeech 35 · Grand Rapids, MIDec 22, 1966 · N2820V · Substantial damageNTSB CHI67F0387Accident · No injuriesClosedPiper PA-24 · Ann Arbor, MIDec 22, 1966 · N6102P · Substantial damageNTSB CHI67F0411Accident · No injuriesClosedCessna 310D · Muskegon, MIDec 19, 1966 · N6890T · Substantial damageNTSB CHI67A0080Accident · No injuriesClosedBeech B95-B · Detroit, MIDec 19, 1966 · N9494S · Substantial damageNTSB CHI67A0079Accident · No injuriesClosedBeech D18S · Grand Rapids, MIDec 19, 1966 · N25Q · Substantial damageNTSB CHI67F0396Accident · No injuriesClosedBeech 35-33 · Saginaw, MIDec 18, 1966 · N109VW · DestroyedNTSB CHI67F0424Accident · No injuriesClosedBeech H35 · Reed City, MIDec 16, 1966 · N8210D · Substantial damageNTSB CHI67F0425Accident · No injuriesClosedPiper PA-23 · Muskegon, MIDec 13, 1966 · N4194P · DestroyedNTSB CHI67A0074Accident · 1 fatalClosedBensen B8-M · Dowagiac, MIDec 12, 1966 · N24133 · DestroyedNTSB CHI67F0388Accident · No injuriesClosedPiper PA-28 · Plymouth, MIDec 11, 1966 · N7503W · Substantial damageNTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MIDec 11, 1966 · N3178X · Substantial damageNTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damageNTSB CHI67F0392Accident · Serious injuriesClosedPiper J5A · Houghton, MIDec 10, 1966 · N32787 · DestroyedNTSB CHI67F0410Accident · No injuriesClosedBeech 95-C55 · Frankfort, MIDec 3, 1966 · N824CP · Substantial damageNTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MIDec 2, 1966 · N6041R · Substantial damageNTSB CHI67F0368Accident · Serious injuriesClosedPiper PA-17 · Stanton, MINov 27, 1966 · N4671H · Substantial damageNTSB CHI67F0365Accident · Minor injuriesClosedCessna U206 · Holly, MINov 27, 1966 · N2184F · Substantial damageNTSB CHI67F0355Accident · No injuriesClosedPiper PA-22 · Adrian, MINov 26, 1966 · N5081Z · 2 aircraft · Substantial damageNTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINov 26, 1966 · N226AA · DestroyedNTSB CHI67A0066Accident · 2 fatalClosedPiper PA-18 · Cassopolis, MINov 20, 1966 · N1997A · DestroyedNTSB CHI67F0382Accident · Serious injuriesClosedPiper PA-22 · Lewiston, MINov 18, 1966 · N3261Z · Substantial damageNTSB CHI67F0348Accident · No injuriesClosedBeech 95-A55 · Jackson, MINov 16, 1966 · N9333S · Substantial damageNTSB CHI67D0390Accident · No injuriesClosedPiper PA-23 · Gladwin, MINov 16, 1966 · N4264P · Substantial damageNTSB CHI67F0340Accident · No injuriesClosedAeronca 65-TAC · Plainwell, MINov 12, 1966 · N36940 · Substantial damageNTSB CHI67F0332Accident · Minor injuriesClosedPietenpol Camper · Plymouth, MINov 7, 1966 · N4062C · Substantial damageNTSB CHI67F0339Accident · No injuriesClosedPiper PA-28 · Battle Creek, MINov 6, 1966 · N6639W · Substantial damageNTSB CHI67F0335Accident · No injuriesClosedBeech B35 · Astings, MINov 5, 1966 · N5220C · Substantial damageNTSB CHI67A0062Accident · Serious injuriesClosedCessna 310 · New Boston, MINov 5, 1966 · N310M · DestroyedNTSB CHI67F0344Accident · No injuriesClosedLear Jet 23A · Ypsilanti, MINov 2, 1966 · N428EJ · Substantial damageNTSB CHI67D0552Accident · No injuriesClosedBellanca 14-19 · Eaton Rapids, MIOct 31, 1966 · N8535R · Substantial damageNTSB CHI67F0351Accident · No injuriesClosedBellanca 14-19 · Pontiac, MIOct 30, 1966 · N416MB · Substantial damageNTSB CHI67A0058Accident · Minor injuriesClosedHughes 269B · Pontiac, MIOct 29, 1966 · N9464F · Substantial damageNTSB CHI67F0315Accident · Minor injuriesClosedFairchild 24K · Plymouth, MIOct 28, 1966 · N20614 · Substantial damageNTSB CHI67F0297Accident · No injuriesClosedLuscombe 8A · Gaines, MIOct 27, 1966 · N1429K · DestroyedNTSB CHI67F0314Accident · No injuriesClosedPiper PA28 · Troy, MIOct 25, 1966 · N7495R · Substantial damageNTSB CHI67F0333Accident · No injuriesClosedHelio H-250 · Lushing, MIOct 22, 1966 · N5460E · Substantial damageNTSB CHI67F0305Accident · No injuriesClosedCessna 310D · Pontiac, MIOct 21, 1966 · N6864T · Substantial damageNTSB CHI67F0256Accident · No injuriesClosedCessna 150 · Ypsilanti, MIOct 20, 1966 · N1929Z · Substantial damageNTSB CHI67F0290Accident · Serious injuriesClosedMeyers 200-B · East Jordan, MIOct 13, 1966 · N34394 · Substantial damageNTSB CHI67F0287Accident · No injuriesClosedBeech D18S · Muskegon, MIOct 13, 1966 · N86K · Substantial damageNTSB CHI67A0052Accident · No injuriesClosedViscount V-745D · Muskegon, MIOct 13, 1966 · N7408 · Substantial damageNTSB CHI70A0049Accident · 4 fatalClosedStinson 108-1 · Hudson, MIOct 9, 1966 · N8984K · DestroyedNTSB CHI67F0272Accident · No injuriesClosedWaco UPF-7 · Midland, MIOct 9, 1966 · N32133 · Substantial damageNTSB CHI67F0238Accident · No injuriesClosedAeronca 11AC · Greenville, MIOct 9, 1966 · N9808E · Substantial damageNTSB CHI67A0050Accident · 6 fatalClosedPiper PA-32 · Dowagiac, MIOct 9, 1966 · N3279W · DestroyedNTSB CHI67F0263Accident · No injuriesClosedCessna 180 · La Salle, MIOct 8, 1966 · N9115C · Substantial damageNTSB CHI67F0375Accident · No injuriesClosedCessna 182 · Beaver Isl., MIOct 6, 1966 · N6161B · Substantial damageNTSB CHI67D0253Accident · No injuriesClosedPiper PA-22 · Sharon, MIOct 1, 1966 · N3330A · Substantial damage