OpenAirDocs.org

NTSB investigations: Lycoming IO-540 series

62 cases on aircraft whose registry engine model is Lycoming IO-540 series, where the first occurrence was “In flight encounter with weather”. 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 ('41530', '41585')
      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\" = 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 DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…Jun 4, 1988 · N8802Z · DestroyedNTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.Feb 23, 1988 · N8429N · Substantial damageNTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…May 23, 1987 · N81796 · DestroyedNTSB CHI87FA057Accident · No injuriesField investigationFinal reportPiper PA-32-301 · Wheeling, ILThe pilot attempted flight although pirep's for icing had been issued during weather briefing from fss and aircraft was not equipped for icing conditions. Shortly after takeoff, pilot reported to ATC problems with aircraft flight instruments and then reported…Dec 29, 1986 · N8281Y · Substantial damageNTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…Jul 18, 1986 · N1402X · DestroyedNTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…May 19, 1985 · N300UM · Substantial damageNTSB CHI85LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Lacon, ILWhile on final apch moderate turbulence was experienced. A 200 to 300 foot verticle loss of alt occurred. The plt added pwr and increased the pitch attitude. Before alt could be regained the acft contacted a utility pole. The apch was being made to rwy 18.…Mar 5, 1985 · N3012L · Substantial damageNTSB ATL85FA101Accident · 2 fatalField investigationFinal reportCessna 182R · Burkes Garden, VAThe plt departed manassas without a current wx briefing or filing a flt plan. Plt had also left maps and a list of checkpoints at home. His route of flt was into an area of low ceilings and visibility. The acft crashed into a mountain at the 3850 ft level.…Feb 19, 1985 · N2370E · DestroyedNTSB MIA83FA202Accident · 5 fatalField investigationFinal reportRockwell 114A · Ebro, FLShortly after takeoff the plt advised departure control that he was going around clouds & that there was no activity on his onboard storm scope. Several minutes later radar contact was lost. The acft had broke up in flight. Although VMC prevailed at the…Aug 14, 1983 · N215XP · DestroyedNTSB NYC83FA087Accident · 6 fatalField investigationFinal reportPiper PA-32RT-300 · Wellsville, NYJust prior to this flt, the plt had flown from hornell, NY to Wellsville, NY. Before departing hornell, he radioed that the vacuum annunciator light was on, & during a run-up, the suction gauge read zero. Ground personnel advised that with this problem, the…Apr 8, 1983 · N3515M · DestroyedNTSB CHI83LA040Accident · Serious injuriesLimited investigationFinal reportPiper 601P · Sheboygan, WIThe plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around.Nov 18, 1982 · N6078U · DestroyedNTSB LAX82FA275Accident · 2 fatalField investigationFinal reportPiper PA-601P · South Of Wicken, AZAt about 1005 MST the plt received a wx briefing for a flt to Florida with an overnight stay in Texas. Thunderstorm activity was forecast along the proposed route of flt. The briefer advised the plt to get an updated briefing before departure because of the…Jul 24, 1982 · N3642T · Destroyed