NTSB investigations: Subaru ALL MDLS A/B

8 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B, where the probable cause includes Not determined, general. 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

20092026
NTSB investigations: Subaru ALL MDLS A/B per year, 2009–2026: 8 cases
20092
20111
20151
20171
20181
20211
20241

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.\"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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '05000000')))
  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 CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.Aug 4, 2024 · N140DG · Substantial damageNTSB ERA21LA277Accident · No injuriesClass 3 · LimitedFinal reportVans RV7 · Pottstown, PAA total loss of power for reasons that could not be determined based on the available information.Jul 4, 2021 · N654C · DestroyedNTSB WPR19LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV7A · Ramona, CAThe partial loss of engine power for reasons that could not be determined based on the available information.Nov 10, 2018 · N5433T · DestroyedNTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.Dec 2, 2017 · N481ZK · DestroyedNTSB CEN16LA031Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Wakeman, OHA loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Nov 4, 2015 · N80825 · Substantial damageNTSB ERA11CA373Accident · No injuriesData collectionFinal reportLeatherman Karl L Zodiac CH 601 HDS · Gray Court, SCThe total loss of engine power due to the failure of the radiator coolant supply fitting.Jun 30, 2011 · N67KL · Substantial damageNTSB WPR09LA264Accident · 1 fatalLimited investigationFinal reportPolit Kitfox Ser 5 Outback · Apple Valley, CAThe pilot's loss of aircraft control for undetermined reasons while maneuvering at low altitude.May 23, 2009 · N781VP · Substantial damageNTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.Apr 25, 2009 · N518PV · Substantial damage