NTSB investigations: Lycoming VO-540 series
13 cases on aircraft whose registry engine model is Lycoming VO-540 series, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 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.\"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\" = 250))
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" = 250))
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 LAX03LA197Accident · 1 fatalLimited investigationFinal reportBell 47-G4 · Porterville, CAloss of control for undetermined reasons.NTSB FTW02LA186Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Grand Lake, LAthe pilot's inability to control the helicopter in a hover due to the restricted movement of the cyclic for undetermined reasons.NTSB CHI01LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hastings, NEAircraft control not being maintained by the pilot which resulted in the encountered settling with power flight condition during the initial climb. Factors to the accident were the reported variable winds during the takeoff and the corn crop.NTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.NTSB FTW98LA030Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Welsh, LAthe pilot's failure to maintain control of the helicopter, while maneuvering to avoid an obstruction. The abrupt maneuver was a related factor.NTSB FTW96LA005Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Edinburg, TXthe pilot's improper takeoff planning which resulted in the loss of conrol. A factor was the gusty crosswind condition.NTSB FTW95LA105Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · El Indio, TXThe loss of tail rotor effectiveness. A factor was the gusty right quartering tailwind.NTSB LAX92LA396Accident · Minor injuriesLimited investigationFinal reportBell 47-G4A · Volcano, HIThe pilot's improper use of the collective control after inadvertently entering a power settling condition.NTSB FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.NTSB LAX88DVA16Accident · Minor injuriesFinal reportHiller UH-12E · Helm, CADuring an aerial application flight, the pilot lost control of the helicopter just after liftoff and collided with the terrain. Inspection of the wreckage revealed that the chemical trucks filler hose was still attached to the helicopter when it lifted off.NTSB DEN85LTG06Accident · No injuriesFinal reportBell 47G-4A · Minot, NDThe plt was engaged by a deputy sheriff to fly the helicopter about 2-1/2 mi to the Minot intl arpt for impoundment. During takeoff, it began climbing, then the plt lost control & the helicopter entered a descent & crashed. Initial impact occurred about 35 ft…NTSB DEN84LA177Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Granby, COThe helicopter plt was on a reconnaissance flt to survey a hilltop landing site in mountainous terrain. When he arrived, he made a high reconnaissance pass, then began a low reconnaissance apch. He estimated the wind was from 210 deg at 10 to 15 KTS with…NTSB LAX84LA010Accident · No injuriesLimited investigationFinal reportHiller UH12E · Los Banos, CAThe plt loaded the helicopter & started a spraying operation. He stated that as he pulled the helicopter up from the 1st spray run, it started shaking & went partially out of control. He was able to regain enough control to get the helicopter in level flt…