OpenAirDocs.org

NTSB investigations: Lycoming 0-540 series, FL

8 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of engine power”. 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

19852026

Where

Open the map

Latest 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.\"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 ('41532')
      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\" = 350))
  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.

NTSB MIA08LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Marathon, FLA loss of engine power for undetermined reasons.Dec 13, 2007 · N801VC · Substantial damageNTSB MIA06FA092Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Dunnellon, FLThe loss of engine power as a result of fuel starvation due to a contaminated carburetor fuel inlet screen.Apr 14, 2006 · N592PR · DestroyedNTSB MIA05FA020Accident · 1 fatalField investigationFinal reportRawdon Bros. T1 · Pembroke Pines, FLImproper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…Nov 2, 2004 · N2706D · DestroyedNTSB MIA04FA128Accident · 4 fatalField investigationFinal reportCessna R182 · Milton, FLThe pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…Sep 23, 2004 · N5157T · DestroyedNTSB MIA04LA061Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ocala, FLThe failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.Mar 17, 2004 · N7194S · Substantial damageNTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.Feb 3, 1999 · N5528J · DestroyedNTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.Aug 11, 1997 · N8213P · DestroyedNTSB MIA85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Everglades, FLThe acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted…Mar 24, 1985 · N8773L · Destroyed