# NTSB investigations, IN: Propeller/rotor contact to 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 CHI97LA140](https://openairdocs.org/ntsb/CHI97LA140.md): Aerospatiale AS-365-N2 · Indianapolis, IN · Accident · 1 fatal · Limited investigation · Final report · May 21, 1997 · N653CN · No damage
  > inadequate visual clearance by the passenger resulting in his being struck with the rotor blade. A factor relating to this accident was the gusting winds.
- [NTSB CHI88LA042](https://openairdocs.org/ntsb/CHI88LA042.md): Cessna 172K · Converse, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1988 · N46701 · No damage
  > The plt had flown one closed circuit pattern of the local arpt and landed to pick up two additional passengers. Purpose of the local flight was for sightseeing. The acft was parked with engine at idle. One boarding passenger approached the acft from the left…
- [NTSB CHI85FEX01](https://openairdocs.org/ntsb/CHI85FEX01.md): Cessna 404 · Indianapolis, IN · Accident · Serious injuries · Final report · May 2, 1985 · N68103 · No damage
  > The right prop struck a person who was loading freight onto the acft. The plt reported that he had started the right eng to bring it up to operating temp to deforst the windscreen. He stated the eng had been running for aprx 3 minutes when he felt something…

## 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" = 'IN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 370)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=370&state=IN

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