NTSB investigations: Bombardier ROTAX (ALL), 1984
7 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 per year
| 1983 | 7 |
|---|---|
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 27 |
| 1993 | 20 |
| 1994 | 16 |
| 1995 | 27 |
| 1996 | 20 |
| 1997 | 31 |
| 1998 | 35 |
| 1999 | 31 |
| 2000 | 32 |
| 2001 | 51 |
| 2002 | 39 |
| 2003 | 20 |
| 2004 | 22 |
| 2005 | 16 |
| 2006 | 22 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 29 |
| 2010 | 21 |
| 2011 | 27 |
| 2012 | 17 |
| 2013 | 16 |
| 2014 | 10 |
| 2015 | 14 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 6 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 12 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 5 |
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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 LAX85FA066Accident · 1 fatalField investigationFinal reportBarry Zielinski SNS 8 Hiperlt · Corona, CAN5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar…NTSB CHI85LA030Accident · No injuriesLimited investigationFinal reportMoore Quicksilver MX II · Aurora, ILPlt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same…NTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…NTSB SEA84LA143Accident · No injuriesLimited investigationFinal reportEipper Quicksilver Mark II · Salem, ORPlt attempted takeoff on short grass field at gross wt with a OAT of aprx 80 deg f. once airborne the acft drifted to the left of the airstrip. Plt pulled up to clear a fence. After clearing the fence the acft stalled striking the ground with the left wing…NTSB LAX84LA412Accident · No injuriesLimited investigationFinal reportMolino PIK 20E · Fremont, CAThe plt stated that during takeoff, the motorized glider had just lifted off when the right wing dropped & hit tall weeds next to the 20 ft wide paved rwy. The weeds were about 2 1/2 ft tall. Subsequently, the glider 'ground looped' to the right & the…NTSB ATL84LA174Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Thomasville, NCThe plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…NTSB ATL84LA089Accident · Minor injuriesLimited investigationFinal reportBach CGS Hawk · Newton, NCReportedly, the eng of the registered ultralight acft lost power in flt & the student plt began a forced landing however, before landing, the ultralight collided with utility wires, then it struck the ground. The plt reported that the acft had an unexpectedly…