NTSB investigations: Lycoming 0-320 series, CA
42 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2004 | 1 |
| 2005 | 1 |
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 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\" = 200))
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" = 200))
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 LAX06CA019Accident · No injuriesData collectionFinal reportHarmel RV6A · Oceanside, CAthe pilot-induced oscillations encountered on landing following the pilot's misjudged landing flare and premature release of elevator backpressure during touchdown.NTSB LAX04CA255Accident · Minor injuriesData collectionFinal reportCessna 172N · Chemehuevi, CAthe pilot's improper recovery from a bounced landing, inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane.NTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.NTSB LAX02LA128Accident · No injuriesLimited investigationFinal reportWilson Magnum · Woodland, CAThe pilot's inadequate compensation for the gusty crosswind condition, and his failure to maintain airplane control.NTSB LAX02LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Avalon, CAThe pilot's inadequate bounced landing recovery technique, which resulted in an inadvertent porpoise.NTSB LAX01LA232Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Hayward, CAthe student's excessive rate of descent during a practice autorotation, and, the inadequate use of the rotorcraft flight controls by both pilots during the attempted recovery, which resulted in a hard landing. The flight instructor's inadequate supervision…NTSB LAX01LA125Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAFailure of the CFI to adequately monitor the flight, which resulted in a low airspeed autorotation and hard landing.NTSB LAX00LA299Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakland, CAThe pilot's improper landing flare.NTSB LAX99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Coalinga, CAThe flight instructor's failure to maintain a sufficient airspeed to compensate for the known wind shear condition, which resulted in a failure to maintain runway alignment and a hard landing. The flight instructor's inadequate supervision of the flight was…NTSB LAX99LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Fresno, CAThe pilot's misjudged landing flare and inadequate recovery procedures from the subsequent bounced landing.NTSB LAX99LA042Accident · No injuriesLimited investigationFinal reportMartin Stoddard Hamilton II · Georgetown, CAThe pilot's improper flare. Also causal was the flight instructor's inadequate supervision.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB LAX98LA160Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Jose, CAThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's inadequate supervision of the flight.NTSB LAX98LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Barbara, CAThe pilot's misjudging the landing flare and subsequent hard landing.NTSB LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.NTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…NTSB LAX97LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAimproper flare by the pilot during the landing, and his improper recovery from a bounced landing, which resulted in a hard landing, dragged wing tip, and a collapsed main gear.NTSB LAX96LA324Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAthe pilot's misjudged landing flare and improper bounced landing recovery. A contributing factor was his lack of recent flying experience.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB LAX96LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Avalon, CAthe pilot's failure to initiate a landing flare, which resulted in a bounced landing and porpoise, and his loss of directional control during an attempt to initiate a go-around with insufficient airspeed, which resulted in an inadvertent stall/mush and…NTSB LAX96LA237Accident · No injuriesLimited investigationFinal reportCessna 172N · Ramona, CAthe pilot's misjudged and delayed landing flare, and inadequate recovery technique from a bounced landing (porpoise). Sun glare was a factor in the accident.NTSB LAX95LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAthe failure of the pilot to properly judge the landing flare, and his improper bounced landing recovery technique, which resulted in a landing gear collapse during a hard landing.NTSB LAX94LA305Accident · No injuriesLimited investigationFinal reportCessna 172N · Cameron Park, CAthe pilot's improper use of the elevator control during the landing flare.NTSB LAX94LA150Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAthe student pilot's improper use of the collective and tail rotor controls, and the flight instructor's inadequate supervision of the flight.NTSB LAX93LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Monica, CAThat the pilot misjudged the flare and failed to properly recover from the ensuing bounced landing. The pilot's failure to attain the proper touchdown point was a factor.NTSB LAX93LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Folsom, CAThe student pilot's excessive rate of descent during a approach for landing, improper remedial action to arrest the rate of descent, and a failure to maintain proper main rotor RPM. The student pilot's lack of total aeronautical experience was a factor in…NTSB LAX92LA238Accident · No injuriesLimited investigationFinal reportCessna 177A · Mariposa, CAThe pilot's poorly planned approach for landing, his failure to initiate a go-around, his failure to obtain the proper touchdown point, his misjudgment of the touchdown flare, and his improper recovery from a bounced landing. A factor in this accident was the…NTSB LAX92LA162Accident · No injuriesLimited investigationFinal reportRobinson R22B · Simi Valley, CAThe instructor pilot's delayed flare from the autorotation landing. A contributing factor was the soft nature of the terrain.NTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.NTSB LAX91LA244Accident · No injuriesLimited investigationFinal reportCessna 172M · Willits, CAThat the pilot misjudged the flare and failed to properly recover from a bounced landing. Contributing to this accident was entering into an inadvertent porpoise.NTSB LAX89LA290Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, CAThe pilot's improper recovery from a bounced landing and loss of directional control.NTSB LAX89LA272Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAThe pilot's improper level-off, recovery from bounced landing, and failure to maintain directional control during the landing. The pilot's limited recent experience was a contributing factor.NTSB LAX89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Petaluma, CADuring a telephone interview, the pilot stated that she was attempting a touch and go landing when the airplane landed hard on its nosewheel. She lost directional control and the airplane collided with a hangar. There were no problems with the nosewheel…NTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…NTSB LAX88LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAAt the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft…NTSB LAX87LA349Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe student pilot, on his first supervised solo flight, executed two full stop landings without incident. On the next landing, the student pilot stated that the aircraft apparently caught a gust of wind and ballooned. He indicated that he over-corrected and…NTSB LAX87LA270Accident · No injuriesLimited investigationFinal reportCessna 172P · Grass Valley, CADuring a pleasure flight, while attempting to land at the airport, the pilot made a go around because he was too high. On the second approach, the pilot noted that he may have been a little high and fast. During the landing the aircraft bounced three times…NTSB LAX87LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Hawthorne, CADuring a solo instructional flight, the student pilot was practicing touch and go landings. He noticed as the flight progressed, that there was some gusting conditions aloft and that the wind direction was varying. On the last landing the aircraft touched…NTSB LAX85LA317Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Piru, CAThe flight instructor instructed the 25-hour student plt to perform an autorotation with a pwr recovery at 20 ft AGL. The instructor became aware too late that the student was 'dead locked' on the controls and he was unable to recover prior to touchdown. A…NTSB LAX84LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe acft landed hard and porpoised down the rwy. The plt made a go-around and reported to the tower that he had control problems. He performed a tower fly-by and no damage was apparent to the controllers. The plt was cleared for landing anddid so without…NTSB LAX83LA356Accident · No injuriesLimited investigationFinal reportCessna 172M · Santa Monica, CAThe plt reported that during the flare the acft began to 'porpoise.' Reportedly, it bounced during the landing, but the plt did not add power to go around or to reland the acft. The acft bounced several times. The nose gear, eng mounts & firewall were bent,…NTSB LAX83FA226Accident · No injuriesField investigationFinal reportRobinson R22 · Torrance, CAThe helicopter was on an FAA certification test flt with a part-time company employee in the left seat as pilot- in-command (PIC). An FAA test plt was in the right seat. The purpose of the flt was to establish new data for the helicopter's height-velocity…