Skip to content

NTSB investigations, MA

30 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351)
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 NYC05LA071Accident · No injuriesLimited investigationFinal reportBrennan Flightstar · Middleboro, MAA loss of engine power for undetermined reasons.Apr 16, 2005 · N125KM · Substantial damage NTSB NYC04LA014Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Athol, MAThe loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.Oct 21, 2003 · N3419S · Substantial damage NTSB NYC03LA204Accident · Serious injuriesLimited investigationFinal reportLaBarge Titan Tornado I · Charlton, MAA seizure of the forward piston during the initial climb.Sep 24, 2003 · UNREG · Substantial damage NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.Oct 15, 2000 · N4381S · Substantial damage NTSB NYC99IA239Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Nantucket, MAA fractured turbine wheel.Sep 26, 1999 · N666K · Minor damage NTSB NYC98LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Gt. Barrington, MAslippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.Oct 1, 1997 · N29134 · Substantial damage NTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.Nov 21, 1996 · N4926G · Substantial damage NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.Jul 5, 1996 · N131AC · Substantial damage NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…May 28, 1996 · N19708 · Substantial damage NTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.Mar 30, 1996 · N57012 · Destroyed NTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.Nov 26, 1995 · N344C · Substantial damage NTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.Jun 15, 1994 · N8029Z · Substantial damage NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.Jul 30, 1992 · N1073P · Substantial damage NTSB NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.Jul 22, 1991 · N54819 · Substantial damage NTSB NYC91FA178Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Yarmouth, MAThe failure of the number one cylinder fuel injector line due to fatigue cracking induced by corrosion and propagated by cyclic loading which resulted in a total loss of engine power. The corrosion was due to the manufacturer's process of brazing the metal…Jul 13, 1991 · N36272 · Destroyed NTSB NYC90LA208Accident · No injuriesLimited investigationFinal reportPiper J5 CUB · Douglas, MAA total engine failure when the #3 exhaust valve failed, causing internal damage to the engine. Factors related to the accident were: the pilot had to make a forced landing in unsuitable terrain.Aug 31, 1990 · N38428 · Substantial damage NTSB NYC90FA199Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Mattapan, MAThe pilot's improper in-flight planning/decision, which resulted in his failure to maintain control of the aircraft. Factors related to the accident were: failure of the left fuel control unit, and the adverse weather conditions.Aug 24, 1990 · N85HB · Destroyed NTSB NYC90LA122Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Becket, MAA power loss due to oil starvation, after maintenance personnel failed to comply with Lycoming directives during the engine overhaul. Factors related to the accident were: improper adjustment of the engine oil pressure by maintenance personnel and unsuitable…May 31, 1990 · N39268 · Substantial damage NTSB NYC90LA074Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, MAAn off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.Mar 3, 1990 · N34873 · Substantial damage NTSB NYC90LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Worcester, MAA power loss due to an oil pump failure while operating over unsuitable terrain. A factor related to the accident was night conditions.Feb 14, 1990 · N763DS · Substantial damage NTSB NYC88LA016Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Barre, MAThe aircraft was in the traffic pattern when it experienced a power loss. The plt made an off-airport landing in a wooded area. The pilot reported that he was in a slip prior to and at the time of the reported power loss. The FAA reported that the engine…Oct 25, 1987 · N333FG · Substantial damage NTSB NYC86FA234Accident · Serious injuriesField investigationFinal reportCessna U206F · Holoyoke, MAWhile en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.…Sep 11, 1986 · N8316Q · Substantial damage NTSB NYC84FA072Accident · 1 fatalField investigationFinal reportCessna 152 · Barre, MAThe acft was landed off the arpt tailing fire and smoke shortly after takeoff. It was a cold day and the CFI and student had trouble starting the acft even after pre-heat was used. Witnesses saw the acft after takeoff descending withsmoke and flames trailing…Jan 22, 1984 · N5536L · Destroyed NTSB NYC83FNA04Accident · No injuriesFinal reportSikorsky H-19D · Halifax, MAAfter arriving at the field to be sprayed, the plt initiated a descent to begin aerial application. At aprx 40 ft AGL & 50 KTS, the eng failed. The plt entered an autorotation, but could not avoid telephone wires. He was able to avoid hitting a dike, but in…Aug 3, 1983 · N37799 · Substantial damage NTSB NYC83LA112Accident · No injuriesLimited investigationFinal reportForney F-1 · Fitchburg, MAThe acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…May 14, 1983 · N7528C · Substantial damage NTSB NYC83FNA02Accident · No injuriesFinal reportRogers Long EZ · Fall River, MAThe plt reported that during flt, the eng lost power. He moved the carburetor heat control to apply carb heat & tried to start the eng, but was unable. He then tried to land on a road, but crashed in a wooded area before reaching the roadway. An investigation…May 11, 1983 · N245R · Substantial damage NTSB NYC83LA100Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Ashley Falls, MAThe pilot stated that he was about a half mile from the airport when the engine quit. He restarted it but it quit a 2nd time and would not restart. By this time the acft was down to about 200 ft. a right turn was made to land on an island. The acft landed…Apr 23, 1983 · N86948 · Substantial damage NTSB NYC82DA223Accident · No injuriesFinal reportBeech B23 · West Yarmouth, MAAbout 30 min after takeoff, the engine lost power at about 1000 ft AGL when the pilot added power to climb. He was unable to restart the engine and elected to land along the shoreline. During the approach, the aircraft collided with power lines. Reportedly,…Sep 11, 1982 · N7674R · Substantial damage NTSB NYC82FNE04Accident · Serious injuriesFinal reportBellanca 7KCAB · Agawam, MAWhile setting up to land on rwy 23, the plt throttled back the eng & it quit. The acft crashed into a wooded area approximately 1/4 mi from the end of the rwy. During the post-accident eng run, the eng would not maintain 700 RPM at idle (manufacturers…Jul 31, 1982 · N57507 · Destroyed NTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…Mar 29, 1982 · N1104Q · Substantial damage