OpenAirDocs.org

NTSB investigations, MN

298 cases where the phase of flight was Takeoff.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 300)
  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 CEN26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-25-235 · Forest Lake, MNOn July 4, 2026, about 0942 central daylight time, a Piper PA-25-235 airplane, N386AB, was substantially damaged when it was involved in an accident near Forest Lake, Minnesota. The pilot was not injured. The airplane was operated as a Title 14 Code of…Jul 4, 2026 · N386AB · Substantial damageNTSB CEN24LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna A185E · Eveleth, MNWater contamination of the fuel system which resulted in a total loss of engine power. Contributing was the pilot’s inadequate preflight.Aug 14, 2024 · N2248T · Substantial damageNTSB CEN24LA273Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Blaine, MNThe airplane’s collision with a deer on the runway during takeoff.Jul 16, 2024 · N220CE · Substantial damageNTSB CEN24LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Duluth, MNThe failure of the left engine induction coupling during takeoff, which resulted in a total loss of left engine power and an uncommanded left yaw/roll due to asymmetrical thrust and increased drag, from which the pilot had insufficient altitude to recover…Jun 27, 2024 · N5080J · Substantial damageNTSB CEN24LA138Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Aitkin, MNThe student pilot’s failure to maintain directional control during the takeoff in crosswind conditions.Mar 18, 2024 · N788JN · Substantial damageNTSB CEN23LA346Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Halstad, MNThe pilot’s attempt to rotate the airplane without sufficient airspeed which resulted in a lack of climb performance and impact with terrain. Contributing to the accident was the pilot’s decision to attempt the takeoff with a tailwind.Aug 2, 2023 · N45453 · Substantial damageNTSB CEN23LA182Accident · No injuriesClass 3 · LimitedFinal reportLoehle Acft 5151 Mustang · Hector, MNA total loss of engine power due to fuel starvation as a result of the pilot’s modifications to the fuel system. Contributing to the accident was the pilot’s decision to continue the takeoff despite observing lower than anticipated propeller rpm, his decision…May 11, 2023 · N91026 · Substantial damageNTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.Feb 25, 2023 · N208SP · Substantial damageNTSB CEN23LA110Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado II · Windom, MNThe fatigue failure of the right landing gear leg that resulted in its separation from the airplane during takeoff.Feb 18, 2023 · N9168P · Substantial damageNTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damageNTSB WPR23LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fergus Falls, MNThe pilot’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion.Dec 4, 2022 · N926HM · Substantial damageNTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.Aug 10, 2022 · N73194 · Substantial damageNTSB CEN22LA348Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sturgeon Lake, MNThe pilot’s failure to maintain directional control during takeoff from a gravel driveway resulting in an impact with a tree.Jul 29, 2022 · N42584 · Substantial damageNTSB CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.Jan 29, 2022 · N2923E · Substantial damageNTSB CEN21LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Faribault, MNThe student pilot’s failure to maintain control during takeoff in gusty wind conditions and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with trees and subsequently the ground.Apr 22, 2021 · N7114C · Substantial damageNTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.Oct 2, 2020 · N62ZM · Substantial damageNTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.Aug 15, 2020 · N2510H · DestroyedNTSB CEN20LA207Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Duluth, MNThe pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.Jun 3, 2020 · N838BA · Substantial damageNTSB CEN20CA188Accident · No injuriesClass 4 · Data collectionFinal reportCessna R172 · Lino Lakes, MNThe pilot's loss of directional control during takeoff with a crosswind.May 20, 2020 · N612R · Substantial damageNTSB 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 CEN20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Rush City, MNThe total loss of engine power due to fuel starvation because the student pilot failed to reposition the fuel mixture control to full rich before takeoff.Dec 21, 2019 · N9646Q · Substantial damageNTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Oct 27, 2019 · N2621P · DestroyedNTSB CEN18LA332Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Westbrook, MNA runway excursion during takeoff for reasons that could not be determined based on the available evidence.Aug 15, 2018 · N5521X · Substantial damageNTSB CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.Oct 18, 2017 · N50609 · Substantial damageNTSB CEN17LA304Accident · Serious injuriesLimited investigationFinal reportRoger M Allen RA2 · Hector, MNThe pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight.Aug 6, 2017 · N952RA · Substantial damageNTSB CEN17LA238Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Mahnomen, MNThe pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…Jun 21, 2017 · N2558E · Substantial damageNTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.Aug 17, 2016 · N631TK · Substantial damageNTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.Aug 14, 2016 · N50437 · Substantial damageNTSB GAA16CA293Accident · No injuriesData collectionFinal reportBell 47G · Hastings, MNThe pilot's failure to attain a positive rate of climb during takeoff from a service truck, which resulted in an impact with terrain and substantial damage to the tail boom and fuselage.Jun 8, 2016 · N25LB · Substantial damageNTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.Nov 13, 2015 · N717AT · Substantial damageNTSB 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 CEN15LA309Accident · No injuriesLimited investigationFinal reportCessna 172RG · Anoka, MNFailure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.Jul 17, 2015 · N6511V · Substantial damageNTSB CEN15CA304Accident · No injuriesData collectionFinal reportCessna 340 · South St. Paul, MNThe airplane's inability to takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies. The aborted takeoff resulted in a runway overrun and impact with a fence.Jul 12, 2015 · N5139J · Substantial damageNTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…Mar 28, 2015 · N30341 · Substantial damageNTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.Sep 7, 2014 · N622MC · 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 CEN14LA320Accident · No injuriesLimited investigationFinal reportCessna 172XP · St. Cloud, MNThe pilot's failure to maintain the proper airspeed and angle-of-attack after a partial loss of engine power on takeoff, which resulted in a stall and the subsequent impact with water. Contributing to the accident was the partial loss of engine power due to…Jun 20, 2014 · N758HP · Substantial damageNTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.Mar 9, 2014 · N4764B · Substantial damageNTSB CEN14CA156Accident · No injuriesData collectionFinal reportOlson Kenneth H T Zodiac 601 HDS · Garrison, MNThe pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.Mar 8, 2014 · N981HT · Substantial damageNTSB CEN14LA028Accident · 1 fatalLimited investigationFinal reportPiper PA 22-150 · Princeton, MNThe pilot's loss of airplane control during takeoff.Oct 28, 2013 · N4803A · DestroyedNTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.Jul 14, 2013 · N855F · Substantial damageNTSB CEN12CA278Accident · No injuriesData collectionFinal reportGalloway/Ward RV-4 · Redwood Falls, MNThe pilot’s failure to maintain control of the airplane during takeoff in gusty wind conditions.May 3, 2012 · N102GW · Substantial damageNTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.Aug 29, 2011 · N73712 · Substantial damageNTSB CEN11CA600Accident · No injuriesData collectionFinal reportCessna 182C · Grand Marais, MNThe pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.Aug 27, 2011 · N9011T · Substantial damageNTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Mar 16, 2011 · N2816Z · Substantial damageNTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.Jan 29, 2011 · N7195B · Substantial damageNTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.Sep 3, 2010 · N333HK · Substantial damageNTSB CEN10CA354Accident · No injuriesData collectionFinal reportCessna 175 · Brainerd, MNThe pilot's loss of airplane control while taking off with gusting wind.Jun 27, 2010 · N7691M · Substantial damageNTSB CEN10LA064Accident · Serious injuriesLimited investigationFinal reportKrusmark David Homer Searey · St. Paul, MNThe pilot's delay in aborting the takeoff during the takeoff roll when he became aware of the engine not producing full power.Nov 28, 2009 · N4031 · Minor damageNTSB CEN10LA002Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Rosemount, MNThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Oct 3, 2009 · N70585 · Substantial damage