NTSB investigations: Lycoming 0-320 series, MI

8 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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-320 series, MI per year, 1984–2026: 8 cases
1984	1
1987	1
2001	2
2003	1
2006	2
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" = 'MI' 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 ('41508') 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" = 350)) 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\" = 'MI' 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 ('41508')
      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\" = 350))
  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" = 'MI' 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 ('41508')
    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" = 350))
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 CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.Aug 11, 2007 · N13586 · Substantial damage NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.Dec 20, 2006 · N5811D · Substantial damage NTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.Aug 12, 2006 · N208BY · Substantial damage NTSB CHI03LA298Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Harrisville, MIThe loss of engine power for undetermined reasons and the unsuitable terrain encountered during the forced landing. A factor to the accident was the trees.Aug 30, 2003 · N9574U · Substantial damage NTSB CHI01LA295Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Romeo, MIthe reason for the loss of engine power is undetermined.Aug 28, 2001 · N9047L · Substantial damage NTSB CHI01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mecosta, MIthe inadequate preflight planning/preparation by the pilot and fuel starvation. Additional causes were the aircraft control not maintained, and the inadvertent stall by the pilot.Jul 3, 2001 · N8007N · Destroyed NTSB CHI87LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIWhile the plt was using short field techniques for takeoff, the acft lifted off into ground effect. At about that time, the plt thought there was a partial power loss. He stated, 'after perceiving a partial power loss which was accompanied with a loss in…Aug 19, 1987 · N32387 · Substantial damage NTSB CHI84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lake City, MIAccording to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that…Aug 29, 1984 · N7335D · Substantial damage