NTSB investigations, MN
110 cases where NTSB found Physical environment.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 5 |
| 2014 | 11 |
| 2015 | 2 |
| 2016 | 10 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 1 |
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\", '0302'))
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", '0302')) 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 CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.NTSB CEN25LA046Accident · Serious injuriesClass 4 · LimitedFinal reportRotor Flight Dynamics Dominator · Gilbert, MNA total loss of engine power and subsequent autorotation to a swamp, that resulted in a rollover. Contributing to the pilot’s delayed egression from the gyroplane, was the lack of a restraint system cutting device.NTSB CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.NTSB CEN24LA372Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Eden Prairie, MNThe bird strike during cruise flight that resulted in substantial damage to the airplane.NTSB CEN24LA273Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Blaine, MNThe airplane’s collision with a deer on the runway during takeoff.NTSB CEN24LA267Accident · No injuriesClass 4 · LimitedFinal reportCovington Edward L SHA-GLASAIR · Saint James, MNAn in-flight bird strike which resulted in an engine compartment fire that ultimately destroyed the airplane.NTSB CEN24LA254Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV8 · Atwater, MNThe pilot’s inability to stop the landing roll on a wet grass runway which resulted in a runway overrun.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 CEN24LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Red Lake, MNThe pilot’s inadequate landing surface evaluation and failure to stop the airplane on the frozen lake, which resulted the airplane continuing into a crack in the ice.NTSB CEN24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Glencoe, MNThe collision with deer during the landing rollout.NTSB CEN24LA053Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters Deutschland EC135T3 · Dodge Center, MNAn in-flight collision with a flock of birds.NTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.NTSB CEN23LA385Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206 · Hibbing, MNThe ground crew’s failure to secure the backpack at the landing zone (LZ), that resulted in the tail rotor impacting the backpack during the landing. Contributing to the accident was the pilot’s inadequate selection of an area at the LZ, the lack of awareness…NTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.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 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 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.NTSB CEN22LA387Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Millville, MNThe pilot’s inadequate inflight planning resulted in impact with a power line.NTSB CEN22LA340Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620A · Stewart, MNThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.NTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.NTSB 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.NTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.NTSB CEN21LA128Accident · No injuriesClass 4 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Alexandria, MNThe helicopter’s impact with an object on departure that could not be determined.NTSB CEN21LA116Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Mankato, MNThe pilot’s loss of situational awareness while landing, resulting in an impact with power lines.NTSB CEN21LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hinckley, MNThe airplane’s impact with deer while landing.NTSB 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.NTSB CEN20CA111Accident · Minor injuriesData collectionFinal reportCessna P206 · Hill City, MNThe pilot's failure to maintain the proper altitude and airspeed during the approach and his delayed addition of power to go around and the flight instructor’s delayed remedial action, which resulted in a nose-over after landing on the closed snow-covered…NTSB CEN20FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Rogers, MNInadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.NTSB CEN20CA101Accident · No injuriesData collectionFinal reportCessna A185 · Hawley, MNThe pilot's improper landing flare and touchdown, which resulted in a bounced landing and loss of directional control and the airplane's subsequent impact with a snowbank and ground loop during an attempted go-around.NTSB 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.NTSB GAA19CA489Accident · No injuriesData collectionFinal reportCessna 180 · Two Harbors, MNThe pilot's abrupt maneuver to try and avoid a deer during landing on a grass strip runway, which resulted in a ground loop.NTSB GAA19CA297Accident · No injuriesData collectionFinal reportQuicksilver 2S Sport · Waverly, MNThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced, hard landing in a field.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 GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.NTSB 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.NTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB CEN18LA237Accident · No injuriesLimited investigationFinal reportZenith Stol CH701 · Maple Lake, MNThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.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 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.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 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.NTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.NTSB CEN17LA021Accident · Serious injuriesLimited investigationFinal reportZenith CH-750 · Morristown, MNA total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps.NTSB CEN16LA391Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cloquet, MNA lack of lubrication in the engine for reasons that could not be determined based on the available information, which resulted in a failure of the No. 4 connecting rod and a subsequent total loss of engine power.NTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.NTSB 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.NTSB GAA16CA399Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Bird Island, MNThe pilot's diverted attention inside the cockpit and failure to maintain the airplane's altitude while maneuvering at a low altitude, resulting in an impact with terrain.