NTSB investigations: Lycoming VO-540 series, AZ
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
| 1965 | 2 |
|---|---|
| 1968 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 2008 | 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\" = 'AZ' 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" = 'AZ' 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 WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.NTSB LAX90DUJ03Accident · Serious injuriesFinal reportHiller UH-12E · Yuma, AZThe pilot misjudged the flare altitude. Contributing to this accident was the failure of the engine torsional coupling which ultimately caused the total loss of power.NTSB LAX89DUJ09Accident · Minor injuriesFinal reportHiller UH-12E · Tolleson, AZAn engine failure due to water contamination in the fuel supply which preceded an autorotation and collision with the ground during night time conditions.NTSB LAX87DUJ11Accident · Minor injuriesFinal reportHiller UH-12E · Scottsdale, AZDuring an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle…NTSB LAX84LA494Accident · Serious injuriesLimited investigationFinal reportHiller UH12ET · Yuma, AZThe pilot stated that he was carrying a load of pesticide for application on a broccoli field. The aircraft was in level flight, approximately 4 to 8 feet AGL when it became uncontrollable and impacted the ground. The aircraft was consumed by a post crash…NTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.NTSB LAX80DUJ91Accident · No injuriesClosedHiller Acft UH-12E · Sommerton, AZNTSB LAX79DUJ36Accident · No injuriesClosedHiller UH12E · Yuma, AZNTSB LAX79DUJ04Accident · Minor injuriesClosedHiller UH-12E · Queen Creek, AZNTSB LAX77DUJ82Accident · No injuriesClosedHiller Acft UH-12E · Yuma, AZNTSB LAX77DUJ42Accident · No injuriesClosedBell 47J-2A · Kingman, AZNTSB LAX76DUJ80Accident · No injuriesClosedHiller Acft UH-12E · Somerton, AZNTSB LAX72AL018Accident · Minor injuriesClosedHiller Acft UH12L4 · Grnd Canyon, AZNTSB LAX68A0080Accident · Minor injuriesClosedHiller UN-12L · Windna, AZNTSB DEN65A0066Accident · No injuriesClosedHiller UH12E · Ne Bouse, AZNTSB DEN65A0065Accident · Minor injuriesClosedBell 47G3B1 · Payson, AZ