Fatal NTSB investigations: Subaru ALL MDLS A/B
14 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 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
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')
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."highestInjuryLevel" = 'Fatal'
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')
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 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 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 IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.NTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).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 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 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.