Skip to content

NTSB investigations: Lycoming 0-290 series, OH

26 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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 ERA24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Georgetown, OHAn inadvertent encounter with the rotor wash of a nearby hovering helicopter during landing, which resulted in a loss of control and a runway excursion.May 2, 2024 · N8290C · Substantial damage NTSB CEN20LA063Accident · Serious injuriesClass 3 · LimitedFinal reportPiel CP301 · Paulding, OHThe pilot’s failure to maintain control of the airplane following the loss of engine power. The loss of engine power was the result of fuel starvation due to the degraded fuel tank and fuel contamination.Jan 17, 2020 · N4120 · Destroyed NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.Jun 15, 2018 · N8273C · Substantial damage NTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.Aug 31, 2011 · N10365 · Substantial damage NTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · Destroyed NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.Dec 13, 2005 · N290DM · Substantial damage NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.Feb 9, 2002 · N2254A · Substantial damage NTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.Apr 15, 2000 · N13545 · Substantial damage NTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.May 30, 1989 · N2124A · Destroyed NTSB ATL87DEI04Accident · Minor injuriesFinal reportButler EAA Biplane 1 · Orrville, OHAcft lost power and was landed in a corn field. Left main gear collapsed and acft flipped onto its back. Mixture cable set screw on carburetor was found loose allowing mixture to vibrate to lean position. Earlier in the day the PIC had replaced the carburetor.May 23, 1987 · N11TB · Substantial damage NTSB CHI83LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Lisbon, OHDuring takeoff, the eng lost power when the acft was climbing thru aprx 150 ft AGL. The plt attempted to maneuver back to the airport. Reportedly, he had insufficient altitude to clear over 60 ft trees near the end of the rwy. There was extensive damage to…Jan 28, 1983 · N17DA · Substantial damage NTSB CHI78FEI31Accident · No injuriesClosedPiper PA-20 · Cadiz, OHJul 28, 1978 · N7606K · Substantial damage NTSB CHI78FEI05Accident · No injuriesClosedPiper PA-18 · Smithville, OHDec 18, 1977 · N46891 · Substantial damage NTSB CHI76FEI05Accident · No injuriesClosedCougar TY-1 · Northfield, OHJul 22, 1975 · N6510D · Substantial damage NTSB CHI74FEI46Accident · Minor injuriesClosedPiper PA-20 · Fremont, OHJun 19, 1974 · N7335K · Substantial damage NTSB CHI74DEI11Accident · No injuriesClosedPiper PA-22 · Norwalk, OHOct 31, 1973 · N2573A · Destroyed NTSB CHI71FGA03Accident · No injuriesClosedSmith Mini DSA-1 · Trotwood, OHJul 12, 1970 · N9071 · Substantial damage NTSB CHI70D0113Accident · No injuriesClosedPlayboy SA-3A · Brookville, OHJul 13, 1969 · N4747G · Substantial damage NTSB CHI69F0344Accident · Serious injuriesClosedPiper PA-22 · Darby Dale, OHNov 8, 1968 · N8895C · Substantial damage NTSB CHI68D0044Accident · No injuriesClosedMong Sport MS-2 · Phillipsburg, OHJun 25, 1967 · N570A · Substantial damage NTSB CHI67F0409Accident · Serious injuriesClosedPiper PA-20 · Prt Columbus, OHJan 5, 1967 · N7371K · Substantial damage NTSB CHI67D0356Accident · Minor injuriesClosedPiper PA-20 · No.Jackson, OHMay 28, 1966 · N7002K · Substantial damage NTSB CHI66D0591Accident · No injuriesClosedPiper PA-22 · Wooster, OHFeb 26, 1966 · N2616A · Substantial damage NTSB CHI66A0049Accident · 1 fatalClosedPiper PA-18 · New Carlisle, OHNov 14, 1965 · N1532V · 2 aircraft · Substantial damage NTSB UNK65X1223Accident · Minor injuriesClosedPiper PA22 · Prospect, OHJan 3, 1965 · N8590C · Substantial damage NTSB UNK64X0173Accident · No injuriesClosedPiper PA22 · Toledo, OHJan 5, 1964 · N8545C · Substantial damage