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

19932026
Fatal NTSB investigations: Subaru ALL MDLS A/B per year, 1993–2026: 14 cases
19931
19942
19961
19991
20001
20021
20031
20041
20051
20061
20073

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.

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.Dec 29, 2007 · N136DG · DestroyedNTSB LAX07LA147Accident · 1 fatalLimited investigationFinal reportCeridono Vegas Sport Flyer · Mountain Pass, CAThe loss of airplane control while maneuvering after takeoff for an undetermined reason.May 1, 2007 · N169BC · DestroyedNTSB 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.Apr 29, 2007 · N445SM · DestroyedNTSB 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.Mar 31, 2006 · N41964 · Substantial damageNTSB 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.Jul 4, 2005 · N481KB · Substantial damageNTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.Oct 26, 2004 · N166DK · DestroyedNTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).Nov 16, 2003 · N999GC · DestroyedNTSB 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.Mar 16, 2002 · N6158F · Substantial damageNTSB 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.Apr 30, 2000 · N2411V · DestroyedNTSB 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.Aug 25, 1999 · N787TP · DestroyedNTSB 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.Nov 2, 1996 · N914VT · Substantial damageNTSB 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.Jun 2, 1994 · N263MP · DestroyedNTSB 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.Mar 6, 1994 · N7014B · Substantial damageNTSB 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.Nov 6, 1993 · N70334 · Destroyed