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 MKC66F0201Accident · No injuriesClosedCessna 140 · Robbinsdale, MNJul 29, 1965 · N77095 · Substantial damage NTSB MKC66F0226Accident · No injuriesClosedAeronca 7AC · Detroit Laks, MNJul 27, 1965 · N7146E · Substantial damage NTSB MKC66F0180Accident · No injuriesClosedCessna 172 · So St Paul, MNJul 26, 1965 · N7737U · Substantial damage NTSB MKC66F0263Accident · No injuriesClosedPiper PA-22 · Gaylord, MNJul 17, 1965 · N3265Z · Substantial damage NTSB MKC66D0203Accident · No injuriesClosedCessna 310 · Backus, MNJul 17, 1965 · N4845R · Substantial damage NTSB MKC66F0159Accident · No injuriesClosedCessna 180 · Bigfork, MNJul 16, 1965 · N3156C · Substantial damage NTSB MKC66F0158Accident · No injuriesClosedStinson 108-3 · Grand Portage, MNJul 13, 1965 · N6630M · Substantial damage NTSB MKC66F0188Accident · Minor injuriesClosedCessna 175 · Aitkin, MNJul 11, 1965 · N6831E · Substantial damage NTSB MKC66F0164Accident · No injuriesClosedPiper PA-25 · Nosseo, MNJul 11, 1965 · N6150Z · Substantial damage NTSB MKC66F0095Accident · No injuriesClosedPiper PA-30 · Maple Lake, MNJul 11, 1965 · N7235Y · Substantial damage NTSB MKC66F0157Accident · No injuriesClosedBeechcraft 23 · Litchfield, MNJul 8, 1965 · N8701M · Substantial damage NTSB MKC66F0127Accident · Minor injuriesClosedCessna 180 · Rosemount, MNJul 7, 1965 · N9416C · Substantial damage NTSB MKC66D0181Accident · No injuriesClosedPiper PA-28 · Hopkins, MNJul 7, 1965 · N6618W · Substantial damage NTSB MKC66F0267Accident · No injuriesClosedCessna 170B · Hibbing, MNJun 30, 1965 · N1678D · Substantial damage NTSB MKC66F0184Accident · No injuriesClosedPiper PA-22 · St Bonifacius, MNJun 26, 1965 · N90410 · Substantial damage NTSB MKC66F0187Accident · No injuriesClosedBeechcraft 23 · Fergus Falls, MNJun 20, 1965 · N8739M · Substantial damage NTSB MKC66F0083Accident · No injuriesClosedPiper PA-12 · Spring Valley, MNJun 17, 1965 · N7752H · Substantial damage NTSB CHI66F0072Accident · No injuriesClosedCessna 120 · Fergus Falls, MNJun 12, 1965 · N1707V · Substantial damage NTSB MKC65A0072Accident · No injuriesClosedBell 47G2 · Brooklyn Prk, MNJun 10, 1965 · N2813B · Substantial damage NTSB MKC66F0022Accident · Minor injuriesClosedPiper PA-22 · Detroit Lakes, MNJun 3, 1965 · N806A · Substantial damage NTSB MKC66F0098Accident · No injuriesClosedPiper PA-22 · Fairbault, MNMay 30, 1965 · N2621P · Substantial damage NTSB MKC66D0017Accident · No injuriesClosedCessna 140 · Lamberton, MNMay 30, 1965 · N89297 · Substantial damage NTSB MKC66F0065Accident · No injuriesClosedCessna 205 · Roseau, MNMay 29, 1965 · N8126Z · Substantial damage NTSB MKC66D0099Accident · Minor injuriesClosedCessna 140 · Ely, MNMay 28, 1965 · N72683 · Substantial damage NTSB MKC66F0033Accident · No injuriesClosedBeechcraft 95-B55 · St Paul, MNMay 25, 1965 · N8666M · Substantial damage NTSB MKC66D0039Accident · No injuriesClosedPiper PA-22 · Bemidji, MNMay 15, 1965 · N8126D · Substantial damage NTSB MKC65A0066Accident · 2 fatalClosedBeechcraft 35 · Intnl Falls, MNMay 14, 1965 · N8836A · Destroyed NTSB MKC65F0129Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNMay 3, 1965 · N501UM · Substantial damage NTSB MKC65A0065Accident · 1 fatalClosedAeronca 7AC · Hallock, MNMay 2, 1965 · N1581E · Destroyed NTSB MKC66F0007Accident · Minor injuriesClosedCessna 150 · Pine Bend, MNApr 30, 1965 · N4142U · Destroyed NTSB MKC66F0121Accident · No injuriesClosedPiper PA-24 · Dodge Center, MNApr 22, 1965 · N5186P · Substantial damage NTSB MKC66F0008Accident · No injuriesClosedBeechcraft H-35 · Redwood Falls, MNApr 17, 1965 · N7931D · Substantial damage NTSB MKC66F0006Accident · No injuriesClosedAeronca 7AC · Albert Lea, MNApr 16, 1965 · N83445 · Substantial damage NTSB MKC66D0043Accident · No injuriesClosedCessna 182 · Moose Lake, MNApr 7, 1965 · N9013X · Substantial damage NTSB MKC65F0145Accident · No injuriesClosedCessna 150 · Hopkins, MNApr 7, 1965 · N5529E · Substantial damage NTSB MKC66F0038Accident · No injuriesClosedChampion 7EC · Spring Lake, MNApr 4, 1965 · N7511E · Substantial damage NTSB MKC66F0005Accident · No injuriesClosedCessna 150 · Minneapolis, MNApr 4, 1965 · N6052T · Substantial damage NTSB MKC66F0015Accident · No injuriesClosedNavion A · Coon Rapids, MNApr 1, 1965 · N4599K · Destroyed NTSB MKC65A0056Accident · Serious injuriesClosedBell 47G3B · Edina, MNApr 1, 1965 · N73222 · Substantial damage NTSB MKC65F0108Accident · No injuriesClosedCessna 140 · Minneapolis, MNMar 30, 1965 · N72108 · Substantial damage NTSB MKC65F0092Accident · No injuriesClosedMooney M20A · Eveleth, MNMar 26, 1965 · N1075B · Substantial damage NTSB MKC65D0106Accident · No injuriesClosedCessna 182 · Hopkins, MNMar 26, 1965 · N3202S · Substantial damage NTSB MKC65F0130Accident · No injuriesClosedStinson 108-3 · St Paul, MNMar 21, 1965 · N653C · Substantial damage NTSB MKC65F0077Accident · No injuriesClosedCessna 150 · Hopkins, MNMar 21, 1965 · N4862E · Substantial damage NTSB MKC65D0063Accident · No injuriesClosedChampion 7FC · Mankato, MNMar 20, 1965 · N9988Y · Substantial damage NTSB MKC65D0082Accident · Minor injuriesClosedCessna 175 · Tyler, MNMar 18, 1965 · N9242B · Substantial damage NTSB MKC65F0085Accident · No injuriesClosedBeech C35 · Luverne, MNMar 14, 1965 · N114S · Substantial damage NTSB MKC65F0079Accident · No injuriesClosedFairchild 24W-46 · Minneapolis, MNMar 14, 1965 · N81344 · Substantial damage NTSB MKC65F0061Accident · Minor injuriesClosedBeechcraft N-35 · Maywood, MNMar 14, 1965 · N637B · Destroyed NTSB MKC65D0070Accident · Serious injuriesClosedAeronca 11BC · Grand Rapids, MNMar 12, 1965 · N86119 · Destroyed