Fatal NTSB investigations: Bombardier ROTAX (ALL), 2000
3 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
| 1984 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 4 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 12 |
| 2002 | 10 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 2000
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2000
AND c."highestInjuryLevel" = 'Fatal'
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 DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.NTSB FTW00LA117Accident · 2 fatalLimited investigationFinal reportJohnson Zodiac CH-601-HDS · Orange, TXthe inadvertent stall while maneuvering. A contributing factor was the loss of engine power for an undetermined reason.