NTSB investigations: Bombardier ROTAX (ALL), 1988
8 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 | 7 |
|---|---|
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 27 |
| 1993 | 20 |
| 1994 | 16 |
| 1995 | 27 |
| 1996 | 20 |
| 1997 | 31 |
| 1998 | 35 |
| 1999 | 31 |
| 2000 | 32 |
| 2001 | 51 |
| 2002 | 39 |
| 2003 | 20 |
| 2004 | 22 |
| 2005 | 16 |
| 2006 | 22 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 29 |
| 2010 | 21 |
| 2011 | 27 |
| 2012 | 17 |
| 2013 | 16 |
| 2014 | 10 |
| 2015 | 14 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 6 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 12 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 5 |
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\") = 1988
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") = 1988
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 CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…NTSB MKC88DCQ04Accident · Serious injuriesFinal reportTeratorn Tierra II · Plevna, KSThe pilot stated that on takeoff climb, approximately 100 feet AGL, the a/c broke to the right and hit the ground. The pilot suspected right aileron control problems. Inspection of a/c revealed no mechanical problems. The wind was light and variable at 10 KTS.NTSB MIA88LA226Accident · No injuriesLimited investigationFinal reportEvans Maxair MU503 · Fort Walton Bch, FLWhile on a personal flt with reported thunderstorms in the vicinity, the plt lost control of the homebuilt acft while on final aprch to land. The acft descended & collided with terrain.NTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…NTSB NYC88DHM01Accident · Serious injuriesFinal reportRutgers Agriplane · Freehold, NJThe plt was working for a firm that was developing the experimental, light weight, crop duster in a joint venture with another firm. An acdnt occurred as he was operating the acft at the location of one of the firms. The plt stated that after takeoff, 'I was…NTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…NTSB NYC88DFJ01Accident · Minor injuriesFinal reportHurd/Drifter XP503 · Baldwinsville, NYThe plt rprtd that during a preflt, he noted the fuel tank was about 1/4 full. He rprtd that as he was taking off, the acft was climbing thru about 200 ft AGL, when the eng lost power. From that position, he was unable to rtrn to the arpt or glide to an open…NTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.