Skip to content

NTSB investigations, MN

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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.

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 c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI81DER43Accident · Minor injuriesClosedCessna 188A · Wabasso, MNJun 12, 1981 · N9926G · Substantial damage NTSB CHI81FER42Accident · No injuriesClosedCallair A-9B · Hector, MNJun 6, 1981 · N7759V · Destroyed NTSB CHI81FER41Accident · No injuriesClosedCessna A188B · Villard, MNJun 3, 1981 · N91228 · Substantial damage NTSB CHI81FER39Accident · Serious injuriesClosedPiper PA-25 · Lake Elmo, MNMay 31, 1981 · N6140Z · Destroyed NTSB CHI81FER40Accident · No injuriesClosedCessna A188B · Leroy, MNMay 29, 1981 · N4797Q · Substantial damage NTSB CHI81FER38Accident · Minor injuriesClosedMcculloch J-2 · Owatonna, MNMay 21, 1981 · N18804 · Destroyed NTSB CHI81FER37Accident · No injuriesClosedPiper PA-28R · Detroit Lakes, MNMay 19, 1981 · N44767 · Substantial damage NTSB CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNMay 7, 1981 · N9207R · Substantial damage NTSB CHI81DER36Accident · No injuriesClosedGrumman G-164B · Angus, MNMay 6, 1981 · N6698K · Substantial damage NTSB CHI81FER33Accident · Minor injuriesClosedCessna 180H · Grand Rapids, MNApr 30, 1981 · N3404Y · Substantial damage NTSB CHI81FER31Accident · Minor injuriesClosedPiper PA-28 · Worthington, MNApr 13, 1981 · N43719 · Destroyed NTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNApr 10, 1981 · N6315G · Destroyed NTSB CHI81FER32Accident · No injuriesClosedPiper PA-38 · Blaine, MNApr 8, 1981 · N2359K · Substantial damage NTSB CHI81FER21Accident · No injuriesClosedCessna 195 · Redwood Falls, MNMar 22, 1981 · N1576D · Substantial damage NTSB CHI81FER29Accident · No injuriesClosedBeech E-55 · Eden Prairie, MNMar 17, 1981 · N980TK · Substantial damage NTSB CHI81FER28Accident · No injuriesClosedPiper PA-30 · Fosston, MNMar 14, 1981 · N746EM · Substantial damage NTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNMar 13, 1981 · N7823F · Substantial damage NTSB CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNMar 13, 1981 · N76028 · Substantial damage NTSB CHI81FER26Accident · No injuriesClosedPiper PA-32 · Faribault, MNMar 10, 1981 · N8157R · Substantial damage NTSB CHI81FER24Accident · No injuriesClosedCessna 210M · Ivanhoe, MNMar 8, 1981 · N6039N · Substantial damage NTSB CHI81DER25Accident · No injuriesClosedCessna 182RG · Warren, MNMar 8, 1981 · N9950C · Substantial damage NTSB CHI81DER23Accident · No injuriesClosedPiper PA-23 · Roseau, MNMar 6, 1981 · N700KC · Substantial damage NTSB CHI81FER22Accident · No injuriesClosedCessna 152 · Duluth, MNMar 4, 1981 · N6353H · Substantial damage NTSB CHI81DER19Accident · No injuriesClosedWar Corsair · Blue Earth, MNFeb 24, 1981 · N246S · Substantial damage NTSB CHI81DER20Accident · No injuriesClosedCessna 172F · Slaton, MNFeb 22, 1981 · N5639R · Substantial damage NTSB CHI81FER16Accident · Minor injuriesClosedMooney M20 · Lacrescent, MNFeb 20, 1981 · N2664W · Substantial damage NTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNFeb 15, 1981 · N2560M · Substantial damage NTSB CHI81FER14Accident · No injuriesClosedPiper PA-23 · St.Michael, MNFeb 10, 1981 · N3478P · Substantial damage NTSB CHI81DER11Accident · No injuriesClosedCessna 140A · St Cloud, MNJan 29, 1981 · N53990 · Substantial damage NTSB CHI81FER13Accident · Serious injuriesClosedPiper PA-32 · Webb Lake, MNJan 25, 1981 · N2174A · Destroyed NTSB CHI81FA023Accident · No injuriesClosedCessna U206F · Sherburne, MNJan 12, 1981 · N4291Q · Substantial damage NTSB CHI81FEX08Accident · No injuriesClosedBeech F33A · St.Paul, MNJan 3, 1981 · N17702 · Substantial damage NTSB CHI81FER10Accident · No injuriesClosedCessna 172N · Excelsior, MNDec 30, 1980 · N5623E · Substantial damage NTSB CHI81FER09Accident · No injuriesClosedBeech A23 · Stanton, MNDec 28, 1980 · N8871M · Substantial damage NTSB CHI81DER08Accident · No injuriesClosedBeech 23 · Alexandria, MNDec 8, 1980 · N2370Z · Substantial damage NTSB CHI81FA010Accident · 5 fatalClosedMitsubishi MU-2 · Ramsey, MNDec 6, 1980 · N969MA · Destroyed NTSB CHI81DER07Accident · No injuriesClosedCessna 150 · Cook, MNNov 19, 1980 · N19592 · Substantial damage NTSB CHI81DER05Accident · No injuriesClosedCessna 172 · Thief River, MNOct 30, 1980 · N3222L · Substantial damage NTSB CHI81DER06Accident · No injuriesClosedCessna 152 · Cloquet, MNOct 28, 1980 · N67996 · Substantial damage NTSB CHI81FER04Accident · Minor injuriesClosedAeronca 11AC · Clyndon, MNOct 26, 1980 · N85906 · Substantial damage NTSB CHI81FER03Accident · No injuriesClosedPiper PA-18 · Brainerd, MNOct 26, 1980 · N2466H · Substantial damage NTSB CHI80DER02Accident · No injuriesClosedPiper PA-28 · Grand Meadows, MNOct 7, 1980 · N8035N · Substantial damage NTSB CHI81FER01Accident · No injuriesClosedGreat Lakes Baby · Whitebear Lake, MNOct 4, 1980 · N6761 · Substantial damage NTSB CHI80FER69Accident · Serious injuriesClosedCameron Viva · Chaska, MNSep 27, 1980 · N72CB · Destroyed NTSB CHI80DER67Accident · No injuriesClosedPiper PA-32 · Litchfield, MNSep 12, 1980 · N3559C · Substantial damage NTSB CHI80FER59Accident · Minor injuriesClosedHughes 269C · Rockford, MNSep 7, 1980 · N7473F · Substantial damage NTSB CHI80DER58Accident · No injuriesClosedPiper PA-25 · Bingham Lake, MNSep 5, 1980 · N9785P · Substantial damage NTSB CHI80FER66Accident · No injuriesClosedCessna A188B · Garden City, MNAug 24, 1980 · N731AX · Substantial damage NTSB CHI80FER65Accident · No injuriesClosedBeech B19 · Eden Prairie, MNAug 19, 1980 · N6973R · Substantial damage NTSB CHI80FER64Accident · No injuriesClosedCessna 150 · Ogema, MNAug 10, 1980 · N8215F · Substantial damage