Skip to content

NTSB investigations: Lycoming 0-290 series, AR

18 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…Feb 26, 2026 · N30P · Destroyed NTSB GAA18CA442Accident · No injuriesData collectionFinal reportChampion 7GC · Warren, ARThe pilot’s failure to maintain directional control during landing.Jul 14, 2018 · N2127C · Substantial damage NTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.Jan 31, 2012 · N2677A · Substantial damage NTSB FTW99FA171Accident · 1 fatalField investigationFinal reportHeilig-Reading Emeraude CP 301A · Altus, ARThe pilot's failure to maintain clearance with a wire, during an approach to a private airstrip.Jun 18, 1999 · N3751 · Substantial damage NTSB FTW98FA101Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Wooster, ARthe pilot's failure to maintain clearance with trees during an aborted landing. A contributing factor was the pilot's delayed decision to abort the long landing.Jan 16, 1998 · N99302 · Destroyed NTSB FTW98LA087Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Roland, ARThe pilot's inadvertent encounter with soft, wet grass during landing.Jan 4, 1998 · N87SD · Substantial damage NTSB FTW96LA308Accident · No injuriesLimited investigationFinal reportDearinger Duce · Corning, ARThe pilot's failure to arrest his rate of descent and his improper recovery from a bounced landing.Jul 16, 1996 · N85JD · Substantial damage NTSB FTW96LA301Accident · No injuriesLimited investigationFinal reportMyers Smythe Sidewinder · El Dorado, ARthe pilot's failure to attain the correct touchdown point. Factors were: hydroplaning due to the wet runway, and the berm in the overrun area.Jul 6, 1996 · N112AM · Substantial damage NTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.Apr 15, 1995 · N4842E · Substantial damage NTSB FTW83LA236Accident · No injuriesLimited investigationFinal reportPiper J3 · Sherrill, ARThe acft nosed over on an emergency downwind landing in a wet rice field after an eng failure. The plt stated that the eng failed as a result of water in the fuel. The operator services his acft from a private underground fuel storage tank. As a result of…May 16, 1983 · N42563 · Substantial damage NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB FTW73FPG13Accident · No injuriesClosedPiper PA-20 · Booneville, ARAug 13, 1972 · N6988K · Substantial damage NTSB FTW72FPG69Accident · No injuriesClosedChampion 7GC · Flippin, ARMay 6, 1972 · N8945R · Substantial damage NTSB FTW71DPG65Accident · No injuriesClosedPiper PA-12 · Bismark, ARJun 27, 1971 · N3687N · Substantial damage NTSB FTW71FPG57Accident · Minor injuriesClosedPiper PA-22 · Mcgehee, ARMay 20, 1971 · N8894C · Substantial damage NTSB FTW67D0011Accident · No injuriesClosedPiper PA-12 · Salem, ARJun 5, 1966 · N3687N · Substantial damage NTSB FTW66F0248Accident · No injuriesClosedPiper PA-22 · Spring Hill, ARAug 22, 1965 · N1840A · Substantial damage NTSB UNK64X3884Accident · Minor injuriesClosedPiper PA22 · Melbourne, ARSep 9, 1964 · N678A · Substantial damage