Skip to content

NTSB investigations: Lycoming 0-290 series, IL

30 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.Jul 21, 2021 · N3S · Substantial damage NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.Jul 2, 2005 · N47111 · Substantial damage NTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.Sep 8, 2003 · N615A · Substantial damage NTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.Jun 30, 2002 · N1419 · Substantial damage NTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.Jun 6, 1993 · N8236C · Substantial damage NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.Jun 13, 1992 · N4PV · Destroyed NTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.May 21, 1992 · N6989K · Substantial damage NTSB CHI87DEV03Accident · No injuriesFinal reportPiper PA-22 · Roanoke, ILAfter developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was…Aug 2, 1987 · N7958A · Substantial damage NTSB CHI87LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Rockford, ILDuring landing roll, plt applied brakes too hard at high speed and nosed over.Nov 16, 1986 · N1457A · Destroyed NTSB CHI85LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Plainfield, ILRight wing of acft was lifted by wind while taxiing after landing. Plt was taxiing south then made turn into tie down area when accident occurred. Flaps were down and control wheel was held forward with left aileron input. Acft flipped over. Plt recommended,…Nov 22, 1984 · N2381A · Substantial damage NTSB CHI83LA352Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Pittsfield, ILThe student plt was on a personal flt with a passenger on board. During arrival, he landed on rwy 25 (1700 ft long) with a x-wind from 160 deg at 8 KTS. He reported that the landing was made on his 2nd attempt, but he did not get on the ground soon enough to…Aug 2, 1983 · N111BT · Substantial damage NTSB CHI81DEE52Accident · No injuriesClosedPitts S1C · Lockport, ILSep 6, 1981 · N56ST · Substantial damage NTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · Destroyed NTSB CHI78FEV41Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 28, 1978 · N7323K · Substantial damage NTSB CHI78DEV31Accident · No injuriesClosedMustang P-51 · Gibson City, ILApr 29, 1978 · N37952 · Substantial damage NTSB CHI77FEV39Accident · No injuriesClosedStits Plyboy · Beardstown, ILJul 23, 1977 · N46834 · Substantial damage NTSB CHI75FEE26Accident · No injuriesClosedPiper PA-18 · Huntley, ILSep 29, 1974 · N6063V · Substantial damage NTSB CHI72FEE82Accident · 1 fatalClosedLowers Bird · Crystal Lake, ILJun 15, 1972 · N591T · Destroyed NTSB CHI72FEV12Accident · Serious injuriesClosedSmith-Mini DSA-1 · Smithfield, ILAug 15, 1971 · N175N · Substantial damage NTSB CHI71FBQ11Accident · Minor injuriesClosedPiper PA-18A · Gibson City, ILAug 12, 1970 · N1825A · Substantial damage NTSB CHI68F0706Accident · Minor injuriesClosedPiper PA-22 · Kankakee, ILApr 14, 1968 · N2294A · Substantial damage NTSB CHI68D0242Accident · No injuriesClosedPiper PA-22 · Pekin, ILAug 13, 1967 · N8023C · Substantial damage NTSB CHI67D0580Accident · No injuriesClosedPiper PA-20 · Mt Vernon, ILMar 18, 1967 · N7089K · Substantial damage NTSB CHI66D0700Accident · No injuriesClosedPiper PA-22 · Galva, ILMay 5, 1966 · N3317A · Substantial damage NTSB CHI67D0054Accident · No injuriesClosedPiper PA-20 · Joliet, ILMay 2, 1966 · N7430K · Substantial damage NTSB CHI66F0074Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 6, 1965 · N7622K · Substantial damage NTSB CHI65F0113Accident · No injuriesClosedPiper PA-22 · Tinley Park, ILMar 15, 1965 · N2297A · Substantial damage NTSB CHI65F0189Accident · No injuriesClosedPiper PA-22 · Donovan, ILJan 26, 1965 · N3307B · Substantial damage NTSB UNK64X2810Accident · No injuriesClosedPiper PA22 · Iola, ILJul 13, 1964 · N879A · Substantial damage NTSB UNK64X0834Accident · No injuriesClosedPiper PA22 · East Moline, ILMar 7, 1964 · N8816C · Substantial damage