NTSB investigations: Bombardier ROTAX (ALL), MN
20 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
| 1998 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
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.
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."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA'
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" DESCRun 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 CEN23LA182Accident · No injuriesClass 3 · LimitedFinal reportLoehle Acft 5151 Mustang · Hector, MNA total loss of engine power due to fuel starvation as a result of the pilot’s modifications to the fuel system. Contributing to the accident was the pilot’s decision to continue the takeoff despite observing lower than anticipated propeller rpm, his decision…NTSB CEN20CA177Accident · Minor injuriesClass 4 · Data collectionFinal reportM-Squared Sport 1000 · Little Falls, MNThe uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain.NTSB CEN19LA176Accident · No injuriesClass 3 · LimitedFinal reportKolb Kolb Twinstar TSP 1 · Hector, MNThe pilot’s operation of the airplane outside of the center of gravity limits, which resulted in an adverse aerodynamic condition and subsequent hard landing. Contributing to the accident was the pilot’s incorrect calculations of the airplane’s CG limits.NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.NTSB CEN13LA363Accident · No injuriesLimited investigationFinal reportThomsen Avid Flyer MK IV · Hibbing, MNA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.NTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.NTSB CHI08LA228Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Maple Lake, MNThe certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.NTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB CHI02LA037Accident · 1 fatalLimited investigationFinal reportVermeys T-Bird II · Sherburn, MNThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI01LA237Accident · 1 fatalLimited investigationFinal reportVeith Kolb Sling Shot · Goodview, MNThe loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…NTSB CHI01LA141Accident · No injuriesLimited investigationFinal reportParker Rotorway 162F · Minneapolis, MNThe tail rotor drive belt coming off in cruise flight and it not being possible for the student pilot to maintain aircraft control during the emergency landing attempt. Factors relating to the accident were the loose bearing in the secondary drive unit to the…NTSB CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.NTSB CHI98LA334Accident · No injuriesLimited investigationFinal reportCulver-Revolution Mini 500 · Eden Prairie, MNa design change to the fuel tank filler neck sealant made by the owner/builder of the helicopter. Factors associated with this accident were an improper sealant material used by the owner/builder and an autorotation was not possible by the pilot due to the…