NTSB investigations, MN
328 cases where NTSB found Personnel issues.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 22 |
| 2010 | 26 |
| 2011 | 21 |
| 2012 | 21 |
| 2013 | 25 |
| 2014 | 19 |
| 2015 | 12 |
| 2016 | 19 |
| 2017 | 17 |
| 2018 | 7 |
| 2019 | 14 |
| 2020 | 21 |
| 2021 | 11 |
| 2022 | 20 |
| 2023 | 25 |
| 2024 | 17 |
| 2025 | 9 |
| 2026 | 3 |
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\", '02'))
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", '02')) 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 CEN26LA124Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Glencoe, MNThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision of the flight.NTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN25LA393Accident · No injuriesClass 4 · LimitedFinal reportFloyd G Halderman JR RV-6 · Cambridge, MNThe pilot’s continued operation of the faulty fuel selector valve which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the degraded operation of the fuel selector valve and the pilot’s poor decision to operate the…NTSB CEN25LA400Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Rush City, MNThe pilot’s failure to properly monitor the airplane glide path which resulted in the inadvertent descent below the approach minimum descent altitude and the impact with trees.NTSB CEN25LA331Accident · Minor injuriesClass 4 · LimitedFinal reportElmwood Christavia · South Saint Paul, MNThe pilot’s failure to maintain airplane control during the landing roll. Contributing to the accident was the pilot’s decision to land the airplane on a non-approved landing surface.NTSB CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA246Accident · No injuriesClass 4 · LimitedFinal reportThorp T18 · Lake Elmo, MNThe pilot’s failure to maintain obstacle clearance during the go-around, that resulted in the tailwheel impacting a taxiway sign, a subsequent loss of control due to the damaged tailwheel, and a runway excursion during the landing.NTSB CEN25LA189Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Luverne, MNThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN25LA171Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · South Saint Paul, MNThe student pilot’s inadvertent brake application during the touchdown, that resulted in abnormal runway contact and a loss of directional control. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot during the…NTSB CEN25LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Crystal, MNThe malfunction of the landing gear system which resulted in a collapse of the main landing gear during the landing roll.NTSB CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.NTSB CEN25LA008Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Inguadona, MNThe pilot’s failure to properly configure the landing gear on the amphibious airplane before a water landing.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 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 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.NTSB CEN24LA310Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Crystal, MNThe pilot’s improper landing flare which resulted in a hard landing.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 CEN24LA207Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR20 · Aitkin, MNThe pilot’s failure to maintain adequate airspeed, which resulted in a loss of airplane control during the go-around. Contributing to the accident was the pilot’s failure to properly configure the airplane’s flaps during the go-around.NTSB CEN24LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Forest Lake, MNThe flight instructor’s delayed remedial action and failure to maintain aircraft control during the simulated forced landing.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 CEN24LA149Accident · No injuriesClass 4 · LimitedFinal reportVan's RV-12iS · Lake Elmo, MNThe student pilot’s improper landing flare, which resulted in a bounced landing, and the nose gear collapsing. Contributing to the accident was the student pilot’s lack of experience.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 CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB CEN24LA109Accident · Minor injuriesClass 4 · LimitedFinal reportJavron PA-12 Replica · Inver Grove Heights, MNThe pilot’s failure to properly configure the landing gear on his amphibious airplane before landing on water.NTSB CEN24LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Park Rapids, MNThe pilot’s failure to maintain directional control and terrain clearance during initial climb, that resulted in an impact with trees and terrain.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 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 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 CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.NTSB CEN23LA398Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-12 · Crystal, MNThe pilot’s improper landing flare, which resulted in a bounced landing and an overstress fracture of the nose landing gear strut.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 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 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 CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.NTSB CEN23LA335Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Tyler, MNThe pilot’s improper flap position during takeoff, which resulted in degraded climb performance and a collision with terrain.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 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 CEN23LA298Accident · No injuriesClass 4 · LimitedFinal reportMariner Unknown · Lino Lakes, MNThe pilot’s failure to retract the landing gear on the amphibious airplane before landing on water.NTSB CEN23FA270Accident · 1 fatalClass 3 · FieldFinal reportIcon A5 · Onamia, MNThe pilot’s failure to maintain clearance from the water while flying at a low altitude.NTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.NTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.NTSB CEN23LA215Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Forest Lake, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with the runway.NTSB 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…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.