NTSB investigations: Subaru ALL MDLS A/B

8 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B, where the first occurrence was “Loss of control - on ground/water”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19982026

NTSB investigations: Subaru ALL MDLS A/B per year, 1998–2026: 8 cases
1998	1
2001	1
2003	2
2004	2
2007	2

Where

Open the map

Latest cases

Query with SQL

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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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."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" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 SEA07CA136Accident · Minor injuriesData collectionFinal reportLidgard 4-1200 · Spartanburg, SCThe pilot lost directional control of the airplane during takeoff. A contributing factor was the pilot's lack of experience in the accident airplane make/model.May 26, 2007 · N613KF · Substantial damage NTSB CHI07CA081Accident · No injuriesData collectionFinal reportRotary Air Force Marketing RAF 2000 · Neenah, WIThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing factors were a bent rudder trim tab, the narrow runway, and the uneven terrain at the edge of the runway pavement.Feb 23, 2007 · N5077F · Substantial damage NTSB NYC05CA019Accident · No injuriesData collectionFinal reportVigneau RAF 2000 GTX · Chatham, MAThe pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.Nov 21, 2004 · N9327B · Substantial damage NTSB NYC04CA184Accident · No injuriesData collectionFinal reportPascucci RAF 2000 · Beverly, MAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.Aug 2, 2004 · N62188 · Substantial damage 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.Oct 20, 2003 · N540CX · Substantial damage 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.Sep 19, 2003 · N24DN · Substantial damage NTSB LAX01LA146Accident · No injuriesLimited investigationFinal reportArthur Lee Beer ALB Special · Santa Rosa, CAThe failure of the pilot to maintain directional control during landing roll.Apr 14, 2001 · N117V · Substantial damage NTSB SEA99LA021Accident · No injuriesLimited investigationFinal reportElliott RAF 2000 · Walla Walla, WAThe pilot's failure to maintain directional control after landing.Dec 16, 1998 · N797X · Substantial damage