NTSB investigations: Lycoming 0-320 series, 2003

35 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming 0-320 series, 2003 per year, 1982–2026: 930 cases
198250
198346
198441
198531
198640
198746
198837
198928
199036
199134
199223
199332
199426
199532
199624
199743
199842
199928
200038
200143
200237
200335
200436
200539
200641
200722

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\") = 2003
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 LAX04CA082Accident · No injuriesData collectionFinal reportCessna 172N · Angels Camp, CAthe CFI's inadequate compensation for a crosswind condition, which resulted in the loss of directional control. The crosswind and wind gusts were factors.Dec 29, 2003 · N461BD · Substantial damageNTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.Nov 22, 2003 · N61924 · Substantial damageNTSB LAX04LA044Accident · Minor injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Pacoima, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a sign and an unoccupied airplane.Nov 14, 2003 · N124WD · Substantial damageNTSB FTW04LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Amarillo, TXThe pilot's inadequate compensation for wind condition. Contributing factors were the pilot's lack of total experience in the make and model of aircraft, and the crosswind.Nov 5, 2003 · N5203W · Substantial damageNTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.Nov 1, 2003 · N41977 · Substantial damageNTSB LAX04CA023Accident · No injuriesData collectionFinal reportCessna 172M · Montague, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Oct 23, 2003 · N80543 · Substantial damageNTSB ATL04LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe student pilot's failure to maintain directional control on landing roll resulting in a collision with a ditch, and subsequent nose over.Oct 16, 2003 · N64255 · Substantial damageNTSB ANC04LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ketchikan, AKThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an inadvertent stall and a ground loop. A factor contributing to the accident was the loss of directional control on the ground.Oct 11, 2003 · N3573P · Substantial damageNTSB LAX03CA301Accident · No injuriesData collectionFinal reportStarduster SA300 · Quincy, CAthe pilot's failure to maintain directional control of the airplane, which resulted in a ground loop.Sep 27, 2003 · N1698 · Substantial damageNTSB ANC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tanana, AKThe pilot's failure to maintain aircraft control during the landing roll, which resulted in an overrun and nose down. Factors contributing to the accident were gusty winds, and restricted aileron control movement.Sep 23, 2003 · N1386A · Substantial damageNTSB SEA03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Billings, MTThe pilot's inadequate compensation for wind conditions which led to a loss of control and subsequent ground loop. A contributing factor was the wind gust.Sep 10, 2003 · N9332D · Substantial damageNTSB ANC03LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop, and collapse of the main landing gear.Aug 22, 2003 · N2608S · Substantial damageNTSB DEN03LA145Accident · No injuriesLimited investigationFinal reportR. I. Woods Bushby Mustang II · Logan, UTthe pilot's failure to maintain aircraft control, and his inadequate recovery from the bounced landing. A contributing factor was the wind gust.Aug 7, 2003 · N74ST · Substantial damageNTSB ANC03CA090Accident · No injuriesData collectionFinal reportPiper PA-18 · Seward, AKThe pilot's inadvertent water loop/swerve during landing roll, which resulted in the airplane nosing over.Aug 7, 2003 · N9668P · Substantial damageNTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.Jul 28, 2003 · N9032L · Substantial damageNTSB ANC03LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Pilot Point, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane that resulted in the left wing striking the ground during the landing roll. A factor contributing to the accident was the presence of wind gusts.Jun 29, 2003 · N9897Y · Substantial damageNTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.Jun 27, 2003 · N739NW · Substantial damageNTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.Jun 15, 2003 · N9566L · Substantial damageNTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.Jun 12, 2003 · N5779D · Substantial damageNTSB SEA03LA091Accident · No injuriesLimited investigationFinal reportCessna 150 · Dillon, MTThe pilot's failure to maintain directional control during the takeoff roll, and his inadequate remedial actions during his attempt to realign the aircraft with the runway. Factors include a crosswind, and the pilot's lack of experience in tailwheel-equipped…May 31, 2003 · N4424U · Substantial damageNTSB DEN03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Price, UTthe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A related factor was the crosswind.May 31, 2003 · N5886W · Substantial damageNTSB LAX03LA153Accident · No injuriesLimited investigationFinal reportBeech B19 · Chandler, AZthe pilot's failure to maintain directional control on the landing roll due to his inadvertent use of brakes.May 18, 2003 · N24006 · Substantial damageNTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.May 15, 2003 · N7412G · Substantial damageNTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.May 3, 2003 · N175W · Substantial damageNTSB SEA03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Marion, MTThe pilot-in-command's failure to maintain directional control during the takeoff roll resulting in the aircraft leaving the runway, crossing a ditch and collapsing the landing gear. A contributing factor was the ditch.Apr 23, 2003 · N60733 · Substantial damageNTSB DEN03LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kemmerer, WYthe pilot's failure to maintain directional control and his inadequate compensation for wind during the landing roll which resulted in a ground loop/swerve and impact with terrain. Contributing factors include the wind gust and the ditch.Apr 20, 2003 · N40520 · Substantial damageNTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.Apr 7, 2003 · N4857A · Substantial damageNTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.Mar 30, 2003 · N4961T · Substantial damageNTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.Mar 23, 2003 · N2968Z · Substantial damageNTSB LAX03LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAthe pilot's failure to maintain directional control during an aborted landing. A contributing factor is the pilot's improper recovery from a bounced landing.Mar 23, 2003 · N63788 · Substantial damageNTSB ATL03LA058Accident · No injuriesLimited investigationFinal reportCessna 172 M · Collegedale, TNThe student pilot's failure to maintain directional control, which resulted in a loss of control, impact with terrain and subsequent nose over.Mar 9, 2003 · N1754V · Substantial damageNTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlMar 8, 2003 · N7342D · Substantial damageNTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.Feb 26, 2003 · N733XP · Substantial damageNTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.Feb 8, 2003 · N734KU · Substantial damageNTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.Jan 8, 2003 · N3628X · Substantial damage