NTSB investigations: Lycoming 0-235 series, 1985
12 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\") = 1985
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") = 1985
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 BFO86LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAccording to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear…NTSB LAX85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Modesto, CAThe student plt reptd the final approach angle was too shallow. He added power and as the acft arrived over the threshold he reduced the power. The acft landed hard and bounced. When the acft became airborne the plt added power to execute a go-around. The…NTSB CHI85LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Almont, MIThe student plt stated that during touchdown the acft bounced back into the air. On the second touchdown, the acft swerved to the left and departed the rwy. It then rolled until the left wing struck a small tree, causing substantial damage to that wing. The…NTSB DEN85LQA02Accident · No injuriesFinal reportCessna 152 · Santa Teresa, NMThe helcopter plt was on a solo instructional flt in the Cessna 152 airplane. He had only 9 hrs flt time in fixed wing acft. While on a touch-&-go landing, the acft bounced as it touched down. It then bounced 2 more times with each bounce becoming…NTSB NYC85LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartford, CTThe acft nosed over following a loss of control during landing. The student plt stated the acft bounced three times on touchdown. The propeller then contacted the rwy and the acft nosed over.NTSB SEA85LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Las Vegas, NVDuring a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at…NTSB BFO85LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe plt prefldd the acft iaw a checklist and did not note any abnormalities. Following a normal tkof the plt remained in the traffic pattern, experiencing no complications until touchdown. The winds recorded at bwi were out of 220 degrees at 8 knots. The plt…NTSB FTW85LA208Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student plt was on a local instructional flt practicing solo landings. He stated he made a hard landing and the acft bounced with the nose gear ass'y separating allowing the acft to be substantially damaged. The left wing ass'y received substantial damage.NTSB DEN85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTThe student plt was on his 1st solo flt. His instructor plt reported that the student made a high & fast apch. The acft touched down on its main gear, bounced, then came down on the nose gear which collapsed. After the nose gear collapsed, the acft skidded…NTSB CHI85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, INWhile on a solo training flt the student plt allowed the acft to bounce during touchdown. The acft then became airborne & stalled while several feet above the rwy. During the ensuing hard landing the nose gear strut collapsed & the acft veered to the left…NTSB BFO85LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152-II · Ocean City, MDWhile on a student solo x-country flight, the plt experienced vertical gusting conditions during the second landing pattern, following an initial go-around. Fearing a hard landing due to a severe gust, the plt abruptly applied full back pressure on the stick,…NTSB LAX85LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZAccording to the flt instructor (CFI), the student plt demonstrated 4 good touch-&-go landings while on a dual instructional flt. The CFI decided to solo the student, who did not hold either a medical or student plt certificate. The CFI told the student to…