NTSB investigations: Lycoming 0-320 series, 1990

6 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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

19822026
NTSB investigations: Lycoming 0-320 series, 1990 per year, 1982–2026: 341 cases
198215
198311
19847
19859
198616
198718
19884
19894
19906
199112
19929
19938
19947
199514
19969
199716
199817
199915
200013
200123
200221
200321
200420
200513
200618
200715

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\") = 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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 LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.Oct 11, 1990 · N6147J · DestroyedNTSB 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 LAX90LA204Accident · No injuriesLimited investigationFinal reportRobinson R22A · Torrance, CAThis accident was a dynamic roll over due to the right skid encountering soft soil during the forced landing.May 30, 1990 · N8557Z · Substantial damageNTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.Apr 8, 1990 · N5628U · Substantial damageNTSB MIA90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Immokalee, FLThe loss of engine power due to an undetermined reason. A factor related to the accident was: rough terrain in the emergency landing area.Jan 15, 1990 · N8445G · Substantial damage