# NTSB investigations, 2023: 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 WPR24LA036](https://openairdocs.org/ntsb/WPR24LA036.md): Bell OH-58A · Estacada, OR · Accident · No injuries · Class 4 · Limited · Final report · Nov 15, 2023 · N103WC · Substantial damage
  > The pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.
- [NTSB ANC23LA085](https://openairdocs.org/ntsb/ANC23LA085.md): Eurocopter AS 350 B3 · Johnson River, AK · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 16, 2023 · N297SH · No damage
  > The ground crew’s failure to remain clear of a tag line during sling load operations, resulting in his entanglement.
- [NTSB CEN23LA385](https://openairdocs.org/ntsb/CEN23LA385.md): Bell Helicopter Textron Canada 206 · Hibbing, MN · Accident · No injuries · Class 4 · Limited · Final report · Aug 27, 2023 · N19BH · Substantial damage
  > The 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…

## 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") = 2023
  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=2023

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