NTSB investigations: Lycoming 0-320 series, WY
9 cases on aircraft whose registry engine model is Lycoming 0-320 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1998 | 1 |
| 2003 | 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\" = 'WY' 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\" = 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" = 'WY' 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" = 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 DEN07CA151Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Rawlins, WYthe pilot's failure to maintain directional control during landing. A contributing factor to the accident was the crosswind.NTSB DEN07CA032Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Riverton, WYthe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.NTSB DEN03LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kemmerer, WYthe pilot's failure to maintain directional control and his inadequate compensation for wind during the landing roll which resulted in a ground loop/swerve and impact with terrain. Contributing factors include the wind gust and the ditch.NTSB FTW98LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20-160 · Kemmerer, WYThe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. A factor was the pilot's lack of experience in a conventional landing gear type of airplane.NTSB DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…NTSB DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.NTSB DEN87LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenrock, WYThe private plt planned a takeoff from the unimproved ranch rwy for a local flt. Elevator trim was not set for takeoff according to the plt. When the tailwheel came up during the takeoff roll, the acft swerved left, and the plt attempted to correct with…NTSB DEN83LA169Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Cody, WYThe acft groundlooped during landing and damaged the landing gear. The pilot had 80 hours in tailwheel acft but only 1.6IN the accident make and model. The landing was on rwy 22 and the wind was from 130 degrees at 10 to 12 KTS. The plt slipped the acft on…NTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.