OpenAirDocs.org

NTSB investigations: Bombardier ROTAX (ALL)

18 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Hard landing”. 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 per year

19832026

Where

Open the map

Latest cases

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\" = 200))
  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 DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…Dec 31, 2006 · N928LM · Substantial damageNTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.Aug 10, 2005 · N912PJ · Substantial damageNTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.Aug 6, 2005 · N42923 · Substantial damageNTSB DEN04LA051Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Berthoud, COthe pilot's improper flare and his inadequate compensation for wind. The wind gust was a contributing factor.Mar 8, 2004 · N7138K · Substantial damageNTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.Sep 15, 2002 · N25069 · Substantial damageNTSB 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.Feb 9, 2002 · N3218N · Substantial damageNTSB FTW01LA070Accident · No injuriesLimited investigationFinal reportBartels Rans S-7 · Lafayette, LAthe pilot's improper flare which resulted in a hard landing.Feb 25, 2001 · N777SB · Substantial damageNTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.Jun 28, 2000 · N912EA · Substantial damageNTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.Feb 16, 2000 · N460AK · Substantial damageNTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…Aug 30, 1998 · N9GH · Substantial damageNTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.May 9, 1997 · N757DM · Substantial damageNTSB CHI97LA128Accident · No injuriesLimited investigationFinal reportRochette Rans S-12 XL · Hays, KSthe pilot improperly flared the airplane and the pilot's lack of experience in the type of airplane.Mar 27, 1997 · N102EY · Substantial damageNTSB LAX97LA140Accident · No injuriesLimited investigationFinal reportHoffman, Wolf, Flugzeugbau Super Dimona HK 36R · Scottsdale, AZthe pilot's failure to maintain an adequate glide path.Mar 18, 1997 · N351HK · Substantial damageNTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.Jul 18, 1996 · N695WM · Minor damageNTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.Sep 18, 1994 · N1280D · Substantial damageNTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.Sep 25, 1993 · N273GW · Substantial damageNTSB MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.Dec 19, 1992 · N4305C · Substantial damageNTSB ATL83LA218Accident · No injuriesLimited investigationFinal reportRotec Engineering Rally 3 · Newport, MDThe acft nosed over onto its wings during landing on a soft muddy field. The weather was VMC and no flt plan was filed. The pilot stated he was making a soft field landing on the muddy field. The acft touched down hard in a nosedown attitude. The rt side…Jun 4, 1983 · N2046D · Substantial damage