Fatal, Ongoing NTSB investigations: Rotax 912ULS series

6 cases on aircraft whose registry engine model is Rotax 912ULS series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Fatal, Ongoing NTSB investigations: Rotax 912ULS series per year, 2025–2026: 6 cases
2025	4
2026	2

Where

Open the map

Latest cases

Query with 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 ('55572')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('55572'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 ('55572'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA26FA177Accident · 1 fatalClass 3 · FieldPreliminary reportRajchl Vladimir Airplane Swing 06 · O'Brien, FLOn April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title…Apr 16, 2026 · N613SA · Substantial damage NTSB ANC26FA024Accident · 2 fatalClass 3 · FieldPreliminary reportAirplane Factory Ltd The Sling · Avalon, CAOn April 09, 2026, about 1224 Pacific daylight time, an Airplane Factory (Pty) Ltd. Sling 2 airplane, N166TW, was substantially damaged when it was involved in an accident near Avalon, California. The pilot and pilot-rated passenger were fatally injured. The…Apr 9, 2026 · N166TW · Substantial damage NTSB CEN26FA023Accident · 2 fatalClass 3 · FieldPreliminary reportJMB VL-3LSA-912 · Erie, COOn October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The…Oct 19, 2025 · N594TT · Substantial damage NTSB ERA25FA332Accident · 1 fatalClass 3 · FieldPreliminary reportCzech Sport Sportcruiser · Fryeburg, MEOn September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…Sep 4, 2025 · N336SC · Substantial damage NTSB WPR25FA197Accident · 1 fatalClass 3 · FieldPreliminary reportEvolution Revolt · Mount Vernon, WAOn July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally…Jul 2, 2025 · N774RS · Substantial damage NTSB ERA25FA154Accident · 1 fatalClass 3 · FieldPreliminary reportAero SP Z O O AT-4 LSA · Zellwood, FLOn March 22, 2025, about 0925 eastern daylight time, a Aero SP Z O O AT-4 LSA, N8548U, was substantially damaged when it was involved in an accident near Zellwood, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…Mar 22, 2025 · N8548U · Substantial damage