NTSB investigations: Bombardier ROTAX (ALL), FL
7 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2006 | 1 |
Where
Open the mapLatest 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\" = 130))
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" = 130))
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 MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB MIA99LA183Accident · Serious injuriesLimited investigationFinal reportSouth Mississippi Light Aircra Buccaneer II · Panacea, FLThe intentional continued operation of the airplane by the pilot-in-command with known deficiencies with the pitot system after takeoff, resulting in erroneous airspeed indications, and inadvertent stall by the pilot resulting in the uncontrolled descent into…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 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 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 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…