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 ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB MIA90FA102Accident · 1 fatalField investigationFinal reportFarrington AIR Command 532 · Okeechobee, FLPilot's decision to attempt to fly the gyrocopter without proper training resulting in the inflight loss of control and subsequent crash.NTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.NTSB DEN90LA083Accident · No injuriesLimited investigationFinal reportPeterson KIT FOX Model 1 · Highwood, MTA premature lift-off by the pilot, resulting in a stall/mush.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 CHI90DEP01Accident · Serious injuriesFinal reportWychen Challenger II · Warrens, WIA broken cranskshaft which resulted in the loss of power. A factor related to the accident was: the lack of suitable terrain for a forced landing.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 CHI89DEP11Accident · Minor injuriesFinal reportTierra II Panther 2 Plus · Tomah, WIThe pilot's premature liftoff, which resulted in a stall/mush and subsequently impact on the runway.NTSB MIA89LA225Accident · Minor injuriesLimited investigationFinal reportCocchiarella Buccaneer II · Clermont, FLImproper planning/decision by the pilot, which resulted in a subsequent collison with the ground, when the acft would not climb after takeoff. The high obstructions (trees) and high density altitude were considered to be contributing factors.NTSB CHI89DEP12Accident · Serious injuriesFinal reportSchuning/Teratorn Terra II · New Berlin, WIFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall.NTSB SEA89LA080Accident · Minor injuriesLimited investigationFinal reportMccoy Super Koala · Kelso, WAThe pilot's failure to adequately compensate for wind conditions, and the pilot's delay in initiating a go-around. Contributing to the accident were crosswind gusts, and lack of total pilot experience.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 LAX89DUQ03Accident · No injuriesFinal reportMartin Sorrell Hiperlight · Liano, CAEngine failure due to a seized piston.NTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…NTSB MKC88DCQ04Accident · Serious injuriesFinal reportTeratorn Tierra II · Plevna, KSThe pilot stated that on takeoff climb, approximately 100 feet AGL, the a/c broke to the right and hit the ground. The pilot suspected right aileron control problems. Inspection of a/c revealed no mechanical problems. The wind was light and variable at 10 KTS.NTSB MIA88LA226Accident · No injuriesLimited investigationFinal reportEvans Maxair MU503 · Fort Walton Bch, FLWhile on a personal flt with reported thunderstorms in the vicinity, the plt lost control of the homebuilt acft while on final aprch to land. The acft descended & collided with terrain.NTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…NTSB NYC88DHM01Accident · Serious injuriesFinal reportRutgers Agriplane · Freehold, NJThe plt was working for a firm that was developing the experimental, light weight, crop duster in a joint venture with another firm. An acdnt occurred as he was operating the acft at the location of one of the firms. The plt stated that after takeoff, 'I was…NTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…NTSB NYC88DFJ01Accident · Minor injuriesFinal reportHurd/Drifter XP503 · Baldwinsville, NYThe plt rprtd that during a preflt, he noted the fuel tank was about 1/4 full. He rprtd that as he was taking off, the acft was climbing thru about 200 ft AGL, when the eng lost power. From that position, he was unable to rtrn to the arpt or glide to an open…NTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.NTSB LAX88DUQ02Accident · Minor injuriesFinal reportIsgrigg Elite · Tehachapi, CAThe homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15…NTSB MKC87FA148Accident · 1 fatalField investigationFinal reportWatts 532 Elite · Davenport, IAWitnesses located 1/4 mi north of the accident site, observed the gyrocopter departing the Davenport, IA airport and turning to the southwest. While in cruise flight the witnesses observed the aircraft moving in an up and down motion prior to what appeared to…NTSB LAX87DUG05Accident · Serious injuriesFinal reportEipper Quicksilver MX II · Corona, CAWhile attempting to land on runway 25 at the Corona airport, Corona, California, in gusting wind conditions, the aircraft stalled and collided with the terrain. The pilot said that the 'extreme gusty wind conditions' combined with a very light and stable…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 ATL87DEI07Accident · Serious injuriesFinal reportEipper MX2 · Newbury, OHThe ultralight had not been flown for 8 months. Plt rpted that after takeoff the eng quit. Fuel had not been added since prior oct. Examination of eng revealed cracks in the exhaust system, evidence of overheating and recent scoring of cylinders. Witness…NTSB ANC87DAG03Accident · No injuriesFinal reportDenney FOX 1 · Palmer, AKThe pilot stated that after touchdown on the sand bar the aircraft struck an open ditch. The pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB SEA87LA107Accident · No injuriesLimited investigationFinal reportAerodynamics . Hawk Mkii · Ellensburg, WADespite warnings from the flight service station about turbulence, high winds aloft, severe low level wind shear, and low ceilings along the pilots intended route of flight, the pilot elected to depart the airport for his destination. Standing lenticular…NTSB BFO87DID03Accident · No injuriesFinal reportHam Wizard · Chesapeake, VADrg flt, a portion of the exhaust stack broke off & struck the wooden prop. Aprx 1/3 of the prop separated & a severe vibration started. The plt shut down the eng & headed for an open field. Due to lack of altitude, he was barely able to clear nearby trees.…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 CHI87DEE05Accident · Serious injuriesFinal reportResney Commander 447 · Lansing, ILThe acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered…NTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.NTSB MIA87FA003Accident · 1 fatalField investigationFinal reportGriffin STAR-LITE · Raymond, MSThe plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…NTSB ATL86LA238Accident · No injuriesLimited investigationFinal reportJoe Almon Falcon XP · Mt Olive, ALWhile apchg to land, the registered ultralight acft encountered a downdraft which exceeded its climb performance. The acft was headed twd power lines, so the plt elected to fly under the lines. As the ultralight was crossing under the power lines, one of its…NTSB LAX86FUM02Accident · 1 fatalFinal reportStar-Lite UNK · Ramona, CADuring a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the…NTSB MKC86LA170Accident · No injuriesLimited investigationFinal reportTeratorn Tierra 2 · Dixon, IAThe experimental acft was loaded near max gross wt on takeoff from the pvt sod airatrip. The plt stated the acft performed sluggishly during the climbout from the field. The plt stated that on the climbout that he was overflying a corn field bordering the…NTSB DEN86LA127Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Longmont, COThis experimental glider has a stowable 2 cycle eng mounted behind the cockpit. When the eng is stowed the glide ratio is about 40:1. When the eng is deployed but not running, the glide ratio is about 10:1. While returning after a 4 hr and 50 min flt the plt…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 CHI85FA284Accident · 1 fatalField investigationFinal reportEipper MX Super · Almont, MIWitnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had…NTSB FTW85FRD02Accident · 1 fatalFinal reportTeratorn Tierra II · Lake Charles, LAThe acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground…NTSB ANC85LAG01Accident · Minor injuriesFinal reportBrians Puffin · Eagle River, AKThe plt was conducting taxi tests on his homebuilt acft when it started to sustain a hull structure failure and control interference from separating parts. The acft pitched off the water, climbed to aprx 100 ft AGL, stalled and spun to ground impact.NTSB LAX85FA066Accident · 1 fatalField investigationFinal reportBarry Zielinski SNS 8 Hiperlt · Corona, CAN5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar…NTSB CHI85LA030Accident · No injuriesLimited investigationFinal reportMoore Quicksilver MX II · Aurora, ILPlt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same…NTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…NTSB SEA84LA143Accident · No injuriesLimited investigationFinal reportEipper Quicksilver Mark II · Salem, ORPlt attempted takeoff on short grass field at gross wt with a OAT of aprx 80 deg f. once airborne the acft drifted to the left of the airstrip. Plt pulled up to clear a fence. After clearing the fence the acft stalled striking the ground with the left wing…NTSB LAX84LA412Accident · No injuriesLimited investigationFinal reportMolino PIK 20E · Fremont, CAThe plt stated that during takeoff, the motorized glider had just lifted off when the right wing dropped & hit tall weeds next to the 20 ft wide paved rwy. The weeds were about 2 1/2 ft tall. Subsequently, the glider 'ground looped' to the right & the…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…NTSB DEN83FTE13Accident · Minor injuriesFinal reportEipper Quicksilver MX 11 · Erie, COThe plt of the 2 place, ultralight vehicle stated that he was demonstrating a power off glide when a severe sink developed. He applied full power; however, he was unable to arrest the descent prior to ground impact. The plt reported that the wind was variable…