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

10 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

19642026

NTSB investigations: Lycoming GSO&IGSO-480 series, CA per year, 1964–2026: 10 cases
1964	1
1965	1
1967	2
1969	1
1977	1
1980	1
1987	1
1988	1
2010	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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…Sep 2, 2010 · N832B · Substantial damage NTSB LAX88FA130Accident · Serious injuriesField investigationFinal reportDornier DO-24 · Oildale, CAPilot's improper fuel consumption calculations and his failure to properly use the mixture control.Mar 17, 1988 · N772AX · Destroyed NTSB LAX88LA004Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Clearlake, CAThe aircraft nosed over when the pilot made a water landing with the wheels extended. The pilot failed to use the landing checklist.Oct 4, 1987 · N87583 · Substantial damage NTSB LAX80DUM19Accident · Serious injuriesClosedAero Comdr 680 · Carlsbad, CAMay 6, 1980 · N8445C · No damage NTSB LAX77FA049Accident · 5 fatalClosedAero Comdr 680 · Upland, CAJun 7, 1977 · N6853S · Destroyed NTSB LAX70D0145Accident · No injuriesClosedAero Comdr 680 · Calexico, CAJun 11, 1969 · N352SS · Substantial damage NTSB OAK67F0322Accident · No injuriesClosedAero Comdr 680-E · Sacramento, CAMay 21, 1967 · N8439C · Substantial damage NTSB OAK67A0073Accident · No injuriesClosedAero Cmdr 680 · Fresno, CAApr 4, 1967 · N6898S · Substantial damage NTSB LAX66D0009Accident · No injuriesClosedAero Cmdr 680 · Colton, CAFeb 15, 1965 · N6837S · Substantial damage NTSB UNK65X0257Accident · No injuriesClosedAero Comm 680E · Redding, CAOct 12, 1964 · N6852S · Substantial damage