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

13 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
NTSB investigations: Lycoming 0-320 series, 1997, CA per year, 1964–2026: 1,367 cases
196425
196530
196646
196750
196841
196933
197041
197130
197236
197331
197424
197524
197618
197739
197836
197932
198032
198130
198228
198327
198424
198519
198627
198722
198822
198919
199029
199122
199220
199328
199425
199520
199620
199713
199817
199920
200024
200124
200225
200321
200417
200520
200619
200718
200817
200917
201012
20119
20126
201311
20148
201512
201612
201712
201813
201914
20207
20217
20226
202313
20249
20253
202611

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.\"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 LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.Nov 28, 1997 · N739HE · Substantial damageNTSB LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.Nov 24, 1997 · N6463D · DestroyedNTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…Nov 22, 1997 · N45SG · Substantial damageNTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…Nov 15, 1997 · N5231B · DestroyedNTSB LAX98LA030Accident · No injuriesLimited investigationFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain adequate clearance from a hangar while taxiing.Nov 5, 1997 · N98483 · Substantial damageNTSB LAX97LA267Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · San Jose, CAThe pilot's failure to maintain directional control, and excessive remedial action, which resulted in an inadvertent swerve off the runway.Jul 26, 1997 · N8333V · Substantial damageNTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.May 12, 1997 · N83795 · Substantial damageNTSB LAX97LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAthe student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.May 7, 1997 · N6469D · Substantial damageNTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.Mar 29, 1997 · N2128Q · Substantial damageNTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.Mar 15, 1997 · N7163R · Substantial damageNTSB LAX97LA119Accident · No injuriesLimited investigationFinal reportCessna 172N · Oakland, CAthe student pilot's failure to completely reduce the throttle after landing, and his failure to maintain proper runway alignment.Mar 10, 1997 · N6375D · Substantial damageNTSB LAX97LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.Feb 24, 1997 · N20508 · Substantial damageNTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.Feb 11, 1997 · N34PC · Substantial damage