NTSB investigations: Lycoming 0-320 series, 1992, MI

7 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 per year

19642026
NTSB investigations: Lycoming 0-320 series, 1992, MI per year, 1964–2026: 393 cases
19648
196511
196611
196715
196815
196914
197010
19719
197213
19738
197412
19757
197615
197710
19788
19799
19808
19818
198210
198316
19846
19855
19868
19875
19887
19892
19904
19919
19927
19937
19946
19957
19963
19975
19983
19995
20005
20018
20022
20035
20045
20053
20066
20076
20081
20105
20111
20124
20134
20142
20154
20162
20173
20185
20192
20204
20211
20223
20231
20241
20253
20261

Latest cases

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\") = 1992
    AND c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
    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 CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.Oct 16, 1992 · N2945Z · DestroyedNTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.Oct 4, 1992 · N9807D · Substantial damageNTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.Sep 15, 1992 · N96593 · Substantial damageNTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.Sep 12, 1992 · N5361K · Substantial damageNTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.Sep 8, 1992 · N3743P · Substantial damageNTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.Jun 10, 1992 · N80490 · Substantial damageNTSB CHI92DEM02Accident · No injuriesFinal reportGillespie/Pitts S1C · Freeland, MIA total failure of the rudder control cable and unavailability of rudder to control the airplane during its landing process. Factors which contributed to the accident were directional control and remedial action not being possible on behalf of the pilot.May 6, 1992 · N71309 · Substantial damage