NTSB investigations: Lycoming 0-320 series, 1997
200 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\") = 1997
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") = 1997
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 FTW97FA348Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Telluride, COfailure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.NTSB ANC97TA148Accident · No injuriesFinal reportPiper PA-18-150 · Saint Mary'S, AKThe excessive pressure in the brake system resulting from heating of the recently serviced hydraulic fluid in the brake master cylinders, and the resultant locked brakes and inability to maintain directional control of the airplane.NTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.NTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.NTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.NTSB CHI97LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's fixation on the end of the runway, his failure to place the airplane in an attitude to land (flare) which resulted in a hard landing, and the pilot's failure to recover from the subsequent bounced landing.NTSB CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.NTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.NTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.NTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.NTSB ANC97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKbinding or braking action of the left brake for undetermined reason(s).NTSB FTW97LA327Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Terrell, TXthe student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).NTSB CHI97LA269Accident · No injuriesLimited investigationFinal reportCessna 177 · Maple Lake, MNthe pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.NTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.NTSB FTW97LA312Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Longmont, COThe pilot in command's failure to maintain directional control of the aircraft, resulting in an inadvertent ground loop.NTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB IAD97LA108Accident · 1 fatalLimited investigationFinal reportRiekkenen Ryelong LE · Wurtsboro, NYThe pilot performed an aerobatic maneuver and misjudged the altitude.NTSB ANC97LA118Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe inadequate visual lookout by the pilot, and his selection of a landing area with high vegetation in the landing path. Factors which contributed to the accident were fatigue and the high vegatation.NTSB ATL97LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Rockhill, SCThe pilot's failure to plan and have adequate fuel for the flight.NTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.NTSB SEA97LA186Accident · No injuriesLimited investigationFinal reportCessna 172M · Langley, WAA failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing. .NTSB ANC97LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKthe pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.NTSB LAX97LA271Accident · No injuriesLimited investigationFinal reportMiller S-1 · Cottonwood, AZThe inadequate strength and braking capability of the landing gear and wheel brakes, and the builder's attempt to adapt motorcycle parts to an aircraft application. A factor in this accident was the pilot's lack of familiarity with this experimental aircraft.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB NYC97LA156Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WVThe student pilot's improper recovery from a bounced landing.NTSB FTW97LA289Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXfailure of the pilot to maintain directional control of the airplane during the takeoff roll, as he attempted to close and lock the left cabin window. Factors relating to the accident were: the pilot's failure to follow the before takeoff checklist (secure…NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.NTSB LAX97LA267Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · San Jose, CAThe pilot's failure to maintain directional control, and excessive remedial action, which resulted in an inadvertent swerve off the runway.NTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.NTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.NTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.NTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…NTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.NTSB ANC97LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain aircraft control during takeoff. Factors were the intentional relinquishing of controls by the pilot, and interference with the rudder controls by the nonpilot passenger.NTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.NTSB CHI97LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Ottumwa, IAthe improper flare performed by the student and the inadequate recovery from the bounced landing. A factor related to the accident was the student lack of experience.NTSB ANC97LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot's selection of unsuitable terrain for landing.NTSB ATL97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during the landing, which resulted in a collision with a runway marker. The rear-quartering tailwind (crosswind) and gusts were related factors.NTSB ANC97LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Fairbanks, AKThe pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…NTSB ANC97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKwater contamination of the fuel supply. Soft, unsuitable terrain for the precautionary landing were factors.NTSB SEA97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Naches, WAinadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…NTSB ANC97LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Cantwell, AKThe pilot's failure to maintain sufficient altitude to clear terrain. Factors were exceeding the airplane's maximum allowable gross weight, and downdrafts and turbulence associated with wind flowing across a mountain ridge.NTSB SEA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…NTSB CHI97LA201Accident · Serious injuriesLimited investigationFinal reportWeber RV-4 · Hermann, MOthe pilot's inadequate in-flight planning/decision and encounter with a stall. Related factors were the chafed throttle cable, which became jammed; and failure of the pilot to perform an engine shut down in order to land on the runway.NTSB SEA97LA157Accident · No injuriesLimited investigationFinal reportCessna 172M · UTUndetermined.