NTSB investigations: Lycoming 0-235 series, KS

5 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

19822026

NTSB investigations: Lycoming 0-235 series, KS per year, 1982–2026: 5 cases
1982	2
1983	2
2004	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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 CHI04LA238Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Eudora, KSA loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.Aug 6, 2004 · N9442L · Substantial damage NTSB MKC83LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Holton, KSThe pilot stated that he looked in the fuel tanks prior to takeoff and they appeared to be about half full and he thought this was about three hours fuel. About one hour after takeoff the engine quit and a forced landing was attempted in a pasture. The pilot…Jul 26, 1983 · N89876 · Substantial damage NTSB MKC83LA118Accident · No injuriesLimited investigationFinal reportGulfstream American AA1A · Wichita, KSPrior to the flt to Wichita, the plt received a local night checkout with a CFI at olathe. The flt then departed olthe a 2030. As the plt began his descent for a landing at witchita mid-continent arpt the eng quit. He was given a vector tocol. James jabara…May 30, 1983 · N9284L · Substantial damage NTSB MKC83LA048Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe aircraft was on downwind when the engine stopped. The aircraft touched down 1000 ft short of the runway. Investigation revealed there was no fuel in the fuel tanks.Dec 31, 1982 · N94291 · Substantial damage NTSB MKC83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSThe pilot estimated there was about 10 gallons of fuel on board before he took off. After making three takeoffs and landings, he picked up a passenger and flew in the local area. After flying about one hour and 17 minutes, the engine lost power. While landing…Oct 3, 1982 · N757PF · Substantial damage