NTSB investigations: Bombardier ROTAX (ALL), 2001
12 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Loss of control - in flight”. 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 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 8 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 14 |
| 1999 | 12 |
| 2000 | 5 |
| 2001 | 12 |
| 2002 | 10 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 3 |
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\") = 2001
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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") = 2001
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 ATL02LA009Accident · 1 fatalLimited investigationFinal reportBass Moni · Locust Grove, GAThe pilot's failure to maintain airspeed during a low-altitude aerobatic maneuver, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into terrain.NTSB MIA02LA014Accident · 2 fatalLimited investigationFinal reportRans S-6 · Wyatte, MSthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with trees, while at a low altitude.NTSB CHI02LA003Accident · Serious injuriesLimited investigationFinal reportKainz Kitfox IV · Tomahawk, WIThe inadvertent stall/spin encountered by the pilot during a slow flight maneuver. Factors relating to this accident were the low airspeed and the trees.NTSB ANC01LA140Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Chugiak, AKThe pilot's inadvertent stall of the airplane during takeoff.NTSB NYC01LA198Accident · Minor injuriesLimited investigationFinal reportMoran Europa Monowheel · Oxford, CTThe pilot's failure to maintain directional control during an aborted landing.NTSB ATL01LA092Accident · Serious injuriesLimited investigationFinal reportKolb Twin Star Mark III · Edgewater, FLThe loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.NTSB CHI01LA227Accident · No injuriesLimited investigationFinal reportMcIlraith Searey Amphibian · La Crosse, WIThe pilot's inadequate compensation for wind conditions and turbulence which resulted in the encountered stall. Factors to the accident were turbulence and the high wind condition.NTSB ATL01LA077Accident · 1 fatalLimited investigationFinal reportKenneth West ARV 582 · Sebring, FLThe pilot's failure to maintain flying speed, followed by a subsequent inadvertent stall spin.NTSB CHI01FA186Accident · No injuriesField investigationFinal reportBowman Renegade Spirit · Lynn Center, ILthe in-flight deformation of the left wing.NTSB MIA01LA147Accident · No injuriesLimited investigationFinal reportRussell Heyn Rans S-6 · Swainsboro, GAthe failure of the pilot to properly compensate for a crosswind and for gusty conditions during takeoff/initial climb, which resulted in an inflight loss of control and collision with the ground.NTSB LAX01LA188Accident · No injuriesLimited investigationFinal reportWright Avid Flyer · Show Low, AZthe pilot's failure to maintain control of the airplane during a go-around, which resulted in an in-flight collision with terrain and a nose down. A contributing factor was the turbulence.NTSB MIA01LA114Accident · Serious injuriesLimited investigationFinal reportArnet Pereyra Aventura II · Rockledge, FLthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.