NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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.\"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."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 ATL82DA275Accident · Minor injuriesFinal reportCessna 172F · Millry, ALThe pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.…NTSB FTW82DA377Accident · No injuriesFinal reportCessna P210N · Gage, NMWhile on a VFR cross-country flight from tucson, AZ to roswell, NM, the engine failed and the pilot made an emergency landing in the desert. The engine teardown revealed that the oil passage which feeds the number 2 and 3 main bearing journals had not been…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,…NTSB ATL82DA268Accident · No injuriesFinal reportCessna 188 · Nashville, GAThe engine failed while the acft was enroute to spray a soybean crop. Deposits of dirt & sediment were found in the fuel control assembly body screen.NTSB DEN82DA199Accident · No injuriesFinal reportCessna 175 · Hulett, WYThe pilot reported that during flight the engine began to run rough. He diverted toward a nearby airstrip, but while en route, there was a "bang" and smoke began entering the cabin. At that point, he shut off the fuel, magnetos and master switch, then lost…NTSB CHI82DA349Accident · No injuriesFinal reportBensen BM8 · Zilwauker, MIDuring flight at about 1500 ft AGL, the aircraft engine lost power. The pilot made a steep approach to land in a small field surrounded by power lines. He stated that during an extreme flare to stop the forward flight, the main rotor blades hit the ground and…NTSB CHI82DA348Accident · No injuriesFinal reportCessna 172M · Cheboygan, MIThe flight was being conducted over the waters of lake huron when engine stoppage occurred. Unable to glide to the airport the pilot ditched the aircraft on the shoreline in the water. The post-accident investigation revealed that the foam rubber from the air…NTSB SEA82AA155Accident · 2 fatalFinal reportPiper PA-32-300 · 23 Mi Ene Toutl, WAWhile on a sightseeing flt in the Mt. St.helens national volcanic monument area the acft crashed on the mud flats of the north fork of the toutle river in a relatively flat & open area. There were indications of a massive oil leak from the eng area in flight.…NTSB FTW82DPD18Accident · Serious injuriesFinal reportBennet VP-1 · Fort Worth, TXEngine quit after takeoff and aircraft stalled during forced landing in tall weeds. Bendix zenith carburetor acceleration pump rubber cover was deteriorated, sucking in air.NTSB LAX82DA331Accident · No injuriesFinal reportPiper 601P · Burbank, CADuring lift-off the right engine failed. The takeoff was aborted & the plt swerved the acft to avoid a blast fence at the end of the rwy. The left main landing gear failed & the acft collided with the fence. Maintenance records revealed a total of 12…NTSB ATL82DA264Accident · No injuriesFinal reportPiper PA-28R · Sewanee, TNEnroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at…NTSB ANC82FA081Accident · No injuriesField investigationFinal reportde Havilland DHC-3 · Near Skwentna, AKThe acft experienced a power loss & a forced landing was made on a sandbar. During the landing roll the acft struck a log, folding the main gear. Eng teardown revealed a failed no.4 articulating rod. The rod separated just above the knuckle pin area.NTSB SEA82FA149Accident · Minor injuriesField investigationFinal reportCessna T207A · Boise, IDBefore takeoff, the pilot filed a company flight plan for a VFR flight from Boise to salmon, ID. He reported that during initial climb, the engine surged, then seemed to return to normal operation. He reduced the power to 33 inches of manifold pressure and…NTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…NTSB FTW82DA351Accident · No injuriesFinal reportAir Tractor AT-400 · Alvin, TXThe pilot had finished spraying a field and was surveying another field for his next day operation when the aircraft engine flamed out. He landed the aircraft in a soybean field and ground-looped the aircraft to prevent hitting trees at the edge of the field.…NTSB ATL82DA252Accident · No injuriesFinal reportGrumman G-164C · Gunnison, MSThe pilot reported that he smelled something hot while spraying. He checked the instruments and noted that the oil temperature gauge was indicating off the high side of the scale. He started to make a precautionary landing but the engine seized during final…NTSB FTW82DA350Accident · No injuriesFinal reportAir Tractor AT-301 · Winnesboro, LAThe pilot was circling the field during alignment for his initial swath run when the aircraft engine failed. During the forced landing the aircraft nosed over and the pilot exited the aircraft without turning off any switches. He stated that fuel was leaking…NTSB LAX82IA309Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30F · Honolulu, HIAt rotation, the fire bell and the #2 engine fire warning light came on and the crew noted a power loss on the #2 engine. The takeoff was continued, the engine secured and the fire bottles discharged. The fire continued to burn. The aircraft circled and made…NTSB LAX82DA311Accident · No injuriesFinal reportBell 206B · Grand Canyon, AZDuring flight at about 300 ft AGL, there was an abrupt loss of engine power. The pilot descended at 60 to 70 KTS, then made an autorotative landing on a dirt road. During the landing, the main rotor blades struck the tail boom. An engine teardown revealed…NTSB NYC82DA206Accident · No injuriesFinal reportBell 206L-1 · Ho Ho Kus, NJWhile in straight and level flight at 1000 ft, the pilot heard a "pop" in the engine area. He noted that the turbine outlet temperature (tot) began an immediate rise to the high yellow area initially, the power was reduced to 50% torque and the tot returned…NTSB FTW82IA331Incident · Minor injuriesIncident investigationFinal reportCessna 421B · El Paso, TXN1969J is a 1974 Cessna 421B modified by a riley conversion kit. The aircraft was descending through about 1900 ft MSL when, without previous warning, it yawed left. The pilot reported that the acft then immediately yawed severely to the right and began to…NTSB SEA82DA140Accident · Minor injuriesFinal reportCondor 150L · 16nm No. Of Pie, IDThe eng failed enroute & while landing on a logging road the right wing contacted vegetation causing the acft to swerve & come to rest nose low. The eng had been inspected 1 hr previous to the accident & had 8 hrs of operating time since new at the…NTSB LAX82FVG30Accident · Serious injuriesFinal reportPiper PA-36-285 · Malin, OKPower loss during takeoff resulted in forced landing. Aircraft collided with canal bank. Cylinder had broken rings. Both plugs were badly oil fouled. One plug would not fire & the other fired intermittently.NTSB CHI82DA301Accident · No injuriesFinal reportHiller 12E · Palisade, MNAircraft lost power, pilot autorotated at 20 feet AGL. Made hard forced landing and aircraft rolled over. Piston rod failed because cap bolt was undertorqued.NTSB DEN82DA159Accident · No injuriesFinal reportAerospatiale SA-315B · Afton, WYEn route during a seismic operation a loud screeching, grinding sound was heard. The pilot reported the aircraft seemed to buck. A long flame emitting from the aft end of the aircraft was observed by witnesses. The engine ceased and the aircraft crashed into…NTSB DEN82FTC09Accident · 1 fatalFinal reportBell 47G-3B-L · Kaycee, WYThe pilot was having cooling fan problems, some blades had broken. He landed in a canyon stayed overnight to cool engine and planned to fly to top of the canyon to get repairs. After takeoff, the helicopter had climbed almost level with the top of the canyon…NTSB SEA82DA137Accident · No injuriesFinal reportHughes 369D · Shelton, WADuring a sight seeing flight the pilot smelled a burning odor and prepared to make a precautionary off-airport landing. Shortly thereafter, engine RPM decayed and an autorotative landing was effected on a dirt road. On touchdown, the main rotor blades flexed…NTSB MKC82IA137Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-25 · St. Joseph, MOAfter takeoff, the pilot was cleared to climb to 6000 ft MSL. While climbing through about 5000 ft, he heard a loud noise (bam) as the left engine lost power. The left engine was shut down and feathered and a landing was made with no other problems. An…NTSB LAX82FA287Accident · Minor injuriesField investigationFinal reportCessna 150M · Los Angeles, CAThe flight was doing traffic reporting when the engine failed. The pilot selected a place for a forced landing. During the landing, the aircraft bounced out of this lot, went over some buildings, then touched down into an athletic field. During a short…NTSB ATL82DA226Accident · No injuriesFinal reportHughes 269A · Wetumpka, ALThe pilot reported that at the end of a spray run, the engine lost power. He stated that the engine RPM dropped to zero, the airspeed was zero, and he established an autorotation. According to the pilot, the helicopter touched down on rough hilly terrain,…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…NTSB CHI82DA287Accident · No injuriesFinal reportBeech A23A · Grantsburg, WIThe pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…NTSB CHI82DA280Accident · Minor injuriesFinal reportSIAI Marchetti S.205-22/R · Carrollton, ILThe aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.NTSB CHI82DA278Accident · No injuriesFinal reportPiper PA-23 · Ladysmith, WIA ferry permit was issued to fly the aircraft to the rusk county airport for an annual inspection. The previous annual inspection had been on 8/20/80. During the arrival at the destination, the approach was high, so the pilot elected to go around. At about…NTSB ATL82DA209Accident · No injuriesFinal reportCessna T188C · Moultrie, GAA catastrophic engine failure occurred at an altitude of about 500 ft AGL while the pilot was returning to the airport. The pilot elected to land on a highway. He reported that during the landing, he ran the plane off the road to avoid an oncoming car. An…NTSB ATL82FKM06Accident · 1 fatalFinal reportEvans VP-1 · Greensboro, NCThe eng quit at about 100 ft AGL after takeoff. The acft struck the ground approximately 80 deg nose down. Inspection of the fuel strainer revealed the screen gasket bent double which would allow foreign matter to enter the carburetor. The fiberglass fuel…NTSB FTW82DA285Accident · No injuriesFinal reportAerospatiale AS-350D · Gulf Of MexicoDuring an over water flight, the engine chip detector light illuminated and shortly thereafter, the engine failed. The pilot made an autorotative landing in the Gulf Of Mexico with no further damage. All three rotor blades were full of holes and tears and one…NTSB FTW82DA281Accident · No injuriesFinal reportBell 206B · Sabine, TXDuring flight at about 500 ft AGL, the engine lost power. The pilot began an autorotative landing and made a mayday call. He autorotated to a marshy area which had 4 to 5 ft grass. The helicopter touched down hard and the main rotor blades flexed down and…NTSB ATL82DA192Accident · No injuriesFinal reportPiper PA-28-180R · Carrollton, GADuring cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation…NTSB SEA82DA103Accident · No injuriesFinal reportCoot Amphibian · Bellingham, WAThe aircraft was being flown on a local test flight following a new engine installation. This was only the second flight for this home built aircraft. During climb-out, the engine lost power and there was insufficient altitude for a normal runway landing. The…NTSB FTW82DPG17Accident · No injuriesFinal reportRockwell S2R · Blackton, ARThe eng failed during a swath run & the acft struck a rice levee drg the forced landing in an adjacent bean field. After exiting the aircraft and while talking to his flagman the pilot stated the aircraft began to burn around the engine area. The fire spread…NTSB FTW82DA271Accident · No injuriesFinal reportCessna 182J · Munester, TXDuring flight, the engine began losing power and both occupants detected a strong odor of gasoline. The pilot made a successful forced landing in a field. He stated that the engine lost all power on final approach. After coming to a stop, the pilot and…NTSB NYC82FGM12Accident · No injuriesFinal reportAerospatiale SA 316B · Crafton, PAShortly after takeoff the pilot heard a loud grinding noise and felt a vibration emanating from the rear of the aircraft. Immediately, the nose yawed to the left and the engine failed. The pilot entered autoration and made a hard landing. Examination of the…NTSB NYC82DA142Accident · Minor injuriesFinal reportBeech B23 · North Castle, NYAircraft was ditched and sank in a reservoir in 20 feet of water after the engine failed in flight. The crankshaft was found to be fractured when aircraft was raised. Oil had sprayed on the windshield. Avco-lycoming part number that failed was 74968 serial…NTSB CHI82DA235Accident · Minor injuriesFinal reportGrumman American AA-1C · Danville, ILThe student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the…NTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…NTSB LAX82FA247Accident · No injuriesField investigationFinal reportHughes 369B · Jenner, CAHelicopter was on routine police patrol when engine failed and it autorotated to a rough landing on a rocky beach. The 1st stage of the gas producer section of the turbine was found frozen. The turbine wheel blades were rubbing & seized to the 1st stage…NTSB ANC82FAA07Accident · 2 fatalFinal reportMaule M-5 · Fairbanks, AKEarlier in the day the plt returned from a flt after experiencing a rough running eng & changed the spark plugs. The acft again departed the chena marina arpt. Witnesses observed the acft level off approximately 300 to 350 ft AGL. One witness observed the…NTSB LAX82FA245Accident · No injuriesField investigationFinal reportHiller UH-12L3 · Stockton, CAThe pilot reported that the engine lost power at about 5 ft AGL as he was taking off from a trailer. He turned to avoid a gas and water tank near the poll truck. The helicopter came to rest, right-side-up, but was damaged. A fuel leak was found in a line that…NTSB CHI82DA230Accident · No injuriesFinal reportPiper PA-28-161 · Ladysmith, WIThe student pilot collided with a fence and rough terrain during a forced landing on a cross-country flight. The student heard a loud knocking from the engine after about 35 minutes of flight. He reduced power which helped but the engine was still noisy. The…