NTSB investigations: Lycoming 0-320 series, 1995
189 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\") = 1995
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") = 1995
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 FTW95FA380Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Midland, TXthe pilot's selection of a downwind runway for takeoff. Factors were the tailwind, the density altitude, and the overloading of the airplane.NTSB SEA95LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mt Pleasant, UTThe pilot in command's failure to maintain airspeed during climbout. Factors include wind shear and high density altitude.NTSB SEA95FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Missing, WAUndetermined until the Missing aircraft is located.NTSB NYC95FA212Accident · 1 fatalField investigationFinal reportPiper PA-18A-150 · Egg Harbor, NJFailure of the pilot to maintain adequate airspeed during pull-up from a banner pickup, which resulted in a stall and collision with trees before recovering from the stall.NTSB CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.NTSB CHI95FA307Accident · 1 fatalField investigationFinal reportCessna 172M · Orr, MNthe pilot misjudged the landing flare. Factors associated with the accident were the visual illusion caused by the glassy smooth water condition and the forward center of gravity.NTSB LAX95LA320Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Rosa, CAthe pilot's failure to maintain directional control. The pilot's improper use of the brakes and the soft terrain were factors in this accident.NTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.NTSB CHI95LA303Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Saint James, MIthe pilot's operation of the airplane with an inoperative fuel gage and the leaking fuel line fitting, which resulted in fuel exhaustion, loss of engine power, and a forced landing. The inoperative fuel gage was a related factor.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB CHI95LA297Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clarkston, MIthe pilot's failure to refuel.NTSB ANC95FA150Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's improper in-flight planning and decision by flying into a box canyon.NTSB BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.NTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB LAX95LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAThe failure of the connecting rod due to the rod bolt backing off, and the pilot's misjudging the distance and altitude.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB FTW95TA390Accident · Minor injuriesFinal reportPiper PA-18-150 · Brackettville, TXThe pilot's improper compensation for wind conditions, and failure to maintain directional control. A factor relating to the accident was: the variable crosswind.NTSB NYC95LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYthe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the nose gear.NTSB ANC95LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aniak, AKThe pilot's misjudged landing flare, which resulted in a hard landing and overload failure of the main landing gear.NTSB ANC95LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKFailure of the pilot to maintain proper alignment with the intended takeoff area during the takeoff roll. Factors relating to the accident were: pilot fatigue and the proximity of rocks/boulders to the takeoff area.NTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.NTSB SEA95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sekiu, WAThe pilot's continued flight into adverse weather necessitating a landing on a highway. The weather was a factor.NTSB ANC95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Alsworth, AKAn in-flight separation of a propeller blade, which resulted in a severe vibration, shutdown of the engine, and a forced landing in alder bushes.NTSB ANC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Ketchikan, AKThe pilot's inadequate preflight preparation and the water in the airplane's fuel system. A factor in the accident was the rough water in the forced landing area.NTSB ANC95LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe pilot's premature liftoff during takeoff.NTSB ANC95LA127Accident · No injuriesLimited investigationFinal reportCessna 206 · Sterling, AKFailure of both pilot's to maintain adequate visual lookout. The low angle of the sun was a related factor.NTSB CHI95LA252Accident · No injuriesLimited investigationFinal reportStevens Acro II · Oshkosh, WIthe failure of the pilot of the Acro II, N40LF, to maintain clearance from the Cessna 172, N5542R.NTSB NYC95LA179Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Farmingdale, NJthe pilot's improper inflight decision and inaccurate fuel consumption calculations, resulting in a loss of engine power due to fuel exhaustion and a forced landing over unsuitable terrain.NTSB CHI95LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kingman, KSthe pilot's failure to obtain sufficient airspeed before liftoff, and his delay in aborting the takeoff. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB LAX95LA267Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's loss of directional control during a crosswind landing using full flaps and the lack of familiarity with the crosswind landing component chart for the aircraft.NTSB CHI95LA235Accident · No injuriesLimited investigationFinal reportCessna 172 · Springfield, MOimproper in-flight planning/decision by the pilot, and his continued flight into adverse weather conditions, which resulted in an uncontrolled altitude deviation and collision with terrain. Factors relating to the accident were: the adverse weather conditions.NTSB CHI95LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Versailles, MOthe pilot's improper recovery from a bounced landing, which resulted in his failure to maintain directional control of the airplane.NTSB LAX95LA256Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAthe pilot's failure to maintain directional control of the aircraft after one foot slipped off the rudder pedals, and his inadvertent application of asymmetrical brake forces.NTSB SEA95LA149Accident · No injuriesLimited investigationFinal reportEdwin J. Estenson RV-4 · Elk River, IDThe pilot failed to maintain directional control. The tall vegetation was a factor.NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB ATL95LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Statesville, NCA cracked cylinder that resulted in a loss of engine power.NTSB SEA95LA155Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon, WAThe loss of engine power due to connecting rod bolt overload failure. The rough, uneven terrain in the emergency landing area was a factor.NTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.NTSB NYC95LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Stormville, NYThe reported pothole in the runway.NTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.NTSB ANC95LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Kotzebue, AKFuel exhaustion due to the pilot's improper planning/decision. The unfavorable (stronger than forecast) headwind was a related factor.NTSB ANC95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's failure to maintain directional control, during an off-airport landing on rough/uneven terrain, which resulted in an inadvertent ground swerve. The terrain condition was a related factor.NTSB LAX95LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Long Beach, CAthe inadvertent entanglement of the banner tow cable with the rudder control system, which resulted in a full and uncorrectable deflection of the rudder, and the pilot's inability to control the aircraft.NTSB SEA95LA144Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Moses Lake, WAThe pilot's failure to maintain directional control during the landing and go around. The crosswind and gusty wind conditions were factors in the accident.NTSB LAX95LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · New Cuyama, CAthe pilot's failure to attain and maintain an adequate airspeed, his premature rotation, and his failure to maintain directional control when the aircraft settled back onto the runway. The pilot's selection of a closed airport for the takeoff attempt was a…