NTSB investigations: Subaru ALL MDLS A/B, TX
9 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B. 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
| 1997 | 1 |
|---|---|
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2013 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59050'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59050'))
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 CEN14CA059Accident · No injuriesData collectionFinal reportGroen Sparrowhawk II · Lubbock, TXThe pilot's failure to attain a proper glidepath for landing which resulted in a hard landing.NTSB CEN12CA226Accident · No injuriesData collectionFinal reportRuiz E RAF 2000 · Anahuac, TXThe student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.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 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 FTW02LA110Accident · Serious injuriesLimited investigationFinal reportThornley Thornley 2000 · Granite Shoals, TXthe pilot's failure to maintain clearance with a power line while maneuvering. Contributing factors were the pilot's diverted attention and the power lines.NTSB FTW99FA038Accident · 1 fatalField investigationFinal reportBlanton RAF 2000 · The Colony, TXThe pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.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.