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
| 1982 | 50 |
|---|---|
| 1983 | 46 |
| 1984 | 41 |
| 1985 | 31 |
| 1986 | 40 |
| 1987 | 46 |
| 1988 | 37 |
| 1989 | 28 |
| 1990 | 36 |
| 1991 | 34 |
| 1992 | 23 |
| 1993 | 32 |
| 1994 | 26 |
| 1995 | 32 |
| 1996 | 24 |
| 1997 | 43 |
| 1998 | 42 |
| 1999 | 28 |
| 2000 | 38 |
| 2001 | 43 |
| 2002 | 37 |
| 2003 | 35 |
| 2004 | 36 |
| 2005 | 39 |
| 2006 | 41 |
| 2007 | 22 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.NTSB 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.NTSB 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.NTSB 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.NTSB LAX04CA023Accident · No injuriesData collectionFinal reportCessna 172M · Montague, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB 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.NTSB 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.NTSB LAX03CA301Accident · No injuriesData collectionFinal reportStarduster SA300 · Quincy, CAthe pilot's failure to maintain directional control of the airplane, which resulted in a ground loop.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB 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.NTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlNTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.NTSB 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.NTSB 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.