NTSB investigations: Lycoming IO-320 series, CA

6 cases on aircraft whose registry engine model is Lycoming IO-320 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

19822026
NTSB investigations: Lycoming IO-320 series, CA per year, 1982–2026: 6 cases
19821
19831
19901
20001
20031
20061

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 ('41509')
      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 LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.Jan 9, 2006 · N36382 · Substantial damageNTSB LAX03LA155Accident · No injuriesLimited investigationFinal reportMonaghan Glasair · Hayward, CAthe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control, resulting in a ground loop.May 18, 2003 · N271RP · Substantial damageNTSB LAX00LA287Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Davis, CAthe dual student's improper response to a simulated engine failure and the flight instructor's delayed remedial action and inadequate supervision of the flight.Aug 4, 2000 · N300RE · Substantial damageNTSB LAX90DVA05Accident · No injuriesFinal reportVans RV-3 · Bakersfield, CAThe pilots loss of directional control after a touch and go landing in a newly acquired homebuilt aircraft. Contributing to the accident was the pilots lack of experience in this aircraft.Jun 15, 1990 · N9030N · Substantial damageNTSB LAX84LA006Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAThe acft groundlooped during landing after an aerial glider tow. The plt reported that he had performed 23 glider tows that day and he may have become fatigued. He was accustumed to making a low level turn to a short final from a base leg at 100 ft AGL. This…Oct 6, 1983 · N88314 · Substantial damageNTSB LAX83LVM05Accident · No injuriesFinal reportPitts S1C · 6 N.W. Half Moo, CAAircraft landed and a gust of wind turned the aircraft. Aircraft continued off right side of runway and nosed over in soft ground.Dec 9, 1982 · N2363 · Substantial damage