# NTSB investigations: Physical fitness

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 WPR24FA123](https://openairdocs.org/ntsb/WPR24FA123.md): Ayres S2R-G10 · Derner, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 9, 2024 · N40261 · Substantial damage
  > The pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.
- [NTSB WPR22FA098](https://openairdocs.org/ntsb/WPR22FA098.md): Bell UH-1H · Coalinga, CA · Accident · 1 fatal · Class 3 · Field · Final report · Feb 17, 2022 · N72297 · Substantial damage
  > The pilot’s loss of situational awareness for reasons that could not be determined given the available evidence, which led to controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the helicopter while ill and…
- [NTSB ERA18FA235](https://openairdocs.org/ntsb/ERA18FA235.md): Airtime Cygnet · Pensacola, FL · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2018 · N186AT · Substantial damage
  > The student pilot's loss of aircraft control for undetermined reasons.
- [NTSB ERA18FA187](https://openairdocs.org/ntsb/ERA18FA187.md): Robinson R44 · Williamsburg, VA · Accident · 2 fatal · Field investigation · Final report · Jul 8, 2018 · N616HS · Destroyed
  > The pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.
- [NTSB ERA15FA351](https://openairdocs.org/ntsb/ERA15FA351.md): Cessna 172 · Riegelwood, NC · Accident · 1 fatal · Field investigation · Final report · Sep 11, 2015 · N52445 · Substantial damage
  > The noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.
- [NTSB WPR14LA100](https://openairdocs.org/ntsb/WPR14LA100.md): Ercoupe 415 C · Poulsbo, WA · Accident · 1 fatal · Limited investigation · Final report · Jan 20, 2014 · N2076H · Substantial damage
  > The pilot's failure to confirm that the engine oil filler cap was secured before flight, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.
- [NTSB CEN10FA071](https://openairdocs.org/ntsb/CEN10FA071.md): Cessna 310R · Alva, OK · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2009 · N310CR · Substantial damage
  > The pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was 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 c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02013010'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02013010/cases

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