NTSB investigations, 1981, MN

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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\") = 1981
    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 CHI81FER48Accident · No injuriesClosedCessna 172P · Thief River Fa, MNJul 1, 1981 · N52565 · Substantial damageNTSB CHI81FA069Accident · Serious injuriesClosedRockwell 680V · Minneapolis, MNJun 28, 1981 · N161XX · Substantial damageNTSB CHI81DER47Accident · No injuriesClosedBell 47G-2 · Gully, MNJun 27, 1981 · N6744D · Substantial damageNTSB CHI81DER45Accident · No injuriesClosedPiper PA-28 · Angle Inlet, MNJun 27, 1981 · N5179L · Substantial damageNTSB CHI81DER46Accident · No injuriesClosedCessna 180 · Afton, MNJun 25, 1981 · N4790B · Substantial damageNTSB CHI81FA066Accident · 1 fatalClosedPiper PA-32R · Crystal, MNJun 18, 1981 · N21594 · DestroyedNTSB CHI81DER44Accident · No injuriesClosedCessna A188 · Thief Rvr Fall, MNJun 12, 1981 · N8155V · DestroyedNTSB CHI81DER43Accident · Minor injuriesClosedCessna 188A · Wabasso, MNJun 12, 1981 · N9926G · Substantial damageNTSB CHI81FER42Accident · No injuriesClosedCallair A-9B · Hector, MNJun 6, 1981 · N7759V · DestroyedNTSB CHI81FER41Accident · No injuriesClosedCessna A188B · Villard, MNJun 3, 1981 · N91228 · Substantial damageNTSB CHI81FER39Accident · Serious injuriesClosedPiper PA-25 · Lake Elmo, MNMay 31, 1981 · N6140Z · DestroyedNTSB CHI81FER40Accident · No injuriesClosedCessna A188B · Leroy, MNMay 29, 1981 · N4797Q · Substantial damageNTSB CHI81FER38Accident · Minor injuriesClosedMcculloch J-2 · Owatonna, MNMay 21, 1981 · N18804 · DestroyedNTSB CHI81FER37Accident · No injuriesClosedPiper PA-28R · Detroit Lakes, MNMay 19, 1981 · N44767 · Substantial damageNTSB CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNMay 7, 1981 · N9207R · Substantial damageNTSB CHI81DER36Accident · No injuriesClosedGrumman G-164B · Angus, MNMay 6, 1981 · N6698K · Substantial damageNTSB CHI81FER33Accident · Minor injuriesClosedCessna 180H · Grand Rapids, MNApr 30, 1981 · N3404Y · Substantial damageNTSB CHI81FER31Accident · Minor injuriesClosedPiper PA-28 · Worthington, MNApr 13, 1981 · N43719 · DestroyedNTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNApr 10, 1981 · N6315G · DestroyedNTSB CHI81FER32Accident · No injuriesClosedPiper PA-38 · Blaine, MNApr 8, 1981 · N2359K · Substantial damageNTSB CHI81FER21Accident · No injuriesClosedCessna 195 · Redwood Falls, MNMar 22, 1981 · N1576D · Substantial damageNTSB CHI81FER29Accident · No injuriesClosedBeech E-55 · Eden Prairie, MNMar 17, 1981 · N980TK · Substantial damageNTSB CHI81FER28Accident · No injuriesClosedPiper PA-30 · Fosston, MNMar 14, 1981 · N746EM · Substantial damageNTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNMar 13, 1981 · N7823F · Substantial damageNTSB CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNMar 13, 1981 · N76028 · Substantial damageNTSB CHI81FER26Accident · No injuriesClosedPiper PA-32 · Faribault, MNMar 10, 1981 · N8157R · Substantial damageNTSB CHI81FER24Accident · No injuriesClosedCessna 210M · Ivanhoe, MNMar 8, 1981 · N6039N · Substantial damageNTSB CHI81DER25Accident · No injuriesClosedCessna 182RG · Warren, MNMar 8, 1981 · N9950C · Substantial damageNTSB CHI81DER23Accident · No injuriesClosedPiper PA-23 · Roseau, MNMar 6, 1981 · N700KC · Substantial damageNTSB CHI81FER22Accident · No injuriesClosedCessna 152 · Duluth, MNMar 4, 1981 · N6353H · Substantial damageNTSB CHI81DER19Accident · No injuriesClosedWar Corsair · Blue Earth, MNFeb 24, 1981 · N246S · Substantial damageNTSB CHI81DER20Accident · No injuriesClosedCessna 172F · Slaton, MNFeb 22, 1981 · N5639R · Substantial damageNTSB CHI81FER16Accident · Minor injuriesClosedMooney M20 · Lacrescent, MNFeb 20, 1981 · N2664W · Substantial damageNTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNFeb 15, 1981 · N2560M · Substantial damageNTSB CHI81FER14Accident · No injuriesClosedPiper PA-23 · St.Michael, MNFeb 10, 1981 · N3478P · Substantial damageNTSB CHI81DER11Accident · No injuriesClosedCessna 140A · St Cloud, MNJan 29, 1981 · N53990 · Substantial damageNTSB CHI81FER13Accident · Serious injuriesClosedPiper PA-32 · Webb Lake, MNJan 25, 1981 · N2174A · DestroyedNTSB CHI81FA023Accident · No injuriesClosedCessna U206F · Sherburne, MNJan 12, 1981 · N4291Q · Substantial damageNTSB CHI81FEX08Accident · No injuriesClosedBeech F33A · St.Paul, MNJan 3, 1981 · N17702 · Substantial damage