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 MKC78DER88Accident · No injuriesClosedStoppelman PDQ-2 · Winsted, MNAug 19, 1978 · N83836 · Substantial damage NTSB MKC79DER86Accident · No injuriesClosedCessna 421B · Crystal, MNAug 10, 1978 · N110SW · 2 aircraft · Minor damage NTSB MKC78DA061Accident · No injuriesClosedSikorsky S-64 · Buffalo, MNAug 8, 1978 · N4036S · No damage NTSB MKC79FER85Accident · Minor injuriesClosedPiper PA-28 · Washington Cy, MNAug 7, 1978 · N461FT · Substantial damage NTSB MKC78FER84Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNAug 5, 1978 · N6291A · Substantial damage NTSB MKC78DER82Accident · No injuriesClosedCessna 172M · Rosemount, MNAug 5, 1978 · N80631 · Substantial damage NTSB MKC78DER83Accident · No injuriesClosedCessna 180B · Eveleth, MNAug 4, 1978 · N5273E · Substantial damage NTSB MKC78DER87Accident · No injuriesClosedCessna 150G · Lester Prairie, MNAug 3, 1978 · N4681X · Substantial damage NTSB MKC78FER81Accident · Serious injuriesClosedHughes 369HS · Sauk Centre, MNJul 28, 1978 · N9199F · Destroyed NTSB MKC78DER80Accident · No injuriesClosedAmer Avco AA-5B · Cook, MNJul 28, 1978 · N28335 · Substantial damage NTSB MKC78FER77Accident · No injuriesClosedCassutt 3-M · Cloquet, MNJul 25, 1978 · N71MM · Substantial damage NTSB MKC78DER78Accident · No injuriesClosedAeronca 7AC · Brandon, MNJul 25, 1978 · N81534 · Substantial damage NTSB MKC78DER76Accident · No injuriesClosedCessna 172 · Wilmar, MNJul 23, 1978 · N19951 · Substantial damage NTSB MKC79FER75Accident · Minor injuriesClosedPiper PA-22 · Jasper, MNJul 16, 1978 · N9749D · Substantial damage NTSB MKC78FER74Accident · 1 fatalClosedJ Lowers T-WIND · Fergus Falls, MNJul 14, 1978 · N195J · Destroyed NTSB MKC78DER73Accident · No injuriesClosedCessna 152 · Anoka, MNJul 14, 1978 · N757CN · Substantial damage NTSB MKC78FA055Accident · 6 fatalClosedBeech 60 · Faribault, MNJul 12, 1978 · N777HH · Substantial damage NTSB MKC78FER68Accident · Serious injuriesClosedLuscombe 8E · Webster, MNJul 9, 1978 · N1715K · Substantial damage NTSB MKC78FER67Accident · Minor injuriesClosedCessna 180J · Goodland, MNJul 8, 1978 · N9993N · Substantial damage NTSB MKC78DER71Accident · No injuriesClosedSchleicher K8B · Stanton, MNJul 8, 1978 · N221L · Substantial damage NTSB MKC78FER69Accident · No injuriesClosedCessna 172 · Ada, MNJul 6, 1978 · N12240 · Substantial damage NTSB MKC78FER70Accident · Minor injuriesClosedCessna T210L · Merrifield, MNJul 1, 1978 · N2090L · Destroyed NTSB MKC78FER66Accident · Serious injuriesClosedPiper PA-25 · Corvuso, MNJun 30, 1978 · N7334Z · Destroyed NTSB MKC78DER64Accident · No injuriesClosedBoeing A-75 · Felton, MNJun 28, 1978 · N5413N · Destroyed NTSB MKC78FER63Accident · Minor injuriesClosedWeatherly 201C · Angus, MNJun 26, 1978 · N1297W · Destroyed NTSB MKC78DER60Accident · No injuriesClosedPiper PA-28 · St James, MNJun 22, 1978 · N9622J · Substantial damage NTSB MKC78FER59Accident · No injuriesClosedCessna 210 · St Paul, MNJun 18, 1978 · N711TM · Substantial damage NTSB MKC78DER65Accident · Minor injuriesClosedSchweizer 2-33 · White Bear Lk, MNJun 18, 1978 · N2462W · Substantial damage NTSB MKC78DER62Accident · No injuriesClosedCessna 172 · Ely, MNJun 18, 1978 · N7813U · Substantial damage NTSB MKC79DER57Accident · No injuriesClosedPiper PA-25 · Mahnomen, MNJun 16, 1978 · N7739Z · Substantial damage NTSB MKC78DER40Accident · No injuriesClosedStinson 108-2 · Minneapolis, MNJun 15, 1978 · N916D · Substantial damage NTSB MKC78FER56Accident · No injuriesClosedAero-Comdr A9-B · Stephen, MNJun 13, 1978 · N7263V · Destroyed NTSB MKC78FA048Accident · 1 fatalClosedPiper PA-28 · Albert Lea, MNJun 13, 1978 · N40891 · Destroyed NTSB MKC78DER54Accident · No injuriesClosedPiper PA-28 · Belle Plaine, MNJun 13, 1978 · N9062K · Substantial damage NTSB MKC78FER53Accident · No injuriesClosedPiper PA-12 · St Cloud, MNJun 11, 1978 · N3138M · Substantial damage NTSB MKC78FA045Accident · 2 fatalClosedCessna 170B · Isle, MNJun 4, 1978 · N4602C · Destroyed NTSB MKC78DER52Accident · No injuriesClosedCessna 150 · St Cloud, MNJun 2, 1978 · N63124 · Substantial damage NTSB MKC78DER51Accident · No injuriesClosedPiper PA-25 · Ada, MNJun 2, 1978 · N9629P · Substantial damage NTSB MKC78DER50Accident · No injuriesClosedPiper PA-28 · Belle Plaine, MNJun 2, 1978 · N75327 · Substantial damage NTSB MKC78FA041Accident · 4 fatalClosedBeech 35-B33 · Harris, MNMay 29, 1978 · N1320Z · Destroyed NTSB MKC78DER47Accident · Minor injuriesClosedPiper PA-25 · Warren, MNMay 27, 1978 · N6816Z · Substantial damage NTSB MKC78DER48Accident · Minor injuriesClosedCessna 172M · Halstad, MNMay 26, 1978 · N64223 · Substantial damage NTSB MKC79FER46Accident · No injuriesClosedBoeing E-75 · Perham, MNMay 23, 1978 · N5269N · Destroyed NTSB MKC78FER49Accident · Serious injuriesClosedPiper PA-28R · Warroad, MNMay 23, 1978 · N7487J · Destroyed NTSB MKC78FA039Accident · 1 fatalClosedCessna 402B · Alexandria, MNMay 19, 1978 · N87143 · Destroyed NTSB MKC78FER44Accident · No injuriesClosedAero Comdr 100 · E Grand Forks, MNMay 18, 1978 · N4088X · Substantial damage NTSB MKC78FER55Accident · No injuriesClosedPiper PA-24 · Hutchinson, MNMay 17, 1978 · N5251P · Substantial damage NTSB MKC78FER45Accident · Minor injuriesClosedBell 47G-2A · Arden Hills, MNMay 17, 1978 · N7578 · Destroyed NTSB MKC78DER43Accident · No injuriesClosedCessna 185 · Eveleth, MNMay 3, 1978 · N1076F · 2 aircraft · Substantial damage NTSB MKC78FER41Accident · Serious injuriesClosedBeech A23-19 · Inver Grv Hts, MNApr 30, 1978 · N6972Q · Substantial damage