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 UNK64X1531Accident · Minor injuriesClosedHughes 269B · West Concord, MNApr 30, 1964 · N9326F · Destroyed NTSB UNK64X1496Accident · No injuriesClosedPiper PA24 · Howard Lake, MNApr 28, 1964 · N6293Z · Substantial damage NTSB UNK64X1481Accident · No injuriesClosedPiper PA22 · New Ulm, MNApr 27, 1964 · N1803A · Substantial damage NTSB UNK64X1459Accident · No injuriesClosedBenson B2 · Rosemount, MNApr 25, 1964 · N1076Z · Substantial damage NTSB UNK64X1453Accident · No injuriesClosedCessna 172 · Circle Pines, MNApr 25, 1964 · N9146B · Substantial damage NTSB UNK64X1448Accident · No injuriesClosedStinson 108 · Aitkin, MNApr 25, 1964 · N8545K · Substantial damage NTSB UNK64X1433Accident · No injuriesClosedCessna 170 · Tracy, MNApr 24, 1964 · N4038V · Substantial damage NTSB UNK64X1360Accident · No injuriesClosedPiper PA20 · So St Paul, MNApr 18, 1964 · N3585A · Substantial damage NTSB UNK64X1353Accident · No injuriesClosedBeechcraft 95A55 · S St Paul, MNApr 17, 1964 · N8560M · Substantial damage NTSB UNK64X1298Accident · No injuriesClosedBeechcraft M35 · Rochester, MNApr 13, 1964 · N9579R · Substantial damage NTSB UNK64X1156Accident · No injuriesClosedCessna 120 · Robbinsdale, MNApr 4, 1964 · N2888N · Substantial damage NTSB UNK64X1036Accident · No injuriesClosedCessna 172B · Winona, MNMar 25, 1964 · N7621T · Substantial damage NTSB UNK64X0998Accident · No injuriesClosedPiper PA22 · Lake Elmo, MNMar 21, 1964 · N5873Z · Substantial damage NTSB UNK64X0996Accident · No injuriesClosedAeronca 7BCM · Angle Lake, MNMar 20, 1964 · N2663E · Substantial damage NTSB UNK64X0848Accident · No injuriesClosedChampion 7FC · St Paul, MNMar 8, 1964 · N7503B · Substantial damage NTSB UNK64X0843Accident · No injuriesClosedCessna 172 · Le Sueur, MNMar 8, 1964 · N6314E · Substantial damage NTSB UNK64X0839Accident · Minor injuriesClosedAeronca 7AC · Lake Ann, MNMar 7, 1964 · N1410E · Destroyed NTSB UNK64X0776Accident · No injuriesClosedPiper PA18 · Intl Falls, MNMar 1, 1964 · N165T · Substantial damage NTSB UNK64X0741Accident · No injuriesClosedBeechcraft 35 · St Paul, MNFeb 29, 1964 · N2824V · Substantial damage NTSB UNK64X0689Accident · Minor injuriesClosedCessna 150 · Moorehead, MNFeb 25, 1964 · N7897E · Destroyed NTSB UNK64X0644Accident · No injuriesClosedBeechcraft 35 · Crystal, MNFeb 22, 1964 · N4261D · Substantial damage NTSB UNK64X0624Accident · No injuriesClosedPiper PA23 · Alexandria, MNFeb 20, 1964 · N4743P · Substantial damage NTSB UNK64X0564Accident · No injuriesClosedCessna 140 · Hopkins, MNFeb 14, 1964 · N76111 · Substantial damage NTSB UNK64X0481Accident · No injuriesClosedPiper J-3 · Delano, MNFeb 6, 1964 · N88114 · Substantial damage NTSB UNK64X0416Accident · 2 fatalClosedTaylorcraft BC12D · Henning Minn, MNFeb 1, 1964 · N96885 · Destroyed NTSB UNK64X0391Accident · Minor injuriesClosedCessna 150 · Elk River, MNJan 28, 1964 · N5755E · Substantial damage NTSB UNK64X0357Accident · Serious injuriesClosedAeronca 7BCM · Hasty, MNJan 26, 1964 · N85758 · Destroyed NTSB UNK64X0299Accident · No injuriesClosedPiper J3 · Lancaster, MNJan 19, 1964 · N40821 · Substantial damage NTSB UNK64X0286Accident · Serious injuriesClosedPiper J-3 · Albertville, MNJan 19, 1964 · N38801 · Destroyed NTSB UNK64X0233Accident · No injuriesClosedCessna 170A · Rushford, MNJan 12, 1964 · N5795C · Substantial damage NTSB UNK64X0229Accident · No injuriesClosedCessna 150 · Rosemont, MNJan 12, 1964 · N5828E · Substantial damage NTSB UNK64X0200Accident · No injuriesClosedPiper PA22 · St Paul, MNJan 9, 1964 · N915A · Substantial damage NTSB UNK64X0135Accident · No injuriesClosedBeechcraft 35 · St Paul, MNJan 3, 1964 · N419B · Substantial damage NTSB UNK64X0119Accident · Minor injuriesClosedLuscombe 8F · Excelsior, MNJan 2, 1964 · N1828B · Substantial damage