NTSB investigations: Bombardier ROTAX (ALL)
99 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Loss of engine power”. 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
| 1984 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1992 | 3 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 7 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 13 |
| 2002 | 11 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 7 |
| 2007 | 7 |
Where
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09050')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09050')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA08CA016Accident · Minor injuriesData collectionFinal reportDye Rans S-12 Airaile · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07LA252Accident · No injuriesLimited investigationFinal reportKearney Pulsar XP · Cottonwood, AZThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.NTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB ANC06LA086Accident · Serious injuriesLimited investigationFinal reportStorm Zenair CH-701 · Fairbanks, AKThe total loss of engine power for an undetermined reason during cruise flight, which resulted in an emergency descent into trees.NTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.NTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.NTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.NTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.NTSB ANC05LA032Accident · Minor injuriesLimited investigationFinal reportJohnson Revolution Mini 500 · Isabela, PRThe loss of engine power during cruise flight for an undetermined reason, which resulted in an autorotation and collision with terrain.NTSB SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.NTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.NTSB MIA05LA015Accident · Serious injuriesLimited investigationFinal reportDavid Cadorette Fox Model II · Vero Beach, FLLoss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.NTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB MIA03LA109Accident · Serious injuriesLimited investigationFinal reportBill Darling Rans S9 · Green Cove Sprg, FLA loss of engine power for undetermined reasons.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.NTSB CHI02LA268Accident · 1 fatalLimited investigationFinal reportRebholz Rans S-10 · Cottage Grove, WIThe pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…NTSB IAD02LA089Accident · 1 fatalLimited investigationFinal reportPuhl Genesis · Petersburg, WVThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Factors included the pilot's inadequate preflight planning which resulted in fuel exhaustion, and the transmission wires in the pilot's glide…NTSB LAX02LA253Accident · Minor injuriesLimited investigationFinal reportReed Avid Commuter · Goffs, CAThe engine loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD02LA063Accident · No injuriesLimited investigationFinal reportMurawski Pulsar · Bentleyville, PAFailure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.NTSB SEA02LA087Accident · Serious injuriesLimited investigationFinal reportHanson Rans S6ES · Spanaway, WAThe loss of engine power for undetermined reasons during the climb-out after takeoff. Factors include no suitable terrain upon which to attempt a forced landing, and trees and cars alongside of the residential street that the pilot attempted to land on.NTSB ATL02LA110Accident · Serious injuriesLimited investigationFinal reportKendall, Blair Rans S-12 · Lincolnton, GAThe loss of engine power due to the delamination of the propeller blade during takeoff, and the pilot's improper touchdown flare during the emergency landing resulted in a hard landing.NTSB CHI02LA139Accident · No injuriesLimited investigationFinal reportWattier Tornado · Grant, MIThe disregarded replacement of the airplane's fuel lines, the operation of the aircraft with known deficiencies, and the turn back to the departure airport by the owner/pilot. The inadequate condition inspection by the mechanic, the cracked fuel line, the…NTSB MIA02LA078Accident · Serious injuriesLimited investigationFinal reportUltravia Aero Int' Pelican Club PL · Crystal River, FLThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.NTSB ATL02LA071Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Naples, FLThe loss of engine power for undetermined reasons.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 NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.NTSB NYC02LA001Accident · Serious injuriesLimited investigationFinal reportClark T Bird II · Elberon, VAA partial power loss for undetermined reasons.NTSB ATL01LA097Accident · 1 fatalLimited investigationFinal reportTroy A. Woodland Sky Raider II · NewSmyrna Beach, FLThe pilot's failure to maintain airspeed while performing an emergency maneuver, resulting in a stall and an uncontrolled descent, and the subsequent collision with terrain. A factors was, the loss of engine power for undetermined reasons.NTSB CHI01LA285Accident · Serious injuriesLimited investigationFinal reportWaters Avid Bandit · Northville, MIfuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.NTSB FTW01LA189Accident · No injuriesLimited investigationFinal reportDonald A Chiasson FP-404 · Port Allen, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA205Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Sydnorsville, VAA loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.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 ATL01LA088Accident · Serious injuriesLimited investigationFinal reportW. E. Simmons Max Air Drifter ARV 582 · Collington, NCThe internal seizing of the engine assembly that resulted in a total loss of engine power during climb out.NTSB NYC01LA177Accident · Serious injuriesLimited investigationFinal reportRaum Rans S-12 · Waldorf, MDFuel contamination. A factor related to the accident was the builder’s decision to not install fuel tank drains.NTSB CHI01LA216Accident · No injuriesLimited investigationFinal reportStemme S10-VT · Antigo, WIThe cause of the loss of engine power and in-flight fire was undetermined.NTSB CHI01LA192Accident · Minor injuriesLimited investigationFinal reportMelenyk Genesis · Howell, MIthe in-flight planning/decision by the pilot. Contributing factors were the undetermined loss of engine power, the quartering tailwind and the unsuitable terrain encountered by the pilot.NTSB FTW01LA110Accident · No injuriesLimited investigationFinal reportPerlick Avid Commuter · Crawford, TXthe loss of engine power on takeoff initial climb due to fuel starvation as a result of an air blocked fuel line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA317Accident · No injuriesLimited investigationFinal reportSteinke Early Bird -JENNY · Chino, CAThe engine lost power for undetermined reasons and nosed over in a soft field during the resulting forced landing.