NTSB investigations: Lycoming 0-320 series, 1990
190 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\") = 1990
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") = 1990
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 ANC90LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Heiden, AKThe pilot-in-command's failure to maintain aircraft control during a strong crosswind.NTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB LAX90LA317Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · Beatty, NVThe pilot's selection of an inadequate cruise altitude and his failure to maintain adequate rotor RPM. Contributing factors related to the high density altitude, rising terrain, and the pilot's delayed and improper use of the collective.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.NTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…NTSB CHI90LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's failure to abort takeoff.NTSB ANC90LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe pilot-in-command's failure to maintain aircraft control.NTSB ANC90LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.NTSB ANC90LA151Accident · Minor injuriesLimited investigationFinal reportArtic S1B2 · Talkeetna, AKThe pilot-in-command's failure to maintain air speed on takeoff.NTSB LAX90FA292Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Long Beach, CAThe inadequate visual outlook of the pilots of the Cessna 172P and their failure to see and avoid the Piper pa- 28RT-201. Contributing to the accident was the azimuth and angle of the sun which was in a position at the time of the accident to impair the scan…NTSB LAX90LA291Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Weaverville, CAThe pilot's failure to maintain directional control of the aircraft. The existing wind conditions and the ditch that was located near the runway were factors in the accident.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.NTSB ANC90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gustavus, AKThe pilot's failure to maintain directional control during the landing roll.NTSB LAX90LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Coalinga, CAThe failure of the student pilot to accurately interpret the wind sock, and his inadvertent attempt to perform a downwind landing.NTSB CHI90LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greenwood, INThe pilot misjudged the landing flare and the airplane stalled and landed hard.NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB FTW90FA151Accident · Minor injuriesField investigationFinal reportCessna 172M · Elmendorf, TXInadequate visual lookout by both pilots in the T-38 and by the instructor pilot (CFI) in the Cessna 172.NTSB NYC90LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tunkhannock, PAThe pilot did not obtain the proper touchdown point which resulted in an overrun. The factors were altitude, wet runway, and go around not performed.NTSB ANC90LA130Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Merrill Pass, AKThe pilot-in-command's failure to maintain flying speed.NTSB CHI90LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mooresville, INThe pilot in commands failure to land with enough runway remaining resulting in a runway overun and on ground collision with a wall.NTSB ANC90T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kotzebue, AKNTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.NTSB CHI90FA196Accident · No injuriesField investigationFinal reportCessna 172 · Canton, MIThe pilot's inadequate takeoff procedure, premature liftoff and delayed reaction to abort the takeoff.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB NYC90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Radnow Township, PAWire strike during an off airport forced landing in unsuitable terrain. Contributing factors were a power loss, caused by an engine oil leak.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.NTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.NTSB ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.NTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.NTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.NTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.NTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.NTSB SEA90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Sitka, AKFailure of the pilot to maintain directional control of the airplane during the landing roll. The crosswind condition was a factor related to the accident.NTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.NTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasNTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB NYC90LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marcellus, NYFailure of the pilot-in-command to maintain airspeed after takeoff. A contributing factor was the the upslope gradient of the runway.