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 MKC79DER40Accident · No injuriesClosedPiper PA-25 · Watson, MNMay 25, 1979 · N6337Z · Substantial damage NTSB MKC79FA030Accident · 2 fatalClosedCessna 172M · Grand Marais, MNMay 22, 1979 · N1390U · Destroyed NTSB MKC79DER39Accident · No injuriesClosedCessna 180J · Grand Rapids, MNMay 21, 1979 · N112GC · Substantial damage NTSB MKC79FER44Accident · 1 fatalClosedPiper PA-25 · Gaylord, MNMay 19, 1979 · N70152 · Destroyed NTSB MKC79DER37Accident · No injuriesClosedPiper PA-28 · Glenwood, MNMay 19, 1979 · N5725U · Substantial damage NTSB MKC79DER36Accident · No injuriesClosedBeech B19 · Detroit Lakes, MNMay 18, 1979 · N23849 · Substantial damage NTSB MKC79DER38Accident · No injuriesClosedCessna 182P · Ogema, MNMay 16, 1979 · N111TP · Substantial damage NTSB MKC79DER35Accident · Minor injuriesClosedCessna 150H · Chokio, MNApr 28, 1979 · N50185 · Substantial damage NTSB MKC79DER34Accident · Minor injuriesClosedChampion 7FC · Glencoe, MNApr 17, 1979 · N7546E · Substantial damage NTSB MKC79DER33Accident · No injuriesClosedNavion H · St Cloud, MNApr 13, 1979 · N2556T · Substantial damage NTSB MKC79DER32Accident · No injuriesClosedPiper PA-22 · Hutchinson, MNApr 7, 1979 · N8052D · Substantial damage NTSB MKC79FER31Accident · No injuriesClosedCessna 152 · Eden Prairie, MNMar 21, 1979 · N65572 · Substantial damage NTSB MKC79DER30Accident · No injuriesClosedPiper PA-28R · Fergus Falls, MNMar 3, 1979 · N41731 · Substantial damage NTSB MKC79IA021Incident · No injuriesClosedBoeing B727 · Minneapolis, MNMar 2, 1979 · N2819W · Minor damage NTSB MKC79DER28Accident · No injuriesClosedCessna 152 · Blaine, MNFeb 28, 1979 · N48863 · Substantial damage NTSB MKC79FER27Accident · No injuriesClosedPiper PA-28 · Winona, MNFeb 26, 1979 · N4363F · Substantial damage NTSB MKC79DER26Accident · No injuriesClosedCessna 185 · Oak Island, MNFeb 21, 1979 · N9003H · Substantial damage NTSB MKC79FER25Accident · No injuriesClosedCessna 172 · Sabin, MNFeb 18, 1979 · N738YK · Substantial damage NTSB MKC79DER24Accident · Serious injuriesClosedPiper PA-28 · Lindstrom, MNFeb 12, 1979 · N9746K · Substantial damage NTSB MKC79DER23Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNFeb 7, 1979 · N2359D · Substantial damage NTSB MKC79FER21Accident · No injuriesClosedPiper PA-22 · Tonka Bay, MNFeb 4, 1979 · N744D · Substantial damage NTSB MKC79DER20Accident · No injuriesClosedCessna 210 · Cloquet, MNJan 29, 1979 · N3796Y · Substantial damage NTSB MKC79DER18Accident · No injuriesClosedCessna 152 · Cottage Grove, MNJan 13, 1979 · N757WE · Substantial damage NTSB MKC79FER22Accident · No injuriesClosedCessna 207 · St Paul, MNJan 4, 1979 · N1597U · Substantial damage NTSB MKC79DER16Accident · Minor injuriesClosedPiper PA-22 · Bricelyn, MNDec 26, 1978 · N7133B · Substantial damage NTSB MKC79FER15Accident · No injuriesClosedBeech F33A · Two Harbor, MNDec 24, 1978 · N9086S · Substantial damage NTSB MKC79DER14Accident · No injuriesClosedCessna 152 · St Cloud, MNDec 22, 1978 · N67338 · Substantial damage NTSB MKC79FA010Accident · Serious injuriesClosedLear Jet 25 · Minneapolis, MNDec 20, 1978 · N40SN · Destroyed NTSB MKC79DER12Accident · Minor injuriesClosedAerospatial SA315B · Hinckley, MNDec 15, 1978 · N49538 · Destroyed NTSB MKC79FER09Accident · No injuriesClosedCessna 402 · Hastings, MNDec 8, 1978 · N3600T · Substantial damage NTSB MKC79DER13Accident · No injuriesClosedCessna 152 · Grand Rapids, MNDec 8, 1978 · N757AP · Substantial damage NTSB MKC79DER17Accident · No injuriesClosedCessna 182J · Faribault, MNDec 5, 1978 · N381LA · Substantial damage NTSB MKC79DER08Accident · No injuriesClosedPiper PA-22 · Sleepy Eye, MNNov 26, 1978 · N8872D · Substantial damage NTSB MKC79DER04Accident · Minor injuriesClosedCessna 150 · Crystal, MNNov 18, 1978 · N7562U · Substantial damage NTSB MKC79FA003Accident · 1 fatalClosedCessna 310Q · Eden Prairie, MNNov 12, 1978 · N8050Q · Destroyed NTSB MKC79DER02Accident · No injuriesClosedBeech C35 · Pipestone, MNNov 2, 1978 · N5877C · Substantial damage NTSB MKC79DER03Accident · No injuriesClosedCessna 182RG · Wolverton, MNOct 21, 1978 · N3277C · Substantial damage NTSB MKC79DER11Accident · No injuriesClosedRyan PT-22 · Webster, MNOct 19, 1978 · N53148 · Substantial damage NTSB MKC78FER95Accident · Minor injuriesClosedCessna 172K · Grygla, MNSep 27, 1978 · N78368 · Substantial damage NTSB MKC78DER94Accident · Minor injuriesClosedGrumman AA-5 · Milaca, MNSep 23, 1978 · N5824L · Substantial damage NTSB MKC78DER98Accident · No injuriesClosedCessna 172 · Warren, MNSep 22, 1978 · N8976B · Substantial damage NTSB MKC78FER93Accident · No injuriesClosedGrumman AA-5A · St Paul, MNSep 20, 1978 · N9580U · Substantial damage NTSB MKC78FER96Accident · Minor injuriesClosedCessna 150 · Belle Plaine, MNSep 17, 1978 · N8241S · Destroyed NTSB MKC78DER92Accident · No injuriesClosedCessna P337H · Jacobsen, MNSep 9, 1978 · N4CZ · Substantial damage NTSB MKC78FER91Accident · Minor injuriesClosedBenson RW-B8M · Winona, MNSep 2, 1978 · N47199 · Substantial damage NTSB MKC78FER90Accident · Minor injuriesClosedCessna A188B · Clements, MNSep 2, 1978 · N70499 · Substantial damage NTSB MKC78FER97Accident · No injuriesClosedCessna 175A · White Bear Lk, MNAug 29, 1978 · N6945E · Substantial damage NTSB MKC78FA067Accident · 2 fatalClosedPiper PA-28 · St George, MNAug 26, 1978 · N43177 · Destroyed NTSB MKC78FA066Accident · 2 fatalClosedCessna 172N · Blaine, MNAug 20, 1978 · N733SD · Destroyed NTSB MKC78DER89Accident · No injuriesClosedCessna 172M · Hibbing, MNAug 20, 1978 · N9296H · Substantial damage