OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, 2004, CA

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

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 year(c.\"eventDate\") = 2004
    AND 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 ('41508'))
  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 LAX05LA049Accident · No injuriesLimited investigationFinal reportRobinson R22B · Los Angeles, CAThe activation of the low main rotor rpm warning system for undetermined reasons.Dec 11, 2004 · N145RJ · Substantial damageNTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.Nov 13, 2004 · N502GL · Substantial damageNTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.Oct 30, 2004 · N8158D · Substantial damageNTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.Oct 28, 2004 · N9081L · Substantial damageNTSB LAX04CA298Accident · No injuriesData collectionFinal reportBerry Hatz CB-1 · Upland, CAthe pilot's inadequate recovery following a bounced landing, improper use of the rudder control, and failure to maintain directional control.Aug 20, 2004 · N592DJ · Substantial damageNTSB LAX04CA282Accident · No injuriesData collectionFinal reportCessna 172P · Big Bear City, CAthe instructor's inadequate compensation for wind conditions and delayed decision to perform a go-around. Contributing factors were wind gusts, windshear, and an excessive descent rate.Jul 27, 2004 · N65615 · Substantial damageNTSB LAX04LA269Accident · No injuriesLimited investigationFinal reportNewell RV-6A · San Jose, CAThe pilot's misjudgment of the airplane's distance/speed during a precautionary landing, which resulted in the airplane overrunning the runway. Contributing factors were failure of an oil line, and the fence.Jul 16, 2004 · N16TN · Substantial damageNTSB LAX04LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CAthe pilot's failure to attain an adequate altitude to clear mountainous terrain during a high density altitude condition.Jul 11, 2004 · N6106H · Substantial damageNTSB LAX04CA255Accident · Minor injuriesData collectionFinal reportCessna 172N · Chemehuevi, CAthe pilot's improper recovery from a bounced landing, inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane.Jul 7, 2004 · N734PW · Substantial damageNTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.Jun 9, 2004 · N621BP · DestroyedNTSB LAX04CA196Accident · No injuriesData collectionFinal reportCessna 172N · Lincoln, CAthe pilot's failure to maintain obstacle clearance.Apr 25, 2004 · N734RE · Substantial damageNTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.Apr 22, 2004 · N8492A · Substantial damageNTSB LAX04CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · California City, CAthe certified flight instructor's failure to maintain an adequate airspeed, which resulted in a stall/mush condition and a collision with terrain. Factors in the accident were strong tailwind conditions and a sudden wind shift.Apr 3, 2004 · N88BM · DestroyedNTSB LAX04LA124Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Upland, CAA partial loss of engine power for undetermined reasons during takeoff.Feb 13, 2004 · N5107K · Substantial damageNTSB LAX04CA115Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Placerville, CAthe pilot's failure to attain a proper glide path during the final approach and delayed go-around, resulting in an undershoot of the runway. The inadequate supervision of the flight and flight instructor's delayed remedial action was also causal.Jan 30, 2004 · N28385 · Substantial damageNTSB LAX04FA096Accident · 2 fatalField investigationFinal reportCessna 172K · Grass Valley, CAthe pilot's continued visual flight into instrument meteorological conditions and failure to maintain an adequate terrain/object clearance altitude. Also causal was the pilot's improper in-flight decision to return to the origin airport in the face of…Jan 20, 2004 · N99LR · DestroyedNTSB LAX04CA098Accident · No injuriesData collectionFinal reportCessna 172P · Granada Hills, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Jan 20, 2004 · N5364K · Substantial damage