Skip to content

NTSB investigations: Lycoming GO-480 series, FL

17 cases on aircraft whose registry engine model is Lycoming GO-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

19652026

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 ('41527')) 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 ('41527'))
  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 ('41527'))
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 ERA18LA201Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 560 · Crestview, FLA collapse of the right main landing gear for reasons that could not be determined based on the available information.Jul 26, 2018 · N2705B · Substantial damage NTSB IAD04LA016Accident · 2 fatalLimited investigationFinal reportPilatus P3-05 · Edgewater, FLThe delamination of the no. 2 connecting rod bearing for undetermined reasons, resulting in a total loss of engine power. A factor in the accident was the pilot's inability to complete a successful forced landing due to oil on the windscreen, and smoke and…Apr 10, 2004 · N860MK · Destroyed NTSB MIA96LA090Accident · No injuriesLimited investigationFinal reportHelio H-295 · Key West, FLThe pilot's inadequate compensation for wind conditions during lift-off, which resulted in the right wingtip contacting the runway. The gusty crosswind was a related factor.Mar 3, 1996 · N68883 · Substantial damage 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.May 5, 1995 · N253FW · Substantial damage NTSB MIA92LA187Accident · No injuriesLimited investigationFinal reportHelio HE29 · Lantana, FLThe total failure of the landing gear tail wheel lock on landing roll out, resulting in an on ground loss of control (ground loop) and collapse of the left main landing gear.Sep 21, 1992 · N6DB · Substantial damage 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.Jan 6, 1992 · N8434C · Substantial damage NTSB MIA89LA005Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Miami, FLThe pilot stated that he was having problems with the elevator trim and elected to land the amphibious acft in the bay. He acknowledged and witnesses observed him lower the landing gear prior to attempting to land on the water. The aircraft flipped inverted…Oct 6, 1988 · N3263G · Substantial damage NTSB MIA79FKT36Accident · Serious injuriesClosedAero Comdr 560E · Clewiston, FLJan 15, 1979 · N438G · Destroyed NTSB MIA78FKT30Accident · No injuriesClosedHelio Acft H-295 · Miami, FLFeb 1, 1978 · N6468V · Substantial damage NTSB MIA78FLA13Accident · No injuriesClosedBeech C50 · Jacksonville, FLJan 7, 1978 · N444CD · Destroyed NTSB MIA76AM097Accident · No injuriesClosedAero Comdr 560 · Okeechobee, FLJul 9, 1976 · N2699B · Substantial damage NTSB MIA75DLA25Accident · No injuriesClosedAero Comdr 560E · Tallahassee, FLDec 3, 1974 · N111U · Substantial damage NTSB MIA73FLD35Accident · No injuriesClosedGrumman G44A · Melbourne, FLNov 10, 1972 · N41988 · Substantial damage NTSB MIA72AM064Accident · No injuriesClosedAero Comdr 560 · Tampa, FLJan 3, 1972 · N2715B · No damage NTSB MIA71FKT03Accident · No injuriesClosedHelio Acft H-295 · Opa Locka, FLAug 13, 1970 · N6468V · Substantial damage NTSB MIA69D0278Accident · Minor injuriesClosedAero Comdr 560-E · Miami, FLNov 22, 1968 · N2788B · Substantial damage NTSB UNK65X1434Accident · No injuriesClosedHelio 395 · Miami, FLFeb 17, 1965 · N4150D · Substantial damage