NTSB investigations: Subaru ALL MDLS A/B, 2003
10 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
| 1980 | 1 |
|---|---|
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 9 |
| 2003 | 10 |
| 2004 | 9 |
| 2005 | 8 |
| 2006 | 5 |
| 2007 | 11 |
| 2008 | 5 |
| 2009 | 4 |
| 2010 | 2 |
| 2011 | 10 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
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\") = 2003
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 year(c."eventDate") = 2003
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 NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.NTSB LAX04CA014Accident · Minor injuriesData collectionFinal reportMayfield RAF 2000 · Buckeye, AZthe pilot misjudged the landing flare.NTSB CHI04LA011Accident · Minor injuriesLimited investigationFinal reportDomeier RV-7A · Augusta, MOThe failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…NTSB SEA03LA191Accident · No injuriesLimited investigationFinal reportLevick RAF 2000 GTX-SE · Bonners Ferry, IDThe pilot's inadequate compensation for gusty wind conditions and his failure to maintain directional control, which resulted in the gyrocraft departing the runway and the main rotor impacting the ground. A contributing factor was wind gusts.NTSB IAD03CA062Accident · No injuriesData collectionFinal reportWilliam Stevens RAF2000 · Stoutsville, OHSeparation of the engine computer wire and connector, which resulted in a partial loss of engine power.NTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.NTSB CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…NTSB MIA03CA107Accident · No injuriesData collectionFinal reportMichael Allen Brown RAF 2000 GTX · Punta Gorda, FLThe pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.NTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.