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 MKC77DER76Accident · No injuriesClosedBeech B19 · Glyndon, MNAug 12, 1977 · N6516R · Substantial damage NTSB MKC77FER75Accident · 1 fatalClosedWendt WH-1 · Lakeville, MNAug 8, 1977 · N3146 · Destroyed NTSB MKC77DER74Accident · No injuriesClosedPietenpol-A Scout · Mankato, MNAug 6, 1977 · N5987 · Substantial damage NTSB MKC77FER73Accident · No injuriesClosedGrumman G-164A · Perham, MNAug 3, 1977 · N6606 · Substantial damage NTSB MKC77FER70Accident · No injuriesClosedTayorcraft BCS-12 · Coon Lake, MNAug 1, 1977 · N94921 · Substantial damage NTSB MKC77FER72Accident · No injuriesClosedPiper PA-22 · Minneapolis, MNJul 31, 1977 · N9314D · Substantial damage NTSB MKC77FER71Accident · No injuriesClosedPiper PA-25 · Springfield, MNJul 30, 1977 · N7634Z · Substantial damage NTSB MKC77FER69Accident · No injuriesClosedRockwell S-2R · Stewartville, MNJul 29, 1977 · N75GS · Substantial damage NTSB MKC77FER68Accident · No injuriesClosedCessna A150 · Osage, MNJul 26, 1977 · N5956J · Substantial damage NTSB MKC77FER66Accident · No injuriesClosedPiper PA-22 · Thief River, MNJul 25, 1977 · N9222D · Substantial damage NTSB MKC77DER77Accident · No injuriesClosedPiper PA-18A · Battle Lake, MNJul 24, 1977 · N1190C · Substantial damage NTSB MKC77FER67Accident · No injuriesClosedBeech D18S · Bemidji, MNJul 22, 1977 · N119L · Substantial damage NTSB MKC77FER63Accident · No injuriesClosedGrumman AA-1B · Lakeville, MNJul 21, 1977 · N6298L · Substantial damage NTSB MKC77DER64Accident · No injuriesClosedCessna 150 · Staples, MNJul 19, 1977 · N10859 · Substantial damage NTSB MKC77DER62Accident · No injuriesClosedBellanca 7GCBC · Grand Lake, MNJul 17, 1977 · N68534 · Substantial damage NTSB MKC77FER61Accident · No injuriesClosedPitts S-1S · Jordan, MNJul 16, 1977 · N2997G · Substantial damage NTSB MKC77DER60Accident · No injuriesClosedCessna 180 · Grand Rapids, MNJul 15, 1977 · N7586K · Destroyed NTSB MKC77FER58Accident · No injuriesClosedBaby GRT LK S-2 · Grand Rapids, MNJul 7, 1977 · N52DS · Substantial damage NTSB MKC77FER57Accident · Minor injuriesClosedPiper PA-28 · Mazeppa, MNJul 4, 1977 · N5634U · Substantial damage NTSB MKC77DER55Accident · No injuriesClosedPiper PA-28 · Minnesota Lake, MNJul 4, 1977 · N9703W · Substantial damage NTSB MKC77FER59Accident · No injuriesClosedPiper PA-18 · Spring Grove, MNJul 3, 1977 · N83536 · Substantial damage NTSB MKC77DER54Accident · Minor injuriesClosedCessna 140 · Monticello, MNJul 1, 1977 · N1867V · Substantial damage NTSB MKC77DER56Accident · No injuriesClosedCessna U206 · Evelyth, MNJun 30, 1977 · N7347C · Substantial damage NTSB MKC77FER53Accident · No injuriesClosedPiper PA-24 · Winona, MNJun 27, 1977 · N7058P · Substantial damage NTSB MKC77FER52Accident · Serious injuriesClosedPiper PA-25 · Alexandria, MNJun 24, 1977 · N4740Y · Destroyed NTSB MKC77FA029Accident · 4 fatalClosedPiper PA-28 · Walker, MNJun 22, 1977 · N55548 · Destroyed NTSB MKC77DER50Accident · No injuriesClosedLuscombe 8E · Apple Valley, MNJun 22, 1977 · N1574K · Substantial damage NTSB MKC77FER49Accident · No injuriesClosedCessna 210 · Duluth, MNJun 19, 1977 · N176LL · Substantial damage NTSB MKC77FER48Accident · No injuriesClosedPiper PA-25 · Shevlin, MNJun 14, 1977 · N7453Z · Destroyed NTSB MKC77DER51Accident · No injuriesClosedCessna 180 · Oak Island, MNJun 12, 1977 · N5107E · Substantial damage NTSB MKC77FER46Accident · No injuriesClosedPiper PA-25 · Canby, MNJun 10, 1977 · N8784L · Substantial damage NTSB MKC77FER47Accident · Minor injuriesClosedCessna 150M · Crystal, MNJun 9, 1977 · N7562U · Substantial damage NTSB MKC77FER45Accident · No injuriesClosedPiper PA-28 · Alexandria, MNJun 4, 1977 · N8294N · Substantial damage NTSB MKC77FER44Accident · Minor injuriesClosedAeronca O-58 · Isle, MNJun 4, 1977 · N47500 · Substantial damage NTSB MKC77FER43Accident · No injuriesClosedPiper PA-28R · St. Paul, MNMay 28, 1977 · N7547J · Substantial damage NTSB MKC77FA023Accident · 4 fatalClosedPiper PA-28 · White Bear Lke, MNMay 20, 1977 · N55644 · Destroyed NTSB MKC77DER42Accident · No injuriesClosedCessna 150 · Pine City, MNMay 15, 1977 · N60541 · Substantial damage NTSB MKC77FER40Accident · Minor injuriesClosedBell 47G · Mankato, MNMay 14, 1977 · N5163B · Substantial damage NTSB MKC77FER39Accident · Serious injuriesClosedHiller Acft UH-12E · Big Lake, MNMay 2, 1977 · N155HA · Substantial damage NTSB MKC77DER37Accident · No injuriesClosedCessna A188B · Elbow Lake, MNApr 25, 1977 · N92619 · Substantial damage NTSB MKC77DER36Accident · No injuriesClosedCessna 172 · Erskine, MNApr 18, 1977 · N9252H · Substantial damage NTSB MKC77FER34Accident · Serious injuriesClosedSchweizer SGU2 · Cloquet, MNApr 17, 1977 · N2717Z · Substantial damage NTSB MKC77DER35Accident · Minor injuriesClosedLet-Np-K L-13 · Warren, MNApr 17, 1977 · N99953 · Substantial damage NTSB MKC77FER33Accident · Serious injuriesClosedCessna 172 · Terrace, MNApr 13, 1977 · N7635T · Destroyed NTSB MKC77FER31Accident · No injuriesClosedStinson SR-8C · Eveleth, MNApr 10, 1977 · N52875 · Substantial damage NTSB MKC77FER30Accident · No injuriesClosedMooney M20-F · Lake Elmo, MNApr 9, 1977 · N9378V · Substantial damage NTSB MKC77FER32Accident · No injuriesClosedPiper PA-32 · Mountain Lake, MNApr 8, 1977 · N8600N · Substantial damage NTSB MKC77DER29Accident · No injuriesClosedCessna 172 · Cambridge, MNApr 7, 1977 · N3060U · Substantial damage NTSB MKC77DER28Accident · No injuriesClosedCessna 172G · Sandstone, MNApr 7, 1977 · N4621L · Substantial damage NTSB MKC77FER27Accident · Serious injuriesClosedPiper PA-18 · Barrett, MNApr 3, 1977 · N9126D · Destroyed