NTSB investigations: Subaru EA-81
6 cases on aircraft whose registry engine model is Subaru EA-81. 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
| 1994 | 1 |
|---|---|
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59052'))
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 ('59052'))
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 WPR22LA322Accident · Minor injuriesClass 3 · LimitedFinal reportRay E Roberts Kitfox V Vixen · Caldwell, IDThe partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…NTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.NTSB CEN20CA206Accident · No injuriesClass 4 · Data collectionFinal reportZenair CH601 · Worthington, MNThe pilot's excessive brake application during the landing roll to avoid an animal on the runway, which resulted in a ground loop.NTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.NTSB CEN18FA003Accident · 1 fatalField investigationFinal reportSchaffer Fisher Horizon 2 · Eden Prairie, MNAn inflight loss of control and collision with terrain for undetermined reasons after a thorough examination of the airplane's flight controls was unable to confirm control continuity. Contributing to the accident was the pilot's lack of experience in the…NTSB NYC94LA120Accident · No injuriesLimited investigationFinal reportFreeman PRO-STAR II · Sanford, METhe pilot's failure to maintain airspeed resulting in an inadvertent stall and collision with the terrain.