# NTSB investigations, FL: Ground resonance

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 ERA24LA399](https://openairdocs.org/ntsb/ERA24LA399.md): Bell Textron Canada 505 · Marianna, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 23, 2024 · N945TC · Substantial damage
  > The student pilot’s failure to maintain rotor rpm during a simulated autorotation, which allowed for a resonance phenomenon to develop. Contributing to the accident was the flight instructor’s inadequate monitoring of the student pilot’s collective control…
- [NTSB ERA23LA284](https://openairdocs.org/ntsb/ERA23LA284.md): Schweizer 269C · Macclenny, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 1, 2023 · N9WZ · Substantial damage
  > The improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude.

## 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" = '232' 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/232/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.
