NTSB investigations: Bombardier ROTAX (ALL), KS
11 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
| 1988 | 2 |
|---|---|
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2010 | 2 |
| 2015 | 1 |
| 2026 | 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\" = 'KS' 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" = 'KS' 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 CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.NTSB CEN10LA099Accident · 2 fatalLimited investigationFinal reportBuckeye DM · Sublette, KSThe failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.NTSB CHI02LA226Accident · No injuriesLimited investigationFinal reportGiroux Air Cam · Ozawkie, KSThe pilot's delay in aborting the landing. A contributing factor was the excessive airspeed.NTSB CHI97LA128Accident · No injuriesLimited investigationFinal reportRochette Rans S-12 XL · Hays, KSthe pilot improperly flared the airplane and the pilot's lack of experience in the type of airplane.NTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.NTSB CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.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 MKC88DCQ04Accident · Serious injuriesFinal reportTeratorn Tierra II · Plevna, KSThe pilot stated that on takeoff climb, approximately 100 feet AGL, the a/c broke to the right and hit the ground. The pilot suspected right aileron control problems. Inspection of a/c revealed no mechanical problems. The wind was light and variable at 10 KTS.NTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.