NTSB investigations: Lycoming 0-235 series

251 cases on aircraft whose registry engine model is Lycoming 0-235 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, newest first

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
      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.

NTSB CHI00LA313Accident · No injuriesLimited investigationFinal reportCessna 152 · Cumberland, WIthe go-around not performed and the inadequate flare by the pilot.Aug 18, 2000 · N5354M · Substantial damageNTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.Jul 3, 2000 · N48858 · Substantial damageNTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.Jul 2, 2000 · N6432M · Substantial damageNTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.Feb 7, 2000 · N69174 · Substantial damageNTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.Dec 5, 1999 · N49328 · Substantial damageNTSB CHI00LA005Accident · No injuriesLimited investigationFinal reportZenair CH 2000 · St. Louis, MOthe student pilot misjudged the landing flare which resulted in a hard landing. A factor associated with the accident was the student's lack of total experience.Oct 6, 1999 · N25ZA · Substantial damageNTSB MIA99LA275Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Dunnellon, FLThe pilot's improper recovery from a bounced landing.Sep 28, 1999 · N9908L · Substantial damageNTSB FTW99LA264Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXThe pilot's hard landing as result of his improper landing flare and his improper recovery from a bounced landing. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.Sep 22, 1999 · N5093Q · Substantial damageNTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damageNTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.Aug 18, 1999 · N869NE · Substantial damageNTSB MIA99LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Ocala, FLA misjudged flare and the failure of the student pilot to use the proper recovery technique for a bounced landing, allowing the airplane to commence a porpoise, and the eventual collapse of the nose landing gear.Aug 17, 1999 · N5416M · Substantial damageNTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.Dec 27, 1998 · N5527L · Substantial damageNTSB IAD98LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, CTThe pilot's improper flare and inadequate recovery from a bounced landing. A factor was the pilot's lack of experience.Sep 26, 1998 · N89644 · Substantial damageNTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.Sep 25, 1998 · N94784 · Substantial damageNTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Aug 3, 1998 · N93116 · Substantial damageNTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.Feb 28, 1998 · N25275 · Substantial damageNTSB MIA98LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLthe pilot's inadequate compensation for wind conditions and failure to properly flare the airplane, which resulted in a hard landing and overload failure of the nose gear. The unfavorable wind conditions were related factors.Jan 2, 1998 · N757VT · Substantial damageNTSB IAD98LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJthe pilot's improper flare during touchdown, which resulted in a hard landing and subsequent encounter with terrain.Oct 26, 1997 · N4950A · Substantial damageNTSB FTW98LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent collapse of the nose gear.Oct 18, 1997 · N93116 · Substantial damageNTSB LAX97LA309Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Imperial, CAThe pilot's failure to maintain directional control during landing and to arrest porpoising after an improper recovery from a bounced landing. Factors in the accident were the misjudging of distance and speed during a downwind landing.Aug 31, 1997 · N65273 · Substantial damageNTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.Jun 21, 1997 · N7506F · Substantial damageNTSB CHI97LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Crystal, MNthe student pilot's misjudged flare and improper recovery from a bounced landing. A factor was the lack of recent flight time.May 24, 1997 · N5499B · Substantial damageNTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.Apr 20, 1997 · N2477K · Substantial damageNTSB ANC97LA034Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Iliamna, AKfailure of the pilot to maintain adequate airspeed during the flare, which resulted in a hard landing.Mar 13, 1997 · N5326H · Substantial damageNTSB NYC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the pilot's failure to perform a go-around.Jan 12, 1997 · N48693 · Substantial damageNTSB ATL97LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GApremature flare by the dual student, and his improper remedial action to correct the flare; and inadequate supervision by the flight instructor (CFI).Oct 25, 1996 · N757CU · Substantial damageNTSB CHI96LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNthe student pilot misjudged the landing flare which resulted in the hard landing.Sep 17, 1996 · N757PC · Substantial damageNTSB MIA96LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student pilot's improper recovery from a bounced landing, resulting in a loss of directional control, collapse of the nose gear, and subsequent nose down on the runway.Sep 3, 1996 · N93102 · Substantial damageNTSB ATL96LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Waycross, GAThe student pilot's improper flare and recovery from a bounced landing.Aug 24, 1996 · N4982A · Substantial damageNTSB FTW96LA277Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Providence, LAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise motion of the airplane and subsequent damage.Jun 27, 1996 · N93526 · Substantial damageNTSB CHI96LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIthe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. Factors associated with the accident were the misjudged landing flare and the raised taxiway edge which the airplane contacted.May 30, 1996 · N49459 · Substantial damageNTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.May 3, 1996 · N2364N · Substantial damageNTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.Apr 23, 1996 · N2537D · Substantial damageNTSB ATL96LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAthe pilot's improper flare, which resulted in a hard landing, a collapsed nose gear, and a subsequent nose over.Mar 12, 1996 · N105AT · Substantial damageNTSB LAX96LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVthe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the flight instructor's inadequate instruction concerning recovery from…Mar 7, 1996 · N5531M · Substantial damageNTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.Aug 23, 1995 · N94891 · Substantial damageNTSB FTW95LA324Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Raton, NMThe pilot's inadvertent activation of the flaps. Factors in the accident were the weather conditions and the dark night.Jul 29, 1995 · N49209 · Substantial damageNTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.May 14, 1995 · N67492 · Substantial damageNTSB CHI95LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot misjudged the landing flare. Factors related to the accident were the dark light conditions and the pilot's lack of visual cues for the runway environment.Apr 7, 1995 · N757UV · Substantial damageNTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.Mar 24, 1995 · N23680 · Substantial damageNTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.Mar 11, 1995 · N89359 · Substantial damageNTSB LAX95LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · La Verne, CAthe student pilot's poor recovery from a bounced landing and improper use of the elevator control. The lack of total experience is a factor in this accident.Oct 27, 1994 · N64851 · Substantial damageNTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.Jul 12, 1994 · N5351L · Substantial damageNTSB MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .Jun 11, 1994 · N46140 · Substantial damageNTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.Mar 25, 1994 · N89761 · Substantial damageNTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.Mar 17, 1994 · N2MS · Substantial damageNTSB LAX94LA088Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B-TR2 · Riverside, CAThe pilot's improper recovery from a bounced landing. A factor related to the accident was: the pilot's improper flare for landing.Dec 31, 1993 · N1413R · DestroyedNTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.Nov 19, 1993 · N5312L · Substantial damageNTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.Aug 21, 1993 · N6596P · Substantial damageNTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.Aug 8, 1993 · N25211 · Substantial damage