NTSB investigations: Lycoming 0-320 series, 2004
30 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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 | 30 |
|---|---|
| 1983 | 35 |
| 1984 | 34 |
| 1985 | 40 |
| 1986 | 35 |
| 1987 | 23 |
| 1988 | 40 |
| 1989 | 21 |
| 1990 | 31 |
| 1991 | 34 |
| 1992 | 31 |
| 1993 | 33 |
| 1994 | 32 |
| 1995 | 20 |
| 1996 | 21 |
| 1997 | 30 |
| 1998 | 25 |
| 1999 | 27 |
| 2000 | 30 |
| 2001 | 26 |
| 2002 | 31 |
| 2003 | 36 |
| 2004 | 30 |
| 2005 | 37 |
| 2006 | 27 |
| 2007 | 36 |
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\") = 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\" = 250))
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" = 250))
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 LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.NTSB ANC05CA007Accident · No injuriesData collectionFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain adequate airspeed during the landing approach, which resulted in a stall and an uncontrolled descent to the runway. A factor contributing to the accident was an inadvertent stall.NTSB IAD05LA003Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Pittsburgh, PAThe delayed remedial action by the flight instructor.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB ANC04LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to compensate for wind conditions during landing, and his failure to maintain adequate airspeed, which resulted in a loss of control, and subsequent collision with trees during an uncontrolled descent. Factors contributing to the accident…NTSB CHI04CA258Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Detroit, MIThe student pilot's failure to maintain directional control of the airplane during the landing flare and subsequent go-around. A factor was the T-hangar.NTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.NTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW04LA222Accident · No injuriesLimited investigationFinal reportLancair 320 · Houston, TXThe pilot's premature lift-off before attaining adequate airspeed resulting in a stall and collision with the ground.NTSB ANC04LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…NTSB CHI04FA197Accident · 1 fatalField investigationFinal reportRobinson R22 Alpha · Mount Clemens, MIA loss of control in flight for undetermined reasons.NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB FTW04LA189Accident · Serious injuriesLimited investigationFinal reportCalhoun RV-4 · Latexo, TXThe pilot's failure to maintain directional control and attain adequate airspeed resulting in a stall. Contributing factors were the pilot's diverted attention with closing the canopy, and the quartering crosswind.NTSB NYC04LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Erwinna, PAThe student pilot's failure to maintain airspeed and his failure to follow the go-around procedure which resulted in a stall.NTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.NTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…NTSB CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.NTSB LAX04CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · California City, CAthe certified flight instructor's failure to maintain an adequate airspeed, which resulted in a stall/mush condition and a collision with terrain. Factors in the accident were strong tailwind conditions and a sudden wind shift.NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.