# NTSB investigations, FL: 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 ERA24LA149](https://openairdocs.org/ntsb/ERA24LA149.md): Piper PA28 · Apopka, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 20, 2024 · N686JA · Minor damage
  > The pilot and the landscape worker’s inadequate visual lookout, which resulted in a collision.
- [NTSB ERA24LA216](https://openairdocs.org/ntsb/ERA24LA216.md): Apellix B1 Washing Drone · Orlando, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 20, 2024 · FA33N7WLTR · Substantial damage
  > A failure of the sUAS’s magnetometer while operating in close proximity to commercial air conditioning equipment, which resulted in the sUAS’s erratic maneuvering. Contributing to the accident was the RPIC’s failure to input the appropriate command to disarm…
- [NTSB GAA20CA025](https://openairdocs.org/ntsb/GAA20CA025.md): Cessna 172 · Key West, FL · Accident · Serious injuries · Data collection · Final report · Oct 13, 2019 · N5522S · No damage
  > The pilot’s and the passenger's improper decision to have the passenger attempt to move a wheel chock while the propeller was turning, which resulted in a serious injury.
- [NTSB ERA16LA055](https://openairdocs.org/ntsb/ERA16LA055.md): Robinson R22 · Venice, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2015 · N8560M · Substantial damage
  > The flight instructor's failure to maintain control of the helicopter during an autorotation, which resulted in a hard landing.
- [NTSB ERA13LA248](https://openairdocs.org/ntsb/ERA13LA248.md): Cessna 172N · Geneva, FL · Accident · Serious injuries · Limited investigation · Final report · May 18, 2013 · N4702F · No damage
  > The passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.

## 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" = 'FL' AND c."eventCountry" = 'USA'
  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?state=FL

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