OpenAirDocs.org

NTSB investigations: Lycoming TI0-540 series

69 cases on aircraft whose registry engine model is Lycoming TI0-540 series, where the first occurrence was “In flight collision with object”. 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, newest first

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 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\" = 220))
  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 NYC86LA193Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Lancaster, PAThe Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…Aug 3, 1986 · N9531Q · Substantial damageNTSB FTW86LQG12Accident · No injuriesFinal reportPiper PA-36-300 · Muleshoe, TXThe ag acft was climbing after a pass to clear power lines at the north end of the field. The main lndg gear contacted the top wire as the acft started leveling off. The wire did not break and the acft descended to ground impact. The lndg gear snapped off and…Feb 28, 1986 · N57878 · Substantial damageNTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…Feb 17, 1986 · N7EA · DestroyedNTSB NYC86LA040Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Point, NYThe acft was returning to university park arpt after passengers were dropped off at waterbury oxford arpt. Aprx 20 minutes into the flt, the acft collided with two birds. The left wing tip was damaged along with a portion of a section of the left wing 3 1/2…Nov 23, 1985 · N54236 · Substantial damageNTSB MIA86FA012Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Pensacola, FLAfter takeoff acft headed to destination arpt located 4 miles south. When aprx two miles out, the plt turned back to the departure arpt. Witnesses reported the acft was in a shallow descent, low and fast when it collided with trees and exploded about 1400 ft…Oct 16, 1985 · N5815Y · DestroyedNTSB FTW85LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Brownsville, TXWhile practicing touch-and-go landings the plt allowed the acft to descend below the proper glide slope while on final apch. The acft impacted a power line aprx 1000 ft short of the rwy and crashed on the side of a drainage ditch levee. The elevation of the…Jul 7, 1985 · N21698 · Substantial damageNTSB NYC85FA125Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Latrobe, PADrg an IFR arrival, the acft was vectored for an NDB rwy 23 apch to the westmoreland county arpt. At the NDB final apch fix (8.1 mi from the rwy), the crew turned inbound & contd to the arpt. They contacted the tower & reported over the ILS outer marker (an…May 18, 1985 · N66892 · DestroyedNTSB MIA85FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Homestead, FLWhile cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…Dec 27, 1984 · N8920C · DestroyedNTSB BFO85FA003Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Washington, DCAfter a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,…Oct 27, 1984 · N6235Y · Substantial damageNTSB NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…Aug 11, 1984 · N9202Y · Substantial damageNTSB ANC84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunavachak, AKThe plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…May 24, 1984 · N4143W · 2 aircraft · Substantial damageNTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.Jan 26, 1984 · N76AP · Substantial damageNTSB MKC83FA133Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · 3m Se Of Benton, MOAccording to the surviving passenger, a boy, the plt was flying the acft from the right seat. The acft was flown to the vicinity of the plt's property where he made a pass over a farm belonging to a relative. The low pass was made near the operator of a…Jun 23, 1983 · N99SP · DestroyedNTSB FTW83LA217Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quanah, TXThe helicopter was being used to search for cattle. As the plt was looking down through some bushes for cattle, the m/r blade hit a powerline wire about 25 ft AGL.May 3, 1983 · N138HA · Substantial damageNTSB LAX83FA185Accident · 6 fatalField investigationFinal reportPiper PA32-300 · Weaverville, CAThe acft was being flown to a uni-directional arpt with an instructor plt (CFI) in the right front seat & a student plt/prospective buyer in the left front seat. The rwy elevation was 2230 ft MSL at the south end & 2350 ft at the north end. North of the rwy,…Apr 9, 1983 · N15351 · DestroyedNTSB MIA83FA006Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Placid, FLAircraft was transporting marijuana and during an attempted road landing at Lake Placid collided with wires which damagethe landing assembly. Aircraft continued on to north about 4 miles and ditched in a lake. The aircraft sank with both occupants and cargo.Oct 6, 1982 · N13785 · Substantial damageNTSB ANC82DA080Accident · No injuriesFinal reportPiper PA-32 · Near Dillingham, AKThe pilot began taking off down slope in calm wind conditions with six passengers on board. Reportedly, the 1380 ft runway was mostly dry, but was muddy in places, except the last 100 ft contained standing water. The aircraft had barely lifted off prior to…Aug 26, 1982 · N7989C · Substantial damageNTSB ATL82FKJ11Accident · Serious injuriesFinal reportPiper PA-32 · Muscle Shoals, ALDuring the approach the pilot stated that he could not extend the landing gear. At some point during the approach the aircraft broke out into VFR conditions. The pilot stated he had the airport in sight when the aircraft struck a 160,000 volt power line.…Jan 22, 1982 · N31937 · DestroyedNTSB ATL82FKQ10Accident · 1 fatalFinal reportPiper PA-23-250 · Mccomb, MSBefore taking off from jackson, MS, the pilot received a weather briefing by radio and filed an IFR flight plan to Mccomb, MS. During arrival at Mccomb, the weather was IFR with an indefinitely obscured ceiling at zero ft, visibility 1/2 mile in fog, wind 160…Jan 20, 1982 · N6242Y · Destroyed