NTSB investigations: Lycoming O&VO-360 series, 1985
7 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - in flight”. 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 | 9 |
|---|---|
| 1983 | 7 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 8 |
| 1987 | 4 |
| 1988 | 11 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 10 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 8 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 9 |
| 2002 | 11 |
| 2003 | 16 |
| 2004 | 13 |
| 2005 | 12 |
| 2006 | 7 |
| 2007 | 8 |
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\") = 1985
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\" = 250))
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") = 1985
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" = 250))
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 MIA86LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe plt was attempting a night landing on his first night x-country & had not landed at this aprt prior to this time. He stated that during the flare, he was caught by a x-wind & blown into the trees adjacent to the rwy. Surface winds at the time of the…NTSB NYC86FNE01Accident · No injuriesFinal reportDorfman,William A. Bede 4/275 · Westfield, MAThe aircraft collided with the ground off to the side of the runway during a takeoff attempt. The nose gear and the main gear collapsed during the ground contact. The wind blew the aircraft to the side with a wing raised and before recovery as effected the…NTSB LAX85LA379Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Glendale, AZThe stop at the airport was a planned fuel stop on a flt from conroe, TX to bullhead city, AZ. The flt departed controe,TX about 12 hours prior to the accident. Witnesses saw the acft make two 'high & very erratic' aborted approaches prior to impacting in the…NTSB ANC85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe plt reported sufficient alt could not be obtained to clear trees during takeoff. The acft stalled and the right wing contacted the water resulting in the acft cartwheeling. Investigation revealed the acft was over gross weight and CG was beyond the aft…NTSB ATL85FA242Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Abbeville, SCThe acft crashed into trees & the ground after going into a left turn during a go-around initiated after a bouncy landing. After power was added for the go-around the acft seemed to be uncontrolled so that the CFI on the ground, who had just exited the acft…NTSB NYC85FNA01Accident · Serious injuriesFinal reportGulfstream AA-5B · Boxborough, MAThe pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.NTSB LAX85FA253Accident · 2 fatalField investigationFinal reportCessna 177B · Ojai, CAWitnesses observed the acft enter a box canyon in level flt at an alt below the tops of the surrounding ridges. The eng pwr sounds were reported as 'normal' by the witnesses. Shortly after the acft disappeared behind a ridge, the witnesses saw black smoke…