NTSB investigations: Lycoming 0-320 series, 1997
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\") = 1997
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") = 1997
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 NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.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 CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.NTSB FTW98LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Folsum, NMthe pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.NTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.NTSB SEA97LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Dixie, IDShifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.NTSB FTW97FA348Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Telluride, COfailure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…NTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.NTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB CHI97LA269Accident · No injuriesLimited investigationFinal reportCessna 177 · Maple Lake, MNthe pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB NYC97LA156Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WVThe student pilot's improper recovery from a bounced landing.NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.NTSB CHI97LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Ottumwa, IAthe improper flare performed by the student and the inadequate recovery from the bounced landing. A factor related to the accident was the student lack of experience.NTSB ATL97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during the landing, which resulted in a collision with a runway marker. The rear-quartering tailwind (crosswind) and gusts were related factors.NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB FTW97FA221Accident · 2 fatalField investigationFinal reportCessna 172N · Greenbrier, ARThe pilot's failure to maintain aircraft control during a low altitude maneuver. Factors were the pilot's lack of total experience in the type of operation and inadequate training by the company management.NTSB NYC97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Morristown, NJThe flight instructor's inadequate supervision which allowed the student to solo at night with less than one hour of night instruction with a known inoperative landing and taxi light. A Factor was the student pilot's spatial disorientation which resulted in…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 NYC97LA087Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Salem, OHthe pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.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 ANC97LA054Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Manokotak, AKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall of the airplane. A factor associated with the accident was the pilot's performance of a low altitude flight maneuver.NTSB MIA97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · St Matthews, SCthe pilot's improper decision to take off downwind with gusty wind conditions.NTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.NTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.NTSB NYC97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, MEthe pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…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 ANC97FA026Accident · 1 fatalField investigationFinal reportPiper PA-18 · Circle, AKinadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…NTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.