Skip to content

NTSB investigations: Lycoming 0-290 series, OK

23 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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.Dec 3, 2021 · N3372A · Substantial damage NTSB CEN12LA179Accident · 1 fatalLimited investigationFinal reportSkeeter 1M · Oklahoma City, OKThe pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.Mar 3, 2012 · N1111V · Substantial damage NTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.Apr 21, 2011 · N7804C · Substantial damage NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.Apr 17, 2006 · N945A · Substantial damage NTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…Jan 8, 1996 · N86S · Destroyed NTSB FTW95LA169Accident · No injuriesLimited investigationFinal reportStembridge Spezio · Duncan, OKThe pilot's improper compensation for the wind conditions. A factor was gusty winds.Apr 15, 1995 · N3068 · Substantial damage NTSB FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.Jul 8, 1987 · N1175C · Substantial damage NTSB FTW85FA204Accident · 1 fatalField investigationFinal reportHolder Midget Mustang I · Yukon, OKThe relatively low time pilot (99 total hours) had no recorded experience in high performance aircraft. He had just purchased the midget mustang and had practiced both low and high speed taxi runs on two occasions in the aircraft. He was observed to make one…Apr 30, 1985 · N66H · Destroyed NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.Apr 29, 1984 · N3564A · Destroyed NTSB FTW82FPM16Accident · 1 fatalFinal reportMustang II · Tahlequah, OKThe amateur built Mustang ii crashed while attempting a roll during the annual tulsa fly-in at Tahlequah airport. The acft was observed making a hi-speed fly-by over runway 35 at approximately 50 ft AGL, and start a gradual climb & roll to the right to…Sep 25, 1982 · N48342 · Destroyed NTSB FTW79DPJ36Accident · No injuriesClosedPiper PA-22 · Pauls Valley, OKAug 21, 1979 · N652A · Destroyed NTSB FTW79DPJ11Accident · Minor injuriesClosedCougar 1976 · Ardmore, OKApr 15, 1979 · N5595 · Substantial damage NTSB FTW74DPJ19Accident · No injuriesClosedPiper PA-20 · Woodward, OKJan 14, 1974 · N1580A · Substantial damage NTSB FTW74FPJ09Accident · No injuriesClosedCessna 140A · Bethany, OKSep 3, 1973 · N1108D · Substantial damage NTSB FTW72DPJ06Accident · No injuriesClosedPiper PA-18 · Fort Sill, OKJul 31, 1971 · N6482D · Substantial damage NTSB FTW71DPJ47Accident · No injuriesClosedPiper PA-18 · Oklahoma Cty, OKJun 20, 1971 · N102T · Substantial damage NTSB FTW71FPM30Accident · No injuriesClosedPiper PA-20 · Wagoner, OKJun 6, 1971 · N6995K · Substantial damage NTSB FTW71DPJ21Accident · No injuriesClosedPiper PA-22 · Thomas, OKDec 3, 1970 · N8818C · Substantial damage NTSB FTW69F0224Accident · No injuriesClosedPiper PA-22 · Yukon, OKOct 1, 1968 · N1429C · Substantial damage NTSB FTW69F0174Accident · No injuriesClosedPiper PA-22 · Yukon, OKAug 31, 1968 · N1320C · Substantial damage NTSB FTW68F0213Accident · No injuriesClosedPiper PA-22 · Quinton, OKAug 27, 1967 · N1330C · Substantial damage NTSB UNK64X1090Accident · No injuriesClosedPiper PA20 · Mt View, OKMar 29, 1964 · N7446K · Substantial damage NTSB UNK64X1022Accident · No injuriesClosedPiper PA22 · Gage, OKMar 23, 1964 · N1456A · Substantial damage