NTSB investigations: Bombardier ROTAX (ALL), FL
76 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.\"eventStateOrRegion\" = 'FL' 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" = 'FL' 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" 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 MIA99LA054Accident · No injuriesLimited investigationFinal reportDean Kolb Firestar 1 · Davenport, FLThe pilot's failure to perform weight and balance calculations, resulting in a loss of directional control on initial takeoff climb due to an aft center of gravity flight condition, in flight collision with trees and terrain. Contributing to the accident was…NTSB ATL99LA003Accident · No injuriesLimited investigationFinal reportAuxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FLThe pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.NTSB MIA98LA184Accident · No injuriesLimited investigationFinal reportProgressive Aerodyne Stingray · Lake Tarpon, FLThe pilot's failure to insure that the landing gear was in the up-and-locked position prior to the water landing.NTSB MIA98LA141Accident · 1 fatalLimited investigationFinal reportStar-Lite Engineering Warp 1A · Lakeland, FLthe pilot's failure to maintain airspeed, while maneuvering on crosswind in the traffic pattern, which resulted in an inadvertent stall, and an in-flight collision with a building and the terrain. Factors relating to the accident were: the pilot's decision to…NTSB MIA97LA166Accident · Serious injuriesLimited investigationFinal reportTravis C. Elmore B2B/582 · Haines City, FLThe pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…NTSB MIA97LA136Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Hollywood, FLthe student pilot's failure to maintain directional control during the landing/go-around, which led to subsequent in-flight collision with a fixed object (approach light/light bar/sign) and terrain. The student's failure to obtain the proper touchdown point…NTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.NTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.NTSB ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…NTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.NTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.NTSB MIA95LA140Accident · No injuriesLimited investigationFinal reportMoncrief Zodiac 601 · Fernandina Bch, FLThe failure of maintenance personnel to adequately torque the propeller bolts during the last inspection resulting in the bolt failures and the loss of the propeller.NTSB MIA95LA124Accident · Minor injuriesLimited investigationFinal reportBubel, John A. Condor 2 · Homestead, FLLoss of engine power for undetermined reasons.NTSB MIA95LA125Accident · No injuriesLimited investigationFinal reportFabre Searay Bombadier · Orlando, FLThe abrupt use of the flight controls,by the pilot-in-command while taxiing on water that resulted in the airplane capsizing.NTSB MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…NTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…NTSB MIA92LA155Accident · No injuriesLimited investigationFinal reportDewitt, Richard A. Kitfox · Vero Beach, FLFailure of the engine due to fuel contamination resulting in a forced landing in a grove at which time the aircraft struck trees.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 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 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 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 MIA83LA091Accident · No injuriesLimited investigationFinal reportGray J-3 Trainer · Lakeland, FLWhile maneuvering to enter the ultralight landing area on the arpt during an eaa fly-in, the elevator became jammed in the down position when a bolt in the linkage became jammed against the wheel axle which had been bent in a previous accident. The plt was…