Skip to content

NTSB investigations: Lycoming 0-290 series, IN

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN21LA469Accident · Minor injuriesClass 4 · LimitedFinal reportMeuer SA900 V-STAR · Kokomo, INThe pilot’s failure to maintain adequate speed and altitude during final approach, which resulted in an off field landing short of the runway and a subsequent nose over.Sep 30, 2021 · N675MM · Substantial damage NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.Nov 12, 2020 · N3535A · Substantial damage NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.Apr 7, 2017 · N2389A · Substantial damage NTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.Dec 30, 2012 · N641TD · Substantial damage NTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.May 17, 2008 · N1601P · Substantial damage NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.Sep 1, 2000 · N3383A · Substantial damage NTSB CHI99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-L21B · Vincennes, INthe pilot's failure to maintain directional control after landing. Factors which contributed to this accident were the pilot's long touchdown, the rough area on the runway, and the wheat field.May 10, 1999 · N3VU · Substantial damage NTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.Oct 5, 1996 · N5749H · Destroyed NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.Aug 16, 1996 · N2309A · Substantial damage NTSB CHI87DEX02Accident · Minor injuriesFinal reportRohdecap/Thorp T-18 · Elwood, INThe plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft…Nov 22, 1986 · N2433 · Substantial damage NTSB CHI85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Zionsville, INThe plt stated that she flared slightly high upon landing, causing the acft to bounce. Once the acft was on the ground again it began to drift to the left side of the rwy. To correct for this drift, the plt applied right rudder, however, she overcorrected…Mar 25, 1985 · N7629K · Substantial damage NTSB CHI83LA268Accident · No injuriesLimited investigationFinal reportHomebuilt Baby Great Lakes · Lebanon, INThe acft landing gear collapsed and the acft nosed over after the engine quit due to fuel starvation. The engine lost power in a steep climb of at least a 45 deg angle and could not be restarted. The fuel flows to the engine by gravity. In a steep climb the…Jun 17, 1983 · N35JR · Substantial damage NTSB CHI82DA170Accident · Serious injuriesFinal reportPlaymate SA11A · Pendleton, INThe pilot was cruising at 2000 feet with one passenger when the engine quit. He made a forced landing in a soft soybean field and the aircraft nosed over during deceleration. The aircraft revealed the exhaust system baffles were collapsed. "Blow by" was…May 15, 1982 · N4652 · Substantial damage NTSB CHI79DEX18Accident · No injuriesClosedPiper PA-18 · Spencer, INMar 24, 1979 · N3VU · Substantial damage NTSB CHI79FET04Accident · 2 fatalClosedMonocoupe 90A · Mentone, INNov 4, 1978 · N18062 · Destroyed NTSB CHI79FA009Accident · 4 fatalClosedPiper PA-22 · Tell City, INOct 17, 1978 · N3427A · 2 aircraft · Destroyed NTSB CHI78FET32Accident · Minor injuriesClosedPitts S-1C · Lake Village, INAug 5, 1978 · N170H · Substantial damage NTSB CHI77FEX51Accident · Minor injuriesClosedAcrosport 1 · Indianapolis, INSep 25, 1977 · N15HS · 2 aircraft · Substantial damage NTSB CHI75FEG13Accident · No injuriesClosedPiper PA-22 · Union City, INFeb 2, 1975 · N1528P · Substantial damage NTSB CHI73DEA42Accident · No injuriesClosedPiper PA-20 · Portland, INJun 25, 1973 · N8290C · Substantial damage NTSB CHI71DEA38Accident · No injuriesClosedPiper PA-20 · Seymour, INMay 30, 1971 · N7430K · Substantial damage NTSB CHI69F0165Accident · Minor injuriesClosedPiper PA-22 · Ossian, INAug 7, 1968 · N2373A · Substantial damage NTSB CHI68F0760Accident · Minor injuriesClosedCallair A-2 · New Haven, INApr 28, 1968 · N33351 · Substantial damage NTSB CHI68D0080Accident · No injuriesClosedPiper PA-22 · Indianapolis, INJun 26, 1967 · N3322A · Substantial damage NTSB CHI67D0013Accident · No injuriesClosedPiper PA-22 · Indianapolis, INMay 25, 1967 · N3732A · Substantial damage NTSB CHI67F0461Accident · No injuriesClosedPiper PA-22 · Elkhart, INJan 3, 1967 · N8717C · Substantial damage NTSB CHI67D0158Accident · No injuriesClosedPiper PA-22 · Mooresville, INAug 20, 1966 · N879A · Substantial damage NTSB CHI67D0075Accident · No injuriesClosedPiper PA-22 · Windfall, INMay 28, 1966 · N2373A · Substantial damage NTSB CHI66F0313Accident · No injuriesClosedPiper PA-22 · Clermont, INSep 6, 1965 · N8502C · Substantial damage NTSB UNK64X0652Accident · No injuriesClosedPiper PA22 · Indianapolis, INFeb 22, 1964 · N3314A · Substantial damage