NTSB investigations: Subaru ALL MDLS A/B
27 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B, where the first occurrence was “Loss of control - in flight”. 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
| 1993 | 1 |
|---|---|
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 4 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59050')
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\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59050')
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" = 250))
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 DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB CHI08LA052Accident · Serious injuriesLimited investigationFinal reportLevick RAF-2000-GTX-SE · Salem, INThe pilot's failure to maintain control of the gyroplane during climbout after takeoff.NTSB LAX07LA147Accident · 1 fatalLimited investigationFinal reportCeridono Vegas Sport Flyer · Mountain Pass, CAThe loss of airplane control while maneuvering after takeoff for an undetermined reason.NTSB LAX07LA142Accident · 1 fatalLimited investigationFinal reportMcDonald J4B-2 · Marysville, CAAn in-flight loss of control for undetermined reasons. Contributing to the accident was the impairment of the pilot by the drug substances identified in the toxicological testing.NTSB MIA06LA077Accident · 2 fatalLimited investigationFinal reportMarvin T Eiland SparrowHawk · Ona, FLThe in-flight loss of control for undetermined reasons during a normal descent, resulting in an uncontrolled descent, and in-flight collision with terrain.NTSB CHI06CA055Accident · No injuriesData collectionFinal reportCarpenter RAF 2000 · Wintersville, OHThe pilot not maintaining aircraft control during the landing. A factor was the reported wind gust.NTSB LAX05CA295Accident · Minor injuriesData collectionFinal reportRicardo Lopez RAF 2000 Gtxse · Wickenburg, AZthe pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.NTSB CHI05LA163Accident · 1 fatalLimited investigationFinal reportBecker RAF 2000 · Gladwin, MIThe pilot's failure to maintain control of the gyrocopter while in the traffic pattern. A factor associated with the accident was the pilot's lack of gyrocopter experience.NTSB DFW05CA120Accident · No injuriesData collectionFinal reportMayfield Sparrowhawk · Hondo, TXThe pilot's failure to maintain control of the gyrocraft during takeoff. A contributing factor was the failure of the pre-rotator cable.NTSB DFW05LA016Accident · Serious injuriesLimited investigationFinal reportWilson Loenslo YMF-80 · Arcola, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff initial climb.NTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.NTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.NTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB LAX03LA022Accident · Minor injuriesLimited investigationFinal reportLewis Barnett J4B · Vacaville, CAAn in-flight loss of control for undetermined reasons.NTSB SEA02LA142Accident · Minor injuriesLimited investigationFinal reportKaminski RAF 2000 · Newberg, ORThe pilot's inadequate compensation (excessive altitude) for crosswind conditions resulting in the gyroplane's rotors contacting the ground. Contributing factors were the gusty crosswind conditions.NTSB IAD02LA054Accident · Minor injuriesLimited investigationFinal reportMiller Barnet J4B-2 · Manville, NJThe pilot's improper flare prior to touchdown. A factor was the pilot's lack of experience in aircraft type, make, and model.NTSB ATL02LA064Accident · 1 fatalLimited investigationFinal reportKopp Robert E GYRO-KOPP-TER · Citra, FLThe pilots failure to maintain flight control, followed by a subsequent collision with the terrain.NTSB SEA00LA169Accident · Serious injuriesLimited investigationFinal reportClearwaters RAF 2000 · Leahy, WAA loss of control for undetermined reasons.NTSB DEN00LA079Accident · 1 fatalLimited investigationFinal reportGreen GTX-SE-FI · Gillette, WYThe pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.NTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.NTSB LAX98LA271Accident · Minor injuriesLimited investigationFinal reportClark Barnett J4B2 · Marysville, CAThe pilot's inadequate rigging of the rotor blades and rudder, which led to an inability to maintain control of the gryocopter. The pilot's inadequate landing flare in soft terrain, which resulted in a nose low touchdown and subsequent nose over, and, his…NTSB CHI98LA015Accident · No injuriesLimited investigationFinal reportReed-Madsen Taylor Bird · Humboldt, IAthe failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.NTSB FTW97LA278Accident · Minor injuriesLimited investigationFinal reportWatts RAF 2000 Gyroplane · Conroe, TXThe pilot's failure to maintain aircraft control. A factor was his premature liftoff at low airspeed.NTSB CHI97LA018Accident · 1 fatalLimited investigationFinal reportFrost RAF 2000 GTX SE · Adrian, MIthe pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.NTSB BFO94LA085Accident · 1 fatalLimited investigationFinal reportPecchio Marchetti 263MP · East Moriches, NYthe loss of control for undetermined reasons resulting in an uncontrolled descent and a subsequent collision with trees.NTSB MIA94LA086Accident · 1 fatalLimited investigationFinal reportPiotrowski GIP-1 · Bunnell, FLThe failure of the pilot-in-command to maintain rotor RPM in the gyrocopter on approach. Contributing to the accident was the lack of total experience in gyrocopter flying.NTSB SEA94LA026Accident · 1 fatalLimited investigationFinal reportBird RAF-2000 · Redmond, UTThe pilot in command's exceeding the proper climb rate. A factor contibuting to the accident was the pilot's lack of experience in make/model.