NTSB investigations: Lycoming 0-320 series, TX
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Overrun”. 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 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 2002 | 1 |
| 2003 | 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\" = '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 ('41508')
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\" = 340))
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 ('41508')
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" = 340))
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 FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.NTSB FTW03LA155Accident · No injuriesLimited investigationFinal reportOMF 100-160 · San Antonio, TXThe pilot's failure to land at the proper touchdown point, which resulted in the overrun of the runway.NTSB FTW02CA249Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Graham, TXthe pilot's failure to attain the proper touchdown point which resulted in a runway overrun.NTSB FTW97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, TXThe pilot's misjudgment of distance and altitude. A contributing factor was a tailwind.NTSB FTW95LA386Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kerrville, TXthe pilot's inadequate preflight preparation and his failure to use all the available runway. A factor was the dark night.NTSB FTW95LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Stephenville, TXThe pilot's failure to execute a go-around. Factors were the excessive airspeed and high glidepath during the approach.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB FTW86LA162Accident · No injuriesLimited investigationFinal reportCessna 172M · Mineola, TXThe inboard brake pads were worn to such a degree that metal to metal contact was occurring. This greatly reduced the aircraft's braking ability. After landing the pilot was unable to stop the aircraft upon the 3225 foot runway. The aircraft ran through a…NTSB FTW84LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe acft ran off the departure end of the rwy during landing, went through a fence on into a street. Tower personnel said the acft landed faster then normal about 1/2 way down the rwy and bounced several times before going through the fence. The plt said he…NTSB FTW84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Shiro, TXThe acft collided with a fence, ditch & trees during a touch-&-go landing on a short grass strip with obstructions at both ends. This was the students 4th solo attempt and according to the owner of the aviation training center touch-&-go landings are not…NTSB FTW83LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Sugarland, TXAfter overshooting his first approach, the plt touched down at midfield & ran off the end of the rwy into a ditch.