NTSB investigations: Lycoming 0-290 series, WA

8 cases on aircraft whose registry engine model is Lycoming 0-290 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Lycoming 0-290 series, WA per year, 1985–2026: 8 cases
1985	1
1987	1
1988	1
1991	1
1994	1
1996	1
1998	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" = '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 ('41506') 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

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 ('41506')
      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.

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 ('41506')
    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

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 SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.Jun 16, 2001 · N39RS · Substantial damage NTSB SEA98LA067Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Arlington, WAThe pilot's failure to maintain directional control during the landing roll, and his delayed remedial action when the aircraft started to drift off the side of the runway.Apr 26, 1998 · N7458K · Substantial damage NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.Jun 1, 1996 · N1645A · Substantial damage NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.Jul 15, 1994 · N1540A · Substantial damage NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.Jul 13, 1991 · N7458K · Substantial damage NTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…Jun 12, 1988 · N1453A · Substantial damage NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.May 10, 1987 · N7732K · Substantial damage NTSB SEA85LA192Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAA ground loop occurred and the steering spring failed. The aircraft's steering spring had failed prior to the accident away from a repair station. The pilot made a temporary repair that failed during this ground loop. The pilot stated that a combination of a…Aug 9, 1985 · N7765K · Substantial damage