NTSB investigations: Bombardier ROTAX (ALL), PA
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
| 1986 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2007 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
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 ERA25LA041Accident · Minor injuriesClass 3 · LimitedFinal reportAnderson Kitfox 4 · New Castle, PAA partial loss of engine power due to a split fuel line that resulted in a fuel leak and reduced fuel supply to the aft carburetor.NTSB GAA19CA361Accident · Minor injuriesData collectionFinal reportQuicksilver Aircraft Northeast Sport · Ledgedale, PAThe pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.NTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.NTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.NTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.NTSB ERA11FA463Accident · 1 fatalField investigationFinal reportQuad City Ultralight Challenger II · Ransom Township, PAThe non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…NTSB ERA10LA373Accident · 2 fatalLimited investigationFinal reportNadig Paul K Nadig · Franklin, PAA partial loss of engine power due to the owner’s inadequate fuel system maintenance, which resulted in a collision with trees and subsequent impact with the ground.NTSB ERA10CA287Accident · Minor injuriesData collectionFinal reportLepow David A Prgsv Aerdyn SEA REY · Chester, PAThe airplane’s collision with a submerged object during landing, which resulted in a nose-over.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.NTSB IAD02LA063Accident · No injuriesLimited investigationFinal reportMurawski Pulsar · Bentleyville, PAFailure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.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 IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.NTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.NTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.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 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 NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.NTSB NYC91DHA01Accident · 1 fatalFinal reportJames Cote Kolb Twinstar MK II · Gilbertsville, PAThe failure of the pilot to maintain control of the aircraft after an interuption of power.NTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.