Skip to content

NTSB investigations: Lycoming 0-290 series, KS

20 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.Jun 8, 2014 · N567CM · Substantial damage NTSB CEN10LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Wellington, KSA fire of undetermined cause that originated in the airplane's cabin.Jun 1, 2010 · N1821P · Destroyed NTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.Mar 10, 2008 · N1424A · Substantial damage NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.May 8, 2004 · N12JV · Substantial damage NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…Mar 25, 2000 · N9570E · 2 aircraft · Substantial damage NTSB MKC85LA054Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wa Keeney, KSAcft touched down left of centerline. Left main gear contacted slush on the rwy and the acft swerved into a 2 to 3 ft snowbank alongside the rwy. Plt stated, 'the rwy was plenty clear and the accident would not have happened if the plane had been kept on the…Jan 18, 1985 · N5590H · Substantial damage NTSB MKC80FA052Accident · No injuriesClosedGlobe GC-1B · Benton, KSAug 30, 1980 · N3859K · Substantial damage NTSB MKC77FCQ49Accident · Minor injuriesClosedPiper PA-22 · Larned, KSJul 25, 1977 · N3659A · Substantial damage NTSB MKC71FCQ20Accident · No injuriesClosedSmith DSA-1 · Goodland, KSSep 29, 1970 · N25P · Substantial damage NTSB MKC70DCQ22Accident · No injuriesClosedPiper PA-22 · Bird City, KSMay 20, 1970 · N9331D · Substantial damage NTSB MKC70D0253Accident · No injuriesClosedPiper PA-22 · Hutchinson, KSNov 3, 1969 · N1541P · Substantial damage NTSB MKC68F0065Accident · No injuriesClosedPiper PA-22 · Council Grve, KSJun 29, 1967 · N1497A · Substantial damage NTSB MKC67F0530Accident · Minor injuriesClosedPiper PA-22 · Valley Ctr, KSApr 2, 1967 · N833A · Substantial damage NTSB MKC66F0318Accident · Minor injuriesClosedPiper PA-22 · Salina, KSNov 12, 1965 · N1669A · Substantial damage NTSB MKC65F0143Accident · Minor injuriesClosedPiper PA-20 · Emporia, KSMay 26, 1965 · N1560A · Destroyed NTSB MKC65F0075Accident · No injuriesClosedPiper PA-20 · Clay Center, KSFeb 21, 1965 · N7305K · Substantial damage NTSB UNK65X0923Accident · No injuriesClosedPiper PA22 · Kansas City, KSDec 5, 1964 · N8298C · Substantial damage NTSB UNK64X2385Accident · No injuriesClosedPiper PA22 · Satanta, KSJun 20, 1964 · N3735A · Substantial damage NTSB UNK64X1820Accident · No injuriesClosedPiper PA22 · El Dorado, KSMay 18, 1964 · N892A · Substantial damage NTSB UNK64X1265Accident · No injuriesClosedPiper PA20 · Hays, KSApr 11, 1964 · N7475K · Substantial damage