NTSB investigations: Lycoming VO-540 series
9 cases on aircraft whose registry engine model is Lycoming VO-540 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 2 |
| 2001 | 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\" = 230))
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" = 230))
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 FTW03CA146Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Robinson, TXThe pilot's failure to maintain clearance with the ground while performing a quick stop maneuver which resulted in a dynamic rollover.NTSB LAX01LA196Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Buttonwillow, CAThe pilot's inadequate in-flight planning that resulted in settling with power during an aerial application turn-to-reverse direction and collision with the ground. Factors were high density altitude and a wind shift.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 SEA97LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Idaho Falls, IDThe pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.NTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.NTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.NTSB LAX84FA130Accident · 1 fatalField investigationFinal reportBell 47J-2 · Kahuku, HIAbout 3 min after takeoff, the helicopter was observed descending in a 'gliding fashion' until water impact. A witness reported that it appeared to be flying straight & did not appear to be in trouble. The witness reported that she could hear the eng & it…NTSB ATL83LA379Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Wise, VAThe plt held a commercial certificate, but was a student in helicopter flying. He had over 15,000 hrs total time in airplanes, but only aprx 13 hrs of experience in helicopters. On his 1st solo flt in a helicopter, he was making approaches to a grassy area…NTSB MIA82DA133Accident · No injuriesFinal reportBell 47G-4 · N. Greenville, FLThe pilot took off at about 1922 to dispense a non-toxic liquid chemical and fertilizer on a nearby melon field. After one normal swath run on a northerly heading, he pulled up and began a procedure turn to the left (west). He stated the afternoon sun…