NTSB investigations: Bombardier ROTAX (ALL), 2002, FL
6 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\") = 2002
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") = 2002
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 MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…NTSB MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.NTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB MIA02LA078Accident · Serious injuriesLimited investigationFinal reportUltravia Aero Int' Pelican Club PL · Crystal River, FLThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.NTSB ATL02LA071Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Naples, FLThe loss of engine power for undetermined reasons.NTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…