NTSB investigations, 1980, MN

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19642026
NTSB investigations, 1980, MN per year, 1964–2026: 3,233 cases
1964113
1965115
1966117
1967130
196895
1969113
197088
197180
197282
197377
197483
197598
197678
197792
197898
197976
198066
198189
198261
198368
198451
198557
198643
198740
198852
198950
199042
199159
199225
199340
199439
199537
199640
199737
199836
199933
200039
200140
200246
200340
200432
200531
200629
200725
200831
200929
201032
201128
201228
201333
201424
201515
201626
201720
201814
201916
202026
202112
202224
202334
202424
202522
202613

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\") = 1980
    AND c.\"eventStateOrRegion\" = 'MN' 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 CHI81FER10Accident · No injuriesClosedCessna 172N · Excelsior, MNDec 30, 1980 · N5623E · Substantial damageNTSB CHI81FER09Accident · No injuriesClosedBeech A23 · Stanton, MNDec 28, 1980 · N8871M · Substantial damageNTSB CHI81DER08Accident · No injuriesClosedBeech 23 · Alexandria, MNDec 8, 1980 · N2370Z · Substantial damageNTSB CHI81FA010Accident · 5 fatalClosedMitsubishi MU-2 · Ramsey, MNDec 6, 1980 · N969MA · DestroyedNTSB CHI81DER07Accident · No injuriesClosedCessna 150 · Cook, MNNov 19, 1980 · N19592 · Substantial damageNTSB CHI81DER05Accident · No injuriesClosedCessna 172 · Thief River, MNOct 30, 1980 · N3222L · Substantial damageNTSB CHI81DER06Accident · No injuriesClosedCessna 152 · Cloquet, MNOct 28, 1980 · N67996 · Substantial damageNTSB CHI81FER04Accident · Minor injuriesClosedAeronca 11AC · Clyndon, MNOct 26, 1980 · N85906 · Substantial damageNTSB CHI81FER03Accident · No injuriesClosedPiper PA-18 · Brainerd, MNOct 26, 1980 · N2466H · Substantial damageNTSB CHI80DER02Accident · No injuriesClosedPiper PA-28 · Grand Meadows, MNOct 7, 1980 · N8035N · Substantial damageNTSB CHI81FER01Accident · No injuriesClosedGreat Lakes Baby · Whitebear Lake, MNOct 4, 1980 · N6761 · Substantial damageNTSB CHI80FER69Accident · Serious injuriesClosedCameron Viva · Chaska, MNSep 27, 1980 · N72CB · DestroyedNTSB CHI80DER67Accident · No injuriesClosedPiper PA-32 · Litchfield, MNSep 12, 1980 · N3559C · Substantial damageNTSB CHI80FER59Accident · Minor injuriesClosedHughes 269C · Rockford, MNSep 7, 1980 · N7473F · Substantial damageNTSB CHI80DER58Accident · No injuriesClosedPiper PA-25 · Bingham Lake, MNSep 5, 1980 · N9785P · Substantial damageNTSB CHI80FER66Accident · No injuriesClosedCessna A188B · Garden City, MNAug 24, 1980 · N731AX · Substantial damageNTSB CHI80FER65Accident · No injuriesClosedBeech B19 · Eden Prairie, MNAug 19, 1980 · N6973R · Substantial damageNTSB CHI80FER64Accident · No injuriesClosedCessna 150 · Ogema, MNAug 10, 1980 · N8215F · Substantial damageNTSB CHI80FER61Accident · No injuriesClosedCessna P206 · Blaine, MNAug 2, 1980 · N4741F · DestroyedNTSB CHI80FER63Accident · Minor injuriesClosedCessna 188 · Long Prairie, MNAug 1, 1980 · N8024V · Substantial damageNTSB CHI80DER62Accident · No injuriesClosedGrumman G-164B · E.Grand Forks, MNAug 1, 1980 · N6515K · DestroyedNTSB CHI80FER60Accident · 1 fatalClosedCassutt · Winona, MNJul 26, 1980 · N89MC · DestroyedNTSB CHI80FER56Accident · Serious injuriesClosedBellanca 7GCBC · Duluth, MNJul 11, 1980 · N2612Z · Substantial damageNTSB CHI80FER57Accident · No injuriesClosedPiper PA-34 · Albert Lea, MNJul 10, 1980 · N7021C · Substantial damageNTSB CHI80FER54Accident · No injuriesClosedMooney M20 · Blaine, MNJul 9, 1980 · N5228B · Substantial damageNTSB CHI80DER52Accident · Minor injuriesClosedBell OH-13 · Bixby, MNJul 5, 1980 · N67083 · Substantial damageNTSB CHI80FER55Accident · 1 fatalClosedCassutt 111M · Warren, MNJul 4, 1980 · N10TD · DestroyedNTSB CHI80DER53Accident · No injuriesClosedCessna 172 · Fosston, MNJul 2, 1980 · N12565 · Substantial damageNTSB CHI80FER50Accident · Minor injuriesClosedBell OH-13H · Olivia, MNJun 23, 1980 · N51862 · DestroyedNTSB CHI80FA048Accident · 4 fatalClosedBeech A35 · Angle Inlet, MNJun 20, 1980 · N188Q · DestroyedNTSB CHI80FER51Accident · No injuriesClosedCessna A185F · Ely, MNJun 18, 1980 · N7611Q · DestroyedNTSB CHI80FER49Accident · 1 fatalClosedPiper PA-25 · Grove City, MNJun 16, 1980 · N6444Z · DestroyedNTSB CHI80DER48Accident · Serious injuriesClosedPiper PA-28 · Tower, MNJun 14, 1980 · N4774L · Substantial damageNTSB CHI80FER47Accident · Minor injuriesClosedPiper PA-25 · Hector, MNJun 9, 1980 · N4826Y · Substantial damageNTSB CHI80DER46Accident · No injuriesClosedCessna 188A · Grygla, MNJun 5, 1980 · N2279U · Substantial damageNTSB CHI80FER44Accident · Minor injuriesClosedHughes 269C · Dexter, MNJun 3, 1980 · N7482F · DestroyedNTSB CHI80DER43Accident · No injuriesClosedHughes 269C · Willmar, MNJun 1, 1980 · N7448F · Substantial damageNTSB CHI80FER41Accident · Minor injuriesClosedBeech B19 · Mankato, MNMay 23, 1980 · N24669 · Substantial damageNTSB CHI80FA041Accident · 4 fatalClosedCessna 172K · Big Fork, MNMay 23, 1980 · N64368 · DestroyedNTSB CHI80DA044Accident · 1 fatalClosedCessna 150 · St Paul, MNMay 23, 1980 · N11960 · No damageNTSB CHI80FER40Accident · No injuriesClosedCessna 210 · Minneapolis, MNMay 18, 1980 · N732XM · Substantial damageNTSB CHI80DER39Accident · No injuriesClosedCessna 152 · Minneapolis, MNMay 10, 1980 · N67993 · Substantial damageNTSB CHI80FER42Accident · No injuriesClosedAeronca 7AC · Mora, MNMay 7, 1980 · N3737E · Substantial damageNTSB CHI80FER38Accident · No injuriesClosedPiper PA-22 · Hoffman, MNMay 2, 1980 · N1495A · Substantial damageNTSB MKC80FER37Accident · Serious injuriesClosedFly Baby BWM-10 · Waubun, MNApr 26, 1980 · N1081Z · Substantial damageNTSB MKC80DER33Accident · No injuriesClosedBeech C23 · Eveleth, MNApr 20, 1980 · N6996R · Substantial damageNTSB MKC80DER34Accident · No injuriesClosedCessna 185 · Eveleth, MNApr 19, 1980 · N4220Q · Substantial damageNTSB MKC80DER35Accident · No injuriesClosedCessna 150 · Rushford, MNApr 18, 1980 · N19588 · Substantial damageNTSB MKC80DER36Accident · No injuriesClosedCessna 180 · Battle Lake, MNApr 12, 1980 · N3397D · Substantial damageNTSB MKC80FA030Accident · 2 fatalClosedCessna 340A · Minneapolis, MNApr 8, 1980 · N98547 · Destroyed