NTSB investigations: Lycoming 0-320 series, PA

6 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

19822026

NTSB investigations: Lycoming 0-320 series, PA per year, 1982–2026: 6 cases
1982	1
1986	1
1987	1
1990	1
1995	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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 NYC99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairfield, PAThe pilot's failure to properly use carburetor heat which resulted in carburetor ice and loss of engine power. Contributing factor were trees.Dec 19, 1998 · N82096 · Substantial damage NTSB BFO95LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Factoryville, PAthe loss of engine power for undetermined reasons, and the subsequent hard landing by the student pilot.Jun 20, 1995 · N4876F · Substantial damage NTSB NYC90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Radnow Township, PAWire strike during an off airport forced landing in unsuitable terrain. Contributing factors were a power loss, caused by an engine oil leak.Jul 16, 1990 · N3EF · Destroyed NTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…Jun 24, 1987 · N35354 · Substantial damage NTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…Oct 19, 1986 · N5094K · Substantial damage NTSB NYC82FGT16Accident · No injuriesFinal reportBucker Jungmann BU-131 · Tower City, PAThe engine lost power when the aircraft was about 50 ft AGL during takeoff and landed in a rolling field of crops. The plane contacted the ground in a right bank/nose down attitude and came to rest at the point of impact. The engine separated from the…Jul 22, 1982 · N55JG · Substantial damage