NTSB investigations: Bombardier ROTAX (ALL)
756 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, 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'))
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'))
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 DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB DEN93LA003Accident · Serious injuriesLimited investigationFinal reportO'Connor SNO-BIRD XL · Bryan, TXDelamination of the rudder leading edge and subsequent jamming of the rudder.NTSB NYC93LA018Accident · No injuriesLimited investigationFinal reportFranklin-Sullivan Technologies FS 1 · Littletown, PAInadequate altitude due to an improperly planned approach which resulted in a tree strike on final approach.NTSB CHI92DCA05Accident · Serious injuriesFinal reportRettberg Rans S-7 · Charleston, MOThe pilot-in-command's poor weather evaluation which resulted in a takeoff into adverse weather conditions and a loss of airplane control.NTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.NTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.NTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB MIA92LA155Accident · No injuriesLimited investigationFinal reportDewitt, Richard A. Kitfox · Vero Beach, FLFailure of the engine due to fuel contamination resulting in a forced landing in a grove at which time the aircraft struck trees.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 BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.NTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.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 BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.NTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.NTSB NYC92DGM02Accident · No injuriesFinal reportPeres 5151 · Erie, PASeizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.NTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.NTSB ANC92LA048Accident · Minor injuriesLimited investigationFinal reportGerald G. Holland Challenger II · Fairbanks, AKExcessive taxispeed and directional control was not maintained. Factors to the accident were: lack of familiarization with aircraft and inadequate airspeed.NTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.NTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).NTSB ANC92LA036Accident · No injuriesLimited investigationFinal reportRichard C. Ballow Kitfox 1 · Valdez, AKThe pilot's improper use of the airplane's brakes. Factors which contributed to the accident were the icy runway condition and the pilot's lack of total experience with this type of operation.NTSB ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.NTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.NTSB LAX92LA002Accident · No injuriesLimited investigationFinal reportCano Avid Flyer · Sonora, CAFuel starvation due to vapor lock.NTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.NTSB DEN91LA112Accident · No injuriesLimited investigationFinal reportLars Avid Flyer · Colorado Spring, COThe pilot's delay in flaring the airplane. Factors were: (1) stuck piston rings and (2) the pilot's failure to use flaps.NTSB SEA91LA202Accident · 1 fatalLimited investigationFinal reportTaylor Air Command 532 Elite · Libby, MTLoss of control during takeoff due to the pilot's total lack of experience in the type of aircraft.NTSB SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.NTSB MIA91LA185Accident · 1 fatalLimited investigationFinal reportDonald R. Lee AIR Command · Quitman, MSThe pilot in commands failure to maintain control resulting in an uncontrolled descent and an in flight collision with terrain.NTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB CHI91DCA01Accident · Serious injuriesFinal reportGremminger Kolb Twinstar · St. Genevieve, MOThe failure of the pilot to abort the takeoff and improper remedial action by the pilot rated passenger after assuming control of the airplane. A factor associated with the accident is the pilot losing directional control during the takeoff ground run.NTSB LAX91LA229Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-500M · Minden, NVAn engine failure produced as a result of the pilot improperly adjusting the carburetor mixture jet.NTSB NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.NTSB CHI91DEM04Accident · No injuriesFinal reportFred B. Stencel Falcon X P · St. Charles, MIA result of the pilot in command not maintaining directional control during the go around maneuver. Factors associated with the accident were the pilot in command's lack of total experience and familiarity with the airplane.NTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.NTSB CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB NYC91DHA01Accident · 1 fatalFinal reportJames Cote Kolb Twinstar MK II · Gilbertsville, PAThe failure of the pilot to maintain control of the aircraft after an interuption of power.NTSB CHI90DCA02Accident · No injuriesFinal reportFisher Flying Products Classic BI Plane · Memphis, MOThe failure of the pilot to maintain directional control of the airplane during the landing roll. The pilot's lack of total aviation experience was a related factor.NTSB LAX90DVM03Accident · 1 fatalFinal reportIlli Thunder Gull · Calif Valley, CAPoor judgement of the pilot from use of a drug (cocaine), and the pilot allowing the design stress limits of the aircraft to be exceeded, while maneuvering, which resulted in overload failure of the wing spar & wing separation.NTSB CHI90LA222Accident · No injuriesLimited investigationFinal reportNaaman Haren Kitfox 1 · Grundy Center, IAGo-around delayed by the pilot in command.NTSB FTW90DRA07Accident · 1 fatalFinal reportBensen B-8M · Hearne, TXThe pilot's loss of control in flight due to excessive control inputs and his abrupt attempts to recover control of the aircraft prior to impact.NTSB CHI90DEC03Accident · Serious injuriesFinal reportMaxair MU532 · Troy, MIThe pilot's improper remedial action to regain directional control during the landing.NTSB LAX90DVG11Accident · Serious injuriesFinal reportGary Williams Avid Flyer · Redding, CAThe failure of the pilot to select the correct position of the fuel selector. Contributing to the accident was operation with a known dead battery.NTSB NYC90FHD01Accident · 1 fatalFinal reportMason Hummel Bird · Lumberton, NJFailure of the rudder attach bolt, which resulted in a loss of aircraft control and an uncontrolled descent to the ground.