NTSB investigations: Lycoming 0-235 series, IL

7 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Lycoming 0-235 series, IL per year, 1985–2026: 7 cases
1985	1
1986	1
1989	1
1993	1
1998	1
2000	1
2001	1

Where

Open the map

Latest cases

Query with SQL

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" = 'IL' 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

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\" = 'IL' 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.

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" = 'IL' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI01LA099Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Dekalb, ILFuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…Mar 7, 2001 · N9886U · Substantial damage NTSB CHI01LA019Accident · No injuriesLimited investigationFinal reportZenair CH2000 · Springfield, ILthe loose carburetor heat control clamp bolt and carburetor heat not available to the pilot. Factors were the low altitude, the carburetor icing conditions, the fence and the security gate.Oct 21, 2000 · N420ZA · Substantial damage NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.Aug 15, 1998 · N89648 · Substantial damage NTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.Aug 10, 1993 · N102CF · Substantial damage NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.Aug 3, 1989 · N67342 · Substantial damage NTSB CHI86FEE06Accident · Minor injuriesFinal reportFriling/Cothern Longeze · Plainfield, ILThe pilot made a steep right bank while entering the downwind leg on approach to land when the engine quit and the pilot was forced to make an emergency landing in a field short of the runway. Upon examination of the fuel system there was a lack of fuel in…Aug 28, 1986 · N45FC · Substantial damage NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…Mar 1, 1985 · N68183 · Destroyed