Skip to content

NTSB investigations: Lycoming 0-290 series, NY

27 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA19FA196Accident · 1 fatalClass 3 · FieldFinal reportTrella T-21 · Endicott, NYA partial loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack during an attempted return to the runway, which resulted in an aerodynamic stall/spin at an altitude that…Jun 17, 2019 · N450C · Substantial damage NTSB GAA19CA293Accident · No injuriesData collectionFinal reportPiper PA 20 · Canandaigua, NYThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.May 6, 2019 · N7046K · Substantial damage NTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.Sep 15, 2017 · N1356W · Substantial damage NTSB ERA12CA475Accident · No injuriesData collectionFinal reportPiper PA-20 · Cooperstown, NYThe pilot's inadequate compensation for crosswind conditions during takeoff, which resulted in a loss of directional control.Jul 21, 2012 · N7465K · Substantial damage NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.Oct 8, 1999 · N9964Q · Substantial damage NTSB NYC96LA109Accident · Minor injuriesLimited investigationFinal reportMcCall WATCHA-MCCALL-IT · Steamburg, NYthe pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…May 18, 1996 · N111MC · Substantial damage NTSB BFO93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boonville, NYThe pilot failed to compensate for wind conditions and encountered a stall. The windshear was a factor.Feb 28, 1993 · N1554P · Substantial damage NTSB NYC83LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Olean, NYThe acft nosed over during taxi after landing when the acft went off the runway into soft dirt. The student pilot had completed a cross-country flight without incident. After landing during taxi at Olean, NY the pilot applied brakes and the acft swerved to…May 23, 1983 · N3777A · Substantial damage NTSB NYC82FHM06Accident · 1 fatalFinal reportSpezio Sport DAL-1 · Lagrange, NYThe owner/pilot of the aircraft was a photographer with an amputation above his left wrist. His class iii medical certificate stated that he must wear an artifical limb while flying. The pilot had been asked to photograph a building in an industrial park.…Apr 25, 1982 · N1796 · Destroyed NTSB NYC82DFJ07Accident · No injuriesClosedSpezio DAL-1 · Ceres, NYNov 3, 1981 · N14921 · Substantial damage NTSB NYC77FFJ16Accident · No injuriesClosedPiper PA-22 · Angola, NYApr 13, 1977 · N8637C · Substantial damage NTSB NYC75FFA04Accident · No injuriesClosedPiper PA-18 · Three Mile Bay, NYJul 14, 1974 · N288NY · Substantial damage NTSB NYC72DFJ31Accident · Minor injuriesClosedPiper PA-20 · Lancaster, NYMar 12, 1972 · N7636K · Substantial damage NTSB NYC72DFJ21Incident · No injuriesClosedPiper PA-22 · Central Sq, NYOct 15, 1971 · N1549P · Minor damage NTSB NYC72FFA17Accident · Minor injuriesClosedPiper PA-12 · Adams, NYSep 22, 1971 · N3863M · Substantial damage NTSB NYC72FFJ07Accident · No injuriesClosedPiper PA-20 · Palmyra, NYJul 27, 1971 · N6984K · Substantial damage NTSB NYC71DFA32Accident · No injuriesClosedPiper PA-18 · Old Forge, NYDec 27, 1970 · N1198C · Substantial damage NTSB NYC71DFA23Accident · No injuriesClosedPiper PA-18A · Newcomb, NYOct 8, 1970 · N1551P · Substantial damage NTSB NYC70D0115Accident · No injuriesClosedPiper PA-25 · Orient, NYAug 6, 1969 · N8001C · Substantial damage NTSB NYC69F0294Accident · No injuriesClosedPiper PA-22 · Amityville, NYJan 5, 1969 · N3502A · 2 aircraft · Substantial damage NTSB NYC69F0063Accident · Minor injuriesClosedPiper PA-22 · Akron, NYJul 18, 1968 · N846A · Substantial damage NTSB NYC69D0006Accident · Minor injuriesClosedPiper PA-22 · Old Forge, NYJun 2, 1968 · N2376A · Substantial damage NTSB NYC67F0109Accident · No injuriesClosedPiper PA-22 · Bethpage, NYJul 9, 1966 · N3341A · Substantial damage NTSB NYC66D0521Accident · No injuriesClosedPiper PA-22 · Olean, NYFeb 10, 1966 · N3777A · Substantial damage NTSB UNK65X0720Accident · No injuriesClosedPiper PA22 · Montauk, NYNov 15, 1964 · N2352A · Substantial damage NTSB UNK64X3280Accident · No injuriesClosedPiper PA22 · Staten Island, NYAug 8, 1964 · N3663A · Substantial damage NTSB UNK64X1808Accident · No injuriesClosedPiper PA22 · Albany, NYMay 17, 1964 · N3339B · Substantial damage