Skip to content

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

20 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

Where

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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.Dec 3, 2013 · N71DF · Substantial damage NTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.Mar 3, 1987 · N822Q · Destroyed 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…Mar 1, 1985 · N709G · Destroyed NTSB MIA83FA235Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Miami, FLSeveral days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng…Sep 19, 1983 · N55ED · Destroyed NTSB ATL83AA184Accident · 3 fatalFinal reportAero Commander 680 · Titusville, FLWitnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then…May 12, 1983 · N6880S · Destroyed NTSB MIA83LA029Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Belle Glade, FLAcft had been object of an airborne pursuit by U.S. Customs at about 1830 in the vicinity of Belle Glade. During the pursuit the acft door & 15 bales of a controlled substance were observed being jettisoned from the acft. After landing the acft was set on…Nov 15, 1982 · N163KT · Destroyed NTSB MIA81FA061Accident · 2 fatalClosedAero Comdr 680 · Labelle, FLApr 2, 1981 · N777A · Destroyed NTSB MIA81EKT61Accident · No injuriesClosedAero Comdr 680 · Labelle, FLSep 29, 1980 · N1922H · Substantial damage NTSB MIA80FA099Accident · 6 fatalClosedBeech 65 · Clearwater, FLSep 12, 1980 · N625GP · Destroyed NTSB MIA80FA077Accident · 4 fatalClosedBeech 65 · Ft.Pierce, FLJun 29, 1980 · N156F · Destroyed NTSB MIA80FKT05Accident · No injuriesClosedAero Comdr 680 · Clewiston, FLOct 23, 1979 · N5MZ · Substantial damage NTSB MIA79DLE01Accident · No injuriesClosedRockwell 680 · Suwannee, FLSep 30, 1979 · N6822S · Substantial damage NTSB MIA79FA090Accident · 1 fatalClosedBeech 65 · Boca Raton, FLMay 27, 1979 · N72DR · Destroyed NTSB MIA79FA058Accident · 2 fatalClosedBeech 65 · Arcadia, FLMar 19, 1979 · N70GC · Destroyed NTSB MIA79DKT44Accident · No injuriesClosedBeech 65 · Belle Glade, FLJan 31, 1979 · N707E · Substantial damage NTSB MIA79FKT33Accident · No injuriesClosedBeech 65 · South Bay, FLJan 14, 1979 · N465L · Substantial damage NTSB MIA76FLA33Accident · No injuriesClosedBeech D50C · Jacksonville, FLFeb 11, 1976 · N118D · Substantial damage NTSB MIA73FKT96Accident · No injuriesClosedBeech 65 · Palm Beach, FLMay 12, 1973 · N956B · Substantial damage NTSB MIA73DLD73Accident · No injuriesClosedBeech J50 · Lakeland, FLApr 22, 1973 · N391H · Substantial damage NTSB UNK65X1103Accident · No injuriesClosedAero Cmdr 680E · Jacksonville, FLDec 23, 1964 · N58G · Substantial damage