# NTSB investigations, MN: Part(s) separation from AC

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN20LA207](https://openairdocs.org/ntsb/CEN20LA207.md): Icon A5 · Duluth, MN · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2020 · N838BA · Substantial damage
  > The 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 CEN17LA264](https://openairdocs.org/ntsb/CEN17LA264.md): Bell 47D1 · Big Lake, MN · Accident · No injuries · Limited investigation · Final report · Jul 6, 2017 · N153B · Substantial damage
  > The 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 GAA16LA325](https://openairdocs.org/ntsb/GAA16LA325.md): MD Helicopter 369E · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Jun 17, 2016 · N155NR · Substantial damage
  > The failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.
- [NTSB CEN11LA120](https://openairdocs.org/ntsb/CEN11LA120.md): Beech 300 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Dec 10, 2010 · N206K · Substantial damage
  > The pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.
- [NTSB CEN11LA077](https://openairdocs.org/ntsb/CEN11LA077.md): Halbrook Rans S-6S · St. Cloud, MN · Accident · No injuries · Limited investigation · Final report · Nov 17, 2010 · N280JH · Substantial damage
  > The airplane kit manufacturer’s recommended use of an improper nut type for securing the door hinge.
- [NTSB CHI08LA154](https://openairdocs.org/ntsb/CHI08LA154.md): Beech A36 · Grand Rapids, MN · Accident · No injuries · Limited investigation · Final report · Jun 9, 2008 · N7214Y · Substantial damage
  > A 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.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/338/cases?state=MN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.