NTSB investigations: Lycoming 0-235 series, FL
29 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 per year
| 1982 | 5 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 2 |
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\" = 'FL' 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 ('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."eventStateOrRegion" = 'FL' 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 ('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 MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.NTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.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 MIA99LA275Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Dunnellon, FLThe pilot's improper recovery from a bounced landing.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 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 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 MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .NTSB MIA93LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLThe pilot in command's improper flare which resulted in the aircraft ballooning during landing, followed by his improper recovery from the ballooned landing which resulted in the aircraft touching down hard on the nose landing gear causing it to collapse.NTSB MIA91LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Marianna, FLThe student pilot's failure to maintain proper airspeed during landing and failure to execute a go-around in a timely manner.NTSB MIA91LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot-in-command's improper flare and recovery from a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB MIA89LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLFailure of the pilot to flare for landing and improper recovery from a bounced landing.NTSB MIA88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLAfter successful completion of 6 dual touch-and-go landings, the student plt departed to perform 3 touch-and-go landings for her first solo flight. The instructor plt stated that the apch to the first landing appeared to be low & after touchdown, the acft…NTSB MIA87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe nose gear collapsed following a hard landing due to the student plts failure to adequately flare the acft.NTSB MIA87LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe student plt failed to flare the aircraft, landed hard, bounced 2-3 times, then landed on the nose gear causing it to collapse.NTSB MIA87LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe plt stated that he was about to conduct his first touch-&-go ldg after a local solo training flt. On the first ldg, he said he made a 'slight bounce' & he leveled the acft & set up for another flare. He said the acft touched down again on the mains but…NTSB MIA85LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Ormond Beach, FLStudent pilot was on first solo flight. Upon touchdown on main gear, the aircraft bounced and came down the second time on its nose gear. Main engine mount was bent.NTSB MIA84LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe pilot stated to the chief of the FAA control tower at Key West int'l arpt after the accident that she 'porpoised' on landing, striking the nose gear and causing it to collapse.NTSB MIA84LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Milton, FLThe acft was obsvd during a touch and go lndg to be high and fast. Aft bouncing on initial touchdown the plt lowered the nose and during the second touchdown the gear collapsed.NTSB MIA84LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe acft nosed over after the nose gear collapsed during a hard landing. The student pilot was making touch and go practice landings. This touchdown was hard and on the nose gear. The weather was VMC but the wind was from 330 degrees at 12 KTS. The landing…NTSB MIA83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Daytona Beach, FLBefore the student plt took off, the winds were reported from 080 to 090 deg at 8 to 9 KTS. After takeoff, he stayed in a closed pattern & made 3 touch-and-go landings. Initially, he used 30 deg of flaps for landing. However, he noted varying x-wind…NTSB MIA83LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, FLThe student was practicing touch and go landings. On the second landing the aircraft landed hard in a nose first attitude. The nose gear collapsed.NTSB MIA83LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe student pilot was practicing touch-and-go landings. According to him, the nose gear collapsed as he lowered the nose on his third landing. The propeller struck the runway surface and the plane veered to the left. After departing the left side of the…NTSB MIA82DA142Accident · No injuriesFinal reportPiper PA-38-112 · West Palm Beach, FLWhile landing, the aircraft was observed to bounce several times. It then veered to the right, went into an area of grass, and nosed over. No malfunctions or failures were reported by either the pilot or the owner.NTSB MIA82DA107Accident · No injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot reported that she landed with 30 degrees of flaps on runway 23. She reported that the wind was gusting from 15 to 20 knots and the wind sock seemed to fluctuate from westerly to northwesterly. The pilot related that the aircraftbounced twice upon…NTSB MIA82DA054Accident · No injuriesFinal reportCessna 152 · St. Petersburg, FLThe student pilot was on her first supervised solo flight. During the second landing the aircraft bounced and while attempting to recover the pilot first added power then cut it. The aircraft dropped down on its nose and the nose gear collapsed.