NTSB investigations: Lycoming GSO&IGSO-480 series, VA

5 cases on aircraft whose registry engine model is Lycoming GSO&IGSO-480 series. 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

19722026

NTSB investigations: Lycoming GSO&IGSO-480 series, VA per year, 1972–2026: 5 cases
1972	1
1978	1
1986	1
1991	1
2004	1

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."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41529')) 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.\"eventStateOrRegion\" = 'VA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41529'))
  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."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41529'))
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 NYC05FA006Accident · 1 fatalField investigationFinal reportBeech H50 · Hartwood, VAThe pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.Oct 17, 2004 · N171S · Destroyed NTSB BFO91LA073Accident · Minor injuriesLimited investigationFinal reportBeech H50 · Hartwood, VAThe parachutist failure to properly monitor and secure his release handle to protect against accidental parachute deployment.Jul 14, 1991 · N171S · Substantial damage 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…Feb 27, 1986 · N1QV · Substantial damage NTSB IAD78FA047Accident · No injuriesClosedBeech B65 · Norfolk, VAMar 4, 1978 · N342N · Substantial damage NTSB NYC72DID24Accident · No injuriesClosedBeech 65 · Woolwine, VAMar 25, 1972 · N836Q · Substantial damage