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, newest first
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 SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.NTSB FTW00LA117Accident · 2 fatalLimited investigationFinal reportJohnson Zodiac CH-601-HDS · Orange, TXthe inadvertent stall while maneuvering. A contributing factor was the loss of engine power for an undetermined reason.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 LAX99LA246Accident · No injuriesLimited investigationFinal reportSmith Avid Stol Hauler · S. Lake Tahoe, CAA loss of engine power for undetermined reasons.NTSB SEA99LA093Accident · Minor injuriesLimited investigationFinal reportModrow Avid Flyer · Poulsbo, WAEngine seizing due to failure of main bearing assemblies. Factors include foreign material in the labyrinth sleeve, and a stall encountered while the pilot was attempting his emergency landing.NTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA113Accident · No injuriesLimited investigationFinal reportDryer Fisher 404 · Homestead, FLThe pilots improper in-flight planning/decision of an available forced landing area. This resulted in a subsequent in-flight collision with trees. Contributing to the accident was a total loss of engine power due to an inoperative generator coil.NTSB SEA98LA181Accident · Serious injuriesLimited investigationFinal reportKelly Kolb Mark III · Cashmere, WAFuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.NTSB LAX98LA272Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-20-A1 · Woodland, CAThe pilot's failure during a preflight inspection to detect the damaged propeller from the previous hard landing. The damaged propeller degraded the climb performance capability of the airplane.NTSB FTW98LA355Accident · No injuriesLimited investigationFinal reportCrane Quicksilver Sport 2 · Glenn Heights, TXThe loss of engine power as the result of the owner/pilot's failure to install and adjust the proper carburetor jets. A factor was the lack of suitable terrain for the forced landing.NTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.NTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.NTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.NTSB LAX97LA326Accident · Minor injuriesLimited investigationFinal reportLampert M500 · San Carlos, CAloss of engine power for undetermined reasons, and the pilot's improper use of the flight controls following the loss of power. The pilot's lack of training/certification in rotorcraft operations was a factor in this accident.NTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.NTSB FTW97FA274Accident · 1 fatalField investigationFinal reportHillam Rans S-9 · Mckinney, TXloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with the terrain.NTSB CHI97LA222Accident · No injuriesLimited investigationFinal reportMorgan MINI-500 · Ava, MOLoss of engine power due to loss of engine cooling fluid. Related factors were maintenance service bulletin not complied with by the owner/pilot mechanic resulting in low output of the carburetor, and unsuitable terrain.NTSB ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.NTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB BFO96LA006Accident · Minor injuriesLimited investigationFinal reportMadsen/Rans Rans S12 Airaile · Cobbs Creek, VAloss of engine power for undetermined reasons.NTSB FTW95LA364Accident · Serious injuriesLimited investigationFinal reportIsaacson Kolb Twin Star MK II · Mansfield, TXthe loss of engine power for undertermined reasons, and the pilot's failure to maintain airspeed. A factor was the pilot's lack of flying experience.NTSB MIA95LA124Accident · Minor injuriesLimited investigationFinal reportBubel, John A. Condor 2 · Homestead, FLLoss of engine power for undetermined reasons.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB BFO94LA152Accident · Minor injuriesLimited investigationFinal reportA. Le Francois Rans S-7 · Palmer, MAThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed.NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.NTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.NTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.NTSB LAX92LA314Accident · No injuriesLimited investigationFinal reportJames Schwarzman Avid Flyer Heavy · Truckee, CAFuel starvation due to the aircraft builder locating the fuel filter in an improper location during the construction of the airplane's fuel system.NTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.NTSB SEA92LA143Accident · Minor injuriesLimited investigationFinal reportBorgaes Avid Flyer "C" · Chiloquin, ORPower loss for undetermined reasons and nose gear separation due to overload. A factor contributing to the accident was: terrain condition - dirt bank.NTSB LAX90DUM01Accident · 1 fatalFinal reportFreeman H Easton Falcon XP · Glamis, CAThe pilots loss of control while attempting to return to the airstrip after experiencing a partial loss of engine power.NTSB MIA90LA059Accident · No injuriesLimited investigationFinal reportBiagi, Arthur R. Buccaneer II XA650 · Lake Wales, FLEngine failure due to a hole that chafed in a fuel line on the suction side of the fuel filter due to poor maintenance.NTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…NTSB MKC89LA093Accident · No injuriesLimited investigationFinal reportHuff 1 · Liberty, MOPartial loss of engine power for an unknown reason. The soft terrain (plowed field) was a related factor.NTSB NYC87DNE03Accident · No injuriesFinal reportNoble Falcon X-P · Wallingford, CTThe undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing.NTSB ATL87LA137Accident · Serious injuriesLimited investigationFinal reportMoss Timothy C Quicksilver MX · Monroe, NCThe student plt reported that the engine lost power while the ultralight-type acft was on final approach to a mowed field owned by him. The acft subsequently impacted a tree at the end of the field and fell to the terrain nose-down. The student pilot noted…NTSB LAX86FUQ01Accident · Serious injuriesFinal reportStriplin Ranger · Lancaster, CAThe acft crashed in a flat stalled attitude at a high sink rate after a power loss in an attempted go-around. The pilot had been instructed to stand-by for a go-around because of traffic. The plt continued his approach off-set to the north of the rwy, at 50…NTSB ATL84LA174Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Thomasville, NCThe plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…NTSB ATL84LA089Accident · Minor injuriesLimited investigationFinal reportBach CGS Hawk · Newton, NCReportedly, the eng of the registered ultralight acft lost power in flt & the student plt began a forced landing however, before landing, the ultralight collided with utility wires, then it struck the ground. The plt reported that the acft had an unexpectedly…