NTSB investigations: Lycoming IO-540 series, 2018

7 cases on aircraft whose registry engine model is Lycoming IO-540 series, where the defining event was Loss of control in flight. 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

20082026
NTSB investigations: Lycoming IO-540 series, 2018 per year, 2008–2026: 59 cases
20085
20095
20103
20114
20125
20133
20145
20151
20163
20172
20187
20192
20204
20212
20223
20232
20252
20261

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\") = 2018
    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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
  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 CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.Oct 12, 2018 · N221MC · DestroyedNTSB WPR18FA253Accident · 1 fatalClass 2 · FieldFinal reportCommander 114 · Jean, NVThe pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.Sep 6, 2018 · N6064C · DestroyedNTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.Jul 8, 2018 · N616HS · DestroyedNTSB ERA18LA184Accident · 1 fatalLimited investigationFinal reportSwearingen SX300 · Daytona Beach, FLThe pilot's failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack, experiencing an aerodynamic stall and hard landing, which resulted in a landing gear collapse, loss of directional control, and…Jul 5, 2018 · N42SX · DestroyedNTSB ANC18LA032Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fairbanks, AKThe pilot's failure to maintain helicopter control while in a hovering turn, which resulted in a collision with obstacles.Apr 20, 2018 · N511CC · Substantial damageNTSB GAA18CA140Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Woodland, CAThe pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application.Feb 24, 2018 · N630ML · Substantial damageNTSB WPR18FA084Accident · 2 fatalField investigationFinal reportCessna 182T · Santee, CAThe pilot's decision to take off into instrument meteorological conditions that resulted in spatial disorientation, and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Feb 6, 2018 · N3525T · Substantial damage