NTSB investigations: Bombardier ROTAX (ALL), 1983
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\") = 1983
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") = 1983
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 DEN83FTE13Accident · Minor injuriesFinal reportEipper Quicksilver MX 11 · Erie, COThe plt of the 2 place, ultralight vehicle stated that he was demonstrating a power off glide when a severe sink developed. He applied full power; however, he was unable to arrest the descent prior to ground impact. The plt reported that the wind was variable…NTSB DEN83FTM07Accident · Minor injuriesFinal reportWormley Wizard/T-38 · Spanish Fork, UTThe acft collided with the ground after a stall at about 75 ft afl during takeoff. The pilot stated that he took off on runway 30 after a ground roll of about 200 ft, started to climb, and at about 75 ft noticed he was flying too slow, he felt a buffet and…NTSB NYC83LA166Accident · Minor injuriesLimited investigationFinal reportRotec/Botsford Rally 3 · Kirkville, NYThe 2 place ultralight acft was on final apch to land when the propeller began to freewheel on the propeller shaft. The eng continued to operate & respond to throttle inputs, but the propeller did not produce thrust. The ultralight began to lose altitude…NTSB FTW83FA288Accident · Serious injuriesField investigationFinal reportRotec Rally III · Seven Points, TXReportedly, the plt had previously flown in a Rotec ralley iii ultralight, but handled the controls for only a few minutes. After assembling this ultralight, N148RE, from a kit, he made the necessary ground checks & preflt inspection, then took off on the 1st…NTSB ATL83LA218Accident · No injuriesLimited investigationFinal reportRotec Engineering Rally 3 · Newport, MDThe acft nosed over onto its wings during landing on a soft muddy field. The weather was VMC and no flt plan was filed. The pilot stated he was making a soft field landing on the muddy field. The acft touched down hard in a nosedown attitude. The rt side…NTSB FTW83LA182Accident · No injuriesLimited investigationFinal reportRotec Rally 3B · Edmond, OKThe plt of the registered, 2 place, ultralight acft reported that the winds were variable & he was intending to land into the wind. However, he further stated that he believed the wind had switched to a tail wind before the landing. After landing, he realized…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…