NTSB investigations: Lycoming 0-235 series, 1982
20 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 | 20 |
|---|---|
| 1983 | 22 |
| 1984 | 25 |
| 1985 | 12 |
| 1986 | 4 |
| 1987 | 20 |
| 1988 | 14 |
| 1989 | 12 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 7 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 11 |
| 2006 | 7 |
| 2007 | 3 |
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\") = 1982
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 year(c."eventDate") = 1982
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 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 FTW83LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot on her 2nd solo flight failed to flare during landing. A hard landing and improper recovery from bounced landing followed. The aircraft left the runway and nosed over.NTSB FTW83LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Aztec, NMThe aircraft was involved in a hard bouncing landing when the student pilot allowed the aircraft to porpoise during landing. The nose gear failed during this sequence and the aircraft was damaged. The pilot was uninjured. The pilot did not file an accident…NTSB NYC83LA009Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Jamestown, NYThe student pilot was practicing touch-and-go landings on runway 13 with a reported wind from 180 degrees at 15 KTS. He reported that during a landing, he flared too high and bounced. Reportedly, power was applied to go-around, but the plane began to…NTSB CHI83LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNWhile performing a touch-and-go landing, the pilot used a higher than normal speed. After touching down, the aircraft became airborne again, then began to porpoise. After about the 3rd or 4th bounce, the nose gear failed.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 FTW82DA400Accident · No injuriesFinal reportCessna 152 · Dumas, TXDuring the student's first solo takeoff & landing, she was not lined up with the runway & elected to go around. Power was applied & the flaps were fully retracted. The acft immediately dropped to the ground left of the runway.NTSB SEA82DA144Accident · No injuriesFinal reportCessna 152-II · Grants Pass, ORThe instructor pilot stated that the student was having difficulty aligning the aircraft with the runway during the landing approach. As they approached the runway he instructed the student to "get the nose up." At an altitude of approximately three feet, the…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB SEA82DA109Accident · No injuriesFinal reportPiper PA-12 · Eugene, ORThe pilot was high and fast on approach and bounced on the first touchdown. On the second touchdown the aircraft swerved and the left main landing gear collapsed.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 NYC82DA131Accident · Minor injuriesFinal reportCessna A-152 · Millville, NJOn a cross-country instructional flight the student pilot made a hard landing and the gear collapsed.NTSB LAX82DVM14Accident · Serious injuriesFinal reportCessna 152 · San Carlos, CAThe student pilot was practicing short field landings. On final the pilot lowered the nose of the aircraft and leveled the wings, the nose wheel struck the runway callapsing the nose gear.NTSB NYC82DA108Accident · No injuriesFinal reportCessna 152 · Burlington, CTThe student pilot was on her second supervised solo flight. While landing, she flared high and subsequently landed hard, collapsing the nose gear. The pilot reported that she did not have a good mental attitude since her children had been involved in a car…NTSB DEN82DA097Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDDuring landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…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 LAX82DA145Accident · No injuriesFinal reportPiper PA-38-112 · Santa Monica, CADuring landing, the student pilot allowed the aircraft to bounce. After about the third bounce, the nose gear buckled and the aircraft skidded off the runway.NTSB ANC82DA024Accident · No injuriesFinal reportPiper PA-38-112 · Anchorage, AKStudent pilot rounded out too high,aircraft bounced and became airborne. The student did not apply power and the CFI added power for a go-around. However he stated he waited too long before applying power and the right wing stalled. The aircraft veered right…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.