NTSB investigations: Subaru ALL MDLS A/B, 2016
4 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\") = 2016
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") = 2016
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 CEN17LA066Accident · Serious injuriesLimited investigationFinal reportGosselin Charles Glastar · Lee's Summit, MOPartial failure of the electric system due to a battery short, which resulted in a total loss of engine power.NTSB ERA16LA153Accident · Minor injuriesLimited investigationFinal reportButterhof Anthony J Ginny B · South Harrison Township, NJThe pilot/mechanic's failure to safety-wire the gascolator bale clamp, which resulted in a fuel leak and subsequent total loss of engine power.NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB CEN16LA096Accident · 1 fatalLimited investigationFinal reportRaymond Z Brown Condor · Centralia, ILThe failure of the prerotator belt, which impeded the engine's timing belt and resulted in a loss of engine power at low altitude.