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

20 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, 2005, 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\") = 2005
    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 LAX06CA060Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Irwindale, CAThe pilot failed to maintain adequate main rotor rpm.Dec 19, 2005 · N177LH · DestroyedNTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.Nov 25, 2005 · N8091H · Substantial damageNTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.Oct 31, 2005 · N83785 · Substantial damageNTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.Oct 19, 2005 · N4252P · Substantial damageNTSB LAX06CA019Accident · No injuriesData collectionFinal reportHarmel RV6A · Oceanside, CAthe pilot-induced oscillations encountered on landing following the pilot's misjudged landing flare and premature release of elevator backpressure during touchdown.Oct 15, 2005 · N221MH · Substantial damageNTSB LAX05LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fall River Mill, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain runway alignment during landing.Sep 23, 2005 · N5756Y · Substantial damageNTSB LAX05LA309Accident · Serious injuriesLimited investigationFinal reportThomas RV4 · Kernville, CAa loss of engine power due to fuel starvation caused by the pilot's failure to select a tank containing fuel for takeoff. A factor in the accident was the lack of a runway overrun area beyond the departure end of the runway.Sep 21, 2005 · N3882N · Substantial damageNTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.Aug 31, 2005 · N216RN · DestroyedNTSB LAX05CA276Accident · No injuriesData collectionFinal reportCessna 172N · Ramona, CAthe pilot's failure to maintain directional control during landing.Aug 22, 2005 · N734MY · Substantial damageNTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…Aug 2, 2005 · N4401X · DestroyedNTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.Jun 14, 2005 · N8634 · Substantial damageNTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.Jun 10, 2005 · N1126U · 2 aircraft · Minor damageNTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.Jun 7, 2005 · N7668G · Substantial damageNTSB LAX05CA191Accident · No injuriesData collectionFinal reportCessna 172N · Stockton, CAthe pilot's improper use of the brakes, and his failure to maintain directional control during the landing rollout.May 30, 2005 · N172MR · Substantial damageNTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.Apr 27, 2005 · N737WF · Substantial damageNTSB LAX05LA134Accident · Minor injuriesLimited investigationFinal reportNewell Thomas RV6-A · Hayward, CAA loss of engine power due to fuel system contamination. A factor in the accident was the fuel system not being flushed out after it was involved in a previous accident where the fuel tanks were damaged.Apr 12, 2005 · N16TN · Substantial damageNTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.Mar 30, 2005 · N7832G · Substantial damageNTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.Mar 26, 2005 · N7055H · 2 aircraft · Minor damageNTSB LAX05FA114Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's failure to maintain adequate airspeed that resulted in an inadvertent stall/mush during initial climb. Contributing factors were the pilot's inadequate preflight preparations and the high density altitude.Mar 13, 2005 · N9956W · Substantial damageNTSB LAX05LA064Accident · 1 fatalLimited investigationFinal reportJimmy Hill Lancair 235 · El Cajon, CAthe pilot's failure to maintain the proper glidepath to avoid obstacles and terrain.Jan 12, 2005 · N124JH · Substantial damage