NTSB investigations: Lycoming 0-540 series, WV
13 cases on aircraft whose registry engine model is Lycoming 0-540 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
| 1967 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1979 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 2003 | 1 |
| 2011 | 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 ('41532'))
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 ('41532'))
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 ERA11CA194Accident · No injuriesData collectionFinal reportRobinson R44 · Petersburg, WVThe pilot's failure to maintain control during the takeoff.NTSB NYC03LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Huntington, WVThe pilot's failure to position the fuel selector to a tank with adequate fuel for the flight, which resulted in a power loss due to fuel starvation and the subsequent forced landing.NTSB BFO87FA024Accident · No injuriesField investigationFinal reportCessna R-182 · Martinsburg, WVThe plt stated that he forgot to make a final before lndg check because he was concentrating on traffic and the short lndg he had been requested to make. Twr personnel violated USAF procedures when they requested that the acft hold short of the east-west rwy…NTSB ATL85LA149Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Ravenswood, WVDuring ldg roll the std plt lost directional control of the acft & ran off of the side of the rwy while practicing touch & go ldg with CFI.the CFI stated that the std made a normal approach & upon touchdown the acft made a sharp turn to the right and went off…NTSB ATL83FA290Accident · No injuriesField investigationFinal reportCessna TR 182 · Seneca Rocks, WVThe acft collided with trees and the ground following a reported loss of power. The acft had completed a descent of 2000-3000 ft to observe rock formations and had commenced a climb when power loss occurred. The plt said the mixture wasleft in lean position…NTSB IAD80FA014Accident · 4 fatalClosedPiper PA-32 · Davis, WVNTSB IAD79FIJ05Accident · No injuriesClosedMaule M5-235 · Daybrook, WVNTSB IAD73FIJ22Accident · Serious injuriesClosedPiper PA-32 · Fleminton, WVNTSB IAD71AI051Accident · No injuriesClosedPiper PA-32 · Buckhannon, WVNTSB IAD70D0093Accident · No injuriesClosedPiper PA-24 · Parkersburg, WVNTSB DIA69D0027Accident · No injuriesClosedPiper PA-32 · Ravenswood, WVNTSB DIA68D0074Accident · No injuriesClosedPiper PA-24 · Charleston, WVNTSB DIA67D0092Accident · No injuriesClosedPiper PA-24 · Mullens, WV