NTSB investigations: Bombardier ROTAX (ALL), 1997, FL
4 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 | 1 |
|---|---|
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 3 |
| 2016 | 2 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1997
AND c.\"eventStateOrRegion\" = 'FL' 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 year(c."eventDate") = 1997
AND c."eventStateOrRegion" = 'FL' 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 MIA97LA166Accident · Serious injuriesLimited investigationFinal reportTravis C. Elmore B2B/582 · Haines City, FLThe pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…NTSB MIA97LA136Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Hollywood, FLthe student pilot's failure to maintain directional control during the landing/go-around, which led to subsequent in-flight collision with a fixed object (approach light/light bar/sign) and terrain. The student's failure to obtain the proper touchdown point…NTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.NTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.