NTSB investigations, MA

69 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases, newest first

Query with SQL
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\" = 353)
  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.

NTSB NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…Nov 4, 1987 · N53461 · Substantial damageNTSB NYC88LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Pepperell, MAA student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…Oct 24, 1987 · N310DW · Substantial damageNTSB NYC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weston, MADrg a night arrival, when the acft was apchg the boston tca, the plt dscndd to 1000 ft. as he was leveling off, he noted a power loss & was unable to reach the destn arpt. He identified a field & initiated an emerg landing. Drg the apch, the acft struck power…Oct 10, 1987 · N8391A · DestroyedNTSB NYC87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tewksbury, MAThe pilot switched the fuel selector from what he thought was the left tank to both while on final approach. He then decided to make a go-around during the flare because he felt his a/s was to fast. The engine quit at 40 ft AGL during the go-around. He was…Jun 18, 1987 · N53060 · DestroyedNTSB NYC87LA057Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Marston Mills, MAThe flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of…Jan 9, 1987 · N5571C · Substantial damageNTSB NYC87LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Leominster, MAThe Piper PA-28-181 departed on a cross country flight with full tanks (48 gal) according to the pilot. Enroute the pilot experienced a power loss at night after flying for 3.9 hours. The pilot landed in a residential area and struck a house on landing roll.…Dec 27, 1986 · N8720C · Substantial damageNTSB NYC86LA238Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashburnham, MAWhile crusing at an altitude of about 3500 feet, the flight suffered fuel exhaustion and lost engine power causing the pilot to execute a forced landing in a field.Sep 16, 1986 · N6344S · Substantial damageNTSB NYC86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dennis Port, MAAccording to the plt, he was flying at an alt of 800 ft along the coastline during an aerial advertising flt and was switching from the right fuel tank to the left when the eng lost power. The acft was then ditched in 14 foot deep water. Post accident…Aug 31, 1986 · N3841P · Substantial damageNTSB NYC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Beverly, MAThe acft made a forced landing after the engine vibrated and lost power. The plt said that the fuel gages were checked and indicated 1/4 full. The plt said he switched fuel tanks but the engine did not improve its performance. The plt thenaccomplished the…Jul 21, 1984 · N15963 · Substantial damageNTSB NYC84FA240Accident · 2 fatalField investigationFinal reportMBB BO-105C · Rehobeth, MAThe messerschmitt-blohm-boelkow BO-105C was on an air ambulance flt with a plt, 2 additional crewmembers (doctor & nurse) & a passenger (patient) on board. During flt, the plt radioed that he had lost power in 1 eng, then about 14 sec later, he radioed that…Jul 15, 1984 · N105CP · DestroyedNTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…Jul 8, 1984 · N1257P · Substantial damageNTSB NYC84FA180Accident · 1 fatalField investigationFinal reportBeech D-45 · Taunton, MAN812Z crashed in a wooded area about one mile southeast of the Taunton municipal airport. Witnesses in the area observed the acft prior to the crash. One witness saw what appeared to be yellow smoke coming from the bottom of the acft. Some of the witnesses…May 22, 1984 · N812Z · DestroyedNTSB NYC84FNE01Accident · Minor injuriesFinal reportPiper PA-28-151 · Southwick, MAThe acft lost power & made an emergency forced landing in a school yard. Investigation revealed that only a few drops offuel remained in the powerplant & 1QT plus 1PT remained in the wing tanks with none in the gasolator. There was no evidence of fuel leakage…Jan 2, 1984 · N44386 · Substantial damageNTSB NYC83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Pittsfield, MAOn the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off…Jun 29, 1983 · N6638Y · Substantial damageNTSB NYC83LA108Accident · No injuriesLimited investigationFinal reportBellanca 7GBC · Middleboro, MAThe acft landed short of the runway after experiencing a power loss on the approach. The pilot had carburetor heat on and when he experienced a downdraft on final he said he opened the throttle and the engine quit. The acft was landed in the bushes short of…Apr 18, 1983 · N4163Y · Substantial damageNTSB NYC83LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Norfolk, MAThe acft crash landed shortly after takeoff and was destroyed. The student pilot stated that after clearing the runway on his last takeoff of the day the engine hesitated and stopped. He lowered the nose to a glide speed of 70 mph picked aspot to land and…Apr 14, 1983 · N19435 · Substantial damageNTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…Apr 9, 1983 · N26182 · Substantial damageNTSB NYC83FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Plymouth, MAThe aircraft had been repossessed. The purpose of the flight was for the pilot to demonstrate it to one or both of the other occupants. Prior to this flight, the aircraft had not been flown since 5/20/82. During takeoff, the engine lost power at about 200 ft…Nov 19, 1982 · N9103J · DestroyedNTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…Feb 10, 1982 · N84330 · Substantial damage