NTSB investigations: Lycoming GO-480 series
5 cases on aircraft whose registry engine model is Lycoming GO-480 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1992 | 1 |
| 1995 | 1 |
| 2005 | 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 ('41527')
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\" = 353))
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 ('41527')
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" = 353))
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 ATL07CA068Accident · No injuriesData collectionFinal reportBeech D50E · Decatur, ALThe pilot's improper fuel management resulting in failure of both engines due to fuel starvation.NTSB LAX05CA129Accident · Minor injuriesData collectionFinal reportBeech D50C · Montague, CAThe pilot's inadequate aircraft preflight and failure to verify that an adequate fuel supply was in the right main tank prior to flight, resulting in a fuel starvation induced loss of engine power in the right engine. Also causal was the pilot's failure to…NTSB MIA95LA126Accident · Serious injuriesLimited investigationFinal reportFocke-Wulf FWP 149D · St. Augustine, FLInadequate fuel management by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was the unsuitable terrain encountered during the emergency descent for the forced landing.NTSB MIA92LA056Accident · Minor injuriesLimited investigationFinal reportAero Commander 560E · Boca Raton, FLImproper fuel tank selector position of both engines resulting in total loss of engine power due to fuel starvation. Also, failure of the pilot to perform the emergency procedures following the loss of power from both engines.NTSB DEN83LA080Accident · No injuriesLimited investigationFinal reportHelio H-295 · Baggs, WYThe plt reported that he was hauling hay for his stranded horse. The plt was delivering hay, 5 bales per flt & dropping 1 bale at a time. On the 19th drop, after 4 hrs & 15 min of flt time since refueling, the eng lost power. During a forced landing in deep…