NTSB investigations: Bombardier ROTAX (ALL), 1992
27 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\") = 1992
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") = 1992
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 CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.NTSB DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB DEN93LA003Accident · Serious injuriesLimited investigationFinal reportO'Connor SNO-BIRD XL · Bryan, TXDelamination of the rudder leading edge and subsequent jamming of the rudder.NTSB NYC93LA018Accident · No injuriesLimited investigationFinal reportFranklin-Sullivan Technologies FS 1 · Littletown, PAInadequate altitude due to an improperly planned approach which resulted in a tree strike on final approach.NTSB CHI92DCA05Accident · Serious injuriesFinal reportRettberg Rans S-7 · Charleston, MOThe pilot-in-command's poor weather evaluation which resulted in a takeoff into adverse weather conditions and a loss of airplane control.NTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.NTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.NTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB MIA92LA155Accident · No injuriesLimited investigationFinal reportDewitt, Richard A. Kitfox · Vero Beach, FLFailure of the engine due to fuel contamination resulting in a forced landing in a grove at which time the aircraft struck trees.NTSB LAX92LA314Accident · No injuriesLimited investigationFinal reportJames Schwarzman Avid Flyer Heavy · Truckee, CAFuel starvation due to the aircraft builder locating the fuel filter in an improper location during the construction of the airplane's fuel system.NTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.NTSB BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.NTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.NTSB SEA92LA143Accident · Minor injuriesLimited investigationFinal reportBorgaes Avid Flyer "C" · Chiloquin, ORPower loss for undetermined reasons and nose gear separation due to overload. A factor contributing to the accident was: terrain condition - dirt bank.NTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.NTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.NTSB NYC92DGM02Accident · No injuriesFinal reportPeres 5151 · Erie, PASeizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.NTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.NTSB ANC92LA048Accident · Minor injuriesLimited investigationFinal reportGerald G. Holland Challenger II · Fairbanks, AKExcessive taxispeed and directional control was not maintained. Factors to the accident were: lack of familiarization with aircraft and inadequate airspeed.NTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.NTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).NTSB ANC92LA036Accident · No injuriesLimited investigationFinal reportRichard C. Ballow Kitfox 1 · Valdez, AKThe pilot's improper use of the airplane's brakes. Factors which contributed to the accident were the icy runway condition and the pilot's lack of total experience with this type of operation.