NTSB investigations: Lycoming O&VO-360 series, TX
11 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 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 ('41514')
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\" = 260))
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 ('41514')
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" = 260))
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 DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.NTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.NTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB FTW99LA210Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Whitewright, TXThe pilot's failure to maintain directional control of the airplane.NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.NTSB FTW92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB FTW87LA053Accident · No injuriesLimited investigationFinal reportBellanca Scout · Boyd, TXA private pilot landed on his private strip made of soft sandy soil, the aircraft ground looped breaking the left main gear 'u' bolt and center bolt. The aircraft's left wing contacted the ground causing substantial damage when the aircraft rolled over on its…NTSB FTW86LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Vernon, TXThe pilot reported landing at above normal speed, when he lost control of the aircraft at touchdown. The aircraft then veered off the runway onto wet grass. Do to the slippery conditions, the aircraft began sliding until it collided with a fence 100 feet from…NTSB FTW84LA387Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wharton, TXAfter landing on rwy 14 the plt did a 180 deg turn and taxied back down the rwy. While attempting to turn right onto the taxiway the left main gear departing the improved surface and collapsed when it struck a concrete culvert. Brake skid marks were found on…NTSB FTW84LA357Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXDue to acft parked in close proximity to the right side of the narrow (25 ft) runway and a crosswind from the left, the plt favored the left side of the runway on landing line-up. During the landing roll, he was unable to arrest a left drift before the acft…