NTSB investigations: Bombardier ROTAX (ALL), 2000
32 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\") = 2000
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") = 2000
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 LAX01LA060Accident · No injuriesLimited investigationFinal reportJohn D. Lueck Avid Amphibian · Las Vegas, NVThe failure of the landing gear axle for undetermined reasons.NTSB MIA01LA011Accident · Serious injuriesLimited investigationFinal reportCamillo Annaloro C A Spcl Quicks · Lucedale, MSThe failure of the pilot to secure a fabric panel during preflight inspection resulting in the panel separating from the aircraft during climb after takeoff, passing through the propeller and damaging wing flap fabric, loss of engine power due to wing flap…NTSB ANC01LA008Accident · Minor injuriesLimited investigationFinal reportWeste Avid · Chugiak, AKA total loss of engine power due to a piston failure. Factors in the accident were an out-of-rig flight control system, an inadvertent stall, and no suitable terrain for a forced landing.NTSB NYC00LA266Accident · Serious injuriesLimited investigationFinal reportMorrison RANS-12 · Warrenton, VAThe pilot's inadequate airspeed which resulted in the inadvertent stall. A factor related to the accident was the gusting wind condition.NTSB CHI00LA275Accident · No injuriesLimited investigationFinal reportFlurry Aventura II · Benton, ILthe pilot's inadvertent wheel down landing in water.NTSB LAX00LA317Accident · No injuriesLimited investigationFinal reportSteinke Early Bird -JENNY · Chino, CAThe engine lost power for undetermined reasons and nosed over in a soft field during the resulting forced landing.NTSB LAX00LA311Accident · No injuriesLimited investigationFinal reportPerrucci Randall J Revolution MINI-500 · Gridley, CAThe fracture and separation of a control rod in the cyclic flight control system.NTSB DEN00LA155Accident · Serious injuriesLimited investigationFinal reportTrammell Avid Flyer · Trinidad, COthe failure of wing lift strut attachment rod for an unknown reason, which resulted in a loss of aircraft control during initial takeoff climb.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.NTSB ANC00LA101Accident · Minor injuriesLimited investigationFinal reportHaskins CHALLENGER-2 · Central, AKThe pilot's inadequate evaluation of the winds, and his intentional attempt to takeoff into the known adverse weather. Factors associated with this accident were the gusty crosswind conditions.NTSB CHI00LA240Accident · Minor injuriesLimited investigationFinal reportThompson Avid Mark IV · Springfield, MOthe pilot's inadequate preflight planning, his failure to abort the takeoff, and the inadequate airspeed. Factors included the tall runway grass, the quartering tailwind, and the trees.NTSB FTW00LA222Accident · Serious injuriesLimited investigationFinal reportRomero SEA REY · Tulsa, OKThe loss of control by the pilot due to incapacitation for unknown reasons.NTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.NTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.NTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.NTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.NTSB SEA00LA105Accident · No injuriesLimited investigationFinal reportSchmidt SEA REY · Northport, WAThe pilot's loss of directional control due to his inadequate remedial action in correcting for engine torque during the aborted landing. Factors include trees near the area where the pilot was attempting to land.NTSB NYC00LA163Accident · No injuriesLimited investigationFinal reportPratt Falcon XP · Montgomery, NYThe pilot's failure to maintain control of the airplane while taxiing. Factors related to the accident were the gusting wind conditions and the pilot's improper weather evaluation.NTSB CHI00LA158Accident · No injuriesLimited investigationFinal reportTruthan Searey · Grand Rapids, MIthe pilot's failure to maintain aircraft control when the airplane encountered high winds. Factors which related to this accident were the high crosswind, the wind gusts, and the submerged object.NTSB CHI00LA155Accident · No injuriesLimited investigationFinal reportEdgerly S-12 · Hartford, MIrestricted directional control. Factors relating to this accident were the rough, uneven runway, and the trees.NTSB FTW00LA165Accident · No injuriesLimited investigationFinal reportHard Capella XLS · Taylor, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's lack of experience in the make and model of the accident aircraft.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.NTSB MIA00LA160Accident · Minor injuriesLimited investigationFinal reportDaniel A. Shapiro Searey 1DK · Morganton, NCThe inadvertent forward elevator input by the pilot-in-command while reducing throttle control resulting in the airplane nose-over.NTSB FTW00LA143Accident · Serious injuriesLimited investigationFinal reportLewis Spitfire/Raven · Albuquerque, NMThe pilot's inadvertent stall of the aircraft.NTSB CHI00LA130Accident · Minor injuriesLimited investigationFinal reportGrunska Kitfox IV · Neenah, WIthe pilot's failure to maintain driectional control of the airplane while landing. A factor associated with the accident was the tree that the airplane contacted.NTSB FTW00LA117Accident · 2 fatalLimited investigationFinal reportJohnson Zodiac CH-601-HDS · Orange, TXthe inadvertent stall while maneuvering. A contributing factor was the loss of engine power for an undetermined reason.NTSB CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.NTSB MIA00LA119Accident · Minor injuriesLimited investigationFinal reportBair Helicopters Searey · Kill Devil Hill, NCThe inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.NTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.NTSB ANC00LA023Accident · No injuriesLimited investigationFinal reportStirling AIR CAM · Fairbanks, AKThe pilot's improper compensation for wind conditions during the single-engine landing. Factors associated with this accident were the pilot's intentional shut down of the left engine, the right crosswind, the icy runway, and the snow berms on the edge of the…