NTSB investigations: Lycoming 0-320 series, WV
5 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1991 | 1 |
| 1992 | 1 |
| 2003 | 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.\"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\" = 353))
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."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" = 353))
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 NYC04CA001Accident · No injuriesData collectionFinal reportWilliams RV-4 · Metz, WVThe pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landingNTSB NYC93LA027Accident · No injuriesLimited investigationFinal reportCessna 177 · Morgantown, WVThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing on a highway.NTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.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…