NTSB investigations: Lycoming 0-320 series, NV

5 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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, NV per year, 1982–2026: 5 cases
19821
19951
19992
20071

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 c.\"eventStateOrRegion\" = 'NV' 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')
      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\" = 200))
  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 LAX07CA138Accident · No injuriesData collectionFinal reportTolsma Tony G Avid Magnum · Jackpot, NVThe pilot's inadequate weather evaluation, inadequate compensation for the wind conditions, and decision to land with a gusty, quartering tailwind. Also causal was the pilot's misjudged landing flare and inadequate recovery from a bounced landing, resulting…Apr 28, 2007 · N211RT · Substantial damageNTSB LAX99LA300Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-BETA · Piute, NVthe failure of the pilot to maintain rotor rpm while practicing autorotations, resulting in a hard landing and roll over.Sep 9, 1999 · N4076Z · Substantial damageNTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.Aug 27, 1999 · N3327T · Substantial damageNTSB LAX95LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's improper recovery from a bounced landing. His misjudgment of the height above the runway during flare was a factor.Jun 12, 1995 · N73927 · Substantial damageNTSB LAX82DA156Accident · Minor injuriesFinal reportRobinson R-22HP · North Las Vegas, NVThe passenger stated that during the approach to the landing area he noticed a decrease in rpm's and that the pilot was having difficulty in stabilizing the aircraft. He also noted that the helicopter was descending faster than the prior approach. Damage…May 1, 1982 · N90764 · Substantial damage