NTSB investigations: Bombardier ROTAX (ALL), 1992
4 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Loss of control - on ground/water”. 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
| 1990 | 2 |
|---|---|
| 1991 | 2 |
| 1992 | 4 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 6 |
| 2001 | 3 |
| 2002 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
Where
Latest 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\") = 1992
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\" = 260))
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") = 1992
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" = 260))
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 DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB ANC92LA048Accident · Minor injuriesLimited investigationFinal reportGerald G. Holland Challenger II · Fairbanks, AKExcessive taxispeed and directional control was not maintained. Factors to the accident were: lack of familiarization with aircraft and inadequate airspeed.NTSB ANC92LA036Accident · No injuriesLimited investigationFinal reportRichard C. Ballow Kitfox 1 · Valdez, AKThe pilot's improper use of the airplane's brakes. Factors which contributed to the accident were the icy runway condition and the pilot's lack of total experience with this type of operation.