NTSB investigations, MN
174 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases, newest first
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\" = '470' 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" = '470' 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 CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.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 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.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.NTSB CEN16LA242Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Wyoming, MNThe pilot’s inadequate flight planning and navigation for a flight at night, which resulted in his having to conduct a precautionary landing on an interstate highway due to low fuel and impacting the post of a wire road divider.NTSB 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.NTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…NTSB CEN16LA061Accident · Minor injuriesLimited investigationFinal reportGlobe GC 1B · Lake Elmo, MNA loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.NTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.NTSB 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.NTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…NTSB 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.NTSB GAA15CA151Accident · No injuriesData collectionFinal reportFlight Design Ctls · Andover, MNThe pilot's improper fuel management and preflight planning, which resulted in the total loss of engine power due to fuel exhaustion and a forced landing in a field where the airplane nosed over.NTSB GAA15CA109Accident · Minor injuriesData collectionFinal reportKretsinger Bensen B8M · Maple Plain, MNThe pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.NTSB 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…NTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB CEN15CA041Accident · No injuriesData collectionFinal reportCessna 510 · Faribault, MNAn inflight collision with a goose while descending to land at the destination airport.NTSB CEN14LA486Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Langola Township, MNMaintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.NTSB 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.NTSB CEN14CA470Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Minneapolis, MNThe pilot's loss of control while landing with a crosswind. Contributing to the accident was the pilot lack of experience flying in similar weather conditions.NTSB CEN14CA479Accident · No injuriesData collectionFinal reportQuicksilver 2S · Frontenac, MNThe loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.NTSB CEN14CA442Accident · No injuriesData collectionFinal reportRockwell International S 2R · Kerkhoven, MNThe pilot failure to see and avoid the guide wire during the aerial application flight.NTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.NTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.NTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…NTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.NTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.NTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.NTSB 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.NTSB CEN14LA066Accident · No injuriesLimited investigationFinal reportQuad City Challenger I · Winsted, MNThe pilot’s failure to maintain airspeed while maneuvering for a precautionary landing after the light sport airplane started vibrating, which led to an inadvertent aerodynamic stall.NTSB CEN14FA034Accident · 3 fatalField investigationFinal reportPiper PA 23-250 · Caledonia, MNThe pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA028Accident · 1 fatalLimited investigationFinal reportPiper PA 22-150 · Princeton, MNThe pilot's loss of airplane control during takeoff.NTSB CEN13LA537Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Arlington, MNThe pilot’s failure to maintain control of the helicopter while maneuvering when he removed his hand from the collective control while plugging in his radio connection to his helmet, which resulted in the collective moving to the full-down position.NTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.NTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.NTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.NTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.NTSB CEN13LA363Accident · No injuriesLimited investigationFinal reportThomsen Avid Flyer MK IV · Hibbing, MNA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13FA357Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Maplewood, MNThe loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.NTSB CEN13LA579Accident · Minor injuriesLimited investigationFinal reportBeech 58P · St Paul, MNThe pilot's failure to maintain directional control during a rejected landing, which resulted in a collision with an airport sign off the right side of the runway during the transition to the initial climb.NTSB CEN13LA256Accident · 1 fatalLimited investigationFinal reportEskildsen Steen Skybolt · Easton, MNThe pilot's medical incapacitation due to an acute cardiac event after performing aerobatic maneuvers.NTSB CEN13CA262Accident · Minor injuriesData collectionFinal reportEngineering & Research 415-C · Little Falls, MNThe failure of the airplane's throttle cable.NTSB CEN13LA212Accident · Minor injuriesLimited investigationFinal reportCirrus SR22T · Alexandria, MNThe failure of maintenance personnel to install a safety wire during reinstallation of the right flap, which led to the separation of the right flap rod from the right flap actuation fitting during flap extension. Contributing to the accident were inadequate…NTSB CEN13FA214Accident · 1 fatalField investigationFinal reportCessna 152 · Hawley, MNThe noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.NTSB CEN13FA172Accident · 1 fatalField investigationFinal reportMaule MXT-7-180 · Parkers Parairie, MNThe pilot’s failure to transfer fuel from the auxiliary fuel tanks to the main fuel tanks in a timely manner, which resulted in fuel starvation to the engine.NTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.NTSB CEN13CA093Accident · No injuriesData collectionFinal reportCirrus SR22 · Eden Prairie, MNThe pilot's failure to ensure the airplane was secured prior to attempting an engine start by handpropping.