NTSB investigations: Lycoming VO-435 series, 2002
8 cases on aircraft whose registry engine model is Lycoming VO-435 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 | 17 |
|---|---|
| 1965 | 18 |
| 1966 | 15 |
| 1967 | 21 |
| 1968 | 12 |
| 1969 | 16 |
| 1970 | 28 |
| 1971 | 15 |
| 1972 | 20 |
| 1973 | 25 |
| 1974 | 28 |
| 1975 | 24 |
| 1976 | 18 |
| 1977 | 14 |
| 1978 | 27 |
| 1979 | 20 |
| 1980 | 18 |
| 1981 | 16 |
| 1982 | 15 |
| 1983 | 14 |
| 1984 | 14 |
| 1985 | 16 |
| 1986 | 13 |
| 1987 | 10 |
| 1988 | 12 |
| 1989 | 11 |
| 1990 | 6 |
| 1991 | 13 |
| 1992 | 10 |
| 1993 | 8 |
| 1994 | 11 |
| 1995 | 9 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 5 |
| 2002 | 8 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 4 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 6 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2002
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41525'))
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") = 2002
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41525'))
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 ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…NTSB FTW02LA264Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Edmondson, ARThe pilot's failure to maintain clearance from the high voltage power lines.NTSB LAX02LA262Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Oasis, CAthe pilot's failure to maintain an adequate visual lookout and clearance with power lines while maneuvering during an aerial application flight.NTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.NTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.NTSB CHI02LA163Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Jordan, MNThe loss of engine power due to improper maintenance by unknown maintenance personnel which led to a misalignment of the gearbox casing.NTSB MIA02LA101Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Bunnell, FLThe failure of the student pilot to secure the rotorcraft floorboard mounted ballast, resulting in shifting of the ballast on liftoff, and the subsequent dynamic rollover.NTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.