Fatal NTSB investigations: Lycoming 0-320 series, WV
8 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1999 | 2 |
| 2016 | 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\" = 'WV' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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'))
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" = 'WV' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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'))
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 ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.NTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.NTSB NYC99LA116Accident · 1 fatalLimited investigationFinal reportNations Acro Sport II · Pence Springs, WVThe student pilot's improper decision to perform aerobatics, and his failure to maintain aircraft control, which resulted in an inadvertent spin. A factor in the accident was the pilot's lack of aerobatic experience.NTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.NTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…NTSB ATL86FA002Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Hurricane, WVN9629U crashed in a wooded area near Hurricane, west Virginia while conducting a visual flight from millwood, WV to grundy, Virginia. The pilot and aircraft were certificated in accordance with current FARS. The pilot received a weather briefing for the…NTSB ATL85FA070Accident · 1 fatalField investigationFinal reportRobinson R22 · Moundsville, WVThe helicopter crashed aprx 1/2 mi from the marshall county arpt while on a personal flt. Investigaton revealed that the plt, a doctor who specialized in emergency room procedures, commuted between hospitals located in three different cities. The plt had been…NTSB ATL84FA107Accident · 2 fatalField investigationFinal reportPiper PA-23 · Bluefield, WVWhile cruising on an IFR flt at 10,000 ft, the plt informed atlanta center that he had an eng problem & was declaring an emergency. He was provided a heading to the Bluefield arpt which was nearby. When asked about the problem, he said the left eng was…