NTSB investigations: Lycoming VO-435 series, 1976
18 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\") = 1976
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") = 1976
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 MIA77FKT05Accident · No injuriesClosedHiller UH-12D · Lake Worth, FLNTSB IAD77FLJ02Accident · No injuriesClosedHiller UH-12D · Morrisville, NCNTSB LAX77DVA02Accident · No injuriesClosedEL Tomcat MK5A · Wasco, CANTSB LAX76FUA32Accident · Minor injuriesClosedBell 47G · San Pedro, CANTSB FTW76DPJ49Accident · Minor injuriesClosedBell 47G-2 · Elgin, OKNTSB SEA76DYC66Accident · No injuriesClosedBell 47G3B2 · Vancouver, WANTSB FTW76DRG70Accident · No injuriesClosedBell 47G-2 · Mcallen, TXNTSB FTW76FPG82Accident · Serious injuriesClosedQuinn MK-5A · Corning, ARNTSB NYC76FFJ26Accident · No injuriesClosedBell 47G-2 · Wayland, NYNTSB MKC76FCJ41Accident · Minor injuriesClosedHiller Acft UH-12D · North Platte, NENTSB CHI76FEC47Accident · Minor injuriesClosedEL Tomcat MK-5A · Blissfield, MINTSB FTW76FRD52Accident · No injuriesClosedBell 47G-5 · Walker, LANTSB SEA76FYG53Accident · Minor injuriesClosedBell 47G-2 · Eltopia, WANTSB CHI76FEA35Accident · Minor injuriesClosedBell 47G-2 · Monticello, INNTSB OAK76DVD36Accident · No injuriesClosedBell 47G-5 · Cloverdale, CANTSB MKC76FCJ32Accident · No injuriesClosedBell 47G-5 · Geneva, NENTSB MIA76FKT61Accident · Minor injuriesClosedHiller UH-12D · Miami, FLNTSB IAD76DID20Accident · No injuriesClosedBell 47G-2 · Chesapeake, VA