NTSB investigations: Lycoming O&VO-360 series, 1986
3 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight encounter with weather”. 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 | 8 |
|---|---|
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 6 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest 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 ('41514')
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\" = 240))
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 ('41514')
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" = 240))
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 DEN87FA008Accident · 1 fatalField investigationFinal reportMooney M20B · Buffalo, WYAt aprx 1720 MDT, tower psnl at the dep arpt received a phone call from the plt. He said he wished to depart with an inop 2-WAY radio. He was advised that IMC prevailed & that a radio would be required to depart with an IFR or special VFR clnc. At 1907 (after…NTSB MIA86FA218Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Steinhatchee, FLOn 7/23/86, ARTCC lost radar & radio contact with the acft while the plt was in lvl flt at 6000 ft in an area of lvl 3 & 4 thunderstorms (tstms). Two days later, the left wing panel & the tips of the horizontal stabilators were fnd in the vicinity of where…NTSB LAX86FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CADrg arrival at an arpt near his home, the plt contacted apch control (ctl) & asked the ctlr for assistance in landing & said that the wx looked a little foggy. The ctlr informed the plt of the acft's position in relation to the arpt. As the acft was dscndg…