# Fatal NTSB investigations, FL: Simulated/training event

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 ERA19FA106](https://openairdocs.org/ntsb/ERA19FA106.md): Stol UC-1 · Winter Haven, FL · Accident · 1 fatal · Class 2 · Field · Final report · Feb 23, 2019 · N65NE · Substantial damage
  > A total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…
- [NTSB ERA15FA085](https://openairdocs.org/ntsb/ERA15FA085.md): Robinson Helicopter R22 Beta · Lake Worth, FL · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2014 · N771MM · Substantial damage
  > A main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.
- [NTSB ERA11FA354](https://openairdocs.org/ntsb/ERA11FA354.md): Beech C24R · Valparaiso, FL · Accident · 2 fatal · Field investigation · Final report · Jun 23, 2011 · N38029 · Substantial damage
  > The pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '600' 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/600/sequence?fatal=1&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
