NTSB investigations: Lycoming 0-435, 1986
3 cases on aircraft whose registry engine model is Lycoming 0-435. 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 | 5 |
|---|---|
| 1965 | 2 |
| 1966 | 5 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 3 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 3 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 4 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2016 | 4 |
| 2020 | 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
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 ANC86FA116Accident · 2 fatalField investigationFinal reportStinson 108-2 · Willow, AKAbout 5 to 10 min prior to the acdnt, svrl witnesses in the vicinity of the Willow arpt saw the acft headed southbound. They rprtd the eng was running rough, but they saw no smoke or fire. Aprx 3 mi further south, other witnesses saw the acft make a 180 deg…NTSB DEN86LA180Accident · No injuriesLimited investigationFinal reportMathew M. Kerr Starduster TOO · Roundup, MTDuring the telephone interview, the plt stated the acft landed hard, collapsing the right main gear & broke the right wing spar.NTSB SEA86LA079Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Overton, NVThe noncertificated plt rprtd that he had repaired the helicopter, then proceeded to make a local test flt. He rprtd that he took off in darkness after having a few beers. The plt chose to turn off the landing light shortly after takeoff. While at low…