NTSB investigations: Lycoming 0-320 series, VA
15 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 |
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 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\" = 'VA' 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" = 'VA' 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 MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.NTSB NYC02LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Lynchburg, VAThe pilot's failure to maintain control of the airplane, a factor was the tailwind.NTSB NYC01LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmville, VAthe failure of the pilot to maintain directional control.NTSB NYC98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Weyers Cave, VAthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing roll, which resulted in an encounter with a fence on uneven terrain and a nose over.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB BFO89LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe pilot's failure to maintain directional control of the airplane during landing and the failure to achieve sufficient airspeed during the go-around to initiate a climb.NTSB BFO87LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Charlottesville, VAAfter climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft…NTSB BFO87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pungo, VAThe student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to…NTSB BFO87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hillsville, VAAfter touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of…NTSB BFO86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAThe student pilot stated that uneven braking during landing caused the aircraft to swerve off the side of the runway. He further added that he applied full power shortly thereafter due to the fact that the aircraft was heading for a ditch. The aircraft…NTSB ATL84LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Buckingham, VAThe acft bounced and drifted during the landing flare. The plt added power to go-around and was unable to clear the trees near the rwy.NTSB ATL83LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Williamsburg, VAThe aircraft ran off the runway after an aborted takeoff. The pilot stated that he elected to abort the takeoff about half way down the runway after failing to obtain an airspeed indication sufficient for takeoff. After cutting the power and lowering the nose…NTSB ATL83LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nelly'S Ford, VADuring takeoff roll the aircraft swerved to the left. The pilot applied full right rudder but was not able to straighten the aircraft. The pilot reduced the power and applied brakes. The aircraft collided with a fence at the end of the runway. Fifteen knot…