NTSB investigations: Lycoming 0-540 series

67 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the defining event 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, 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 ('41532')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '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 ERA10CA407Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Aguadilla, PRThe pilot's inadequate preflight performance calculations, which resulted in the overweight helicopter's lack of hover capability out of ground effect.Aug 8, 2010 · N367JM · Substantial damageNTSB CEN10CA410Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Cairo, NEThe pilot's failure to maintain aircraft control.Jul 18, 2010 · N9552P · Substantial damageNTSB WPR10FA239Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Redmond, ORThe pilot's failure to maintain airspeed, which resulted in a stall and collision with terrain.May 14, 2010 · N6967P · Substantial damageNTSB WPR10CA233Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lake Havasu City, AZThe student pilot's failure to maintain aircraft control during a go-around, resulting in a stall/mush.May 8, 2010 · N918JR · Substantial damageNTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…Apr 19, 2010 · N5425P · DestroyedNTSB WPR10CA192Accident · No injuriesData collectionFinal reportRobinson R44 · Temecula, CAThe pilot's failure to maintain control of the helicopter during takeoff.Apr 6, 2010 · N688SS · Substantial damageNTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.Jan 24, 2010 · N222AQ · DestroyedNTSB WPR10CA067Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Llano, CAThe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain lateral and directional control.Nov 27, 2009 · N9600P · Substantial damageNTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…Jun 19, 2009 · N182GT · DestroyedNTSB ANC09CA056Accident · No injuriesData collectionFinal reportMaule M-5-235C · Wasilla, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.Jun 12, 2009 · N407X · Substantial damageNTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.Apr 11, 2009 · N7690P · DestroyedNTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.Mar 14, 2009 · N129AB · DestroyedNTSB WPR09CA131Accident · No injuriesData collectionFinal reportCessna TR182 · Amargosa Valley, NVThe pilot's failure to maintain adequate airspeed and runway alignment.Feb 27, 2009 · N2518S · Substantial damageNTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.Jan 29, 2009 · N3WC · Substantial damageNTSB ERA09LA051Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · San Juan, PRThe detachment of the forward left servo control tube upper rod end attachment bolt during a hover due to separation of its retaining nut for undetermined reasons.Nov 12, 2008 · N452JM · Substantial damageNTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.Aug 21, 2008 · N711BZ · DestroyedNTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.Mar 17, 2008 · N169AB · Substantial damage