Skip to content

NTSB investigations: Bombardier ROTAX (ALL), OH

17 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19872026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND 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

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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND 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

Run 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 CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.Dec 4, 2013 · N5955Y · Substantial damage NTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.Aug 30, 2012 · N84KF · Substantial damage NTSB CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.Nov 7, 2009 · N32786 · Substantial damage NTSB CHI08CA105Accident · No injuriesData collectionFinal reportSchultz Mini 500 · Batavia, OHThe failure of the helicopter's centrifugal clutch during hover which led to the pilot's inability to maintain control of the craft and its subsequent impact with the ground.Apr 6, 2008 · N62GS · Substantial damage NTSB CHI07LA199Accident · Minor injuriesLimited investigationFinal reportHesler Zodiac CH 601 HDS · Jamestown, OHThe loss of engine power during takeoff for undetermined reasons, the pilot not performing an aborted takeoff at the initial recognition of a loss of engine performance, and the stall/mush the pilot encountered after takeoff.Jul 6, 2007 · N43207 · Substantial damage NTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.Oct 10, 2006 · N5103R · Substantial damage NTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).Nov 9, 2003 · N456GW · Substantial damage 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.Jul 13, 2002 · N422EZ · Substantial damage NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.Aug 21, 1999 · N6268A · Substantial damage NTSB NYC98LA187Accident · Minor injuriesLimited investigationFinal reportAnkenbruck Searey · Chippewa Lake, OHEncounter with swells from a boat wake. A factor in the accident was the pilot's inadequate initial training.Sep 14, 1998 · N219LJ · Substantial damage NTSB NYC98LA088Accident · Serious injuriesLimited investigationFinal reportRamseyer Tierra II · Wooster, OHThe pilot's failure to maintain airspeed during the landing approach. A factor in this accident was the pilot's lack of experience in make and model.Apr 3, 1998 · N63250 · Substantial damage NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.Dec 19, 1997 · N727EB · Destroyed NTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.Aug 23, 1997 · N7240E · Substantial damage NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.Aug 13, 1995 · N35KK · Substantial damage NTSB NYC95LA039Accident · 1 fatalLimited investigationFinal reportWilliam MC Glumphy Kitfox III · Cadiz, OHThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall, and uncontrolled collision with the ground. A factor was pilot's lack of total experience in this make and model.Dec 4, 1994 · N345WM · Destroyed NTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.Jul 19, 1994 · N63EA · 2 aircraft · Substantial damage 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…Jun 28, 1987 · N3924L · Substantial damage