NTSB investigations: Lycoming IO-320 series, FL

6 cases on aircraft whose registry engine model is Lycoming IO-320 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 IO-320 series, FL per year, 1984–2026: 6 cases
1984	1
1990	1
1995	1
2003	1
2007	2

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" = 'FL' 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 ('41509') 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\" = 'FL' 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 ('41509')
      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" = 'FL' 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 ('41509')
    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 MIA07LA152Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Milton, FLThe failure of the pilot to attain the proper touchdown point during the precautionary landing resulting in the on-ground collision with fence posts.Sep 17, 2007 · N8751Y · Substantial damage NTSB MIA07FA117Accident · 2 fatalField investigationFinal reportPiper PA-30 · Nichols, FLFailure of the flight crew to maintain minimal controllable airspeed following a total loss of power in the right engine.Jul 9, 2007 · N387RP · Substantial damage NTSB ATL04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Kissimmee, FLThe pilot's failure to maintain directional control which resulted in a collision with terrain and obstacles following a loss of right engine power.Dec 13, 2003 · N230SW · Substantial damage NTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…Jun 11, 1995 · N7631S · Substantial damage NTSB MIA90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Margate, FLLoss of power in both engines due to fuel exhaustion, resulting in a forced landing. A factor in the accident was that the pilot did not follow the flight manual to ensure that the fuel tanks were filled to capacity.Mar 15, 1990 · N7114Y · Substantial damage NTSB MIA84LA189Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Clewiston, FLThe plt stated that before the flt, he visually checked the main tanks & the fuel gages indicated 1/4 full on each side. Before reaching the destination, an eng lost power, & shortly after that, the other eng lost power, both from fuel exhaustion. The plt had…Jun 19, 1984 · N7225Y · Substantial damage