NTSB investigations: Lycoming 0-320 series, 2008, 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
NTSB investigations: Lycoming 0-320 series, 2008, 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\") = 2008
    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 SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…Aug 30, 2008 · N172ST · Substantial damageNTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.Aug 3, 2008 · N7635K · Substantial damageNTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.Jun 30, 2008 · N61736 · Substantial damageNTSB LAX08LA206Accident · No injuriesLimited investigationFinal reportCessna 172N · El Cajon, CAThe loss of engine power due to carburetor ice resulting from the flight instructor's failure to use the carburetor heat when simulating an engine failure. Contributing to the accident were the carburetor icing weather condition and the lack of suitable…Jun 26, 2008 · N6360D · Substantial damageNTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.Jun 24, 2008 · N9629V · Substantial damageNTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.Jun 9, 2008 · N9328H · Substantial damageNTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.Jun 6, 2008 · N73403 · Substantial damageNTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.May 28, 2008 · N21134 · Substantial damageNTSB LAX08CA149Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe pilot's inadequate recovery from a bounced landing.May 20, 2008 · N6521J · Substantial damageNTSB LAX08CA150Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Rockport, CAThe pilot's performance of VFR flight into IMC, resulting in failure to maintain terrain clearance. Contributing to the accident was the fog.May 19, 2008 · N90930 · Substantial damageNTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.Apr 17, 2008 · N3VK · Substantial damageNTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.Apr 16, 2008 · N4080P · Substantial damageNTSB SEA08CA088Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Tracy, CAThe flight instructor's inadequate compensation for the tailwind condition and failure to maintain adequate airspeed that led to an inadvertent stall.Mar 8, 2008 · N75SE · Substantial damageNTSB LAX08FA049Accident · 5 fatalField investigationFinal reportCessna 172N · Corona, CAThe failure of both pilots to see and avoid the other airplane.Jan 20, 2008 · N737EJ · 2 aircraft · DestroyedNTSB LAX08CA048Accident · Minor injuriesData collectionFinal reportWaltermire Glastar · Vacaville, CAThe pilot's failure to maintain directional control during landing and a lack of experience in conventional gear airplanes.Jan 19, 2008 · N248DW · Substantial damageNTSB SEA08CA065Accident · No injuriesData collectionFinal reportRobinson R-22 · Riverside, CAThe pilot's misjudged landing flare and improper use of the collective control.Jan 8, 2008 · N8280J · Substantial damageNTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.Jan 7, 2008 · N30WH · Substantial damage