# NTSB investigations, 2014: AC/prop/rotor contact w person

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 CEN14LA272](https://openairdocs.org/ntsb/CEN14LA272.md): Dehavilland DHC 6 200 · Middletown, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 1, 2014 · N223AL · Minor damage
  > The skydiving operator employee’s failure to see and avoid the rotating propeller blades when she walked toward the cockpit while the airplane’s engines were running.
- [NTSB WPR14FA195](https://openairdocs.org/ntsb/WPR14FA195.md): American Eurocopter AS350B3 · Peach Springs, AZ · Accident · 1 fatal · Field investigation · Final report · May 18, 2014 · N840PA · Substantial damage
  > The pilot’s decision to exit the helicopter while it was running and his failure to properly secure the flight controls with the engine operating at flight idle before exiting the helicopter.
- [NTSB ERA14LA212](https://openairdocs.org/ntsb/ERA14LA212.md): Champion 7ECA · Taylorsville, NC · Accident · 1 fatal · Limited investigation · Final report · Apr 26, 2014 · N9122E · Substantial damage
  > The pilot’s improper approach, which resulted in a long landing right of the runway centerline and the airplane’s subsequent collision with a riding mower that would have been difficult for the pilot to see due to its color and the nose-high attitude of the…

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

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