NTSB investigations: Lycoming TI0-540 series, 2006

7 cases on aircraft whose registry engine model is Lycoming TI0-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 TI0-540 series, 2006 per year, 1982–2026: 73 cases
19824
19833
19844
19853
19864
19874
19893
19901
19912
19923
19931
19941
19962
19971
19982
19991
20003
20015
20028
20034
20044
20067
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\") = 2006
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41533')
      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 CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.Dec 31, 2006 · N888PR · Substantial damageNTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.Dec 21, 2006 · N1AM · DestroyedNTSB CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…Dec 18, 2006 · N9073P · DestroyedNTSB CHI07LA035Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Atlanta, GAThe exceedance of airplane design stress limits when the pilot did not maintain aircraft control after his attention was diverted to the right side attitude indicator during cruise flight. An additional cause was the aural detection for the autopilot…Dec 3, 2006 · N46PT · Substantial damageNTSB NYC07FA038Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601P · West Dover, VTA loss of control during approach for undetermined reasons, which resulted in a collision with trees.Dec 2, 2006 · N9797Q · DestroyedNTSB DEN06CA127Accident · No injuriesData collectionFinal reportPiper PA-46T-350P · Colo. Springs, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall. Contributing factors in this accident were the jet blast encounter, and the pilot's failure to initiate a go-around when he felt an unsafe condition existed.Sep 13, 2006 · N71DH · Substantial damageNTSB CHI06FA232Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Sault Ste Marie, MIThe pilot's failure to maintain aircraft control during the circling approach and his failure to perform a missed approach when the airplane was no longer in a position to land using normal flight maneuvers. Contributing to the accident was the pilot's…Aug 14, 2006 · N133BH · Destroyed