NTSB investigations: Lycoming 0-320 series, 1998
204 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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, newest first
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\") = 1998
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'))
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") = 1998
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'))
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 FTW98LA398Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Watkins, COGusting winds which blew the aircraft inverted during taxi.NTSB ANC98LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was sunglare as the pilot landed into the sun.NTSB MIA98LA245Accident · Serious injuriesLimited investigationFinal reportWood Glasair SH2 · Holly Hill, SCThe pilot's failure to maintain airspeed, and his failure to perform a go-around. The pilot's misjudgment of speed and distance during the landing is a contributing factor.NTSB LAX98LA283Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Truckee, CAThe pilot's failure to use carburetor heat in temperature conditions conducive to carburetor icing and his failure to lean the engine in a high density altitude environment, which combined, led to a partial loss of engine power and the onset of a stall during…NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB ANC98LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of an unsuitable off airport site for landing. A factor associated with the accident was high vegetation (brush and weeds) in the landing area.NTSB SEA98LA173Accident · No injuriesLimited investigationFinal reportKoskella Long EZ · Cascade, IDThe pilot's failure to maintain airspeed on final approach. Factors include inadequate remedial action and erroneous airspeed indications.NTSB CHI98LA331Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit Lakes, MNAn inadequate preflight inspection by the pilot which resulted in fuel exhaustion and subsequent loss of engine power.NTSB NYC98LA178Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Skaneateles, NYThe pilot's failure maintain directional control and his delayed decision to abort the takeoff. Contributing factors were trees.NTSB CHI98LA346Accident · No injuriesLimited investigationFinal reportNeedham Glastar · Allison, IAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ANC98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chugiak, AKThe pilot's inadvertent ground loop of the airplane during the landing roll.NTSB MIA98LA231Accident · Minor injuriesLimited investigationFinal reportBibb RV-4 · Chapel Hill, NCThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.NTSB ANC98LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Arctic Village, AKThe pilot's delayed action to abort the landing. Factors associated with the accident were a tail wind, and rising terrain.NTSB SEA98FA170Accident · 1 fatalField investigationFinal reportCessna 172L · Anacortes, WATerrain clearance was not maintained. A low ceiling and the pilot's inadequate in-flight planning/decision were factors.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB NYC98LA172Accident · No injuriesLimited investigationFinal reportEkstrom-Farrington Twinstar · Paducah, KYFailure of a through-bolt that attached the lateral control arms to the yoke assembly, due to unanticipated rotor brake forces through the flight control system.NTSB ANC98TA128Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe pilot's inadequate preflight planning/preparation, and his delay in aborting the takeoff. Factors in the accident were a short runway area for takeoff, trees located at the end of the runway, and the pilot's excessive application of brakes.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB ANC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cordova, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was grass covered rocks.NTSB ANC98LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Chugiak, AKThe loss of engine power for an undetermined reason.NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.NTSB ANC98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident were gusty winds.NTSB MIA98LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Conway, SCThe total failure of the left wing forward and aft attachment fitting due to corrosion and fatigue during a banner tow pick-up resulting in a subsequent in-flight collision with terrain.NTSB FTW98FA358Accident · 1 fatalField investigationFinal reportCessna 172N · Cord, ARThe pilot's performance of low altitude flight and his failure to maintain obstacle clearance.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB CHI98LA318Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Rantoul, ILthe pilot not maintaining directional control. Factors were crops and encounter with unsuitable terrain.NTSB CHI98LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Redwood Falls, MNthe pilot's not following proper short field landing procedures.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB CHI98LA320Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lac Du Flambeau, WIthe pilot's failure to maintain adequate airspeed and the subsequent inadvertant stall.NTSB ANC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Copper Center, AKThe pilot's selection of an unsuitable off-airport landing site. A factor associated with the accident is rough and uneven terrain.NTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB NYC98LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172P · West Milford, NJThe student pilot's improper recovery from a bounced landing and the instructor's inadequate supervision of the flight.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB SEA98FA161Accident · 1 fatalField investigationFinal reportCessna 177 · Red Lodge, MTThe pilot's failure to maintain adequate altitude over, or clearance with, mountainous terrain during night visual flight rules flight. Factors included night lighting conditions and mountainous terrain.NTSB CHI98LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Laporte, INwas the student pilot s inadequate compensation for the wind conditions he encountered during the landing phase. A factor in this accident was the pilot s lack of total experience.NTSB IAD98LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Lebanon, OHThe pilot's delay in aborting the landing, which resulted in inadequate obstacle (car) clearance during initial takeoff climb. A contributing factor is the pilot's decision to perform a tailwind landing.NTSB ANC98LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cantwell, AKThe pilot's intentional continued VFR flight into IMC. Factors were the scattered to broken clouds, and the mountainous terrain.NTSB LAX98LA250Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Corona, CAThe loss of engine power due to a partially closed fuel shutoff valve as a result of improper maintenance installation.NTSB FTW98LA329Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Rockwall, TXThe pilot's improper use of the fuel tank selector resulting in the loss of engine power due to fuel starvation. A factor was the pilot's failure to follow the check list.NTSB CHI98LA277Accident · Serious injuriesLimited investigationFinal reportMarchetti Avenger Gryo Plane · Mentone, INthe pilot's lack of familiarity with the gyroplane's performance, and his improper in-flight decision to reduce engine power to idle which aggravated the gyroplane's nose down pitch and exceeded the gyroplane's back stick authority.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB MIA98LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, NCThe failure of the pilot to maintain directional control of the airport resulting in the collapse of the nose and left main landing gears.NTSB SEA98LA169Accident · No injuriesLimited investigationFinal reportWiles S1-C · Yelm, WAFuel exhaustion due to overflying an intermediate fuel stop. Factors include high grass in the forced landing area.NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.NTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.NTSB SEA98LA144Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe student pilot's failure to maintain directional control of the aircraft. Related factors were the student pilot's lack of total experience, and airport signs in the accident area.NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.NTSB NYC98LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Chateaugay, NYBinding in the control yoke for undetermined reasons.