# NTSB investigations, 2018: External load event (Rotorcraft)

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 CEN19FA020](https://openairdocs.org/ntsb/CEN19FA020.md): Hughes 369 · McDougal, AR · Accident · 1 fatal · Class 2 · Field · Final report · Nov 2, 2018 · N5187S · Destroyed
  > The pilot's failure to maintain the helicopter's clearance from the powerline structure while hovering in gusty wind conditions, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.
- [NTSB GAA18CA573](https://openairdocs.org/ntsb/GAA18CA573.md): Hiller UH 12E · Frankfort, KS · Accident · No injuries · Data collection · Final report · Sep 20, 2018 · N1349A · Substantial damage
  > The ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.
- [NTSB ERA18FA122](https://openairdocs.org/ntsb/ERA18FA122.md): MD Helicopter 600 · Smethport, PA · Accident · 2 fatal · Field investigation · Final report · Apr 8, 2018 · N602BP · Destroyed
  > The helicopter pilot's failure to maintain adequate clearance during power line construction work, which resulted in the helicopter's main rotor striking and becoming entangled with a wire and a subsequent dynamic rollover and collision with terrain.…
- [NTSB ERA18LA091](https://openairdocs.org/ntsb/ERA18LA091.md): Hughes 369 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 2018 · N571HH · No damage
  > The helicopter pilot's improper decision to use an open-end grapple, instead of an A-frame attachment, to lift and move a ladder with a lineman on it and the lineman's improper decision to be lifted on a ladder via an open-end grapple, which were contrary to…

## 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 year(c."eventDate") = 2018
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '480' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/480/sequence?year=2018

---
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.