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 MKC70F0078Accident · Minor injuriesClosedVolmer VJ-22 · Excelsior, MNJul 4, 1969 · N9471 · Destroyed NTSB MKC70D0091Accident · No injuriesClosedCessna 182 · Duluth, MNJul 3, 1969 · N42224 · Substantial damage NTSB MKC70D0211Accident · Serious injuriesClosedPiper PA-14 · Pelican Rpds, MNJun 28, 1969 · N4290H · Destroyed NTSB MKC70D0088Accident · No injuriesClosedAeronca S15AC · Aitkin, MNJun 28, 1969 · N1417H · Substantial damage NTSB MKC70D0070Accident · Minor injuriesClosedCessna 172 · Austin, MNJun 26, 1969 · N46522 · Substantial damage NTSB MKC70D0025Accident · No injuriesClosedPiper PA-24 · Dora Lake, MNJun 22, 1969 · N5186P · Substantial damage NTSB MKC70D0056Accident · Serious injuriesClosedCessna P206 · Intrnatl Fls, MNJun 19, 1969 · N8642Z · Destroyed NTSB MKC69A0062Accident · 1 fatalClosedTaylorcraft BC12-D · Biwabik, MNJun 15, 1969 · N96276 · Substantial damage NTSB MKC70D0058Accident · No injuriesClosedPiper PA-18 · Wheaton, MNJun 14, 1969 · N7181D · Substantial damage NTSB MKC70D0024Accident · No injuriesClosedCessna 140 · Buffalo, MNJun 14, 1969 · N4280N · Substantial damage NTSB MKC70F0036Accident · No injuriesClosedPiper PA-25 · Halstad, MNJun 13, 1969 · N6991Z · Substantial damage NTSB MKC70F0035Accident · No injuriesClosedCessna 188 · Thief R Fall, MNJun 13, 1969 · N8107V · Destroyed NTSB MKC70F0011Accident · Minor injuriesClosedPiper PA-28 · Delano, MNJun 13, 1969 · N505UM · Substantial damage NTSB MKC70D0101Accident · No injuriesClosedCessna 180 · Little Falls, MNJun 13, 1969 · N1731C · Substantial damage NTSB MKC70D0057Accident · No injuriesClosedCessna 172I · Ely, MNJun 12, 1969 · N8425L · Substantial damage NTSB MKC70F0022Accident · Minor injuriesClosedCessna 172 · Bagley, MNJun 9, 1969 · N2596Y · Substantial damage NTSB MKC70F0049Accident · No injuriesClosedCessna 180 · Westport, MNJun 8, 1969 · N3293D · Substantial damage NTSB MKC70F0152Accident · No injuriesClosedAeronca 7EC · Breckenridge, MNJun 6, 1969 · N84432 · Substantial damage NTSB MKC70D0023Accident · Serious injuriesClosedCessna 180 · N.West Angle, MNJun 4, 1969 · N2479F · Destroyed NTSB MKC70D0012Accident · No injuriesClosedAeronca 7DC · Long Prairie, MNMay 25, 1969 · N4516E · Substantial damage NTSB MKC70F0009Accident · No injuriesClosedCessna 320F · Eden Prairie, MNMay 24, 1969 · N6152Q · Substantial damage NTSB MKC70D0010Accident · No injuriesClosedCessna 150 · Rush City, MNMay 18, 1969 · N3199J · Substantial damage NTSB MKC70D0008Accident · No injuriesClosedCessna 180 · Grand Marais, MNMay 18, 1969 · N3130D · Substantial damage NTSB MKC69A0059Accident · 2 fatalClosedBeech 95-D55 · St.Paul Park, MNMay 17, 1969 · N7119N · Destroyed NTSB MKC69A0058Accident · 1 fatalClosedPiper PA-28 · Detroit Lake, MNMay 8, 1969 · N9510W · Destroyed NTSB MKC69D0440Accident · No injuriesClosedPiper PA-18A · Downer, MNMay 5, 1969 · N9066D · Substantial damage NTSB MKC69D0455Accident · No injuriesClosedCessna 177 · Silver Lake, MNMay 4, 1969 · N2218Y · Substantial damage NTSB MKC69F0419Accident · Minor injuriesClosedJodel D-9 · Forest Lake, MNMay 3, 1969 · N12075 · Substantial damage NTSB MKC69D0433Accident · No injuriesClosedAeronca LB-65 · Wh.Bear Lake, MNApr 29, 1969 · N33756 · Substantial damage NTSB MKC69F0451Accident · No injuriesClosedCessna 172 · Pequot Lakes, MNApr 26, 1969 · N8688B · Substantial damage NTSB MKC69D0426Accident · No injuriesClosedBensen B-8M · Lino Lakes, MNApr 26, 1969 · N8322 · Substantial damage NTSB MKC69D0422Accident · No injuriesClosedCessna 140 · Willmar, MNApr 19, 1969 · N3577V · Substantial damage NTSB MKC69F0410Accident · Minor injuriesClosedBell 47G-2 · Red Wing, MNApr 18, 1969 · N6729D · Substantial damage NTSB MKC69A0056Accident · No injuriesClosedPiper PA-23 · St Cloud, MNApr 13, 1969 · N4141W · Substantial damage NTSB MKC69D0408Accident · No injuriesClosedAeronca 7AC · Silver Bay, MNApr 12, 1969 · N1830E · Substantial damage NTSB MKC69F0421Accident · No injuriesClosedBell 47G-2 · Rosemount, MNApr 11, 1969 · N6716D · Substantial damage NTSB MKC69F0432Accident · No injuriesClosedHughes 269B · St Paul, MNApr 10, 1969 · N9486F · Destroyed NTSB MKC69F0398Accident · Minor injuriesClosedHughes 269A · Burnsville, MNApr 10, 1969 · N8921F · Destroyed NTSB MKC69D0425Accident · No injuriesClosedBeech C50 · Mankato, MNApr 7, 1969 · N515Q · Substantial damage NTSB MKC69D0403Accident · No injuriesClosedCessna 177A · Lake Elmo, MNApr 7, 1969 · N30388 · Substantial damage NTSB MKC69D0382Accident · No injuriesClosedCessna 182 · Minneapolis, MNApr 2, 1969 · N2100R · Substantial damage NTSB MKC69D0386Accident · No injuriesClosedCessna 172 · Pine River, MNMar 25, 1969 · N6842X · Substantial damage NTSB MKC69D0362Accident · No injuriesClosedAeronca 7AC · Roseau, MNMar 21, 1969 · N2974E · Substantial damage NTSB MKC69D0368Accident · No injuriesClosedCessna 150 · Grand Rapids, MNMar 17, 1969 · N8585G · Substantial damage NTSB MKC69F0354Accident · Minor injuriesClosedCessna 182 · St.Paul, MNMar 7, 1969 · N5424B · Substantial damage NTSB MKC69A0052Accident · Minor injuriesClosedPiper PA-23 · Windom, MNMar 6, 1969 · N6470Y · Substantial damage NTSB MKC69D0384Accident · No injuriesClosedMooney M20C · Rosemount, MNMar 5, 1969 · N9747M · Substantial damage NTSB MKC69D0363Accident · No injuriesClosedCessna 180 · Eveleth, MNMar 2, 1969 · N8611X · Substantial damage NTSB MKC69D0415Accident · No injuriesClosedBensen B-8M · Cloquet, MNMar 1, 1969 · N1361 · Substantial damage NTSB MKC69F0357Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNFeb 26, 1969 · N502UM · Substantial damage