NTSB investigations: Lycoming VO-540 series, 1991
8 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
| 1964 | 4 |
|---|---|
| 1965 | 15 |
| 1966 | 16 |
| 1967 | 5 |
| 1968 | 15 |
| 1969 | 10 |
| 1970 | 8 |
| 1971 | 7 |
| 1972 | 6 |
| 1973 | 9 |
| 1974 | 11 |
| 1975 | 14 |
| 1976 | 13 |
| 1977 | 13 |
| 1978 | 22 |
| 1979 | 17 |
| 1980 | 8 |
| 1981 | 14 |
| 1982 | 9 |
| 1983 | 10 |
| 1984 | 9 |
| 1985 | 3 |
| 1986 | 9 |
| 1987 | 8 |
| 1988 | 6 |
| 1989 | 5 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 4 |
| 2008 | 6 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2017 | 1 |
| 2022 | 2 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1991
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 year(c."eventDate") = 1991
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 FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.NTSB LAX91LA388Accident · 1 fatalLimited investigationFinal reportTexas Helicopter M74 · Farmington, CALoss of engine power for an undetermined reason. Factors related to the accident were: the excessive gross weight of the helicopter, and the pilot's improper use of flight controls due to impairment from use of a drug (marijuanna).NTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.NTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.NTSB LAX91LA249Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAThat unknown pilot(s) impoperly used the throttle control which caused an overspeed condition. Contributing to this accident was the connecting rod bolt fatigue failure.NTSB LAX91LA191Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delano, CAThat the pilot improperly performed the autorotation by misjudging the flare altitude. Contributing to this accident was the total failure of the freewheeling sprag clutch due to excessive wear and the soft dirt terrain.NTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.NTSB ANC91LA041Accident · No injuriesLimited investigationFinal reportBell 47 · Thompson Pass, AKThe pilot's failure to maintain aircraft control and improper flare during landing.