# NTSB investigations, 2024, MN: Evacuation

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 CEN24LA149](https://openairdocs.org/ntsb/CEN24LA149.md): Van's RV-12iS · Lake Elmo, MN · Accident · No injuries · Class 4 · Limited · Final report · Apr 5, 2024 · N245EM · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a bounced landing, and the nose gear collapsing. Contributing to the accident was the student pilot’s lack of experience.
- [NTSB CEN24LA087](https://openairdocs.org/ntsb/CEN24LA087.md): Piper J3C · Park Rapids, MN · Accident · No injuries · Class 4 · Limited · Final report · Jan 9, 2024 · N1401V · Substantial damage
  > The pilot’s failure to maintain directional control and terrain clearance during initial climb, that resulted in an impact with trees and terrain.

## 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."eventStateOrRegion" = 'MN' 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" = '460' 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/460/sequence?state=MN&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
