NTSB investigations: Lycoming 0-290 series, MO

5 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the first occurrence was “Loss of control - on ground/water”. 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

19842026
NTSB investigations: Lycoming 0-290 series, MO per year, 1984–2026: 5 cases
19841
19861
19911
20001
20021

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\" = 'MO' 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 ('41506')
      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\" = 260))
  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 CHI02LA168Accident · Minor injuriesLimited investigationFinal reportBumgarner CA65 Sky Fly · Warrensburg, MOThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the overload failure of the right main landing gear.Jun 15, 2002 · N145JB · Substantial damageNTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.Jul 31, 2000 · N5590H · Substantial damageNTSB CHI91LA285Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOA premature liftoff and improper remedial action by the pilot during a takeoff ground run.Sep 1, 1991 · N11793 · Substantial damageNTSB MKC87LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macon, MOThe pilot stated that he encountered more severe crosswinds than planned upon landing and that he tried remedial action, including a rejected landing, but it came too late. The wind was blowing from the right on the landing roll as he shut down the engine and…Oct 18, 1986 · N1690K · Substantial damageNTSB MKC84LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Boonville, MOThe acft nosed over after landing. The plt said that the arpt manager told him that 'there is a valley that funnels the wind and has blown other acft the same way'. The plt said the only way to avoid this condition is to land farther down the rwy.Feb 13, 1984 · N4944M · Substantial damage