NTSB investigations: Lycoming O-360-A1A, WA

4 cases on aircraft whose registry engine model is Lycoming O-360-A1A. 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

20032026

NTSB investigations: Lycoming O-360-A1A, WA per year, 2003–2026: 4 cases
2003	1
2009	2
2022	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 ('41594')) 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 ('41594'))
  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 ('41594'))
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 WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Apr 24, 2022 · N4398B · Substantial damage NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.Aug 21, 2009 · N116JM · Substantial damage NTSB WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.Jun 22, 2009 · N5617 · Substantial damage NTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…Jul 26, 2003 · N272JT · Substantial damage