Skip to content

NTSB investigations: Lycoming 0-290 series, UT

27 cases on aircraft whose registry engine model is Lycoming 0-290 series. 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

19642026

Where

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" = 'UT' 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 ('41506')) 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\" = 'UT' 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 ('41506'))
  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" = 'UT' 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 ('41506'))
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 WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.Feb 4, 2023 · N3969B · Substantial damage NTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.Jan 1, 2021 · N1571A · Substantial damage NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.Jun 2, 2008 · N8279C · Substantial damage NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.Jun 6, 2006 · N7494K · Substantial damage NTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.Jun 14, 2000 · N3846M · Substantial damage NTSB SEA97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ogden, UTthe pilot's inadequate compensation for wind conditions, while landing, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.Oct 21, 1996 · N3461A · Substantial damage NTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.Aug 24, 1992 · N2169A · Substantial damage NTSB DEN83LTM06Accident · No injuriesFinal reportJodel D11S · Bountiful, UTThe pilot landed and said it felt like he ran into standing water during roll-out. The acft veered left and went through grass, rocks and a ditch. The left gear was punched up through the wing. The right gear and the flaps were also damaged.Aug 15, 1983 · N722E · Substantial damage NTSB DEN82DTM10Accident · No injuriesFinal reportSmith Miniplane BK-1 · West Jordan, UTThe pilot had just purchased the aircraft and was making touch and go landings for familiarization. He was using a paved runway with patches of ice and was landing with about a 10 knot right crosswind. On about his eighth landing, the plane began to drift to…Feb 2, 1982 · N12BK · Substantial damage NTSB DEN79FTM14Accident · Minor injuriesClosedPiper PA-22 · Panguitch, UTMay 18, 1979 · N8702C · Substantial damage NTSB DEN78DTM09Accident · No injuriesClosedPiper PA-18 · Blanding, UTDec 10, 1977 · N255T · Substantial damage NTSB DEN75FTM03Accident · Serious injuriesClosedPiper PA-18 · Tremonton, UTJul 2, 1974 · N3351A · Substantial damage NTSB DEN74FTM06Accident · Minor injuriesClosedWittman W-8 · Salt Lake City, UTOct 4, 1973 · N11511 · Substantial damage NTSB DEN73DTM17Accident · No injuriesClosedPiper PA-18 · Tremonton, UTFeb 1, 1973 · N1249A · Substantial damage NTSB DEN72DTM08Accident · No injuriesClosedPiper PA-20 · Ogden, UTFeb 5, 1972 · N2186A · Substantial damage NTSB DEN71DXT11Accident · No injuriesClosedPiper PA-20 · Ogden, UTOct 3, 1970 · N2186A · Substantial damage NTSB DEN71DXT09Accident · No injuriesClosedK.Twister IMP · Coalville, UTSep 13, 1970 · N5DF · Substantial damage NTSB DEN71DXT01Accident · No injuriesClosedPiper PA-18 · Fielding, UTJul 4, 1970 · N1249A · Substantial damage NTSB DEN69F0074Accident · 1 fatalClosedPiper PA-18 · Paradise, UTJul 26, 1968 · N7244K · Destroyed NTSB DEN69F0018Accident · No injuriesClosedPiper PA-20 · Ogden, UTMay 29, 1968 · N7767K · Substantial damage NTSB DEN67F0093Accident · 1 fatalClosedChampion 7GC · Heber, UTAug 29, 1966 · N7590E · Substantial damage NTSB DEN66D0333Accident · No injuriesClosedPiper PA-22 · Hanksville, UTJun 1, 1966 · N829A · Substantial damage NTSB DEN65F0103Accident · Minor injuriesClosedPiper PA-22 · Logan, UTMay 27, 1965 · N3449A · Substantial damage NTSB UNK65X0193Accident · No injuriesClosedPiper PA20 · Woods Cross, UTOct 8, 1964 · N7783K · Substantial damage NTSB UNK64X4137Accident · No injuriesClosedPiper PA20 · Woods Cross, UTSep 25, 1964 · N7414K · Substantial damage NTSB UNK64X2636Accident · No injuriesClosedPiper PA22 · Green River, UTJul 4, 1964 · N1448C · Substantial damage NTSB UNK64X0367Accident · No injuriesClosedPiper PA18 · Provo, UTJan 26, 1964 · N255T · Substantial damage