NTSB investigations: Bombardier ROTAX (ALL), 1999
31 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\") = 1999
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") = 1999
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 LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.NTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.NTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC99LA237Accident · No injuriesLimited investigationFinal reportPratt Dominator · Auburn, METhe pilot's improper decision to execute a 0 airspeed pedal turn at 100 feet agl.NTSB MIA99FA246Accident · No injuriesField investigationFinal reportDiamond Aircraft Industries DA20-A1 · Cedar Key, FLThe pilot's failure to follow the checklist (turn Fuel Valve-On, and activate electric fuel boost pump) and the pilot's decision to continue flight with a known unairworthy condition (illumination of low fuel pressure warning light on takeoff roll) with…NTSB SEA99LA155Accident · No injuriesLimited investigationFinal reportSchwarzler Kolb Mark 3 · Independence, ORThe pilot's failure to maintain airspeed while on approach.NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.NTSB ATL99LA117Accident · No injuriesLimited investigationFinal reportQuicksilver GT-500 · Ormond Beach, FLThe in-flight collision with an object for an undetermined reasons. A factor was the stolen/unauthorized use of the airplane.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.NTSB NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneNTSB CHI99LA228Accident · Minor injuriesLimited investigationFinal reportMcmillan Zodiac CH 601 HD · Nauvoo, ILThe pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.NTSB LAX99LA246Accident · No injuriesLimited investigationFinal reportSmith Avid Stol Hauler · S. Lake Tahoe, CAA loss of engine power for undetermined reasons.NTSB SEA99LA099Accident · Minor injuriesLimited investigationFinal reportWhithington Kitfox 1200 · Caldwell, IDThe pilot's failure to maintain clearance from obstacles along his departure path. Factors include the pilot's incorrect positioning of the flaps prior to takeoff, and a transmission wire and trees along the aircraft's flight path.NTSB SEA99LA093Accident · Minor injuriesLimited investigationFinal reportModrow Avid Flyer · Poulsbo, WAEngine seizing due to failure of main bearing assemblies. Factors include foreign material in the labyrinth sleeve, and a stall encountered while the pilot was attempting his emergency landing.NTSB FTW99LA173Accident · Serious injuriesLimited investigationFinal reportLibersat Kolb Mark 3 · Vidor, TXThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin.NTSB MIA99LA183Accident · Serious injuriesLimited investigationFinal reportSouth Mississippi Light Aircra Buccaneer II · Panacea, FLThe intentional continued operation of the airplane by the pilot-in-command with known deficiencies with the pitot system after takeoff, resulting in erroneous airspeed indications, and inadvertent stall by the pilot resulting in the uncontrolled descent into…NTSB DEN99LA089Accident · Minor injuriesLimited investigationFinal reportDehaan Challenger II · Douglas, WYThe pilot's failure to maintain directional control of the aircraft by not adequately correcting for torque/p-factor during initial climb following takeoff.NTSB NYC99LA112Accident · Serious injuriesLimited investigationFinal reportAbrams Titan Tornado · Monroe, CTThe failure of the magneto (mag) cylinder bearing resulting in a total loss of power and subsequent forced landing.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB CHI99LA143Accident · No injuriesLimited investigationFinal reportNarzinski Avid Flyer Mark IV · West Alton, MOThe failure of the connecting rod bearing, and the rough/uneven terrain condition.NTSB FTW99LA125Accident · Serious injuriesLimited investigationFinal reportOakes J3 CUB · Greenbriar, ARThe student pilot's failure to compensate for the gusty wind condition while maneuvering, which resulted in the inadvertent stall. A factor was the gusty wind condition.NTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA060Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Coyote, NMThe pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…NTSB MIA99LA113Accident · No injuriesLimited investigationFinal reportDryer Fisher 404 · Homestead, FLThe pilots improper in-flight planning/decision of an available forced landing area. This resulted in a subsequent in-flight collision with trees. Contributing to the accident was a total loss of engine power due to an inoperative generator coil.NTSB LAX99LA119Accident · Minor injuriesLimited investigationFinal reportGallob Rans S4 · Mesa, AZThe pilot's failure to adequately compensate for the existing crosswind condition and to maintain lateral control of the aircraft.NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB DEN99LA044Accident · No injuriesLimited investigationFinal reportParsons Kitfox II · Colorado Spgs, COThe airplane's encounter with a dust devil during landing.