NTSB investigations, MN

8 cases where NTSB found Qualification/certification.

Cases per year

20122026
NTSB investigations, MN per year, 2012–2026: 8 cases
20121
20131
20141
20151
20162
20171
20201

Latest cases

Query with SQL
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'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02031010'))
  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.

NTSB CEN20CA177Accident · Minor injuriesClass 4 · Data collectionFinal reportM-Squared Sport 1000 · Little Falls, MNThe uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain.May 5, 2020 · N7013W · Substantial damageNTSB CEN17FA361Accident · 3 fatalField investigationFinal reportCessna TR182 · Thief River Falls, MNThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, and his subsequent loss of control due to spatial disorientation.Sep 23, 2017 · N4777T · DestroyedNTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.Dec 23, 2016 · N7961F · Substantial damageNTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…May 5, 2016 · N701FP · DestroyedNTSB CEN15LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-160 · Tyler, MNThe student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.Aug 25, 2015 · N2805Z · Substantial damageNTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.Aug 2, 2014 · N4118X · Substantial damageNTSB CEN13FA214Accident · 1 fatalField investigationFinal reportCessna 152 · Hawley, MNThe noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.Mar 29, 2013 · N5367B · Substantial damageNTSB CEN12FA196Accident · 3 fatalField investigationFinal reportBeech 35 · Glencoe, MNThe non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.Mar 21, 2012 · N3871N · Substantial damage