NTSB investigations: Lycoming 0-290 series
29 cases on aircraft whose registry engine model is Lycoming 0-290 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2006 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506')
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 SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.NTSB SEA04LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Laurel, MTThe pilot's failure to maintain adequate clearance/altitude while maneuvering resulting in the inadvertent in-flight collision with water/terrain.NTSB LAX02LA268Accident · Serious injuriesLimited investigationFinal reportBreezy RLU-1A · North Las Vegas, NVthe failure of both pilots to maintain an adequate terrain clearance altitude while maneuvering in a canyon.NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.NTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB ANC98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKThe pilot's inadvertent ground loop.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB LAX96LA019Accident · Serious injuriesLimited investigationFinal reportEaa Chapter 163 Breezy RLU-1A · Henderson, NVthe pilot's failure to maintain a proper cruise altitude and his inadequate in-flight planning. Contributing factors were encountering rising terrain and a downdraft.NTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.NTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.NTSB SEA95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Laurel, MTThe selection of unsuitable terrain for landing. A factor to the accident was tall vegetation.NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.NTSB ANC94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Bear Creek, AKThe pilot's delayed go-around procedure. A factor in the accident was the improper use of carburetor heat during the go-around.NTSB LAX93FA096Accident · 1 fatalField investigationFinal reportCessna 172P · Sun City, CAThe pilot's decision to initiate VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, the adverse weather, and the mountainous terrain.NTSB ANC92LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Kasilof, AKThe pilot in command's inadvertant power off stall entry resulting in the collision with the terrain.NTSB ATL90DKJ03Accident · Minor injuriesFinal reportJolly Bakeng Duce · Brownsboro, ALFailure of the pilot to maintain the reference speed on approach and establish a proper glidepath.NTSB ANC89LA104Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Iliamna, AKPilot failed to maintain directional control during the attempted go-around. Factors in the accident were the rough/uneven terrain and the brush beside the runway.NTSB SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.NTSB SEA87LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · John Day, ORPlt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees.NTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…NTSB ANC85LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Mccarthy, AKThe pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree…NTSB MKC85LA116Accident · No injuriesLimited investigationFinal reportEaa Biplane BI-PLANE · Jamestown, MOWhile practicing touch & go landings in a fld which was partially cleared, the main gear became entangled in wheat which bordered the edge of the cleared area. The plt stated he misjudged the distance needed to clear the obstacle.NTSB DEN85LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYThe student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's…NTSB MKC84LA177Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7GC · Columbia, MOThe student plt was practicing emergency procedures during a solo flt. During a simulated forced landing apch to a field of tall fescue grass, he descended too low & the wheels encountered the grass which was 3 to 4 ft tall. The grass slowed the acft, it…NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…