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 LAX87LA246Accident · No injuriesLimited investigationFinal reportBeech V35 · Clearlake, CADuring a cross country flight the engine experienced a loss of power. The plt made a forced landing on a road where during the landing roll the acft collided with a fence and eventually came to rest in a ditch. Inspection of the engine revealed extensive…NTSB FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.NTSB SEA87LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Viola, IDDuring an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted.NTSB BFO87DIG06Accident · 1 fatalFinal reportStriplin SKY Ranger · Easton, MDAfter taking off on a test flt, the plt remained in the traffic pattern & was on downwind when the eng surged or sputtered, then lost power. Soon thereafter, the acft entered a steep dscnt & crashed. The experimental, home built acft had only 11 hrs of flt…NTSB MKC87LA125Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Hazen, ARThe PIC was returning to base of operations after completing an aerial application operation. Enroute, PIC experienced an engine failure and made a forced ldg in a farm field. After touchdown, acft nosed over and was substantially damaged. Subsequent…NTSB CHI87DEX07Accident · Serious injuriesFinal reportBoeing E75 · Mccordsville, INDuring initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the…NTSB ATL87LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Middlefield, OHThe acft struck a fence during a forced ldg, following a loss of engine pwr in flight. The plt reported that he had topped off both main fuel tanks prior to departure. About 10 minutes after departure at about 4000 ft MSL, he smelled fuel fumes in the…NTSB MIA87IA185Incident · No injuriesIncident investigationFinal reportBell 47G-2 · Miami, FLWhile in cruise flt at aprx 300 ft the plt reported that he heard a loud noise followed by a loss of power. He then autorotated & set the helicopter down with no further incident. Insp of the eng revealed that the number 6 cylinder connecting rod failed near…NTSB LAX87LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe aircraft ditched in the pacific ocean while on a VFR instructional flight. Both pilots indicated that the engine stopped abruptly and they were unable to restart it. The propeller would not turn when the starter was engaged, nor would it windmill. The CFI…NTSB CHI87LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Anderson, INThe plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held…NTSB CHI87DET05Accident · Serious injuriesFinal reportBannwart Maxair XP-503 · Michigan City, INWhile in cruise flight the carburetor of this amateur built aircraft became detached and the engine failed. An emergency land was attempted, however obstacles prevented a landing at primary landing site and an alternate was selected. The aircraft was unable…NTSB ATL87LA162Accident · No injuriesLimited investigationFinal reportBeech V35B · Lexington, NCThe airplane encountered rough terrain and impacted trees during a forced landing attempt in a field. The plt reported that the engine had lost pwr at 8,500 ft MSL. Post-accident exam of the engine revealed that the #1 cyl barrel had cracked and separated…NTSB SEA87LA110Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ORDuring climbout at about 500 feet AGL for a touch and go, a loss of power occurred. Forced landing was accomplished onto a rough field where the left wing struck a small tree. The aircraft spun around and the nose gear and main gear collapsed. Examination of…NTSB MKC87LA116Accident · No injuriesLimited investigationFinal reportCessna 188-B · Sigourney, IADuring an unloaded re-positioning flt to begin an aerial application operation, the PIC experienced a total engine failure. A forced ldg was attempted and acft hit a ditch and was substantially damaged.NTSB DEN87LA140Accident · Minor injuriesLimited investigationFinal reportCessna TU206D · Garrison, NDThe plt and a photographer were photo-mapping at 3,000 feet MSL. The plt reported that the engine quit at cruise. The plt selected a gravel road for the forced landing. The aircraft landed short of the intended touchdown pointin a plowed field and on…NTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…NTSB ATL87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Murfreesboro, TNWhile climbing thru 6,000 ft, the plt heard & felt a 'thud' & then realized the eng had failed. Drg a subsequent emerg landing in a muddy corn field, the nose gear mired in soft terrain & the acft nosed over. A teardown of the eng revealed the crankshaft was…NTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…NTSB MKC87LA113Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Paragould, AREn route to a local aerial application operation PIC experienced a total engien failure. During subsequent emergency landing in a farm field the acft was substantially damaged. No reason could be determined for the engine failure.NTSB ATL87DLQ02Accident · Minor injuriesFinal reportHughes 369HS · Hawesville, KYDuring a weed control spraying operation, the pilot experienced a power failure 45 feet above the ground. The autorotation attempt resulted in the helicopter impacting the ground on it's left side. The investigation disclosed that the flexible fuel line to…NTSB FTW87FA130Accident · No injuriesField investigationFinal reportGrumman AA5A · Malakoff, TXThe acft impacted the terrain near Malakoff, Texas. Following an engine failure the pilot attempted to execute a forced landing to a road crossing a dam. The aircraft touched down and bounced into the lake. Examination of the engine revealed that the exhaust…NTSB DEN87FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Ogden, UTAcft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…NTSB ATL87DEI04Accident · Minor injuriesFinal reportButler EAA Biplane 1 · Orrville, OHAcft lost power and was landed in a corn field. Left main gear collapsed and acft flipped onto its back. Mixture cable set screw on carburetor was found loose allowing mixture to vibrate to lean position. Earlier in the day the PIC had replaced the carburetor.NTSB FTW87DRG02Accident · No injuriesFinal reportAir Tractor AT301 · Weslaco, TXDuring an aerial application flt the eng lost pwr and the plt made a forced lndg. Post acc disassembly of the acft eng revealed the failure of an impeller bearing which resulted in the failure of the eng.NTSB NYC87LA144Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Caldwell, NJDrg a ngt takeoff, the eng lost pwr shortly after lift-off & the plt chose an area away from bldgs & obstructions for an emerg landing. However, drg the landing, the acft was extensively damaged. An exam revealed the rgt fuel tank was empty & the left tank…NTSB DEN87LA119Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Ignatius, MTAn ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an…NTSB ANC87LA066Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft…NTSB MIA87LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Panama City Bch, FLThe plt reported that shortly after takeoff the eng began to lose power, then failed. He then autorotated & set the helicopter down aprx 6 feet offshore. Examination of the eng logbooks by FAA personnel revealed that AD 62-23-02 which requires insp of the oil…NTSB MIA87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Apalachicola, FLThe plt stated that he departed panama city en route to tampa, FL, when the manifold pressure and oil pressure started to drop. He then turned towards Apalachicola to try to make it to the airport but was unable and made a forced landing in a swampy area aprx…NTSB MKC87LA100Accident · No injuriesLimited investigationFinal reportCessna 188 · Ottawa, KSThe acft was returning from an aerial application flt when the fuel line to the fuel filter disconnected. During the forced landing, the acft ran into a fence. The eng had been installed 100 flt hrs prior to the accident.NTSB MKC87LA096Accident · No injuriesLimited investigationFinal reportRotorway Executive · Gerald, MOThe stu PIC was solo on a x-country flt when the eng backfired. The stu entered autorotation with low rotor RPM which accelerated the descent rate. The stu flared before touchdown but did not level the helo in time to land. The tailboom struck the gnd and the…NTSB FTW87IA108Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Denton, TXThe aircraft's right engine, while in flight, lost a blade from its fourth stage turbine wheel due to metal fatigue. This resulted in varying degrees of damage throughout the entire engine and caused the engine to shut itself down while climbing through…NTSB ATL87FA124Accident · No injuriesField investigationFinal reportCessna 500 · Willoughby, OHAcft had been flown over 4 hrs on pers. Business for owner. Plts had stopped at lnn to drop off pax. Start & taxi were norm for positioning flt back to home base. Started t.o. roll and when eng RPM reached 80-85% toward tgt of 95.7%, plts reptd loud 'bang'…NTSB MKC87LA093Accident · No injuriesLimited investigationFinal reportForney Ercoupe · Omaha, NEThe annual inspection on this acft was completed the day prior to this accident. During this flt, the wire holding the fuel filter bowl in place came loose and the bowl came off. The eng quit from fuel starvation and the plt made a forced landing in a plowed…NTSB LAX87LA188Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Temecula, CADuring an aerial survey flight, while on final approach to the arpt, the engine began running rough then quit. The plt was unable to land the acft at the arpt, therefore, a nearby dirt road was selected. During the landing roll the acft collided with the…NTSB ATL87LA121Accident · No injuriesLimited investigationFinal reportBell UH-1B · Bay Minette, ALDuring a logging operation, the helicopter experienced a complete engine failure shortly after attempting a pickup. The pilot entered an autorotative glide. The helicopter impacted the water and sank. The wreckage examination disclosed that the compressor…NTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.NTSB FTW87IA097Incident · No injuriesIncident investigationFinal reportBeech 58 · Bridgeport, TXDuring cruise flight, the aircraft's right engine caught fire. The pilot shutdown the engine and feathered the prop, extinguishing the fire. The pilot declared an emergency with ATC and landed safely at an alternate airport, with only minor damage to the…NTSB CHI87DEP03Accident · No injuriesFinal reportErickson Sonerai 2L · Algoma, WIWhile in normal cruise flight the crankshaft failed at the propeller flange and the propeller departed the aircraft. The pilot executed a forced landing to a farm field. He was unable to flare successfully and lost control during landing.NTSB DEN87LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTAn ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original…NTSB LAX87DVW01Accident · Minor injuriesFinal reportNorth American P51D · Ashfork, AZThe North American P-51D experienced a total loss of engine power after cruising at 10,000 feet MSL for 45 minutes. Attempts to restart the engine were unsuccessful. The aircraft collided with some trees prior to coming to rest in an open field. The landing…NTSB MIA87LA125Accident · No injuriesLimited investigationFinal reportNorth American B-25-J · Titusville, FLThe plt stated that he was in the vicinity of melbourne FL when the right engine failed. He secured the right engine and turned back towards new smyrna beach, but as he was nearing tico airport the left engine also failed. The pilot, realizing he was not…NTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…NTSB CHI87IA100Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNThe aircraft landed uneventfully after the right engine failed during a descent. The shutdown occurred after failed antirotation pins allowed gas loads to drive normally stationary third stage vane clusters in the low pressure turbine area. Rotation of the…NTSB MIA87LA115Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Oxford, MSDuring final apch the eng quit. The plt then attempted to land the acft on a road, during which, it collided with trees. Inspection of the acft revealed that the adjusting screw on the eng driven fuel pump backed out aprx 8 turns. Bench test of the pump…NTSB ATL87LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Darien, GADuring normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become…NTSB LAX87LA148Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rio Vista, CAThe aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became…NTSB CHI87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Holland, MIDuring a local flight the aircraft's engine lost oil pressure. The engine continued to run for about two minutes and then totally seized. The pilot made a hard landing on 58th street in Holland (the only available landing area he could see in the dark night…NTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…NTSB LAX87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Santa Ynez, CAJust after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…