NTSB investigations: Lycoming 0-320 series, 1987
21 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 26 |
|---|---|
| 1983 | 23 |
| 1984 | 32 |
| 1985 | 24 |
| 1986 | 24 |
| 1987 | 21 |
| 1988 | 14 |
| 1989 | 20 |
| 1990 | 21 |
| 1991 | 21 |
| 1992 | 19 |
| 1993 | 16 |
| 1994 | 15 |
| 1995 | 15 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 25 |
| 1999 | 18 |
| 2000 | 14 |
| 2001 | 10 |
| 2002 | 19 |
| 2003 | 15 |
| 2004 | 17 |
| 2005 | 12 |
| 2006 | 11 |
| 2007 | 9 |
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\") = 1987
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\" = 353))
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") = 1987
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" = 353))
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 NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…NTSB MKC88LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Sweet Springs, MODuring a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…NTSB LAX88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casa Grande, AZDuring an instructional flt, the student was performing climbs, descents and turns when the engine sputtered and lost power. The flight instructor took control of the aircraft but was unable to restart the engine. The aircraft was landed on a dirt road where…NTSB BFO88LA004Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Front Royal, VAWhile flying at abt 2000 ft AGL, the plt noticed a change in eng sound. The tach indcn dropped below 1000 RPM & the suction gauge went below the green arc. During a subsequent emerg lndg, the nose & left main gear collapsed in soft terrain. No preimpact part…NTSB ANC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe engine stopped producing power but continued to windmill. The pilot was able to glide to a gravel bar and intentionally groundlooped to avoid hitting obstructions. The pilot stated he believed the aircraft ran out of fuel.NTSB ANC87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tanana, AKThe pilot stated that he just lifted off the lake when the engine quit. The aircraft stalled and crashed into the lake. The pilot stated that he just ran out of fuel.NTSB ANC87LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Merrill Pass, AKThe aircraft engine failed in cruise flight. During the landing roll the airplane struck a ditch and nosed over. Examination of the aircraft and the statements from the pilot, revealed the aircraft ran out of fuel during the return trip to the airport.NTSB ATL87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Eubank, KYThe plt reptd that he was planning a refuel stop at short airport near Eubank, KY. Short is a private strip and the owner stated that he did not have fuel available. The pilot reptd that when he was about five minutes away, the engine 'quit and he was unable…NTSB DEN87LA169Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Red Lodge, MTThe plt stated that shortly after takeoff he intended to switch fuel to fullest tank but inadvertently put the fuel selector on off position. The engine failed. He did not have enough altitude or time to correct the situation and had to make a forced landing…NTSB NYC87LA194Accident · Serious injuriesLimited investigationFinal reportChampion 7GCB · Sullivan, NHThe pilot of the float equipped citabria 7GCBC experienced a power loss when he added power and raised his nose for a cruise climb from 3500 ft. he set up for a forced landing in a pond. As he neared touchdown, the engine regained power and responded to the…NTSB NYC87LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Block Island, RIThe plt rprtd that drg takeoff, the eng lost power. Subsequently, the acft crashed into an area of brush on level terrain about 1/2 mi off the departure end of the rwy. The operator rprtd that in a conversation with the plt, the plt indicated that he had…NTSB MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…NTSB FTW87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Aransas, TXThe engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a…NTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…NTSB FTW87LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Jackson, LAEngine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.NTSB FTW87FA087Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Leakey, TXFlight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately…NTSB MIA87FA114Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.NTSB MIA87LA087Accident · No injuriesLimited investigationFinal reportCessna 172 M · San Juan, PRThe instructor plt stated that the flt was over San Juan bay aprx 2.5-3 miles from the arpt at aprx 700 feet when the eng began to run rough. The eng then quit. However it restarted momentarily. Realizing the flt would not reach the arpt the acft was then…