NTSB investigations: Lycoming 0-235 series, MO

10 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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-235 series, MO per year, 1982–2026: 10 cases
19821
19841
19871
19891
19901
19931
19941
20001
20011
20031

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 ('41505')
      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\" = 353))
  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 CHI03LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mansfield, MOThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the loss of engine power.Jan 13, 2003 · N2400K · Substantial damageNTSB CHI02LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedalia, MOThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.Nov 18, 2001 · N48285 · Substantial damageNTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.Mar 25, 2000 · N6375H · Substantial damageNTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.Jun 15, 1994 · N69227 · Substantial damageNTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.Dec 12, 1993 · N757FH · Substantial damageNTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.Jul 18, 1990 · N6095M · DestroyedNTSB MKC90LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOPoor planning by the pilot in not refueling enroute which resulted in fuel exhaustion.Nov 10, 1989 · N47446 · Substantial damageNTSB MKC87LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Louis, MOThe pilot stated that he departed St. Louis downtown-parks airport (cps) on a round-robin flight with planned stops at st. clair memorial airport (K39), Missouri, and richland municipal airport (M034), Missouri. The return flight to cps included another stop…May 22, 1987 · N6136Q · Substantial damageNTSB MKC84FA058Accident · 1 fatalField investigationFinal reportCessna 152 · St. Charles, MOThe acft was progressing from a touch-and-go landing when it collided with transmission wires, 926 ft from the rwy at about 27 ft AGL. The weather was conducive to carburetor icing and the carburetor heat control was found partially open. Several gallons of…Jan 7, 1984 · N5396P · DestroyedNTSB MKC82DA030Accident · No injuriesFinal reportCessna 152 · Chesterfield, MODuring takeoff from a touch and go landing, the engine lost power at about 300 ft AGL. The student pilot was unable to restart the engine. The aircraft was damaged during a forced landing off of the runway. No pre-impact engine malfunctions or failures were…Feb 11, 1982 · N757YE · Substantial damage