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 MKC80DER14Accident · No injuriesClosedCessna 152 · Jackson, MNDec 4, 1979 · N24374 · Substantial damage NTSB MKC80DER13Accident · No injuriesClosedBellanca 7ECA · St James, MNNov 25, 1979 · N41689 · Substantial damage NTSB MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB MKC80DER11Accident · No injuriesClosedPiper PA-22 · Middle River, MNNov 20, 1979 · N5035Z · Substantial damage NTSB MKC80DER10Accident · No injuriesClosedCessna 421A · Crystal, MNNov 9, 1979 · N4025L · Substantial damage NTSB MKC80DER09Accident · No injuriesClosedCessna 340A · Grand Rapids, MNNov 7, 1979 · N1389G · Substantial damage NTSB MKC80IA003Incident · No injuriesClosedConvair 580 · Thief Riv Fls, MNOct 31, 1979 · N4822C · Minor damage NTSB MKC80DER08Accident · Minor injuriesClosedAeronca 7AC · Alexandria, MNOct 28, 1979 · N85121 · Substantial damage NTSB MKC80DER07Accident · No injuriesClosedCessna 182 · Taopi, MNOct 28, 1979 · N1824A · Substantial damage NTSB MKC80IA001Incident · No injuriesClosedBeech 99 · Minneapolis, MNOct 24, 1979 · N652EX · Minor damage NTSB MKC80DER06Accident · No injuriesClosedPiper PA-23 · Cold Springs, MNOct 23, 1979 · N62818 · Substantial damage NTSB MKC80FER04Accident · No injuriesClosedCessna 177 · Wheaton, MNOct 19, 1979 · N29486 · Substantial damage NTSB MKC80DER02Accident · No injuriesClosedPiper PA-28 · Eveleth, MNOct 14, 1979 · N6616W · Substantial damage NTSB MKC80DER01Accident · No injuriesClosedPiper PA-32 · Aitkin, MNOct 13, 1979 · N36815 · Substantial damage NTSB MKC79FER73Accident · No injuriesClosedCessna 140 · Thief Riv Fls, MNSep 24, 1979 · N3073N · Substantial damage NTSB MKC79DER74Accident · Minor injuriesClosedPietenpol Aircmp · Minneapolis, MNSep 21, 1979 · N25157 · Substantial damage NTSB MKC79FA055Accident · 2 fatalClosedCessna 172XP · Intl Falls, MNSep 16, 1979 · N736QH · Destroyed NTSB MKC79FER72Accident · No injuriesClosedCessna 150J · Monticello, MNSep 8, 1979 · N60321 · Substantial damage NTSB MKC79FER71Accident · Serious injuriesClosedAeronca 11AC · Lake Park, MNSep 5, 1979 · N85964 · Substantial damage NTSB MKC79DER70Accident · No injuriesClosedBell 47G-2 · St.Peter, MNSep 2, 1979 · N59H · Substantial damage NTSB MKC79DER66Accident · No injuriesClosedPiper PA-25 · Walker, MNAug 25, 1979 · N9732P · Substantial damage NTSB MKC79DER69Accident · No injuriesClosedPiper PA-32 · Minneapolis, MNAug 18, 1979 · N3641W · Substantial damage NTSB MKC80DER05Accident · No injuriesClosedGrumman G-164 · Campbell, MNAug 15, 1979 · N10214 · Substantial damage NTSB MKC79FA047Accident · 1 fatalClosedCessna 195 · Ely, MNAug 14, 1979 · N9320A · Substantial damage NTSB MKC80DER68Accident · No injuriesClosedCessna T182RG · Winsted, MNAug 11, 1979 · N737PS · Substantial damage NTSB MKC79FER62Accident · Serious injuriesClosedBoeing A75 · Austin, MNAug 11, 1979 · N62559 · Destroyed NTSB MKC79DER61Accident · No injuriesClosedBellanca 8GCBC · Federal Dam, MNAug 5, 1979 · N7695S · Substantial damage NTSB MKC79DER60Accident · No injuriesClosedPiper PA-32 · Wheaton, MNAug 3, 1979 · N9636C · Substantial damage NTSB MKC80DER65Accident · No injuriesClosedGrumman G-164A · Red Lake Falls, MNAug 2, 1979 · N8768H · Substantial damage NTSB MKC79DER58Accident · Minor injuriesClosedPiper PA-25 · Warroad, MNJul 29, 1979 · N7298Z · Substantial damage NTSB MKC79DER59Accident · No injuriesClosedCessna 152 · Brainerd, MNJul 28, 1979 · N757ZV · Substantial damage NTSB MKC79DER57Accident · Minor injuriesClosedCessna 188T · Belview, MNJul 24, 1979 · N2070J · Substantial damage NTSB MKC79DER56Accident · Minor injuriesClosedBellanca 7GCAA · Mankato, MNJul 21, 1979 · N9186L · Substantial damage NTSB MKC79DER55Accident · No injuriesClosedPiper PA-25 · Roseau, MNJul 17, 1979 · N9750P · Substantial damage NTSB MKC79DER54Accident · No injuriesClosedCessna 150 · St Cloud, MNJul 17, 1979 · N714MP · Substantial damage NTSB MKC79FA040Accident · 1 fatalClosedCessna 177 · Le Sueur, MNJul 13, 1979 · N3162T · Destroyed NTSB MKC79FER53Accident · No injuriesClosedPiper PA-31T · Eveleth, MNJul 12, 1979 · N6192A · Substantial damage NTSB MKC79FER52Accident · Serious injuriesClosedPiper PA-38 · St.Paul, MNJul 7, 1979 · N4324E · Destroyed NTSB MKC79FA038Accident · 2 fatalClosedAeronca 7AC · Eveleth, MNJul 4, 1979 · N84906 · Destroyed NTSB MKC79FER63Accident · No injuriesClosedHughes 269C · Willmar, MNJul 2, 1979 · N7448F · Substantial damage NTSB MKC79FER51Accident · Serious injuriesClosedCessna A188B · Donaldson, MNJun 28, 1979 · N8239G · Substantial damage NTSB MKC79FER50Accident · No injuriesClosedPiper PA-25 · Hutchinson, MNJun 27, 1979 · N7634 · Substantial damage NTSB MKC79FA036Accident · 1 fatalClosedGrumman AA-1B · Clearwater, MNJun 17, 1979 · N1459R · Destroyed NTSB MKC79DER49Accident · No injuriesClosedScorpion II · St.Paul, MNJun 11, 1979 · N711RJ · Substantial damage NTSB MKC79FER48Accident · Minor injuriesClosedCessna 177 · Longville, MNJun 10, 1979 · N34471 · Substantial damage NTSB MKC79FER47Accident · No injuriesClosedCessna 185 · Eden Prairie, MNJun 9, 1979 · N4328R · Substantial damage NTSB MKC79DER46Accident · Minor injuriesClosedCessna 175 · Fosston, MNJun 8, 1979 · N26LM · Substantial damage NTSB MKC79DER45Accident · No injuriesClosedLuscombe 8A · Rush City, MNJun 3, 1979 · N45813 · Destroyed NTSB MKC79DER44Accident · No injuriesClosedCessna 188 · Gully, MNMay 31, 1979 · N9709G · Substantial damage NTSB MKC79DER42Accident · Minor injuriesClosedPiper PA-36 · Sabin, MNMay 26, 1979 · N3958E · Substantial damage