Skip to content

NTSB investigations, MN

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MKC72DER18Accident · Minor injuriesClosedBell 47G-5 · Blomkist, MNAug 25, 1971 · N7840S · Destroyed NTSB ANC72AK014Accident · 3 fatalClosedFairchild 24W46 · Lino Lakes, MNAug 15, 1971 · N81344 · Destroyed NTSB MKC72FER17Accident · Minor injuriesClosedPiper PA-25 · E Grnd Forks, MNAug 14, 1971 · N7300Z · Substantial damage NTSB MKC72AK013Accident · 2 fatalClosedEnstrom F-28A · Osseo, MNAug 13, 1971 · N2525M · Destroyed NTSB MKC72FER16Accident · No injuriesClosedBoeing A75N1 · Waseca, MNAug 12, 1971 · N64514 · Destroyed NTSB MKC72FER15Accident · No injuriesClosedBellanca 14-13 · Effie, MNAug 11, 1971 · N86787 · Substantial damage NTSB MKC72FER14Accident · 1 fatalClosedPiper PA-18 · Rosemont, MNAug 8, 1971 · N4187Z · Destroyed NTSB MKC72AK011Accident · 2 fatalClosedAeronca 7BCM · Shakopee, MNAug 7, 1971 · N2772E · Destroyed NTSB MKC72FERI2Accident · Serious injuriesClosedAeronca 15AC · Warroad, MNAug 4, 1971 · N1443H · Destroyed NTSB MKC72DER11Accident · No injuriesClosedChampion 7GC · Hibbing, MNAug 2, 1971 · N8578E · Substantial damage NTSB MKC72FER08Accident · Minor injuriesClosedPiper PA-28 · New Ulm, MNJul 27, 1971 · N7435R · Substantial damage NTSB MKC72FER09Accident · Minor injuriesClosedPiper PA-28 · Ponsford, MNJul 25, 1971 · N9770J · Substantial damage NTSB MKC72DER07Accident · No injuriesClosedCessna 150 · Princeton, MNJul 22, 1971 · N3653J · Substantial damage NTSB MKC72FER10Accident · Minor injuriesClosedCessna 182B · Eden Prairie, MNJul 21, 1971 · N2470G · Substantial damage NTSB MKC72AK007Accident · 2 fatalClosedGlobe GC-1B · St.Paul, MNJul 21, 1971 · N3792K · Destroyed NTSB MKC72DER06Accident · No injuriesClosedGlobe GC-1B · Big Fork, MNJul 8, 1971 · N80613 · Substantial damage NTSB MKC72DER13Accident · No injuriesClosedCessna 170B · Tyler, MNJul 5, 1971 · N2798D · Substantial damage NTSB MKC72FER03Accident · Serious injuriesClosedCessna 150 · Shevlin, MNJul 4, 1971 · N2846S · Substantial damage NTSB MKC72DER04Accident · No injuriesClosedPiper PA-28 · Wheaton, MNJul 4, 1971 · N3826T · Substantial damage NTSB MKC72FER02Accident · 1 fatalClosedBensen B-8M · Anoka, MNJul 3, 1971 · N5680 · Destroyed NTSB MKC72FER05Accident · No injuriesClosedPiper PA-30 · Eden Prairie, MNJul 1, 1971 · N8626Y · Substantial damage NTSB MKC72DER01Accident · No injuriesClosedPiper J3C · Rapidan, MNJul 1, 1971 · N3675K · Substantial damage NTSB MKC71FER77Accident · Minor injuriesClosedCommonwlth 8135 · Royalton, MNJun 27, 1971 · N25552 · Substantial damage NTSB MKC71DER75Accident · No injuriesClosedCessna 172H · Brainerd, MNJun 18, 1971 · N8271L · Substantial damage NTSB MKC71DER74Accident · Minor injuriesClosedBell 47G2 · Franklin, MNJun 15, 1971 · N13298 · Substantial damage NTSB MKC71FER72Accident · Serious injuriesClosedCessna 150 · Browerville, MNJun 13, 1971 · N6922S · Substantial damage NTSB MKC71DER76Accident · No injuriesClosedSchweizer 1-26 · Hayfield, MNJun 13, 1971 · N8603R · Substantial damage NTSB MKC71DER78Accident · Serious injuriesClosedPiper PA-18 · Ortonville, MNJun 12, 1971 · N1667P · Substantial damage NTSB MKC71FER71Accident · 1 fatalClosedPiper PA-18 · Barnesville, MNJun 8, 1971 · N6186D · Destroyed NTSB MKC71FER69Accident · No injuriesClosedHughes 269A · Montevideo, MNJun 6, 1971 · N8925F · Substantial damage NTSB MKC71FER68Accident · No injuriesClosedPiper PA-28S · Roseville, MNJun 5, 1971 · N4974L · Substantial damage NTSB MKC71DER70Accident · No injuriesClosedCessna 170B · Lakeville, MNJun 5, 1971 · N2568C · Substantial damage NTSB MKC71FER67Accident · No injuriesClosedChampion 7GC · Windom, MNJun 2, 1971 · N9607S · Substantial damage NTSB MKC71FER66Accident · Serious injuriesClosedBeech E35 · Park Rapids, MNMay 31, 1971 · N19FF · Destroyed NTSB MKC71FER65Accident · Serious injuriesClosedCessna 182F · Benson, MNMay 31, 1971 · N3604U · Destroyed NTSB MKC71DER64Accident · No injuriesClosedPiper PA-25 · Hallock, MNMay 29, 1971 · N7406Z · Substantial damage NTSB MKC71FER62Accident · Serious injuriesClosedAero Comdr 560 · Hibbing, MNMay 19, 1971 · N445TK · Destroyed NTSB MKC71FER63Accident · Minor injuriesClosedCessna 180E · Lutsen, MNMay 17, 1971 · N2666Y · Substantial damage NTSB MKC71FER59Accident · Serious injuriesClosedNavion A · Minneapolis, MNMay 8, 1971 · N91426 · Substantial damage NTSB MKC71FER60Accident · No injuriesClosedCessna 180 · Little Fork, MNMay 7, 1971 · N9186C · Substantial damage NTSB MKC71DER61Accident · No injuriesClosedBoeing B75N1 · Rosemont, MNMay 4, 1971 · N4871N · Substantial damage NTSB MKC71FDM58Accident · No injuriesClosedCessna 185 · Breezy Point, MNApr 22, 1971 · N9881X · Substantial damage NTSB MKC71FDM55Accident · No injuriesClosedPiper PA-28 · Oklee, MNApr 11, 1971 · N3284R · Substantial damage NTSB MKC71FDM54Accident · No injuriesClosedPiper PA-24 · Minneapolis, MNApr 10, 1971 · N5530P · Substantial damage NTSB MKC71FDM56Accident · No injuriesClosedCulver Cadet · Faribault, MNApr 7, 1971 · N41725 · Substantial damage NTSB MKC71FDM53Accident · No injuriesClosedCessna 150J · St Paul, MNApr 5, 1971 · N50930 · Substantial damage NTSB MKC71FDM51Accident · No injuriesClosedCessna 150G · Clear Lake, MNMar 29, 1971 · N8671J · Substantial damage NTSB MKC71FDM52Accident · No injuriesClosedCessna 140 · Lake Elmo, MNMar 28, 1971 · N89459 · Substantial damage NTSB MKC71FDM50Accident · Minor injuriesClosedAero Comdr 100 · Vineland, MNMar 26, 1971 · N5503M · Destroyed NTSB MKC71FDD22Accident · No injuriesClosedCessna 172 · Detroit Lks, MNMar 14, 1971 · N8607B · Substantial damage