NTSB investigations: Rotax 912ULS series

475 cases on aircraft whose registry engine model is Rotax 912ULS series. 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 ('55572'))
  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.

NTSB WPR14CA004Accident · Minor injuriesData collectionFinal reportVenables Zenith CH701 · Snohomish, WAA jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.Oct 3, 2013 · N143TZ · Substantial damageNTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.Sep 20, 2013 · N619BV · Substantial damageNTSB CEN13CA545Accident · No injuriesData collectionFinal reportSwedener Rans S-6ES · Mullen, NEThe gopher holes and soft terrain the airplane encountered, which resulted in the airplane nosing over.Sep 10, 2013 · N611WE · Substantial damageNTSB ANC13FA095Accident · 1 fatalField investigationFinal reportZenith 701 · Big Lake, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he could not recover.Sep 9, 2013 · N701MG · Substantial damageNTSB WPR13CA401Accident · No injuriesData collectionFinal reportScheel Stanley K KITFOX-SERIES 7 · Cascade, IDThe pilot's failure to maintain a proper glide path, which resulted in a touchdown short of the runway.Sep 7, 2013 · N7075Z · Substantial damageNTSB WPR13LA396Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Sisters, ORThe pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…Sep 2, 2013 · N102HA · Substantial damageNTSB WPR13CA387Accident · No injuriesData collectionFinal reportTL Ultralight Stingsport · Burlington, WAThe pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in a nose gear collapseAug 24, 2013 · N9494 · Substantial damageNTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…Aug 16, 2013 · N19UA · Substantial damageNTSB WPR13CA373Accident · Minor injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NVThe pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.Aug 15, 2013 · N110GX · Substantial damageNTSB ERA13LA346Accident · Serious injuriesLimited investigationFinal reportFpna A-22 Valor · Wurtsboro, NYThe pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.Jul 30, 2013 · N912FP · Substantial damageNTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.Jul 18, 2013 · N926JB · Substantial damageNTSB CEN13LA398Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Sandwich, ILThe pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.Jul 7, 2013 · N549LS · Substantial damageNTSB WPR13CA297Accident · Minor injuriesData collectionFinal reportCharles Peet Zenith CH 701 · Jackson, WYThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff/initial climb.Jun 28, 2013 · N44CP · Substantial damageNTSB CEN13LA308Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Elyria, OHThe failure of the canopy latch spring, which caused the canopy to open during initial climb. Contributing to the accident was the installation of an improper part in the canopy latch assembly, which led to the failure of the canopy latch spring.May 30, 2013 · N319SV · Substantial damageNTSB ERA13CA195Accident · No injuriesData collectionFinal reportPhoenix Air U15 · Foscoe, NCThe motorized glider’s encounter with clear air turbulence, which resulted in substantial damage to the empennage.Apr 6, 2013 · N94DK · Substantial damageNTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.Mar 30, 2013 · N572LS · Substantial damageNTSB WPR13CA142Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Jose, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to adequately latch the canopy before takeoff.Mar 10, 2013 · N811EV · Substantial damageNTSB WPR13LA069Accident · Serious injuriesLimited investigationFinal reportPowerchute Airwolf 912ULS · Dell, MTThe pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.Dec 14, 2012 · N480QP · Substantial damageNTSB WPR13CA039Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Carlsbad, CAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with parked aircraft. Contributing to the accident was the pilot's lack of experience in the airplane make/model.Nov 11, 2012 · N153TB · Substantial damageNTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.Nov 10, 2012 · N678AD · 2 aircraft · Substantial damageNTSB WPR13CA046Accident · No injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe student pilot’s improper landing flare, which resulted in a hard landing.Nov 4, 2012 · N110GX · Substantial damageNTSB CEN13CA017Accident · Serious injuriesData collectionFinal reportHunthrop Autogyro MTO Sport · Bourland, TXThe pilot's decision to fly the gyroplane in gusty wind conditions that exceeded his limitations and his resultant loss of control during takeoff.Oct 20, 2012 · N589DH · Substantial damageNTSB ERA13CA047Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Plymouth, MAThe pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.Oct 18, 2012 · N555HT · Substantial damageNTSB CEN13IA024Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Elyria, OHThe manufacturing defects in the main landing gear leg, which resulted in its eventual failure.Oct 17, 2012 · N21ZA · Minor damageNTSB WPR13FA013Accident · 1 fatalField investigationFinal reportAeropro CZ A240 · Half Moon Bay, CAThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.Oct 15, 2012 · N72AH · Substantial damageNTSB WPR12FA395Accident · 1 fatalField investigationFinal reportSkykits USA Savannah ADV · Murtaugh, IDThe pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…Sep 3, 2012 · N9764J · Substantial damageNTSB WPR12FA385Accident · Serious injuriesField investigationFinal reportEaston Searey · Friday Harbor, WAThe pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.Aug 31, 2012 · N346PE · Substantial damageNTSB CEN12CA603Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Pittsford, MIThe student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.Aug 31, 2012 · N995LS · Substantial damageNTSB CEN12CA600Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Columbus, OHThe failure of the right main landing gear strut due to a preexisting crack.Aug 26, 2012 · N904LA · Substantial damageNTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.Aug 19, 2012 · N812S · Substantial damageNTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.Aug 12, 2012 · N633EV · Substantial damageNTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.Jul 25, 2012 · N930SA · Substantial damageNTSB CEN12LA466Accident · 1 fatalLimited investigationFinal reportToman Jack JR Skystar Kitfox 4 · Cross Lake, MNThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment due to marijuana.Jul 22, 2012 · N602JT · Substantial damageNTSB WPR12CA338Accident · No injuriesData collectionFinal reportAerotrek A220 · Bremerton, WAThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions.Jul 21, 2012 · N216V · Substantial damageNTSB CEN12LA676Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Elyria, OHThe pilot’s misjudged landing flare, which resulted in a hard landing.Jul 20, 2012 · N21ZA · Substantial damageNTSB CEN12IA451Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Marysville, OHFatigue failure of the left main wheel assembly on takeoff, which resulted in a loss of directional control and runway excursion.Jul 16, 2012 · N566FD · Minor damageNTSB CEN12LA445Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro SportCruiser · Waynesville, OHThe airplane's collision with fence posts during an aborted takeoff due to a sudden change in wind direction.Jul 15, 2012 · N516JG · Substantial damageNTSB ERA12CA461Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Sanford, METhe student pilot’s inadequate landing flare and improper recovery from a bounced landing.Jul 13, 2012 · N602PS · Substantial damageNTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.Jul 5, 2012 · N177N · Substantial damageNTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.Jun 30, 2012 · N308TA · Substantial damageNTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…Jun 15, 2012 · N206GX · Substantial damageNTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.Jun 14, 2012 · N617EV · Substantial damageNTSB CEN12CA356Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Indianapolis, INThe student pilot’s failure to maintain control of the airplane during takeoff.Jun 11, 2012 · N902LA · Substantial damageNTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.May 17, 2012 · N297SC · Substantial damageNTSB CEN12CA295Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Moorhead, MNThe failure to maintain adequate airspeed for the wind conditions during landing, which resulted in a loss of airplane control.May 9, 2012 · N9922P · Substantial damageNTSB CEN12CA281Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Houston, TXThe pilot’s improper recovery from a bounced landing.May 5, 2012 · N919LA · Substantial damageNTSB WPR12LA176Accident · Serious injuriesLimited investigationFinal reportSkykits USA Savannah ADV · Ookala, HIA loss of engine power during cruise for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s failure to avoid an…Apr 19, 2012 · N5089F · Substantial damageNTSB CEN12LA231Accident · Serious injuriesLimited investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Ann Arbor, MIThe student pilot's failure to maintain airplane control on takeoff, which resulted in an aerodynamic stall and collision with terrain.Apr 5, 2012 · N75GX · DestroyedNTSB ERA12LA264Accident · Serious injuriesLimited investigationFinal reportPowrachute Airwolf 912ULS · Plant City, FLThe flight instructor’s failure to ensure an obstruction-free takeoff path prior to initiating the takeoff and his inadequate preflight inspection of the powered parachute’s flight controls, which resulted in a collision with trees during the takeoff.Apr 1, 2012 · N415BA · Minor damageNTSB WPR12LA113Accident · No injuriesLimited investigationFinal reportHaycraft Sport Hornet · Mariposa, CAImproper clearance and inadequate heat shielding between engine components and the exhaust system, which resulted in an in-flight fire.Feb 21, 2012 · N72PD · Substantial damage