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

19 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, 2006, 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\") = 2006
    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 LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.Dec 22, 2006 · N8001H · DestroyedNTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.Dec 21, 2006 · N9141Y · Substantial damageNTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…Nov 21, 2006 · N994HV · Substantial damageNTSB LAX07LA022Accident · Serious injuriesLimited investigationFinal reportFish Vans RV-6 · Turlock, CAa partial loss of engine power due to the broken piston rings in the no. 4 cylinder. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in a stall/mush.Oct 28, 2006 · N1198N · Substantial damageNTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.Oct 13, 2006 · N467JF · Substantial damageNTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.Sep 16, 2006 · N6532L · DestroyedNTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.Sep 8, 2006 · N3082P · DestroyedNTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.Sep 2, 2006 · N4813T · Substantial damageNTSB LAX06LA275Accident · 2 fatalLimited investigationFinal reportTerry Tevis RV-6A · Novato, CAThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.Aug 28, 2006 · N312RV · Substantial damageNTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.Aug 17, 2006 · N577JS · Substantial damageNTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…Aug 4, 2006 · N5262R · Substantial damageNTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.Aug 3, 2006 · N12626 · Substantial damageNTSB LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.Jul 23, 2006 · N2115R · Substantial damageNTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.May 26, 2006 · N4596X · Substantial damageNTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.Mar 26, 2006 · N5906W · Substantial damageNTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.Mar 7, 2006 · N739NU · Substantial damageNTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.Feb 15, 2006 · N23617 · Substantial damageNTSB LAX06CA115Accident · No injuriesData collectionFinal reportCessna 172M · Murrieta, CAa partial loss of engine power resulting from the student pilot's mismanagement of the mixture control.Feb 14, 2006 · N80859 · Substantial damageNTSB LAX06LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAthe failure of the pilot of the other airplane to maintain an adequate clearance from obstacles while taxiing.Feb 11, 2006 · N739GY · 2 aircraft · Minor damage