NTSB investigations: Lycoming 0-235 series, TX
14 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 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 'TX' 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" = 'TX' 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 DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB FTW00LA238Accident · No injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe student pilot's delayed landing flare and failure to recover from the ensuing 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 FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW84LA320Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe acft nosed down after a bounced landing. The student plt had 1 hour PIC total. She said the acft ballooned and bounced during landing. She said she should have added power during the ballooning to reflare or completed a go-around.NTSB FTW84LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXDuring a touch-&-go landing, the acft bounced back in teh air after touching down. At that time, the sudent plt reacted by pushing forward on the control yoke. The acft then impacted, nose down, & the nose gear collapsed.NTSB FTW83LA427Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student plt's apch to land was high & he extended 20 deg of flaps & retarded the power to idle. Realizing he was about to land too long, he initiated a go-around. He applied power & retracted the flaps to full up. The student stated that the acft began…NTSB FTW83LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Tyler, TXWhile making a short field approach, the acft touched down hard & the nose gear failed.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 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.