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.

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.Sep 16, 1990 · N59645 · Substantial damageNTSB 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.Sep 15, 1990 · N86483 · Substantial damageNTSB 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.Sep 11, 1990 · N1241U · Substantial damageNTSB 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.Sep 9, 1990 · N9895V · Substantial damageNTSB 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.Sep 7, 1990 · N85594 · Substantial damageNTSB 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.Sep 2, 1990 · N65857 · Substantial damageNTSB 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…Sep 2, 1990 · N23848 · Substantial damageNTSB CHI90LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's failure to abort takeoff.Aug 31, 1990 · N16504 · Substantial damageNTSB ANC90LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe pilot-in-command's failure to maintain aircraft control.Aug 31, 1990 · N4091Z · Substantial damageNTSB ANC90LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.Aug 27, 1990 · N72BW · Substantial damageNTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.Aug 26, 1990 · N965CD · Substantial damageNTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.Aug 26, 1990 · N3163Z · Substantial damageNTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.Aug 25, 1990 · N8450E · Substantial damageNTSB ANC90LA151Accident · Minor injuriesLimited investigationFinal reportArtic S1B2 · Talkeetna, AKThe pilot-in-command's failure to maintain air speed on takeoff.Aug 20, 1990 · N52AT · Substantial damageNTSB 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…Aug 19, 1990 · N3054N · 2 aircraft · DestroyedNTSB 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.Aug 18, 1990 · N6702B · Substantial damageNTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.Aug 18, 1990 · N8335R · Substantial damageNTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.Aug 17, 1990 · N9069Z · Substantial damageNTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.Aug 16, 1990 · N6513R · Substantial damageNTSB ANC90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gustavus, AKThe pilot's failure to maintain directional control during the landing roll.Aug 12, 1990 · N783LK · Substantial damageNTSB 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.Aug 11, 1990 · N9551L · Substantial damageNTSB CHI90LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greenwood, INThe pilot misjudged the landing flare and the airplane stalled and landed hard.Aug 11, 1990 · N8085H · Substantial damageNTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.Aug 9, 1990 · N9072N · Substantial damageNTSB 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.Aug 7, 1990 · N1466V · 2 aircraft · Substantial damageNTSB 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.Aug 4, 1990 · N7265F · Substantial damageNTSB ANC90LA130Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Merrill Pass, AKThe pilot-in-command's failure to maintain flying speed.Aug 3, 1990 · N5110H · Substantial damageNTSB 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.Aug 2, 1990 · N1753T · Substantial damageNTSB ANC90T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kotzebue, AKAug 1, 1990 · N2497B · Substantial damageNTSB 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…Jul 30, 1990 · N9978D · DestroyedNTSB 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.Jul 30, 1990 · N66BR · 2 aircraft · Substantial damageNTSB CHI90FA196Accident · No injuriesField investigationFinal reportCessna 172 · Canton, MIThe pilot's inadequate takeoff procedure, premature liftoff and delayed reaction to abort the takeoff.Jul 25, 1990 · N4330Q · Substantial damageNTSB 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.Jul 24, 1990 · N4184Z · Substantial damageNTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.Jul 21, 1990 · N4153Z · Substantial damageNTSB 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.Jul 19, 1990 · N5011T · Substantial damageNTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.Jul 17, 1990 · N1404R · Substantial damageNTSB 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.Jul 16, 1990 · N3EF · DestroyedNTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.Jul 16, 1990 · N46593 · Substantial damageNTSB 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.Jul 12, 1990 · N82676 · Substantial damageNTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.Jul 12, 1990 · N5330F · Substantial damageNTSB 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.Jul 9, 1990 · N8519Y · Substantial damageNTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.Jul 8, 1990 · N91248 · Substantial damageNTSB 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.Jul 3, 1990 · N8326V · Substantial damageNTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.Jul 3, 1990 · N4878A · Substantial damageNTSB 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.Jul 2, 1990 · N2307Y · DestroyedNTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.Jun 30, 1990 · N9313H · Substantial damageNTSB 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.Jun 28, 1990 · N9993D · Substantial damageNTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.Jun 24, 1990 · N2310J · Substantial damageNTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasJun 20, 1990 · N2200P · DestroyedNTSB 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.Jun 16, 1990 · N8167R · Substantial damageNTSB 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.Jun 12, 1990 · N1323T · Substantial damage