NTSB investigations: Lycoming VO-540 series, SC
5 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
| 1966 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1993 | 1 |
| 1996 | 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\" = 'SC' 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" = 'SC' 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 ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.NTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.NTSB ATL83LA355Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cameron, SCThe plt stated that he was on a trimming/swath run at about 15 ft AGL & 15 mph when he heard a strange noise which was followed by a 180 deg yaw. Subsequently, the helicopter crash landed, damaging the tail boom & tail rotor blades and spreading the landing…NTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…NTSB MIA66A0122Accident · No injuriesClosedBell 47G-5 · Mcbee, SC