Skip to content

NTSB investigations, MN

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.

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 MKC67D0086Accident · No injuriesClosedBeech 23 · Mankato, MNJun 28, 1966 · N8868M · Substantial damage NTSB MKC67F0035Accident · Serious injuriesClosedRyan ST-3KR · Dundas, MNJun 26, 1966 · N49049 · Substantial damage NTSB MKC67D0062Accident · No injuriesClosedNavion A · Foley, MNJun 25, 1966 · N5389K · Substantial damage NTSB MKC66A0068Accident · No injuriesClosedHughes 269A · Minnetonka, MNJun 23, 1966 · N8921F · Substantial damage NTSB MKC67F0050Accident · No injuriesClosedBeech H35 · Bloomington, MNJun 21, 1966 · N381B · Substantial damage NTSB MKC67F0049Accident · No injuriesClosedChampion 7FC · Mankato, MNJun 19, 1966 · N7544B · Substantial damage NTSB MKC67F0022Accident · Serious injuriesClosedPiper PA-28 · Robbinsdale, MNJun 15, 1966 · N7516W · Substantial damage NTSB MKC66A0065Accident · No injuriesClosedBell 47D1 · Maple Plain, MNJun 15, 1966 · N4252A · Destroyed NTSB MKC67F0017Accident · No injuriesClosedCessna 180A · Mora, MNJun 12, 1966 · N5395D · Substantial damage NTSB MKC67D0032Accident · No injuriesClosedBeech A23 · Hecotr, MNJun 12, 1966 · N1438L · Substantial damage NTSB MKC67D0024Accident · No injuriesClosedCessna 180 · Annandale, MNJun 12, 1966 · N4790B · Substantial damage NTSB MKC66A0064Accident · Minor injuriesClosedBell 47G-2 · Hector, MNJun 8, 1966 · N6716D · Substantial damage NTSB MKC66F0575Accident · No injuriesClosedCessna 172G · Park Rapids, MNMay 31, 1966 · N5942R · Substantial damage NTSB MKC67D0023Accident · No injuriesClosedAeronca 7ECA · Hutchinson, MNMay 26, 1966 · N2527F · Substantial damage NTSB MKC67D0008Accident · No injuriesClosedPiper PA-28 · Rochester, MNMay 25, 1966 · N6461W · Substantial damage NTSB MKC66F0583Accident · No injuriesClosedCessna 120 · Rosemount, MNMay 21, 1966 · N1922N · Substantial damage NTSB MKC66F0557Accident · No injuriesClosedCallair A-9 · Warroad, MNMay 21, 1966 · N3584G · Substantial damage NTSB MKC66D0545Accident · No injuriesClosedCessna 172 · Worthington, MNMay 19, 1966 · N7040T · Substantial damage NTSB MKC66A0059Accident · 3 fatalClosedAeronca 15AC · Circle Pines, MNMay 17, 1966 · N1451H · Destroyed NTSB MKC66F0549Accident · No injuriesClosedPiper PA-20 · Minnesota Lk, MNMay 8, 1966 · N6893K · Substantial damage NTSB MKC66F0546Accident · No injuriesClosedBeech A23 · Lake Elmo, MNMay 8, 1966 · N5764V · Substantial damage NTSB MKC66D0529Accident · No injuriesClosedBeech D35 · Minneapolis, MNApr 24, 1966 · N2165D · Substantial damage NTSB MKC66D0518Accident · Minor injuriesClosedChampion 7FC · White Bear Lk, MNApr 24, 1966 · N9970Y · Substantial damage NTSB MKC66A0052Accident · 1 fatalClosedPiper J3 · Withrow, MNApr 16, 1966 · N88581 · Destroyed NTSB MKC66D0532Accident · No injuriesClosedCessna 172 · Faribault, MNMar 31, 1966 · N8264B · Substantial damage NTSB MKC66D0531Accident · Minor injuriesClosedCessna 172 · Minneapolis, MNMar 31, 1966 · N8159B · Substantial damage NTSB MKC66D0507Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNMar 24, 1966 · N502UM · Substantial damage NTSB MKC66D0488Accident · No injuriesClosedAeronca 7CCM · Eveleth, MNMar 21, 1966 · N2924E · Substantial damage NTSB MKC66D0526Accident · No injuriesClosedCessna 150 · Hibbing, MNMar 14, 1966 · N5999T · Substantial damage NTSB MKC66F0482Accident · No injuriesClosedBeech 35-B33 · Lake Elmo, MNMar 12, 1966 · N9649Y · Substantial damage NTSB MKC66D0533Accident · No injuriesClosedPiper PA-28 · Hopkins, MNMar 10, 1966 · N9053J · Substantial damage NTSB MKC66F0486Accident · No injuriesClosedCessna 172 · Dexter, MNMar 8, 1966 · N5100A · Substantial damage NTSB MKC66F0497Accident · No injuriesClosedCessna U206 · Eveleth, MNFeb 27, 1966 · N2117F · Substantial damage NTSB MKC66D0493Accident · No injuriesClosedLuscombe 8A · Baudette, MNFeb 27, 1966 · N9929C · Substantial damage NTSB MKC66A0047Accident · 1 fatalClosedCessna 170B · Windom, MNFeb 27, 1966 · N2595D · Destroyed NTSB MKC66A0046Accident · 2 fatalClosedCessna 150E · Buffalo, MNFeb 27, 1966 · N3065J · Destroyed NTSB MKC66F0478Accident · Minor injuriesClosedGlobe GC-1B · White Bear Lk, MNFeb 24, 1966 · N2387B · Substantial damage NTSB MKC66F0495Accident · No injuriesClosedCessna 172 · S. St Paul, MNFeb 16, 1966 · N7824U · Substantial damage NTSB MKC66F0437Accident · No injuriesClosedPiper PA-12 · Appleton, MNFeb 16, 1966 · N2511M · Substantial damage NTSB MKC66D0483Accident · No injuriesClosedCessna 210 · Grand Rapids, MNFeb 15, 1966 · N7416E · Substantial damage NTSB MKC66D0474Accident · No injuriesClosedPiper PA-24 · Silver Lake, MNFeb 13, 1966 · N6616P · Substantial damage NTSB MKC66A0044Accident · 2 fatalClosedAeronca 7AC · W.Afton, MNFeb 13, 1966 · N82475 · Destroyed NTSB MKC66D0440Accident · No injuriesClosedCessna 150 · Coates, MNFeb 12, 1966 · N4142U · Substantial damage NTSB MKC66D0469Accident · No injuriesClosedChanpion 7FC · Hopkins, MNFeb 5, 1966 · N9072B · Substantial damage NTSB MKC66D0408Accident · No injuriesClosedCessna 172B · Litchfield, MNFeb 3, 1966 · N7436X · Substantial damage NTSB MKC66F0429Accident · No injuriesClosedPiper PA-28 · Hopkins, MNJan 30, 1966 · N6128W · Substantial damage NTSB MKC66A0041Accident · 2 fatalClosedAeronca 7CCM · Dalton, MNJan 22, 1966 · N4475E · Destroyed NTSB MKC66F0451Accident · No injuriesClosedCessna 150E · St.James, MNJan 16, 1966 · N6169T · Substantial damage NTSB MKC66A0038Accident · Serious injuriesClosedHughes 269A · Excelsior, MNJan 15, 1966 · N8865F · Destroyed NTSB MKC66A0037Accident · No injuriesClosedHughes 269A · Big Fork, MNJan 12, 1966 · N8924F · Substantial damage