NTSB investigations: Lycoming VO-540 series, WA
16 cases on aircraft whose registry engine model is Lycoming VO-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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2010 | 1 |
| 2022 | 1 |
| 2025 | 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\" = 'WA' 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 ('41534', '41582'))
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" = 'WA' 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 ('41534', '41582'))
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 WPR25LA246Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Fobes Hill, WAThe pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.NTSB WPR22LA245Accident · Serious injuriesClass 4 · LimitedFinal reportHiller UH-12E · Wenatchee, WAThe pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.NTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.NTSB SEA99LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Wenatchee, WAFuel exhaustion due to the pilot's failure to accomplish refueling.NTSB SEA99FA013Accident · 1 fatalField investigationFinal reportHiller UH-12E · Marshall, WAThe loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.NTSB SEA97LA191Accident · Minor injuriesLimited investigationFinal reportBell 47G · Wellpinit, WAThe pilot's selection of an unsuitable landing site, and his failure to maintain rotor blade clearance from terrain during landing.NTSB SEA96LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12 · Walla Walla, WAthe pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…NTSB SEA93LA181Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Auburn, WAFailure of the connecting rod bolt. The high vegetation was a factor.NTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WANTSB SEA78DYE37Accident · Minor injuriesClosedHiller Acft UH-12E · Amanda Park, WANTSB SEA77DYE04Accident · Minor injuriesClosedHiller Acft UH-12E · Neilton, WANTSB SEA7LDYE16Accident · No injuriesClosedHiller Acft UH-12E · Randle, WANTSB SEA74AS030Accident · 1 fatalClosedBell 47G-4A · Wapato, WANTSB SEA72FYE03Accident · 1 fatalClosedHiller 12E · Skykomish, WANTSB SEA65A0039Accident · No injuriesClosedHiller UH12E · Centerville, WANTSB UNK64X1354Accident · No injuriesClosedHiller 12E · Pomeroy, WA