NTSB investigations: Bombardier ROTAX (ALL), 2006
22 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
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 year(c.\"eventDate\") = 2006
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") = 2006
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 DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…NTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB DFW06CA204Accident · No injuriesData collectionFinal reportRon Burleigh Air Cam · Post, TXThe pilot's failure to maintain clearance with power lines while making a precautionary landing.NTSB DFW06CA196Accident · No injuriesData collectionFinal reportPearson Superfly · Denton, TXThe loss of control as result of the pilot's selection of an unsuitable landing area. A contributing factor was the muddy terrain.NTSB ATL06LA115Accident · 1 fatalLimited investigationFinal reportMcWhorter Skystar Vixen · Peachtree City, GAThe pilot's failure to maintain airspeed while maneuvering to reverse his direction following loss of engine power shortly after takeoff resulting in an inadvertent stall and collision with the ground. A factor in the accident was a loss of engine power for…NTSB NYC06LA187Accident · 1 fatalLimited investigationFinal reportBurleigh SeaRey · Ringoes, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Factors included a partial loss of engine power for undetermined reasons.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB ANC06LA086Accident · Serious injuriesLimited investigationFinal reportStorm Zenair CH-701 · Fairbanks, AKThe total loss of engine power for an undetermined reason during cruise flight, which resulted in an emergency descent into trees.NTSB CHI06CA171Accident · Serious injuriesData collectionFinal reportCroke Zenith CH 701 · Brussels, WIThe pilot not maintaining clearance from the trees during final approach. The trees located along the final approach course were a factor in the accident.NTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.NTSB SEA06CA107Accident · No injuriesData collectionFinal reportTaplin Avid Flyer · Grants Pass, ORThe partial loss of engine power for undertermined reasons, resulting in a forced landing and substantial damage to the airplane. A contributing factor was the transmission wire.NTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.NTSB LAX06LA170Accident · 1 fatalLimited investigationFinal reportSchlitter Rans S-18 Stinger · Llano, CAan in-flight loss of control and collision with terrain for undetermined reasons.NTSB ANC06CA051Accident · Minor injuriesData collectionFinal reportLanford Antares MA-33 · Trapper Creek, AKThe non-certificated pilot's failure to maintain altitude/clearance during final approach for landing, which resulted in the airplane striking a tree, and an in-flight collision with terrain. A factor associated with the accident was the tree.NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB DEN06LA055Accident · Serious injuriesLimited investigationFinal reportMcLaughlin Rans S-7 · Hudson, COthe pilot's failure to maintain control of the airplane during an attempted landing. Contributing factors include the pilot's improper in-flight planning and decision making, the pilot's lack of experience in tailwheel airplanes, the pilot's lack of a…NTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.NTSB ATL06LA051Accident · Serious injuriesLimited investigationFinal reportEakle R Grandin Jr Talon XP · Auburn, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A factor was the improper maintenance inspection of the engine fuel lines resulting in loss of engine power due to a loose fuel line and subsequent fuel starvation.