NTSB investigations: Lycoming 0-540 series, 2005

6 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence 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

19822026
NTSB investigations: Lycoming 0-540 series, 2005 per year, 1982–2026: 92 cases
19822
19835
19847
19855
19863
19873
19883
19893
19902
19913
19924
19932
19941
19951
19965
19971
19987
20003
20013
20023
20032
20047
20056
20066
20075

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\") = 2005
    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\" = 250))
  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 CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.Sep 9, 2005 · N8523W · DestroyedNTSB DEN05CA097Accident · No injuriesData collectionFinal reportRobinson R44 II · Indianola, UTThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and a hard landing.Jun 26, 2005 · N373DM · Substantial damageNTSB LAX05FA189Accident · Serious injuriesField investigationFinal reportRobinson R44 · Lucerne Valley, CAthe pilot's failure to maintain adequate main rotor rpm and directional control while maneuvering at low altitude. Contributing factors in the accident were the helicopter's gross weight in excess of the maximum hover out of ground effect limit, a high…May 28, 2005 · N7015Q · DestroyedNTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.May 21, 2005 · N7361Y · Substantial damageNTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.Feb 5, 2005 · N7091C · Substantial damageNTSB DFW05LA118Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Little Rock, ARThe pilot's failure to maintain control of the airplane during an instrument approach for undetermined reasons. Contributing factors were the mist and low cloud ceiling.Jan 10, 2005 · N6150S · Destroyed