NTSB investigations: Lycoming 0-320 series, 1982
24 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\") = 1982
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") = 1982
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 LAX83LVW02Accident · No injuriesFinal reportPiper PA-28-161 · Beatty, NVThe pilot landed on a 1700 long strip at the elevation of about 3500 ft MSL. He elected to takeoff to the north in calm wind conditions and avoid sun glare off the cover of his engine and on the windshield. He stated that soft field procedures were used in…NTSB ATL83LA038Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Clinton, MDThe pilot was on final approach behind a Cessna 150 and thought the Cessna would turn off at the first taxiway. The Cessna continued to the second taxiway and the pilot of N5442L elected to go-around. The pilot stated the aircraft seemed to mush as it flew…NTSB FTW83FRA01Accident · 3 fatalFinal reportPiper PA-28-140 · Woodville, TXAt about 2310 CDT, the owner/pilot and two other persons took off from the tyler county airport at Woodville, TX. About 15 minutes later, the plane crashed at the intersection of the runway (16/34) and a perpendicular taxiway. Impact and propeller strike…NTSB NYC83LA006Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, PAReportedly, the pilot made his landing approach too high and too fast. After rolling an undetermined distance, he elected to go-around. According to the passenger, the pilot had started a climb when he banked the aircraft and retracted the flaps. Reportedly,…NTSB ANC83LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Near King Salmo, AKAccording to the pilot, he began taking off with a right quartering headwind. As the plane lifted off, a gust of wind was encountered and the aircraft moved sideward and down. Subsequently, the right main gear contacted the ground and separated. The nose then…NTSB ANC83FAA03Accident · No injuriesFinal reportPiper PA-18 · 27 E Sagwon, AKThe plt was inspecting a landing site for possible use. A low pass was being made at approximately 3 ft when the acft encountered a downdraft & impacted a rocky ridge area short of the site.NTSB NYC82DA229Accident · No injuriesFinal reportPiper PA-30F · Dubois, PAThe pilot stated that shortly after takeoff the radio master circuit breaker tripped. He repositioned the switch but it tripped again. As the flight returned to the airport the landing gear and flap trim failed to respond. The pilot confirmed a complete loss…NTSB ANC82DA082Accident · No injuriesFinal reportPiper PA-18 · Anchorage, AKThe pilot departed in an easterly direction from an unimproved strip 700 feet in length. He stated that the aircraft waslifted off the ground at an airspeed of 35 to 40 knots and would not climb. He also stated that a 5 to 7 knot wind down the runway caused a…NTSB LAX82FUM11Accident · 2 fatalFinal reportCessna 172N · San Clemente, CAAircraft declared missing by wife of passenger. Parts of the aircraft were found by boater and beach walkers from 8/18 to 8/25. Injury index presumed.NTSB LAX82DA307Accident · No injuriesFinal reportCessna 172N · Buckeye, AZThe pilot was on a flight to a private dirt strip. While on final approach to land, the sun was in his eyes and he did not see a 3 ft high mound of dirt near the threshold. The left main gear hit the dirt and sheared from the aircraft. After touchdown, the…NTSB ANC82DA072Accident · Serious injuriesFinal reportPiper PA-22 · Icy Bay, AKWhile on a cross country flight, the pilot landed on a small lake to add fuel to the aircraft from cans carried in the aircraft. After departing the lake he encountered weather and attempted to transition to instrument flight when a hole he was using to climb…NTSB FTW82FQA22Accident · 4 fatalFinal reportCessna 172N · Santa Fe, NMThe acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857…NTSB SEA82FYP09Accident · 3 fatalFinal reportCessna 172M · Wenatchee, WAReportedly, the pilot, a geologist, was on a flight to check rock formations. Prior to the accident, the plane was observed flying up a canyon at low altitude and airspeed. About 3/4 mile from the accident site, two witnesses on a rocky cliff at about 3500 ft…NTSB NYC82FHJ06Accident · 3 fatalFinal reportCessna 177 · Larchmont, NYThe aircraft was on a flight to take pictures of a home that was recently constructed on the shore of long island sound. While in flight, pictures were also taken of boats. A witness on a boat stated taht after the pilot made several passes over boats, the…NTSB DEN82DA107Accident · No injuriesFinal reportPiper PA-28-151 · Jackson, MTThe pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at…NTSB LAX82DA223Accident · No injuriesFinal reportRobinson R22 · Concord, CADuring a landing, the pilot reported that he came to a 3 ft hover then initiated a descent by lowering the collective. He stated that when the helicopter was about 6 inches above the ground, he lowered the collective to complete the landing, and at that…NTSB SEA82DA084Accident · No injuriesFinal reportBeech B19 · Quincy, WADuring a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled…NTSB LAX82FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Meiners Oaks, CAWitnesses in a remote canyon reported an aircraft making low passes in that area. They last saw the plane going up the canyon. Later, the aircraft was located on a wall of the same canyon. Tests of the pilot's blood showed an alcohol level of .279 percent.…NTSB MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…NTSB LAX82DA138Accident · No injuriesFinal reportRobinson R-22 · Perris, CAAfter refueling with 12.9 gallons of fuel, the pilot took off with one passenger on board. The pilot stated that after lifting off with 104% prm, he began a normal shallow takeoff with 25 inches of manifold pressure. He reported reaching about 75 ft AGL and…NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.NTSB NYC82FNA11Accident · Minor injuriesFinal reportVarga 2150A · Marlboro, MASnow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…NTSB LAX82DA060Accident · No injuriesFinal reportCessna 172M · Carson City, NVThe aircraft struck an 18 inch high frozen snow bank that a snow plow had left stretched across the approach end of runway 09. The pilot not able to see the snow bank due to fresh fallen snow. The right main gear was sheared off and the aircraft slid to a…