# Fatal, Ongoing NTSB investigations: Bombardier ROTAX (ALL)

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 ERA26FA310](https://openairdocs.org/ntsb/ERA26FA310.md): Diamond Aircraft Ind DA20-A1 · Bristol, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2026 · N83RF · Substantial damage
  > On August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…
- [NTSB CEN25FA247](https://openairdocs.org/ntsb/CEN25FA247.md): Zenith CH601 · Pawnee National Grassland, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N314LB · Destroyed
  > On July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…
- [NTSB WPR24FA284](https://openairdocs.org/ntsb/WPR24FA284.md): Lockwood AIR CAM · Minden, NV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2024 · N2412Y · Substantial damage
  > On August 20, 2024, about 0819 Pacific daylight time, an experimental amateur-built Lockwood Air Cam, N2412Y, was substantially damaged when in was involved in an accident at the Minden-Tahoe Airport, Minden, Nevada. The pilot was fatally injured, and 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."highestInjuryLevel" = 'Fatal'
  AND c."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09050'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=09050&fatal=1&status=ongoing

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