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 MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…NTSB LAX02LA297Accident · Minor injuriesLimited investigationFinal reportPaige Kolb MK III · Fresno, CAthe student pilot's excessive rotation and failure to obtain/maintain adequate airspeed during takeoff, resulting in a stall.NTSB NYC02LA195Accident · 1 fatalLimited investigationFinal reportPaiement Rans S-12 · Mercer, METhe pilot's improper in-flight decision, and failure to maintain adequate clearance, which resulted in a collision with a wire during a low altitude flight.NTSB DEN02LA109Accident · 2 fatalLimited investigationFinal reportSabian Rans S-12XL · Mexican Hat, UTthe pilot's inadequate in-flight planning and decision making (flying up a canyon with insufficient altitude) which resulted in an inadvertent stall/mush, and the pilot's failure to follow the proper emergency procedures for activating his Ballistic Recovery…NTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.NTSB ANC02LA121Accident · No injuriesLimited investigationFinal reportGardner Kitfox · Fairbanks, AKA partial loss of engine power due to an engine bearing failure during the takeoff initial climb. A factor in the accident was unsuitable terrain for a forced landing.NTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.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 MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.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 NYC02LA163Accident · No injuriesLimited investigationFinal reportNiemann Champion II · Foxboro, MAThe pilot's failure to maintain aircraft control during the landing flare.NTSB FTW02LA231Accident · Minor injuriesLimited investigationFinal reportPage Rans S-7 · Welsh, LAthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB CHI02LA226Accident · No injuriesLimited investigationFinal reportGiroux Air Cam · Ozawkie, KSThe pilot's delay in aborting the landing. A contributing factor was the excessive airspeed.NTSB NYC02LA139Accident · No injuriesLimited investigationFinal reportMicket Avid Aerobat · Chesapeake, VAA total loss of engine power due to a seized cylinder, and the pilot's improper decision to conduct the flight with a known deficiency to the engine.NTSB IAD02LA072Accident · No injuriesLimited investigationFinal reportDesimone Zodiac CH-601-H · Wadsworth, OHThe pilot's overrotation after take off, which resulted in an inadvertent stall/mush. A factor was the pilot's decision to take off with a tailwind.NTSB SEA02LA120Accident · No injuriesLimited investigationFinal reportWelborn Pulsar XP · Prineville, ORThe disconnection of the throttle cable on landing resulting in the aircraft's engine going to full throttle and the pilot's subsequent failure to maintain directional control after securing the engine during the landing event.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 NYC02LA124Accident · No injuriesLimited investigationFinal reportHunter A-28 Victor · Shelter Island, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a collision with trees.NTSB NYC02LA120Accident · Serious injuriesLimited investigationFinal reportSmith Kitfox Classic IV · Limerick, METhe pilot's failure to perform a modification required by the manufacturer, which resulted in a failure of the float covering.NTSB NYC02LA099Accident · No injuriesLimited investigationFinal reportBoucher Revolution Mini 500 · Sterling, MAA misalignment of the rotor system drive belt, which resulted in belt chaffing, its subsequent separation, and a resultant loss of power to the rotor system. Also causal was the relatively low altitude and airspeed at which the separation occurred, which…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 LAX02LA155Accident · 1 fatalLimited investigationFinal reportMueller Skyraider 1 · Elko, NVthe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW02LA134Accident · 1 fatalLimited investigationFinal reportRobinson Tierra II · Hooker, OKthe loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.NTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB MIA02LA086Accident · Serious injuriesLimited investigationFinal reportLett R/Campbell K Aircam · Troy, ALthe pilot-in-commands decision to fly at a low altitude and his improper visual lookout resulting in an in-flight collision static with wires.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 NYC02LA073Accident · Minor injuriesLimited investigationFinal reportAnnis Fisher FP-202 · Parksley, VAThe pilot's decision to continue the takeoff. A factor in the accident was the soft wet runway.NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB LAX02LA081Accident · No injuriesLimited investigationFinal reportConrad Pulsar 582 · Prescott, AZThe pilot failed to maintain landing reference speed and aircraft control. A factor was the gusty wind conditions.NTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…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 SEA02LA021Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Ashland, ORThe pilot's excessive use of brakes. A factor was the pilot's lack of recent experience in type of aircraft.NTSB FTW02LA057Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-24E · El Paso, TXthe pilot's failure to maintain minimum airspeed for flight, resulting in an inadvertent stall while maneuvering. A contributing factor was the failure of the tow rope.NTSB MIA02LA042Accident · 1 fatalLimited investigationFinal reportFerguson A 26 Vulcan SS · Newnan, GAThe pilot's failure to maintain directional control during landing and go-around, resulting in a collision with a runway perimeter fence pole and trees.NTSB MIA02LA022Accident · 1 fatalLimited investigationFinal reportRobert N. Gilmore Rans S-10 · Oneonta, ALThe failure of the pilot to maintain airspeed following loss of engine power resulting in the airplane stalling and entering a spin from which it crashed. Factors in the accident was improper repair of the front cylinder intake manifold seal by the pilot…NTSB CHI02LA040Accident · Minor injuriesLimited investigationFinal reportLyon Horizon 1 · Richland, MOThe pilot not attaining altitude/clearance from the tree line during the aborted landing. Factors to the accident were the pilot selecting to operate the airplane on the rough/uneven runway, the pilot's lack of total experience in the airplane, and the tree…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 ATL02LA009Accident · 1 fatalLimited investigationFinal reportBass Moni · Locust Grove, GAThe pilot's failure to maintain airspeed during a low-altitude aerobatic maneuver, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into terrain.NTSB NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.NTSB MIA02LA014Accident · 2 fatalLimited investigationFinal reportRans S-6 · Wyatte, MSthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with trees, while at a low altitude.NTSB CHI02LA003Accident · Serious injuriesLimited investigationFinal reportKainz Kitfox IV · Tomahawk, WIThe inadvertent stall/spin encountered by the pilot during a slow flight maneuver. Factors relating to this accident were the low airspeed and the trees.NTSB FTW02LA002Accident · Serious injuriesLimited investigationFinal reportHamilton Genesis · Grants, NMthe loose throttle cable resulting in a partial loss of engine power. Contributing factors were the pilot's failure to perform the required yearly condition inspection prior to flight and the lack of suitable terrain for the forced landing.NTSB NYC02LA001Accident · Serious injuriesLimited investigationFinal reportClark T Bird II · Elberon, VAA partial power loss for undetermined reasons.NTSB ANC01LA140Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Chugiak, AKThe pilot's inadvertent stall of the airplane during takeoff.NTSB NYC01LA220Accident · No injuriesLimited investigationFinal reportAndre Mini Max 1500R · Chesapeake, VAThe pilot's failure to follow the engine manufacturer's descent procedure, which resulted in a lean mixture condition and subsequent engine seizure.NTSB LAX01LA298Accident · No injuriesLimited investigationFinal reportSparke Air Command 582 Dual · Gerlach, NVThe pilot's inability to maintain altitude because of the gyrocopter's inadequatly designed performance capability.