NTSB investigations, 1976, MI

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1976, 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\") = 1976
    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 CHI77FEC08Accident · No injuriesClosedCessna 150 · Pontiac, MIDec 30, 1976 · N10090 · Substantial damageNTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MIDec 29, 1976 · N2791L · Substantial damageNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MIDec 29, 1976 · N411EF · DestroyedNTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MIDec 19, 1976 · N99258 · DestroyedNTSB CHI77FEM13Accident · No injuriesClosedCessna 421B · Bellaire, MIDec 12, 1976 · N421TC · Substantial damageNTSB CHI77FEM12Accident · Serious injuriesClosedCessna 310 · Saginaw, MINov 28, 1976 · N6931L · DestroyedNTSB CHI77FEC05Accident · Minor injuriesClosedLuscombe 8F · Manchester, MINov 27, 1976 · N1339B · Substantial damageNTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINov 26, 1976 · N246BS · DestroyedNTSB CHI77DEC06Accident · No injuriesClosedPiper PA-28 · Hadley, MINov 25, 1976 · N5120W · Substantial damageNTSB CHI77DEC04Accident · No injuriesClosedPiper PA-28 · Utica, MINov 19, 1976 · N2676T · Substantial damageNTSB CHI77FEM10Accident · 1 fatalClosedScorpion 2 · Alston, MINov 16, 1976 · N63301 · Substantial damageNTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINov 11, 1976 · N74941 · DestroyedNTSB CHI77FEM09Accident · No injuriesClosedPiper PA-28R · Harbor Springs, MINov 5, 1976 · N3759T · Substantial damageNTSB CHI77FEC03Accident · No injuriesClosedCessna 205 · Utica, MIOct 28, 1976 · N8326Z · Substantial damageNTSB CHI77FEM08Accident · No injuriesClosedCessna 150L · Sparta, MIOct 25, 1976 · N17236 · DestroyedNTSB CHI77FEC02Accident · No injuriesClosedBellanca 17-30 · Flint, MIOct 24, 1976 · N7341V · Substantial damageNTSB CHI77FEC01Accident · No injuriesClosedHughes 369HS · Pickney, MIOct 21, 1976 · N9213F · Substantial damageNTSB CHI77FEM11Accident · No injuriesClosedSwearingen SA26T · Clare, MIOct 20, 1976 · N30W · Substantial damageNTSB CHI77DEC09Incident · No injuriesClosedCessna 172 · Detroit, MIOct 11, 1976 · N1895Y · Minor damageNTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MIOct 3, 1976 · N10747 · Substantial damageNTSB CHI77FEM04Accident · Serious injuriesClosedNavion A · St. James, MIOct 3, 1976 · N4491K · DestroyedNTSB CHI77FEM01Accident · No injuriesClosedJeanies Teenie · Frankfort, MIOct 2, 1976 · N519S · DestroyedNTSB UNK77X0100Accident · Minor injuriesClosedPiper PA-22 · Coral, MIOct 1, 1976 · N3438A · Substantial damageNTSB CHI77FEM05Accident · No injuriesClosedBeech B23 · Ironwood, MIOct 1, 1976 · N721RT · Substantial damageNTSB CHI77FEM03Accident · No injuriesClosedCessna 172 · Watersmeet, MIOct 1, 1976 · N35672 · Substantial damageNTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MISep 20, 1976 · N2080C · DestroyedNTSB CHI76FEC66Accident · No injuriesClosedPiper PA-28 · New Hudson, MISep 20, 1976 · N3601R · Substantial damageNTSB CHI76FEM61Accident · No injuriesClosedCessna 172M · Gobles, MISep 19, 1976 · N1279U · Substantial damageNTSB CHI76FEC65Accident · Minor injuriesClosedCessna 150H · Willis, MISep 19, 1976 · N50203 · Substantial damageNTSB CHI76DEM60Accident · No injuriesClosedWeilbuilt WB-4 · Thomas City, MISep 19, 1976 · N788 · DestroyedNTSB CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MISep 18, 1976 · N6108M · Substantial damageNTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MISep 16, 1976 · N8330N · DestroyedNTSB CHI76FEC62Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MISep 13, 1976 · N56619 · Substantial damageNTSB CHI76FEM63Accident · No injuriesClosedBeech D-17S · Mt Pleasant, MISep 12, 1976 · N5400N · Substantial damageNTSB CHI76FEC63Accident · No injuriesClosedPiper PA-32 · Romeo, MISep 12, 1976 · N3895W · Substantial damageNTSB CHI76FEC61Accident · Minor injuriesClosedAeronca 7AC · Owosso, MISep 12, 1976 · N85749 · Substantial damageNTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MISep 11, 1976 · N87943 · Substantial damageNTSB CHI76FEM59Accident · Minor injuriesClosedPiper PA-22 · Delton, MISep 11, 1976 · N5505Z · Substantial damageNTSB CHI76FEC60Accident · No injuriesClosedBeech V35B · Troy, MISep 7, 1976 · N1861W · Substantial damageNTSB CHI76DEM64Accident · No injuriesClosedOsprey I · Vicksburg, MISep 6, 1976 · N2RC · Substantial damageNTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MISep 5, 1976 · N6580M · Substantial damageNTSB CHI76DEM57Accident · No injuriesClosedSchemp SH1 · Lansing, MISep 5, 1976 · N12052 · Substantial damageNTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MISep 5, 1976 · N16109 · Substantial damageNTSB CHI76FEM62Accident · Minor injuriesClosedPiper PA-28 · Gaylord, MISep 4, 1976 · N98053 · Substantial damageNTSB CHI76FEC59Accident · No injuriesClosedCessna 172M · Pontiac, MISep 4, 1976 · N73566 · Substantial damageNTSB CHI76FEC57Accident · No injuriesClosedCessna 172 · Flint, MIAug 29, 1976 · N8285U · Substantial damageNTSB CHI76FEC58Accident · No injuriesClosedCessna 180 · Salem, MIAug 28, 1976 · N3104D · Substantial damageNTSB CHI76AC087Accident · No injuriesClosedSwearingen SA226 · Detroit, MIAug 24, 1976 · N538S · Substantial damageNTSB CHI76DEC56Accident · No injuriesClosedPiper PA-28 · Mason, MIAug 23, 1976 · N75248 · Substantial damageNTSB CHI76FEM55Accident · No injuriesClosedAero Comdr 500 · Hastings, MIAug 22, 1976 · N8457C · Destroyed