NTSB investigations: Lycoming O&VO-360 series, LA

5 cases on aircraft whose registry engine model is Lycoming O&VO-360 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

19882026

NTSB investigations: Lycoming O&VO-360 series, LA per year, 1988–2026: 5 cases
1988	1
1990	1
1991	1
1997	1
1998	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" = 'LA' 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 ('41514') 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\" = 'LA' 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 ('41514')
      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" = 'LA' 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 ('41514')
    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 FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Feb 27, 1998 · N7998W · Substantial damage NTSB FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.Jul 15, 1997 · N777TU · Substantial damage NTSB FTW91LA167Accident · No injuriesLimited investigationFinal reportCessna 177B · Lake Charles, LAThe pilot's failure to perform a complete preflight inspection which resulted in a total loss of engine power due to fuel exhaustion as a result of inadequate fuel supply.Sep 28, 1991 · N34980 · Substantial damage NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.Jan 21, 1990 · N3712X · Destroyed NTSB FTW89LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Houma, LAThe airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…Dec 22, 1988 · N6444U · Substantial damage