NTSB investigations, MN
34 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN25LA298Accident · No injuriesClass 4 · LimitedFinal reportBell 47G · Assumption, MNA total loss of engine power due to fuel starvation, which resulted from attitude-inducing unporting of the fuel.NTSB CEN25LA189Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Luverne, MNThe pilot’s improper landing flare which resulted in a hard landing.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 CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.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 CEN23LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Eden Prairie, MNThe student pilot exceeded the airplane's critical angle of attack, resulting in an aerodynamic stall and ground impact.NTSB CEN22LA418Accident · No injuriesClass 4 · LimitedFinal reportZenith CH701 · Stanton, MNThe pilot’s improper landing flare which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN22LA404Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Beardsley, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with terrain.NTSB CEN22FA111Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Hutchinson, MNThe reduction in fuel flow and subsequent partial loss of engine power after takeoff for reasons that could not be determined.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 CEN20CA251Accident · No injuriesClass 4 · Data collectionFinal reportSonex Onex · Minneapolis, MNThe pilot's hard landing on the airplane's nosewheel, which jammed the steering, and resulted in a runway excursion and impact with runway lights.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 CEN19LA176Accident · No injuriesClass 3 · LimitedFinal reportKolb Kolb Twinstar TSP 1 · Hector, MNThe pilot’s operation of the airplane outside of the center of gravity limits, which resulted in an adverse aerodynamic condition and subsequent hard landing. Contributing to the accident was the pilot’s incorrect calculations of the airplane’s CG limits.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 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 GAA18CA186Accident · No injuriesData collectionFinal reportTerry G. Olson Kitfox S7 Super Spor · Silver Bay, MNThe pilot’s hard landing and subsequent failure to maintain airspeed and bank control during the aborted landing, 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 CEN16LA231Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blaine, MNThe pilot's failure to maintain a proper airspeed during the landing approach, which resulted in an improper flare and hard landing.NTSB CEN16LA156Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Arden Hills, MNA partial loss of engine power for reasons that could not be determined based on the available evidenceNTSB GAA16CA189Accident · No injuriesData collectionFinal reportTL Ultralight Sro TL-3000 Sirius · South St. Paul, MNThe pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…NTSB CEN13CA112Accident · No injuriesData collectionFinal reportCessna 172M · Eveleth, MNThe student pilot’s improper landing flare, which resulted in a hard nosewheel landing.NTSB CEN12LA113Accident · No injuriesLimited investigationFinal reportCessna 182J · St. Paul, MNThe pilot's decision to land on a runway with a gusting, quartering tailwind and his inadequate compensation for the wind, which resulted in a hard landing.NTSB CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.NTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.NTSB CEN10CA280Accident · No injuriesData collectionFinal reportHughes 269A · Cannon Falls, MNThe pilot's failure to maintain rotor speed during the autorotation, which resulted in an excessive sink rate and a hard landing.NTSB CEN10CA224Accident · No injuriesData collectionFinal reportCessna 170-B · White Bear Lake, MNThe flight instructor's inadequate attempted recovery from a bounced landing and the student pilot's abrupt use of the brakes, which resulted in the airplane nosing over.NTSB CEN09CA357Accident · No injuriesData collectionFinal reportAviat A1 · Garrison, MNThe pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.NTSB CEN09CA120Accident · No injuriesData collectionFinal reportBeech 58 · Brainerd, MNThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the unforcasted freezing rain that obscured the windscreen and hindered the pilot's ability to judge the height of the airplane above the runway.NTSB CHI08LA228Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Maple Lake, MNThe certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.NTSB CHI08LA067Accident · Serious injuriesLimited investigationFinal reportZiermann RV8 · Garrison, MNThe loss of engine power for undetermined reasons during cruise and the misjudged flare resulting in a hard landing. Contributing to the accident was the frozen lake to which the pilot performed a forced landing.