Skip to content

NTSB investigations: Lycoming 0-540 series, MA

31 cases on aircraft whose registry engine model is Lycoming 0-540 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

19662026

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" = 'MA' 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 ('41532')) 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\" = 'MA' 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 ('41532'))
  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" = 'MA' 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 ('41532'))
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 ERA26LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Fitchburg, MAThe pilot’s improper landing flare, which resulted in a hard landing.May 26, 2026 · N6287T · Substantial damage NTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.Oct 31, 2021 · N2186U · Destroyed NTSB ERA20LA057Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Florida, MAThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation and a forced landing in a remote, wooded terrain.Dec 20, 2019 · N4726S · Substantial damage NTSB ATL07FA102Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Tyringham, MAThe pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…Jul 9, 2007 · N5595J · Substantial damage NTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.Jan 21, 2006 · N6278T · Substantial damage NTSB NYC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Taunton, MAa delayed decision by the pilot to abort the takeoff, which resulted in an overrun. A factor was false reading from the airspeed indicator.Jun 10, 1998 · N6977P · Substantial damage NTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesJun 28, 1993 · N3490W · Substantial damage NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.Aug 22, 1992 · N3985W · Substantial damage NTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…Jul 29, 1990 · N333EP · Destroyed NTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…Feb 28, 1988 · N5435P · Destroyed NTSB NYC85LA096Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsfield, MADuring a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered…Mar 31, 1985 · N386X · Substantial damage NTSB NYC81FNE25Accident · No injuriesClosedMaule M-5 · Pittsfield, MAAug 6, 1981 · N386X · Substantial damage NTSB NYC79FNA05Accident · No injuriesClosedPiper PA-28 · New Bedford, MADec 1, 1978 · N9436W · Substantial damage NTSB NYC78FA052Accident · 3 fatalClosedPiper PA-32 · Lawrence, MAMay 11, 1978 · N3893W · 2 aircraft · Destroyed NTSB NYC77FNE30Accident · No injuriesClosedPiper PA-32 · New Marlboroug, MAJul 11, 1977 · N3737W · Substantial damage NTSB NYC77FNA15Accident · No injuriesClosedPiper PA-24 · Plymouth, MAApr 10, 1977 · N5855P · Substantial damage NTSB NYC76FNA46Accident · No injuriesClosedPiper PA-32 · Tewksbury, MAJul 26, 1976 · N3893W · Substantial damage NTSB NYC75DNA48Accident · No injuriesClosedPiper PA-24 · Tewksbury, MAJun 24, 1975 · N5570P · Substantial damage NTSB NYC74FNA07Accident · No injuriesClosedPiper PA-24 · Vineyard Hav, MAJul 31, 1973 · N8659P · Substantial damage NTSB NYC73DNA45Accident · No injuriesClosedPiper PA-24 · S.Weymouth, MAApr 28, 1973 · N8430P · Substantial damage NTSB NYC72FNA45Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 17, 1972 · N7825P · Substantial damage NTSB NYC72FNA33Accident · No injuriesClosedPiper PA-24 · Norwood, MAFeb 15, 1972 · N7453P · Substantial damage NTSB NYC71FNA46Accident · No injuriesClosedPiper PA-23 · Norwood, MAApr 17, 1971 · N5376Y · Substantial damage NTSB NYC71FFD10Accident · No injuriesClosedPiper PA-28 · Marlboro, MAAug 21, 1970 · N8829W · Substantial damage NTSB NYC71FFM10Accident · No injuriesClosedIntermount A-9 · Southwick, MAAug 8, 1970 · N7217V · Substantial damage NTSB NYC70FFD16Accident · No injuriesClosedPiper PA-24 · Chatham, MAMay 24, 1970 · N7825P · Substantial damage NTSB NYC70AN116Accident · 3 fatalClosedPiper PA-32 · Stoughton, MAApr 24, 1970 · N3236W · Destroyed NTSB NYC69A0043Accident · No injuriesClosedPiper PA-24 · Northampton, MASep 29, 1968 · N8127P · Substantial damage NTSB NYC68D0352Accident · No injuriesClosedHelio H-250 · Beverly, MAJan 31, 1968 · N784HT · Substantial damage NTSB NYC68D0355Accident · No injuriesClosedPiper PA-28 · Beverly, MAJan 23, 1968 · N9241W · Substantial damage NTSB NYC67D0098Accident · No injuriesClosedPiper PA-24 · Norwood, MAAug 1, 1966 · N8291P · Substantial damage