NTSB investigations: Lycoming IO-540 series, 1997

16 cases on aircraft whose registry engine model is Lycoming IO-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 IO-540 series, 1997 per year, 1964–2026: 1,056 cases
19641
19652
19661
19674
19681
19692
19703
19711
19723
19731
19741
19751
19764
19773
19786
19797
198018
198110
198216
198317
198430
198520
198617
198715
198812
198911
199014
199114
199219
199324
199413
199514
199616
199716
199816
199928
200027
200132
200237
200330
200435
200530
200631
200734
200829
200919
201029
201122
201226
201321
201428
201519
201618
201728
201827
201916
202015
202127
202223
202324
202414
202518
202616

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\") = 1997
    AND 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'))
  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 IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.Dec 10, 1997 · N3041J · DestroyedNTSB MIA98FA040Accident · 3 fatalField investigationFinal reportCommander 114B · Cross City, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…Nov 30, 1997 · N302RS · DestroyedNTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.Nov 26, 1997 · N2202U · Substantial damageNTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.Oct 20, 1997 · N2200J · Substantial damageNTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.Sep 12, 1997 · N79DK · Substantial damageNTSB ATL97LA123Accident · 1 fatalLimited investigationFinal reportJurka P51D Mustang · Fort Pierce, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.Aug 24, 1997 · N151MS · DestroyedNTSB LAX97LA281Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Borrego, CAThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.Aug 10, 1997 · N577JL · Substantial damageNTSB FTW97LA284Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pine Bluff, ARloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.Jul 26, 1997 · N38800 · Substantial damageNTSB FTW97LA263Accident · Serious injuriesLimited investigationFinal reportBronner Steen Skybolt · Brazoria, TXa fuel leak at a wobble pump fuel hose clamp, which resulted in loss of fuel and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.Jul 12, 1997 · N773HD · Substantial damageNTSB SEA97LA140Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3-1 · Monument Valley, UTthe pilot's inadequate preflight planing/preparation, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident included: high, gusty, variable winds, and terrain induced downdrafts.Jun 13, 1997 · N6290K · Substantial damageNTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.Apr 28, 1997 · N885JC · DestroyedNTSB LAX97LA158Accident · 2 fatalLimited investigationFinal reportDevendorf Glassair GL25 · Congress, AZfailure of the pilot to recover from an inverted stall/spin prior to impact with the ground. The reason for the loss of control was not determined.Apr 13, 1997 · N28BD · DestroyedNTSB NYC97LA072Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Vincentown, NJThe pilot's failure to maintain directional control, which resulted in an on ground loss of control. A contributing factor was a crosswind.Apr 9, 1997 · N9768C · Substantial damageNTSB MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…Apr 8, 1997 · N4TZ · Substantial damageNTSB ATL97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Memphis, TNfailure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.Mar 16, 1997 · N1102N · Substantial damageNTSB IAD97LA044Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · University Park, PAthe pilot's inability to control the airplane due to a damaged/bent elevator control lever and resultant lack of elevator authority.Jan 18, 1997 · N2803A · Substantial damage