NTSB investigations: Subaru ALL MDLS A/B
13 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B, where the defining event 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
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2015 | 3 |
| 2018 | 1 |
| 2021 | 1 |
| 2022 | 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 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.NTSB CEN21LA401Accident · No injuriesClass 3 · LimitedFinal reportBulfer James G Genesis · Fairmont, MNThe pilot’s failure to maintain airspeed during a forced landing, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the loss of power due to the failure of the engine’s…NTSB GAA18CA482Accident · No injuriesData collectionFinal reportQac Quickie · helena, MTThe pilot's failure to maintain yaw control and a proper descent rate during an aborted takeoff.NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.NTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.NTSB WPR15LA084Accident · 1 fatalLimited investigationFinal reportBruct J Myers RV-9A · Prineville, ORThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.NTSB CEN12FA619Accident · 1 fatalField investigationFinal reportWiggins AIR Boss · Lansing, ILThe pilot's failure to obtain adequate familiarization with gyroplane operations before attempting a flight test of the recently completed gyroplane, which resulted in his failure to maintain control during the accident flight.NTSB ERA12CA124Accident · No injuriesData collectionFinal reportChapel Robert B Aerial · Simsbury, CTThe pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB WPR10FA373Accident · 1 fatalField investigationFinal reportMarshall CH601 HDS · Kapowsin, WAThe pilot’s failure to maintain adequate airspeed which resulted in a stall and loss of control during the initial climb.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB WPR09LA264Accident · 1 fatalLimited investigationFinal reportPolit Kitfox Ser 5 Outback · Apple Valley, CAThe pilot's loss of aircraft control for undetermined reasons while maneuvering at low altitude.NTSB DFW08CA208Accident · No injuriesData collectionFinal reportGroom Sparrow Hawk · Tulsa, OKThe student pilot's failure to maintain control of the gyroplane. Contributing to the accident was the lack of recent flight instruction prior to the flight.