NTSB investigations: Lycoming 0-320 series, MO

13 cases on aircraft whose registry engine model is Lycoming 0-320 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

19822026
NTSB investigations: Lycoming 0-320 series, MO per year, 1982–2026: 13 cases
19822
19841
19921
19952
19982
20002
20011
20061
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\" = '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 ('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\" = 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 CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.Sep 11, 2007 · N12189 · Substantial damageNTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.Nov 26, 2006 · N74HP · Substantial damageNTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.Apr 14, 2001 · N3021Z · Substantial damageNTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.Apr 13, 2000 · N5909E · Substantial damageNTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.Feb 5, 2000 · N738EJ · Substantial damageNTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).Jul 4, 1998 · N2XC · Substantial damageNTSB CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.Feb 9, 1998 · N1958P · Substantial damageNTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.Dec 27, 1995 · N172DA · Substantial damageNTSB CHI95LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Versailles, MOthe pilot's improper recovery from a bounced landing, which resulted in his failure to maintain directional control of the airplane.Jul 21, 1995 · N14064 · Substantial damageNTSB CHI92LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOThe improper use of the aircraft brake system by the pilot in command.Jul 4, 1992 · N734VF · Substantial damageNTSB MKC84LA075Accident · No injuriesLimited investigationFinal reportCessna 172P · Springfield, MOThe student plt was on the final leg of a x-country flt. While landing with a gusty x-wind, the acft veered off the rwy, encountered soft terrain & nosed over.Feb 14, 1984 · N55277 · Substantial damageNTSB MKC82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Perryville, MOThe student pilot landed on runway 19 at his home airport after returing from a solo cross-country flight. The wind was from 220 degrees at 12 knots. After touchdown, the aircraft drifted to the right and impacted a snowbank beside the runway.Feb 20, 1982 · N2240K · Substantial damageNTSB MKC82DA027Accident · No injuriesFinal reportPiper PA-28-140 · Springfield, MODuring landing on runway 31, the student pilot perceived that he was high. He moved his touchdown point down the runway to the intersection with runway 19. There was an icy spot at the touchdown point on the intersection. After touchdown, the aircraft veered…Feb 6, 1982 · N7041C · Substantial damage