Skip to content

NTSB investigations: Lycoming 0-290 series, IA

25 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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jul 24, 2026 · N27601 · Destroyed NTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.Apr 23, 2020 · N24DE · Substantial damage NTSB CEN11LA539Accident · Serious injuriesLimited investigationFinal reportHurley Richard A Cavalier SA102.5 · Salem, IAThe partial loss of engine power due to the formation of carburetor ice.Jul 29, 2011 · N115RH · Substantial damage NTSB CEN10CA323Accident · Serious injuriesData collectionFinal reportMcculley Ronald W-8 · Lamoni, IAThe non-certificated pilot's decision to attempt a takeoff that exceeded the airplane's performance capability, which resulted in an overrun.Jun 12, 2010 · N8519N · Substantial damage NTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.Sep 22, 1996 · N2982 · Substantial damage NTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.May 18, 1984 · N2390A · Substantial damage NTSB MKC84LA001Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cedar Rapids, IAThe plt reported that when he landed on rwy 13, the wind was from 170 deg at 10 gusting to 20 KTS. He said that about 30 ft beyond the touchdown point, a gust of wind picked up the right wing & the acft swerved to the right. Subsequently, the left main gear…Oct 1, 1983 · N7026K · Substantial damage NTSB MKC80DCD05Accident · No injuriesClosedPiper PA-22 · Des Moines, IAOct 27, 1979 · N8194C · 2 aircraft · Substantial damage NTSB MKC78FCD28Accident · Minor injuriesClosedJungster 1 · Monticello, IAMay 24, 1978 · N47M · Substantial damage NTSB MKC78FCD25Accident · Serious injuriesClosedPiper PA-11 · Terril, IAMay 23, 1978 · N78615 · Substantial damage NTSB MKC77DCD40Accident · No injuriesClosedPiper PA-22 · Pocahontas, IAAug 12, 1977 · N2371A · Substantial damage NTSB MKC72DCD48Accident · No injuriesClosedPiper PA-20 · Woodbine, IADec 10, 1971 · N7044K · Substantial damage NTSB MKC71DCD96Accident · No injuriesClosedPiper PA-23 · Newton, IAJun 27, 1971 · N8025C · Substantial damage NTSB MKC70DCD12Accident · No injuriesClosedPiper PA-22 · Maysville, IAJan 31, 1970 · N7742D · Substantial damage NTSB MKC70DCD13Accident · No injuriesClosedPiper PA-22 · Guthrie Cntr, IAJan 30, 1970 · N2692A · Substantial damage NTSB MKC70DCD18Accident · No injuriesClosedPiper PA-18 · Clarinda, IADec 8, 1969 · N1387A · Substantial damage NTSB MKC70D0013Accident · No injuriesClosedPiper PA-22 · Des Moines, IAJun 8, 1969 · N3739A · Substantial damage NTSB MKC69D0365Accident · No injuriesClosedPiper PA-22 · Ankeny, IAMar 1, 1969 · N1209C · Substantial damage NTSB MKC69D0034Accident · Minor injuriesClosedEaa Biplane P · Rock Rapids, IAJul 5, 1968 · N1781 · Substantial damage NTSB MKC68D0397Accident · No injuriesClosedPiper PA-22 · Forest City, IADec 24, 1967 · N2655A · Substantial damage NTSB MKC67D0477Accident · No injuriesClosedPiper PA-22 · Denison, IAMar 28, 1967 · N3415A · Substantial damage NTSB MKC66D0276Accident · No injuriesClosedPiper PA-22 · Algona, IAOct 5, 1965 · N3386A · Substantial damage NTSB UNK64X1681Accident · No injuriesClosedPiper PA22 · Davenport, IAMay 9, 1964 · N2297A · Substantial damage NTSB UNK64X1399Accident · No injuriesClosedPiper PA22 · Davenport, IAApr 21, 1964 · N3202B · Substantial damage NTSB UNK64X1223Accident · No injuriesClosedPiper PA22 · Traer, IAApr 8, 1964 · N8871C · Substantial damage