NTSB investigations: Bombardier ROTAX (ALL), FL
14 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Loss of control - in flight”. 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
| 1988 | 1 |
|---|---|
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 3 |
| 1999 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2007 | 1 |
Where
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.\"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')
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\" = 250))
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')
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" = 250))
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 MIA08LA023Accident · Serious injuriesLimited investigationFinal reportPorter Glen Aventura II · Rockledge, FLThe failure of the pilot to maintain airspeed during climbout, resulting in an aerodynamic stall and uncontrolled descent. Contributing to the severity of the pilot's injuries was the inadequate manufacture of the shoulder harness restraint cables.NTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ATL01LA092Accident · Serious injuriesLimited investigationFinal reportKolb Twin Star Mark III · Edgewater, FLThe loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.NTSB ATL01LA077Accident · 1 fatalLimited investigationFinal reportKenneth West ARV 582 · Sebring, FLThe pilot's failure to maintain flying speed, followed by a subsequent inadvertent stall spin.NTSB MIA01LA114Accident · Serious injuriesLimited investigationFinal reportArnet Pereyra Aventura II · Rockledge, FLthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.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 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 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 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 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 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.