NTSB investigations, MN
99 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 6 |
| 2015 | 2 |
| 2016 | 9 |
| 2017 | 7 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 9 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 2 |
Where
Open the mapLatest 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\", '0303'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB CEN26LA158Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Luverne, MNThe pilot’s failure to maintain directional control during a gusting crosswind landing, and the flight instructor’s delayed remedial action.NTSB CEN25LA375Accident · Minor injuriesClass 4 · LimitedFinal reportJust Highlander · Forest Lake, MNThe pilot’s failure to maintain directional control of the airplane during a gusty crosswind landing.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA360Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Shakopee, MNThe pilots’ failure to apply carburetor heat during the descent, which resulted in a loss of power on both engines due to carburetor ice.NTSB CEN24LA168Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Clearbrook, MNThe pilot’s delayed use of carburetor heat which resulted in the loss of engine power due to carburetor icing.NTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.NTSB CEN24LA138Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Aitkin, MNThe student pilot’s failure to maintain directional control during the takeoff in crosswind conditions.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.NTSB CEN23LA375Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Rice, MNThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB 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.NTSB CEN23LA311Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Benson, MNThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline. Contributing to the accident was the degraded visibility due to the smoke in the area.NTSB CEN23LA177Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Longville, MNThe pilot’s failure to maintain directional control during the landing roll with an unexpected windshift, which resulted in a runway excursion.NTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB CEN23LA138Accident · Serious injuriesClass 4 · LimitedFinal reportSocata TB21 · Eden Prairie, MNThe pilot’s continued flight into icing conditions in an airplane that was not equipped for icing, which led to structural icing, subsequent loss of airplane control and impact with terrain.NTSB 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.NTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…NTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…NTSB 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.NTSB CEN21LA370Accident · No injuriesClass 4 · LimitedFinal reportMarlowe Thooft Just Acft Highlander · Brainerd, MNThe pilot’s failure to maintain directional control during a crosswind landing that resulted in an impact with terrain.NTSB CEN21FA360Accident · 3 fatalClass 3 · FieldFinal reportMooney M20M · Victoria, MNThe pilot’s loss of airplane control due to spatial disorientation during final approach, which led to a spiral dive that overstressed the airplane and resulted in an in-flight breakup.NTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.NTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.NTSB 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.NTSB CEN21LA101Accident · No injuriesClass 3 · LimitedFinal reportBeech 65-A80-8800 · Alexandria, MNThe pilot’s decision to attempt takeoff with frost covering the airplane and rotating below the published rotation speed, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN21LA075Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32 · Windom, MNThe pilot’s spatial disorientation shortly after takeoff into night instrument meteorological conditions, which resulted in loss of airplane control and subsequent impact with terrain.NTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.NTSB CEN20CA232Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Ely, MNThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapse during a gusty landing.NTSB CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.NTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.NTSB GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.NTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.NTSB GAA19CA154Accident · No injuriesData collectionFinal reportDenney Kitfox MDL Classiciv · Floodwood, MNThe pilot's loss of lateral control while landing in gusting crosswind conditions, which resulted in a nose-over.NTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB DCA18CA102Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A330 323 · Minneapolis, MNan inadvertent encounter with clear air turbulence.NTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB 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.NTSB DCA17CA155Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer S A ERJ170-200LR · Minneapolis, MNAn encounter with convective turbulence.NTSB 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…NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB CEN17LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Longville, MNThe in-flight encounter with wind shear and gusting wind conditions, which resulted in a bounced landing and runway excursion.NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.NTSB CEN16LA369Accident · No injuriesLimited investigationFinal reportStinson V77 · Jordan, MNA partial loss of engine power due to carburetor icing.NTSB 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.