NTSB investigations: Lycoming VO-540 series
17 cases on aircraft whose registry engine model is Lycoming VO-540 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41534', '41582')
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\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41534', '41582')
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" = 220))
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 LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.NTSB LAX03CA284Accident · No injuriesData collectionFinal reportHiller UH12E · Kekaha, HIthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB NYC02LA090Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Blairstown, NJThe pilot's improper flare, and his failure to maintain obstacle clearance which resulted in a tail strike.NTSB LAX01LA276Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Strathmore, CAThe pilot's inadequate visual lookout while maneuvering during an aerial application flight.NTSB LAX00LA107Accident · Minor injuriesLimited investigationFinal reportHiller H-12E · Byron, CAThe pilot's inadequate visual lookout while maneuvering in proximity to wires. A contributing factor was the sun glare, which reduced the wire's conspicuity.NTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.NTSB LAX00LA027Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Castroville, CAThe pilot's inadequate visual lookout and diverted attention.NTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.NTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.NTSB LAX93LA166Accident · 1 fatalLimited investigationFinal reportBell 47G2A · Pacific Ocean (Pacific Ocean)The passenger's failure to adhere to the pilot's instructions. Factors which contributed to the accident were: the language/communications difficulty between the pilot & the passenger, and the bird strike.NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…NTSB FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.NTSB NYC84LA212Accident · No injuriesLimited investigationFinal reportHiller 12E · Meadville, PAThe acft flew into wires during a crop spraying mission. The acft was flying at about 5-10 ft when a flash was seen overhead. The acft vibrated and slowed before impacting the ground and rolling over.NTSB LAX83FA087Accident · Minor injuriesField investigationFinal reportBell 47G4 · Five Points, CAThe pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.NTSB ATL82DA214Accident · No injuriesFinal reportHiller UH-12E · Centre, ALWhile returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing.NTSB LAX82DVA14Accident · Serious injuriesFinal reportHiller UH-12E · Chowchilla, CAThe pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer…