NTSB investigations: Lycoming 0-320 series, CA
79 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 | 3 |
|---|---|
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 6 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 1 |
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 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')
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 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')
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 SEA08FA036Accident · 2 fatalField investigationFinal reportCessna 177 · Auburn, CAThe pilot failed to maintain an adequate airspeed while maneuvering in the traffic pattern for landing, which resulted in a stall/spin. Contributing to the accident was the pilot's impairment during the flight from the effects of over-the-counter medications.NTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.NTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.NTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.NTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.NTSB LAX06CA060Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Irwindale, CAThe pilot failed to maintain adequate main rotor rpm.NTSB 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.NTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.NTSB 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.NTSB 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.NTSB 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.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 LAX03FA109Accident · 2 fatalField investigationFinal reportCessna 172L · Rosamond, CAthe pilot's failure to maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall and impact with flat level terrain. Also causal was the pilot's impaired judgment due to recent use of cocaine, and ethanol.NTSB LAX03FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Phelan, CAthe student pilot's failure to maintain an adequate airspeed while maneuvering that lead to a stall spin and impact with flat desert terrain.NTSB LAX02LA160Accident · No injuriesLimited investigationFinal reportMulligan RV4 · Santa Ynez, CAThe failure of the pilot to maintain sufficient airspeed during the attempted go-around resulting in a stall/mush. The gusting winds, recent purchase of airplane, and premature raising of the flaps were factors.NTSB LAX02LA109Accident · 1 fatalLimited investigationFinal reportTrenti RV-4 · Jacumba, CAin-flight loss of control for undetermined reasons.NTSB LAX02FA088Accident · No injuriesField investigationFinal reportRobinson R22 Beta · Glendora, CAThe student's failure to maintain adequate main rotor rpm, and the flight instructor's inadequate supervision. Contributing factors were the high helicopter gross weight and density altitude, and the descending mountainous terrain.NTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…NTSB LAX01LA176Accident · No injuriesLimited investigationFinal reportLeonard Walters Avid Magnum · Lake Shasta, CAA loss of control on final approach due to encountering a strong wind gust and downdraft.NTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…NTSB LAX01LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rosamond, CAThe pilot's improper airplane handling technique and inadequate airspeed during performance of an intentional soft field takeoff.NTSB LAX01LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gorman, CAthe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.NTSB LAX00FA178Accident · 4 fatalField investigationFinal reportCessna 172P · Chester, CAThe pilot's encounter with a wind shear at low altitude, which resulted in a loss of control and a stall/spin. Factors in the accident were the high density altitude and the pilot's lack of experience and training in high density altitude operations. The…NTSB LAX00FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Rialto, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB LAX99LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Merced, CAThe pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.NTSB LAX99LA307Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Azusa, CAthe pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.NTSB LAX99LA209Accident · 1 fatalLimited investigationFinal reportBlanco SEA Hawker · Yucca Valley, CAA loss of control in flight for undetermined reasons that resulted in an in flight collision with terrain. A factor was turbulent weather conditions in mountainous/hilly terrain.NTSB LAX98LA178Accident · Serious injuriesLimited investigationFinal reportFields Baby Belle · Inyokern, CAThe failure of the pilot to recover from a low rotor rpm condition, which resulted in a loss of aircraft control.NTSB LAX98LA172Accident · 4 fatalLimited investigationFinal reportPiper PA-28-161 · Half Moon Bay, CAThe non-instrument rated pilot's loss of aircraft control due to spatial disorientation in dark night conditions.NTSB LAX98LA146Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Sacramento, CAthe CFI's failure to follow procedures and directives, and the use of an improper technique to transition from an autorotative descent to a hover, which exceeded the aircraft's performance capabilities and resulted in a unplanned hard landing. The soft…NTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.NTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.NTSB LAX96LA022Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Hemet, CAthe pilot's failure to maintain adequate airspeed and the inadvertent stall while performing a short field landing.NTSB LAX94LA290Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Banning, CAthe pilot's failure to obtain and maintain an appropriate climb airspeed after lift-off which resulted in an inadvertent stall mush condition. Factors in the accident were the high-density altitude condition, the pilot's selection of a runway with an uphill…NTSB LAX94FA282Accident · 1 fatalField investigationFinal reportCessna 172M · Running Springs, CAthe flying pilot's operation of the aircraft at an altitude that did not provide sufficient terrain clearance necessary to recover from an inadvertent, pilot-induced stall.NTSB LAX94LA262Accident · Minor injuriesLimited investigationFinal reportPayne Foster Glasair · Hesperia, CAthe pilot's loss of directional control during an attempted landing and subsequent go-around. Factors were the high-density altitude, inappropriate fuel leaning procedures, and the gust of wind.NTSB LAX93LA298Accident · No injuriesLimited investigationFinal reportCessna 172 · Vacaville, CAThe pilot's improper in-flight planning/decision by failing to allow enough time for the rotor wash to dissipate before attempting the approach. The wake turbulence (rotor wash) was a factor in this accident.NTSB LAX93LA277Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Torrance, CAAn encounter with a windshear condition. The delayed banner jettison was a factor.NTSB LAX93LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Turlock, CAThe pilot's poorly planned approach and his failure to maintain airspeed.NTSB LAX93LA224Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Pacoima, CAThe student pilot's failure to maintain directional control, his improper use of the throttle and antitorgue pedals. A factor related to this accident was the student's lack of total experience.NTSB LAX93LA203Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Davis, CAThe pilot's failure to follow a safety tip in the pilot's operating handbook to never make a downwind takeoff, his failure to maintain rotor RPM, and his improper use of the helicopter flight controls. A factor which contributed to the accident was the…NTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.NTSB LAX92LA280Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Barstow, CA1) The pilot's maneuvering at low altitude into a tailwind condition which exceeded the performance capabilities of the helicopter, 2) his failure to maintain proper main rotor RPM, and 3) the pilot's selection of an altitude for the maneuvers which was too…NTSB LAX92LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Oxnard, CAThe pilot's failure to maintain control of the airplane during takeoff as a result of his alcoholic impairment of efficiency and judgement. A factor in the accident was the dark night.NTSB LAX92LA087Accident · No injuriesLimited investigationFinal reportRobinson R22B · Lake Hughes, CAThe failure of the pilot to maintain rotor RPM while maneuvering and his misjudgement of the landing flare. A factor in the accident was the pilot's lack of total experience.NTSB LAX92LA003Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Palo Alto, CAAn inflight los of control due to the failure of the student pilot to correctly configure the rudder trim for takeoff.NTSB LAX91LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · Truckee, CAThe failure of the pilot to maintain airspeed and the inadvertent entry into a stall mush which led to a loss of control and an uncontrolled descent. Factors in the accident were: the pilot's poor preflight planning and the high density altitude.NTSB LAX91LA072Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Torrance, CAThe pilot's improper use of the rotorcraft's flight controls. Contributing factors were related to the pilot's lack of experience in the type of low altitude maneuver.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.