NTSB investigations: Lycoming TI0-540 series, 1987, TX

5 cases on aircraft whose registry engine model is Lycoming TI0-540 series. 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

19642026
NTSB investigations: Lycoming TI0-540 series, 1987, TX per year, 1964–2026: 168 cases
19642
19654
19662
19671
19684
19695
19704
19714
19724
19733
19746
19753
19764
19775
19784
19794
19806
19814
19823
19832
19844
19852
19864
19875
19883
19891
19902
19912
19923
19943
19953
19964
19973
19981
19991
20003
20012
20023
20046
20053
20071
20081
20103
20112
20122
20142
20153
20162
20172
20184
20192
20202
20225
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\") = 1987
    AND c.\"eventStateOrRegion\" = 'TX' 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 ('41533'))
  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 FTW88LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Brownsville, TXDuring initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and…Oct 25, 1987 · N5606Y · Substantial damageNTSB FTW87FA197Accident · No injuriesField investigationFinal reportPiper PA-32R · Mexia, TXThe plt noticed smoke in the cockpit & started to make a precautionary lndg at Mexia, TX, which was nearby. However, drg the dscnt to lnd, the smoke dissipated, so he elected to cont to the destn. Drg the climb back to alt, smoke reappeared & was followed by…Aug 12, 1987 · N8159S · Substantial damageNTSB FTW87FA184Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Imperial, TXAfter takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he ' . . . Checked power, all ok, plane just seemed to lose all lift . . .' Subsequently, the acft…Aug 1, 1987 · N5998Y · DestroyedNTSB FTW87FA149Accident · No injuriesField investigationFinal reportPiper PA-60-601 · Hillsboro, TXAprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &…Jun 22, 1987 · N7481S · Substantial damageNTSB FTW87LA075Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · George West, TXAircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board.Mar 9, 1987 · N178S · Substantial damage