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 MKC69D0125Accident · No injuriesClosedChampion 7GCAA · St.James, MNAug 16, 1968 · N9607S · Substantial damage NTSB MKC69D0113Accident · No injuriesClosedPiper PA-16 · Rush City, MNAug 14, 1968 · N5705H · Substantial damage NTSB MKC69F0088Accident · Minor injuriesClosedCessna TU206B · Anoka, MNAug 10, 1968 · N4963F · Substantial damage NTSB MKC69D0115Accident · No injuriesClosedBoeing A75 · New Richland, MNAug 8, 1968 · N54027 · Substantial damage NTSB MKC69A0009Accident · 2 fatalClosedCessna 170 · Howard Lake, MNAug 7, 1968 · N3901V · Destroyed NTSB MKC69D0103Accident · No injuriesClosedCessna 172 · Isle, MNAug 4, 1968 · N8522B · Substantial damage NTSB MKC69F0066Accident · No injuriesClosedBeech D35 · St.Paul, MNJul 30, 1968 · N3471B · Substantial damage NTSB MKC69D0059Accident · No injuriesClosedCessna 177 · Eden Prairie, MNJul 27, 1968 · N3419T · Substantial damage NTSB MKC69F0106Accident · No injuriesClosedPiper PA-25 · Ada, MNJul 26, 1968 · N7015Z · Substantial damage NTSB MKC69D0203Accident · No injuriesClosedPiper PA-14 · Pelican Rpds, MNJul 23, 1968 · N5188H · Substantial damage NTSB MKC69F0058Accident · No injuriesClosedBeech A23A · Austin, MNJul 21, 1968 · N1000J · Substantial damage NTSB MKC69F0095Accident · Minor injuriesClosedPiper J3C · Austin, MNJul 19, 1968 · N6535H · Destroyed NTSB MKC69F0061Accident · No injuriesClosedStinson 108 · Osseo, MNJul 19, 1968 · N40110 · Substantial damage NTSB MKC69F0063Accident · No injuriesClosedPiper PA-28 · Breckenridge, MNJul 15, 1968 · N4928J · Substantial damage NTSB MKC69D0067Accident · No injuriesClosedCessna 150G · St Cloud, MNJul 14, 1968 · N3252J · 2 aircraft · Substantial damage NTSB MKC69D0065Accident · No injuriesClosedCessna 150 · Waseca, MNJul 13, 1968 · N4772X · Substantial damage NTSB MKC69D0197Accident · No injuriesClosedAeronca 7AC · Alexandria, MNJul 9, 1968 · N83315 · Substantial damage NTSB MKC69D0048Accident · No injuriesClosedCessna 177 · Rushford, MNJul 6, 1968 · N30040 · Substantial damage NTSB MKC69A0001Accident · 1 fatalClosedCessna 172H · Clearwater, MNJul 5, 1968 · N2412L · Destroyed NTSB MKC69F0045Accident · No injuriesClosedAeronca 15AC · Baudette, MNJul 3, 1968 · N1289H · Substantial damage NTSB MKC69D0047Accident · No injuriesClosedBoeing A75 · Waseca, MNJun 27, 1968 · N49997 · Substantial damage NTSB MKC68A0075Accident · Minor injuriesClosedCessna 180 · Ely, MNJun 26, 1968 · N7935V · Substantial damage NTSB MKC69D0059Accident · No injuriesClosedBell 47G-2 · Guckeen, MNJun 23, 1968 · N4735S · Substantial damage NTSB MKC69F0040Accident · No injuriesClosedBeech V35 · Intl Falls, MNJun 18, 1968 · N9576Q · Substantial damage NTSB MKC68F0585Accident · No injuriesClosedPiper PA-15 · Thief Rvr Fl, MNJun 12, 1968 · CF-KNH · Substantial damage NTSB MKC69F0042Accident · Serious injuriesClosedPiper PA-18 · Lake Lillian, MNJun 9, 1968 · N1762P · Destroyed NTSB MKC69F0025Accident · No injuriesClosedChampion 7GCAA · Lake Elmo, MNJun 8, 1968 · N2626G · Substantial damage NTSB MKC69F0043Accident · No injuriesClosedCessna 310C · Cambridge, MNJun 3, 1968 · N1078Q · Substantial damage NTSB MKC69D0029Accident · No injuriesClosedMooney M20C · Grand Rapids, MNJun 1, 1968 · N5736Q · Substantial damage NTSB MKC69D0016Accident · No injuriesClosedPiper PA-28 · Dundas, MNMay 30, 1968 · N7490R · Substantial damage NTSB MKC69D0017Accident · No injuriesClosedCessna 172 · Ormsby, MNMay 28, 1968 · N6077R · Substantial damage NTSB MKC68D0583Accident · No injuriesClosedTaylorcraft BC12-D · Ivanhoe, MNMay 12, 1968 · N96530 · Substantial damage NTSB MKC68D0582Accident · No injuriesClosedCessna 180 · Rochester, MNMay 6, 1968 · N3437Y · Substantial damage NTSB MKC68D0569Accident · No injuriesClosedPiper PA-23 · Coon Rapids, MNMay 5, 1968 · N3311P · Substantial damage NTSB MKC68F0570Accident · No injuriesClosedBensen B-8 · Winsted, MNMay 4, 1968 · N1075Z · Substantial damage NTSB MKC68F0567Accident · No injuriesClosedPiper PA-22 · Buffalo, MNApr 29, 1968 · N4509A · Substantial damage NTSB MKC69D0028Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNApr 28, 1968 · N3643M · Substantial damage NTSB MKC68F0533Accident · No injuriesClosedCessna 170 · Howard Lake, MNApr 26, 1968 · N2232D · Destroyed NTSB MKC68F0532Accident · No injuriesClosedCessna 150 · Mankato, MNApr 25, 1968 · N7037X · Substantial damage NTSB MKC68F0531Accident · No injuriesClosedMooney M20B · Plainview, MNApr 25, 1968 · N74772 · Destroyed NTSB MKC68F0578Accident · No injuriesClosedCessna 150H · Rockford, MNApr 24, 1968 · N6515S · Substantial damage NTSB MKC69F0018Accident · No injuriesClosedCessna 182L · Minneapolis, MNApr 18, 1968 · N3141R · Substantial damage NTSB MKC69D0026Accident · No injuriesClosedPiper J3C-65 · St Cloud, MNApr 11, 1968 · N20149 · Substantial damage NTSB MKC68D0568Accident · No injuriesClosedCessna 172 · St.Paul, MNMar 30, 1968 · N3999S · Substantial damage NTSB MKC68F0506Accident · No injuriesClosedHughes 269B · St Paul, MNMar 28, 1968 · N9487F · Substantial damage NTSB MKC68F0495Accident · No injuriesClosedCessna 150H · Eden Prairie, MNMar 24, 1968 · N7297S · Substantial damage NTSB MKC68D0500Accident · No injuriesClosedPiper PA-28 · Wadena, MNMar 9, 1968 · N9089J · Substantial damage NTSB MKC68F0499Accident · No injuriesClosedMooney M20E · Thief R.Flls, MNMar 3, 1968 · N2639W · Substantial damage NTSB MKC68F0490Accident · No injuriesClosedCessna 182 · Circle Pines, MNFeb 25, 1968 · N5931B · Substantial damage NTSB MKC68D0493Accident · No injuriesClosedCessna 150 · Little Falls, MNFeb 15, 1968 · N3089X · Substantial damage