NTSB investigations: Lycoming GSO&IGSO-480 series
5 cases on aircraft whose registry engine model is Lycoming GSO&IGSO-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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 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 ('41529')
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 ('41529')
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 BFO90LA001Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Friendly, MDThe pilot's improper use of his fuel supply, which resulted in fuel starvation and loss of power in the left engine. A factor related to the accident was the pilot's lack of familiarity with the aircraft.NTSB LAX88FA130Accident · Serious injuriesField investigationFinal reportDornier DO-24 · Oildale, CAPilot's improper fuel consumption calculations and his failure to properly use the mixture control.NTSB BFO86FID02Accident · No injuriesFinal reportBeech BE65 · Wakefield, VAThe acft landed short of the rwy after loss of power on both engines. Contact with a dirt bank sheared the landing gear and the acft slid onto & down the rwy for about 436 ft before stopping. The plt said the fuel gauges were 1/4 on mains and 1/8 on avg…NTSB MIA85LA110Accident · 2 fatalLimited investigationFinal reportRockwell 680E · Key West, FLA coast guard falcon acft was on scene when the acft ditched in the atlantic ocean due to fuel exhaustion. A life raft & marker were dropped by the coast guard acft. A search was conducted all day on 3/1/85 & was called off at sunset on on 3/2/85. The…NTSB FTW84LA249Accident · No injuriesLimited investigationFinal reportBeech 65 · Zapata, TXAccording to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…