NTSB investigations: Lycoming O&VO-360 series, 1986
6 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 5 |
| 1993 | 3 |
| 1994 | 8 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 1 |
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\" = 230))
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" = 230))
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 CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…NTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.NTSB MIA86LA232Accident · No injuriesLimited investigationFinal reportMooney M20C · Ocala, FLThe plt stated that he put the gear handle down, continued his apch and landed without realizing the gear was still up. Post crash examination of the landing gear retract system revealed that the fuse for the landing gear motor had blown during the extension…NTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…NTSB MIA86LA169Accident · No injuriesLimited investigationFinal reportCessna 172RG · Jackson, MSThe plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell…NTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…