# NTSB investigations, 2024: Roll over

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 CEN25LA046](https://openairdocs.org/ntsb/CEN25LA046.md): Rotor Flight Dynamics Dominator · Gilbert, MN · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 15, 2024 · UNREG · Substantial damage
  > A total loss of engine power and subsequent autorotation to a swamp, that resulted in a rollover. Contributing to the pilot’s delayed egression from the gyroplane, was the lack of a restraint system cutting device.
- [NTSB GAA25WA019](https://openairdocs.org/ntsb/GAA25WA019.md): Viking Air DHC-2 MK 1 · Whitehaven, Australia · Accident · No injuries · Class 5 · Foreign · Oct 26, 2024 · VH-OHU · Substantial damage
- [NTSB CEN24LA303](https://openairdocs.org/ntsb/CEN24LA303.md): Robinson Helicopter R44 · Bryant, IA · Accident · No injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N225ML · Substantial damage
  > A loss of engine power during takeoff for reasons that could not be determined, resulting in impact with terrain.
- [NTSB CEN24LA238](https://openairdocs.org/ntsb/CEN24LA238.md): Cessna A185F · Fort Leavenworth, KS · Accident · No injuries · Class 4 · Limited · Final report · Jun 23, 2024 · N74CF · Substantial damage
  > The pilot’s failure to maintain directional control after landing.
- [NTSB ERA24LA236](https://openairdocs.org/ntsb/ERA24LA236.md): Robinson R44 · Gilbertsville, KY · Accident · No injuries · Class 4 · Limited · Final report · Jun 2, 2024 · N220SW · Substantial damage
  > The pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.
- [NTSB CEN24LA184](https://openairdocs.org/ntsb/CEN24LA184.md): Piper PA-22 · Enderlin, ND · Accident · Minor injuries · Class 3 · Limited · Final report · May 13, 2024 · N669A · Substantial damage
  > The pilot’s failure to properly inspect and sump the fuel system before the flight and the maintenance personnel’s inadequate maintenance of the fuel system which resulted in fuel starvation and the subsequent loss of engine power due to the contamination of…

## 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") = 2024
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' 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/097/sequence?year=2024

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