Final NTSB investigations: Bombardier ROTAX (ALL), 2025

6 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL). 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.

Cases per year

19832026
Final NTSB investigations: Bombardier ROTAX (ALL), 2025 per year, 1983–2026: 747 cases
19837
19847
19853
19867
198710
19888
19898
199015
199116
199227
199320
199416
199526
199620
199731
199835
199931
200032
200151
200239
200320
200422
200516
200622
200720
200816
200929
201021
201127
201217
201316
201410
201513
201611
201710
20186
201910
20208
20219
20227
202312
20247
20256
20263

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 2025
    AND c.\"completionStatus\" = 'Completed'
    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"

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.

NTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.Sep 16, 2025 · N65176 · Substantial damageNTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.Jul 22, 2025 · N422K · Substantial damageNTSB ERA25LA257Accident · No injuriesClass 4 · LimitedFinal reportYates Tom W Kitfox III · Greenville, KYThe pilot’s loss of control during takeoff.Jul 4, 2025 · N11TY · Substantial damageNTSB ERA25LA236Accident · No injuriesClass 4 · LimitedFinal reportSting Sport TL-2000 · Dunavant, VAThe inflight failure of the propeller due to its exceedance of the manufacturer’s overhaul requirement.Jun 20, 2025 · N878N · Substantial damageNTSB WPR25LA123Accident · No injuriesClass 4 · LimitedFinal reportPark Roderic B Kitfox IV · Marana, AZThe pilot’s failure to maintain clearance from an obstacle while performing an off-airport landing.Mar 29, 2025 · N70265 · Substantial damageNTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.Feb 23, 2025 · N40DJ · Substantial damage