NTSB investigations: Lycoming 0-320 series, 1986
13 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 24 |
|---|---|
| 1983 | 9 |
| 1984 | 11 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 13 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 7 |
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 ('41508')
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 ('41508')
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 DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.NTSB NYC87FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glen Mawr, PADrg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.…NTSB FTW87LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pollok, TXThe dual student was receiving emergency landing training. Power was reduced while on approach which resulted in a loss of airspeed and a high sink rate. Corrective action was initiated too late and the aircraft touched down a few feet short. The landing gear…NTSB ANC87LA002Accident · No injuriesLimited investigationFinal reportTeal TSC-1A2 · Lewis River, AKThe plt stated that he landed the amphibious acft on the Lewis River with the gear in the extended position. Shortly after touchdown, the acft nosed over on its top. FAA records showed the plt had a total flying time of aprx 710 hrs.NTSB ANC86FA167Accident · 2 fatalField investigationFinal reportPiper PA-18 · Port Alsworth, AKUndetermined.NTSB SEA86LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Preston, IDThe jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged.NTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…NTSB MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…NTSB LAX86LA271Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Upland, CAThe plt stated that he was practicing single engine procedures and he forgot to lower the landing gear. Another plt alerted him on the radio and he attempted to lower the gear but landed with the gear only partially extended. The plt stated that he chose to…NTSB ATL86FA120Accident · 4 fatalField investigationFinal reportPiper PA-28-160 · Winton, NCBefore the flt, the student plt & passengers had been socializing & drinking beer. At aprx 0200 EDT, while at a friend'shome near murfreesboro, NC, they decided to go flying. At about 0300, an acft was observed to fly over the friend's home at low alt, then…NTSB LAX86LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe plt misjudged the flare during landing and the acft touched down in a nose low attitude shearing the nose gear from the acft. The density altitude was calculated to be 3,500 ft when the accident occurred.NTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.