OpenAirDocs.org

NTSB investigations: Lycoming 0-540 series, CA

9 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - on ground/water”. 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

19872026

Where

Open the map

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 c.\"eventStateOrRegion\" = 'CA' 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 ('41532')
      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\" = 260))
  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 LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.Aug 20, 2006 · N2526S · Substantial damageNTSB LAX99LA045Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Inyokern, CAThe failure of the pilot to maintain control of the aircraft while landing.Nov 28, 1998 · N5636M · Substantial damageNTSB LAX98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fullerton, CAthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground swerve and subsequent damage to the airplane.Oct 23, 1997 · N8203P · Substantial damageNTSB LAX96LA128Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bishop, CAfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve. The unfavorable wind condition was a related factor.Mar 8, 1996 · N5652C · Substantial damageNTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.Dec 31, 1992 · N129AB · Substantial damageNTSB LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.Mar 20, 1992 · N8840W · Substantial damageNTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.Mar 6, 1989 · N777ML · Substantial damageNTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CAFeb 7, 1988 · N5533S · Substantial damageNTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…Jan 11, 1987 · N6216N · Substantial damage