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 MKC76DER81Accident · No injuriesClosedAeronca 7EC · Olivia, MNJul 19, 1976 · N7592B · Substantial damage NTSB MKC76DER80Accident · No injuriesClosedCessna T210L · Pipestone, MNJul 14, 1976 · N29134 · Substantial damage NTSB MKC76DER79Accident · No injuriesClosedCessna A188B · Angus, MNJul 10, 1976 · N4779Q · Substantial damage NTSB MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MKC76DER76Accident · No injuriesClosedStarduster 2 · Eveleth, MNJul 7, 1976 · N6099 · Substantial damage NTSB MKC76AK065Accident · 1 fatalClosedCessna 150 · Thief Rv Falls, MNJul 7, 1976 · N1728Q · Destroyed NTSB MKC76DER77Accident · Minor injuriesClosedEnstron F-28 · Ortonville, MNJul 4, 1976 · N625H · Substantial damage NTSB MKC76DER75Accident · No injuriesClosedPiper PA-28R · Sauk Centre, MNJul 3, 1976 · N8405C · Substantial damage NTSB MKC76FER74Accident · No injuriesClosedVolmer VJ-22 · Fairmont, MNJul 1, 1976 · N4600 · Substantial damage NTSB MKC76DER73Accident · No injuriesClosedCessna 188 · Clearbrook, MNJun 30, 1976 · N9370R · Substantial damage NTSB CHI76FER72Accident · No injuriesClosedCessna 185 · Warroad, MNJun 22, 1976 · N2678S · Substantial damage NTSB MKC76AK062Accident · 2 fatalClosedPiper PA-18 · Rockville, MNJun 20, 1976 · N7393D · Destroyed NTSB MKC76DER71Accident · No injuriesClosedPiper PA-25 · Herman, MNJun 14, 1976 · N4444Y · Destroyed NTSB MKC76AK063Accident · Serious injuriesClosedBoeing 727 · Minneapolis, MNJun 12, 1976 · N2820W · No damage NTSB MKC76FER70Accident · No injuriesClosedCessna 188 · Baudette, MNJun 8, 1976 · N9846V · Substantial damage NTSB MKC76DER68Accident · No injuriesClosedPiper PA-31 · Baxter, MNJun 7, 1976 · N6T · Substantial damage NTSB MKC76DER69Accident · No injuriesClosedCessna 172 · Crystal, MNJun 6, 1976 · N4312L · Substantial damage NTSB MKC76FER67Accident · Minor injuriesClosedCessna 188B · Lesueur, MNJun 3, 1976 · N92325 · Substantial damage NTSB MKC76DER66Accident · Minor injuriesClosedCessna 150 · Little Fork, MNMay 30, 1976 · N6485F · Substantial damage NTSB MKC76FER64Accident · No injuriesClosedPiper PA-28 · Hawley, MNMay 8, 1976 · N55524 · Substantial damage NTSB MKC76DER63Accident · Minor injuriesClosedCessna 180J · Ada, MNApr 29, 1976 · N9965N · Substantial damage NTSB MKC76DER65Accident · No injuriesClosedWittman W-8 · Hutchinson, MNApr 26, 1976 · N5995V · Substantial damage NTSB MKC76DER62Accident · No injuriesClosedCessna 172A · Hadley, MNApr 26, 1976 · N7399T · Substantial damage NTSB MKC76FER60Accident · Serious injuriesClosedNavion B · Fergus Falls, MNApr 25, 1976 · N4207K · Substantial damage NTSB MKC76DER61Accident · Minor injuriesClosedChampion 7EC · Fertile, MNApr 25, 1976 · N9861B · Destroyed NTSB MKC76DER59Accident · No injuriesClosedCessna 172 · Grand Marais, MNApr 18, 1976 · CF-HMU · Substantial damage NTSB MKC76DER58Accident · No injuriesClosedAeronca 11AC · Sacred Heart, MNApr 18, 1976 · N86113 · Substantial damage NTSB MKC76AK052Accident · 3 fatalClosedPiper J-3 · Forest Lake, MNApr 6, 1976 · N22996 · 2 aircraft · Destroyed NTSB MKC76FER57Accident · No injuriesClosedPiper PA-28 · Blaine, MNApr 2, 1976 · N9100J · Substantial damage NTSB MKC76FER56Accident · Serious injuriesClosedCessna 150J · Rochester, MNMar 10, 1976 · N60038 · Substantial damage NTSB MKC76DER55Accident · No injuriesClosedBeech 58 · Thief Rvr Fls, MNMar 8, 1976 · N6AC · Substantial damage NTSB MKC76FER54Accident · Serious injuriesClosedNavion H · Bloomington, MNMar 1, 1976 · N2532T · Destroyed NTSB MKC76DER53Accident · No injuriesClosedPiper PA-22 · Gaylord, MNFeb 28, 1976 · N3521Z · Substantial damage NTSB MKC76AK045Accident · 4 fatalClosedBeech V35A · Forbes, MNFeb 28, 1976 · N869S · Destroyed NTSB MKC76DER52Accident · No injuriesClosedCessna 150J · Lake Elmo, MNFeb 13, 1976 · N61039 · Substantial damage NTSB MKC76AK041Accident · No injuriesClosedVolpar D18C-T · Minneapolis, MNFeb 10, 1976 · N349V · Substantial damage NTSB MKC76DER51Accident · No injuriesClosedPiper J3C-65 · Lino Lakes, MNFeb 8, 1976 · N5797N · Substantial damage NTSB MKC76DER50Accident · No injuriesClosedPiper PA-22 · Thief Riv Fls, MNFeb 1, 1976 · N1672A · Substantial damage NTSB MKC76DER48Accident · No injuriesClosedCessna 180C · Intl Falls, MNJan 28, 1976 · N9171T · Substantial damage NTSB MKC76FER49Accident · No injuriesClosedPiper PA-23 · So St Paul, MNJan 24, 1976 · N3266P · Substantial damage NTSB MKC76DER47Accident · No injuriesClosedCessna 170B · Buffalo, MNJan 24, 1976 · N4546C · Substantial damage NTSB MKC76FER45Accident · No injuriesClosedPiper PA-28R · Albert Lea, MNJan 8, 1976 · N1217T · Substantial damage NTSB MKC76DER44Accident · Minor injuriesClosedPiper PA-28 · Windom, MNDec 29, 1975 · N471XT · Substantial damage NTSB MKC76AK034Accident · 1 fatalClosedCessna 337B · St Paul, MNDec 24, 1975 · N2393S · Substantial damage NTSB MKC76AK032Accident · No injuriesClosedCessna A185F · Oak Island, MNDec 22, 1975 · N2678S · Substantial damage NTSB MKC76DER43Accident · No injuriesClosedCessna 421B · Grand Rapids, MNDec 19, 1975 · N421B · Substantial damage NTSB MKC76FER41Accident · No injuriesClosedBeech 35J · Rochester, MNNov 22, 1975 · N8397D · Substantial damage NTSB MKC76DER42Accident · No injuriesClosedCessna 180 · Bemidji, MNNov 20, 1975 · N9161C · Substantial damage NTSB MKC76DER40Accident · Minor injuriesClosedPiper PA-22 · Browerville, MNNov 18, 1975 · N2450A · Substantial damage NTSB MKC76FER39Accident · Serious injuriesClosedBeech A65 · Hibbing, MNNov 16, 1975 · N9537Q · Destroyed