NTSB investigations: Lycoming 0-320 series, TX
43 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 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
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\" = 'TX' 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" = 'TX' 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 DFW08CA041Accident · No injuriesData collectionFinal reportCessna 172P · Bridgeport, TXThe pilot's failure to maintain direction control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.NTSB DFW06CA063Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gail, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/mush.NTSB DFW06CA030Accident · No injuriesData collectionFinal reportCessna 172N · Arlington, TXThe students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.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 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 FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.NTSB FTW03LA045Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Carrizo Springs, TXThe pilot's failure to maintain control of the helicopter after encountering dynamic rollover. A contributing factor was the deer pulling the aircraft unevenly.NTSB FTW02FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Ben Wheeler, TXThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.NTSB FTW00LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ben Wheeler, TXThe pilot's inadvertent stall of the aircraft.NTSB FTW98LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Georgetown, TXinadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.NTSB FTW98LA049Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lubbock, TXfailure of the student pilot to maintain control of the helicopter during hover out-of-ground-effect. A related factor was: the student pilot's lack of experience in flying helicopters.NTSB FTW97LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Austin, TXThe pilot's failure to maintain aircraft control. A factor was the pilot's inadequate compensation for the wind conditions.NTSB FTW97LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor was the pilot's lack of recent experience.NTSB FTW96LA320Accident · 2 fatalLimited investigationFinal reportQualline Hatz CB-1 · Pipe Creek, TXloss of aircraft control in flight for undetermined reason(s).NTSB FTW96LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fredericksburg, TXfailure of the pilot to maintain adequate airspeed during the approach and go-around, which resulted in a stall and subsequent collision with the ground. Factors relating to the accident were: the high, gusty, crosswind conditions, and the pilot's lack of…NTSB FTW95FA380Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Midland, TXthe pilot's selection of a downwind runway for takeoff. Factors were the tailwind, the density altitude, and the overloading of the airplane.NTSB FTW95FA226Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Palestine, TXLoss of aircraft control during a go-around, due to failure of the flight instructor (CFI) to assure that the minimum control speed (VMC) was maintained. Factors relating to the accident were: shutdown of the left engine, which would have prevented normal…NTSB FTW94LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Woodville, TXFailure of the pilot in command to maintain control of the aircraft during an aborted landing.NTSB FTW92FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Breckenridge, TXAn inadvertent stall.NTSB FTW92LA124Accident · No injuriesLimited investigationFinal reportCessna 172M · Canton, TXThe pilot's failure to maintain adequate airspeed and directional control during the attempted go around following an encounter with adverse wind conditions on approach.NTSB FTW92LA049Accident · Minor injuriesLimited investigationFinal reportKinkade E.5 Vans RV-4 · Alpine, TXInadvertent stall.NTSB FTW91LA165Accident · 1 fatalLimited investigationFinal reportPiper PA-28-150 · Van Horn, TXThe pilot's failure to maintain control of the airplane. A factor was the pilot's lack of total experience.NTSB FTW91LA162Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lewisville, TXLoss of control due to foreign object damage induced binding flight controls. A factor was improper maintenance.NTSB FTW91LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Huntsville, TXThe pilot's failure to maintain directional control of the airplane. A factor was the emphasis placed upon full-stall landings by his instructor.NTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…NTSB FTW90LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Amarillo, TXThe loss of aircraft control by the pilot.NTSB FTW88LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXThe student pilot failed to maintain directional yaw axis control of the aircraft during the crosswind take off.NTSB FTW85LA144Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · El Campo, TXAttempting a single-engine take-off, the pilot was unable to maintain VMC or retract the landing gear. He lost control of the aircraft and collided with a tree.NTSB FTW84LA398Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seguin, TXThe acft crashed during the takeoff phase of a touch-&-go landing. The student plt stated that the wind direction and speed had changed at lift-off causing the acft to become airborne then to descend and hit the ground before coming to a stop inverted.NTSB FTW83FA133Accident · 3 fatalField investigationFinal reportCessna 177 · Borger, TXAccording to 2 plt witnesses, the acft stalled during takeoff after it had climbed to aprx 75 to 100 ft AGL. They reported that at that time, it did a wing-over, entered a dive & crashed. Reportedly, the acft was loaded to near its max gross wt limit. The…NTSB FTW82FA402Accident · 1 fatalField investigationFinal reportRobinson R-22 · Paige, TXFollowing completion of the helicopter's annual inspection, the aircraft mechanic/pilot departed clover field in houston for the R22'S home base in austin, TX. One witness observed the helicopter in cruise flight, then saw a large piece separate from the…NTSB FTW82FQD09Accident · 1 fatalFinal reportPiper PA-18A-150 · Sanderson, TXThe pilot was the owner and operator of the aircraft. A search of the FAA airman and medical records revealed no indication of a previous rating. During takeoff, the plane was observed to climb to about 200 to 300 ft AGL, then nose down and crash. There was…