NTSB investigations: Subaru ALL MDLS A/B
9 cases on aircraft whose registry engine model is Subaru ALL MDLS A/B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1998 | 1 |
|---|---|
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
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 ('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\" = 351))
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" = 351))
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 CHI08CA034Accident · Minor injuriesData collectionFinal reportGluff, Alan Zenair 200 · Greenwood, INThe total loss of engine power due to a lubricating system leak for undetermined reasons which resulted in engine seizure, and the unsuitable terrain encountered during the forced landing. Contributing factors were the plowed field and the nose gear failure…NTSB ATL06LA121Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Rans S-6 · Roseboro, NCThe pilot's failure to maintain ground clearance while maneuvering for a forced landing following loss of engine power.NTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.NTSB LAX04LA141Accident · No injuriesLimited investigationFinal reportVogt KR2S · Lompoc, CAa failure of the fuel pump, which induced a total loss of engine power.NTSB LAX04LA140Accident · No injuriesLimited investigationFinal reportAlan Wilson Tandum Air Bike · Elko, NVA total loss of engine power during cruise flight due to the failure of an ignition system component.NTSB CHI04LA011Accident · Minor injuriesLimited investigationFinal reportDomeier RV-7A · Augusta, MOThe failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…NTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.NTSB NYC01LA226Accident · Serious injuriesLimited investigationFinal reportMurray JN4-D · Morrisdale, PAFailure of the ignition coil, which resulted in a loss of engine power. A factor was the 10-foot corn in the forced landing field.NTSB CHI98LA242Accident · No injuriesLimited investigationFinal reportBrunnemer HMB-2 · Greenwood, INA loss of engine power due to a fractured ignition coil. A factor to the accident was the soft terrain.