NTSB investigations: Bombardier ROTAX (ALL), 2007
20 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\") = 2007
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") = 2007
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 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 SEA08CA016Accident · Minor injuriesData collectionFinal reportDye Rans S-12 Airaile · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA07CA142Accident · Minor injuriesData collectionFinal reportFurey Kitfox IV · Cowen, WVThe in-flight collision with a bird resulting in separation of the propeller.NTSB SEA07LA252Accident · No injuriesLimited investigationFinal reportKearney Pulsar XP · Cottonwood, AZThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB CHI07LA238Accident · 1 fatalLimited investigationFinal reportSwanson Aventura II · Lakewood, WIThe pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.NTSB ATL07CA108Accident · No injuriesData collectionFinal reportEvektor Aerotechnic Sportstar · Shirley, NYThe student pilot's failure to maintain adequate airspeed resulting in a stall. Contributing to the accident was the student pilots failure to relinquish the flight controls when instructed to do so.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB CHI07LA199Accident · Minor injuriesLimited investigationFinal reportHesler Zodiac CH 601 HDS · Jamestown, OHThe loss of engine power during takeoff for undetermined reasons, the pilot not performing an aborted takeoff at the initial recognition of a loss of engine performance, and the stall/mush the pilot encountered after takeoff.NTSB SEA07CA162Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus-3DM · Minden, NVThe flight's encounter with severe downdrafts during cruise flight. Contributing factors were the pilot's inadvertent selection of unsuitable terrain with hidden obstructions.NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB LAX07LA156Accident · 2 fatalLimited investigationFinal reportTeague Rans S-6ES Coyote II · Nyssa, ORLoss of aircraft control while maneuvering for undetermined reasons.NTSB DFW07CA098Accident · No injuriesData collectionFinal reportFlagg Kitfox IV · Centerville, TXThe loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA116Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-A1 · Warrenton, MOThe pilot's inadequate pre-flight planning which resulted in exhaustion of the fuel supply and the unsuitable terrain encountered for the forced landing. A factor in the accident was inaccurate fuel quantity indication.NTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB DEN07LA074Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pueblo, COThe pilot of the North American SNJ-5 warbird's inadequate visual lookout while taxiing, resulting in an on-ground collision with the stationary Grob motor glider.NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.