# NTSB investigations, 2003: 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 LAX04LA089](https://openairdocs.org/ntsb/LAX04LA089.md): Cessna 172L · Vacaville, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 26, 2003 · N7668G · No damage
  > the pilot's inadequate hand prop starting procedure.
- [NTSB MIA04LA024](https://openairdocs.org/ntsb/MIA04LA024.md): Beech BE-76 · Daytona Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 2003 · N6013M · No damage
  > The pilot's improper starting procedure which led to inadvertent activation of the propeller.
- [NTSB LAX04LA045](https://openairdocs.org/ntsb/LAX04LA045.md): OMF OMF-100-160 · Van Nuys, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2003 · N290MF · Minor damage
  > the pilot's failure to either brief the passenger about disembarking from an airplane with the propeller running or to shutdown the engine during the passenger's disembarkation. The night lighting condition and the passenger's lack of familiarity with…
- [NTSB LAX03LA280](https://openairdocs.org/ntsb/LAX03LA280.md): Piper PA-28-161 · Sacramento, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 2003 · N9141Y · No damage
  > the pilot's inadequate preflight inspection and the bystander's failure to maintain clearance with the rotating propeller.
- [NTSB IAD03LA036](https://openairdocs.org/ntsb/IAD03LA036.md): Cessna R172K · Richmond, VA · Accident · 1 fatal · Limited investigation · Final report · Mar 15, 2003 · N1444V · No damage
  > The passenger's failure to remain clear of the propeller. Factors included the passenger's recent use of marijuana, the pilot's inadequate pre-flight inspection, and the night lighting conditions.

## 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") = 2003
  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&year=2003

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