NTSB investigations, MN
14 cases where NTSB found Aircraft propeller/rotor.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
Where
Latest 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\", '0104'))
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", '0104')) 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 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 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 CEN22LA318Accident · Serious injuriesClass 3 · LimitedFinal reportHiller UH12E · Becker, MNThe in-flight failure of the main rotor mast hub due to several undetected fatigue fractures.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 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 CEN17LA264Accident · No injuriesLimited investigationFinal reportBell 47D1 · Big Lake, MNThe failure of the metal core assembly within a wooden main rotor blade due to undetected corrosion and fatigue, which caused the wooden blade to separate from the rotor mast.NTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.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 CEN13LA115Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Corcoran, MNThe pilot’s improper decision to land the helicopter in a position that placed the tail rotor near tarps, which resulted in the tarps being lifted into the tail rotor, subsequent tail rotor damage, a loss of tail rotor authority, and an uncommanded tail rotor…NTSB CEN12CA597Accident · No injuriesData collectionFinal reportBordelon Bruce Kitfox IV · Castlerock, MNPropeller system failure during a go-around maneuver resulting in a forced landing. Contributing to the severity of damage to the airplane was the postimpact fire.NTSB CEN10LA484Accident · Serious injuriesLimited investigationFinal reportRammel Thomas W Searey · Cokato, MNSeparation of the composite skin on one of the three propeller blades that resulted in an in-flight vibration, and the pilot's failure to maintain clearance with the water while maneuvering to avoid obstacles in preparation for a precautionary landing.NTSB CEN10CA304Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Stanton, MNThe pilot’s inadvertent propeller blade pitch change and subsequent loss of forward thrust.NTSB CHI08CA164Accident · Minor injuriesData collectionFinal reportHughes 269B · Cook, MNThe pilot not maintaining tail rotor effectiveness while turning in cruise.NTSB CHI08LA154Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MNA loss of engine thrust due to the propeller separating from the aircraft as a result of fatigue failure of the propeller attachment bolts caused by the insufficient torque of the bolts during installation.