NTSB investigations: Lycoming IO-540 series, 1987

4 cases on aircraft whose registry engine model is Lycoming IO-540 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming IO-540 series, 1987 per year, 1982–2026: 69 cases
19823
19834
19845
19855
19864
19874
19903
19911
19942
19962
19973
19981
19993
20006
20013
20024
20033
20041
20054
20065
20073

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 year(c.\"eventDate\") = 1987
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585')
      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\" = 260))
  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 NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…Jul 6, 1987 · N1403W · Substantial damageNTSB ANC87LA076Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kenai, AKThe pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and…Jun 7, 1987 · N5645D · Substantial damageNTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…Apr 8, 1987 · N8248D · Substantial damageNTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…Jan 22, 1987 · N2489R · Substantial damage