NTSB investigations: Lycoming 0-320 series, 2004
36 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
Open the mapLatest 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\") = 2004
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") = 2004
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 DFW05CA046Accident · No injuriesData collectionFinal reportCessna 172P · Houston, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the muddy condition of the terrain.NTSB ATL05CA036Accident · No injuriesData collectionFinal reportChampion 7-GCAA · Talladega, ALThe binding right wheel brake that resulted in a loss of control during landing roll. A factor was the drainage ditch.NTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.NTSB MIA05CA041Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Holly Springs, MSThe failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.NTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.NTSB LAX05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Prescott, AZthe pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.NTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.NTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.NTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.NTSB CHI04CA289Accident · No injuriesData collectionFinal reportArganbright Vans RV-4 · Custer, SDThe pilot's failure to maintain directional control during the landing. Factors were the sudden wind shift and the embankment.NTSB CHI04CA242Accident · No injuriesData collectionFinal reportAeronca Champion 7GCBC · Mullen, NEthe failure of the pilot to maintain direction control during gusty wind conditions on landing.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC04LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kenai, AKThe pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.NTSB CHI04CA247Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grant, NEDirectional control not attained and the control interference encountered by the pilot during landing roll. The ditch was a contributing factor.NTSB ANC04LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, and his failure to maintain directional control which resulted in a loss of control, an encounter with a ditch, and the airplane nosing over. A factor in the accident was a crosswind.NTSB LAX04CA298Accident · No injuriesData collectionFinal reportBerry Hatz CB-1 · Upland, CAthe pilot's inadequate recovery following a bounced landing, improper use of the rudder control, and failure to maintain directional control.NTSB FTW04LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane. A contributing factor was the high wind condition.NTSB DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.NTSB IAD04FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Toughkenamon, PAThe pilot's decision to add power, in an attempt to abort the landing after the airplane had veered off the runway. A factor was the pilot's failure to maintain directional control after the landing.NTSB SEA04CA159Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Sequim, WAAircraft control not maintained during the landing roll. A factor was the irrigation pipe.NTSB CHI04CA176Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake City, MIThe pilot's failure to maintain directional control during landing.NTSB CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.NTSB ANC04LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Chugiak, AKThe pilot's excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.NTSB IAD04LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Wellsboro, PAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB MIA04CA104Accident · Minor injuriesData collectionFinal reportWilliam K. Crawford Tango 2 · Williston, FLThe failure of the pilot to maintain directional control of the airplane during a high speed taxi test resulting in the airplane veering off the left side of the runway, becoming airborne, and nosing over.NTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB ANC04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's loss of directional control during the landing roll, which resulted in the airplane entering deep snow alongside the runway, and nosing over.NTSB ANC04LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naples, FLThe pilot's inadequate compensation for a crosswind condition during landing, which resulted in a loss of control and an on-ground encounter with terrain. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB MIA04CA053Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Sebring, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane ground looping and incurring damage.