NTSB investigations: Lycoming 0-320 series, OR

7 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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, OR per year, 1982–2026: 7 cases
1982	1
1987	1
1991	1
1994	1
1995	1
1999	1
2006	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" = 'OR' 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" = 200)) 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\" = 'OR' 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\" = 200))
  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" = 'OR' 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" = 200))
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 SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.Mar 28, 2006 · N20488 · Substantial damage NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.Jan 6, 1999 · N605HA · Substantial damage NTSB SEA95LA046Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORThe pilot's improper flare and improper recovery from a bounced landing.Feb 4, 1995 · N2901X · Substantial damage NTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.Apr 29, 1994 · N53161 · Substantial damage NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.Jun 17, 1991 · N202PR · Substantial damage NTSB SEA87LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORSeated at the controls in the left front seat was a plt who had not flown in ten years. Seated in the right front seat was the owner/student plt. The purpose of the flt according to the plt, was to familiarize the plt with the acft so that the plt could…Mar 28, 1987 · N4298T · Substantial damage NTSB SEA82DA145Accident · No injuriesFinal reportGulfstream American AA-5A · Medford, ORThe pilot reported that while landing, he flared too soon, touched down hard, and bounced. He reported that he made a power adjustment after bouncing, but landed hard again on the second touchdown. The aircraft was substantially damaged after the second…Aug 17, 1982 · N26922 · Substantial damage