NTSB investigations: Lycoming 0-235 series, WA

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

19842026

NTSB investigations: Lycoming 0-235 series, WA per year, 1984–2026: 7 cases
1984	1
1989	1
1992	1
1995	1
2002	1
2006	1
2007	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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.Jul 9, 2007 · N3964M · Destroyed NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.Jun 28, 2006 · N243K · Substantial damage NTSB SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.Aug 14, 2002 · N4334E · Substantial damage NTSB SEA96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chimacum, WAthe pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.Dec 12, 1995 · N5366M · Substantial damage NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.Oct 11, 1992 · N24563 · Substantial damage NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.Sep 11, 1989 · N25228 · Substantial damage NTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…May 8, 1984 · N8624W · Substantial damage