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.
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" 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 CHI00LA313Accident · No injuriesLimited investigationFinal reportCessna 152 · Cumberland, WIthe go-around not performed and the inadequate flare by the pilot.NTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.NTSB 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.NTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.NTSB 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.NTSB MIA99LA275Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Dunnellon, FLThe pilot's improper recovery from a bounced landing.NTSB 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.NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB 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.NTSB 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.NTSB 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.NTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.NTSB 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.NTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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).NTSB CHI96LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNthe student pilot misjudged the landing flare which resulted in the hard landing.NTSB 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.NTSB ATL96LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Waycross, GAThe student pilot's improper flare and recovery from a bounced landing.NTSB 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.NTSB 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.NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB 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.NTSB 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…NTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.NTSB 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.NTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.NTSB 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.NTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.NTSB 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.NTSB 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.NTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.NTSB MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .NTSB 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.NTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.NTSB 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.NTSB 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.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB 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.