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 FTW83LA243Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Cornerstone, ARThe acft collided with a dirt bank during a forced landing after the engine quit. The plt said he was making a swath runwhen the engine quit. The flagman said he saw black smoke then white smoke as the engine quit. Post crash investigation revealed that the…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…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…NTSB CHI83LA208Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Ceresco, MIThe plt reported that the acft was normal until he was on final apch to land. The acft began to loose too much altitude, so he advanced the throttle, then the eng lost power. Subsequently, the acft hit the top of a tree short of the rwy, then crashed. An exam…NTSB MKC83LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Clinton, MOWhile cruising at 8,500 ft the pax in the right seat noticed that the oil filler access door on top of the right eng wasopen & oil was leaking. The plt checked the eng instruments & the only abnormal reading was a low manifold pressure reading on the left…NTSB ATL83LA180Accident · No injuriesLimited investigationFinal reportEippen MX-2 · Raleigh, NCThe acft nosed over during a forced landing after the engine failed. Examination of the engine after the accident revealed that the #2 cyl piston was badly scored. The cyl. Head temperature gauge read 100 deg lower than the actual temperature. Epoxy sealant…NTSB MIA83AA136Incident · No injuriesFinal reportLockheed L-1011 · Miami, FLThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-84/04. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB FTW83FA221Accident · No injuriesField investigationFinal reportBeech E33 · San Angelo, TXThe eng failed in flt & the acft crashed 1 mi short of rwy 18 during an emergency landing into mathis arpt. The acft's fuselage was streaked with fresh oil. The rigid oil pressure line, extending from the eng to the firewall, failed due tofatigue cracking…NTSB MKC83LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Cape Girardeau, MOThe pilots were participating in a grand prix air race. After a normal preflight, they took off & crossed over the arpt for race timing purposes. A climb was begun on course, and a short time later, the engine began loosing power. The aircrew turned back…NTSB LAX83LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Milpitas, CAWhile descending thru 4300 ft, the eng lost power. The plt made an emergency landing on a gulf course, but during the landing roll, the right wing of the acft impacted a pole & was damaged. An exam revealed that the 5/16 inch bolt, pn STD-847, that secured…NTSB LAX83LA207Accident · Serious injuriesLimited investigationFinal reportAero Commander 600 S-2D · Gilroy, CAPrior to takeoff, the acft was fully fueled with 100 gal of aviation gasoline & was loaded with 300 gal of non-toxic fungicidal mix. The plt took off, flew aprx 5 mi to a field, and after circling over the field, made 2 swath runs. During a procedure turn…NTSB SEA83FA093Accident · 2 fatalField investigationFinal reportBeech 77 · Renton, WAThe acft was taking off for a 1 hour engine run-in following a top overhaul. After liftoff the engine began a gradual power loss and rough running. The pilot was trying turning back to the runway to land when total power loss occurred. The acft had turned 45…NTSB MKC83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Grenola, KSWhile spraying liquid fertilizer, the plt noticed that the fuel indication was dropping rapidly. He stated that he tried to return to the departure point, but was unable. When the engine lost power, he jettisoned the remainder of his load & landed in a…NTSB ATL83FA171Accident · No injuriesField investigationFinal reportBoeing A75N1 · Kennesaw, GAWhile over a wooded area at 800 ft AGL the eng failed. The plt was unable to reach a suitable landing site before contacting the ground on an embankment below the elevation of a nearby road. The acft struck a telephone cable prior to touchdown. The #4 conrod…NTSB CHI83LA187Accident · No injuriesLimited investigationFinal reportTuk Gregory Quickie Q-2 · Ann Arbor, MIThe home built acft was on its 1st test flt. According to the plt, the throttle became bound when he attempted to add power after checking the stall characteristics. Reportedly, the eng lost power at about this time when a rapid throttle movement was made.…NTSB ATL83LA170Accident · No injuriesLimited investigationFinal reportCessna A-188B · New Hope, ALThe acft struck powerlines and crashed during an emergency landing after a loss of power while spraying on an aerial application mission. The plt stated that while spraying he noticed oil beginning to cover the windshield. He had begun aclimb and dumped the…NTSB FTW83LA205Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXThe acft groundlooped in ruts during a forced landing after the engine quit. A ground fire destroyed the acft. The acft had approached the field to be sprayed and a witness on the ground said the engine sounded like it was being throttled back. When the pilot…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…NTSB NYC83FGM02Accident · Serious injuriesFinal reportBeech A-23 · West Mifflin, PAThe acft lost power during takeoff and a forced landing was made from 400 ft AGL to a slag dump about 1 mile south of the airport. The right wing was substantially damaged by the initial impact as the acft was turning right at touchdown. The nose gear…NTSB ATL83LA168Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · New Hope, ALThe acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…NTSB MKC83LA092Accident · No injuriesLimited investigationFinal reportMooney M20K · Trenton, NEThe acft was climbing through 11500 to 12000 ft MSL when the engine made a loud noise followed by a lurch. The oil pressure dropped to zero and the engine developed a roughness. The plt said he shut the engine down at this time, the plt advised denver ARTCC…NTSB SEA83LA084Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Near Almira, WAThe acft made an emergency landing after an engine failure and fire in flt. The pilot stated that he was enroute to spray wheat when the engine lost power and oil sprayed on the windshield. The pilot smelled smoke, dumped his load and made a landing. When he…NTSB NYC83FFJ01Accident · No injuriesFinal reportCessna A188B · Williamson, NYThe acft collided with a tree during a forced landing after a power loss on takeoff. The pilot had a load of 125 gallonsof a fungicide for spraying trees when the engine quit at about 100 ft AGL. The load was dumped and the acft was turned to the right for a…NTSB FTW83FPJ02Accident · Serious injuriesFinal reportCessna R172E · Little, OKThe acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…NTSB MIA83FA121Accident · Minor injuriesField investigationFinal reportBeech G18S · Hollywood, FLThe plt stated that start, taxi & takeoff were normal until after he raised the gear handle & the acft was climbing thru aprx 150 to 200 ft AGL. At that time, he noticed that the left eng RPM was decaying. There was insufficient rwy remaining to abort, so he…NTSB ATL83LA160Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Charleston, WVDuring an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing…NTSB ATL83LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lexington, NCThe aircraft collided with a ditch during a forced landing after power loss while on an aerial application flight. The engine failed because of loss of #2 cylinder. The cylinder head cracked and ruptured two oil lines. With the windshield covered with oil and…NTSB NYC83FA088Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Hawthorne, NYThe flt departed cleveland at 1539. The flt enroute was conducted at 6,000 ft. about 45 mi w of destination the fuel gages indicated 5 gals of fuel in each of the two tanks. At about 5 mi w of the arpt the eng quit. The plt made a forcedlanding on the…NTSB ANC83FA059Accident · Minor injuriesField investigationFinal reportCessna T-41B (R-172E) · Healy, AKThe plt reported that while cruising at 4000 ft MSL, the eng power began to fluctuate, then this was followed by a banging noise, rough eng operation & a decline in power output. He had turned to land into the wind when the eng power increased & stabilized.…NTSB FTW83LA166Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Newellton, LAAprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which…NTSB CHI83LA150Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee 28-5ACF · Neilsville, WIThe aircraft was crash landed in an open field after it had a power loss on #1 engine during cruise flight. The aircraft was on a geodetic survey flight which called for flight at 500 feet AGL. The pilot elected to land because the aircraft could not maintain…NTSB MIA83LA097Accident · No injuriesLimited investigationFinal reportStinson 10A · Defuniak Spring, FLThe engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there…NTSB CHI83LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA24-260 · Mansfield, OHDuring cruise flt at 8000 ft MSL, the eng lost oil pressure. The plt stated that smoke entered the cockpit & sparks were seen in the cowling area. Shortly after that, the eng seized. Radar vectors were obtain to the closest arpt; however, the plt was unable…NTSB MKC83IA078Incident · No injuriesIncident investigationFinal reportAero Commander 680W · Kansas City, KSThe number 2 engine failed in cruise flight. Durng descent the landing gear failed to extend. The pilot landed intentional gear up in the sod area adjacent to the runway.NTSB LAX83LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Tipton, CADuring takeoff, at aprx 80 ft AGL, the eng backfired then lost power. The plt chose an open field for an emergency landing while trying to dump the load. While landing, the acft bounced, rolled about 600 ft, then hit a dirt berm & subsequently came to rest in…NTSB MKC83LA079Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Ultsses, KSThis amateur-built aircraft was being flown at 200 feet AGL on a pleasure flight when the engine quit. The pilot made a forced landing in a soft field and the aircraft nosed over. The engine quit because the fuel cap was not vented. The capwas supplied with…NTSB LAX83IA140Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 8-61 · Mina, NVWhile established in a normal climb to curising altitude the#1 engine failed due to a failure of the first stage compressor wheel. The acft then diverted to reno NV and landed without further incident.NTSB MIA83LA083Accident · No injuriesLimited investigationFinal reportCessna 210H · Near Labelle, FLThe acft collided with a tree during a forced landing and cartwheeled about 150 feet into a palmetto grove. The pilot stated that during the descent to Labelle the engine backfired, lost power and the windshield became covered with oil. The pilot elected to…NTSB CHI83LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ely, MNAbout 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe…NTSB MIA83LA077Accident · No injuriesLimited investigationFinal reportCessna C-182P · Bahia Honda, FLThe acrft was ditched in the bay of Florida after the engine failed at 1000 ft MSL. The pilot and passenger swam to shore without injury. Examination revealed that the #1 cyl exhaust valve rocker shaft housing failed. Lab exam of the housing showed high cycle…NTSB DEN83LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Riverton, WYThe acft slid across a road and slid parallel to a fence until the acft hit a fence post during a forced landing. The acft was on a test flt after maintenance which included adjustment of the absolute controller. The before takeoff checkswere made and…NTSB LAX83FA099Accident · No injuriesField investigationFinal reportCessna 150J · Nogales, AZThe acft nosed over during a forced landing after the engine failed during an instruction flt. The landing was accomplished off arpt about 30 minutes after initial takeoff. The engine had begun to run rough followed by a loss of oil pressure. Then the engine…NTSB LAX83FUA03Accident · No injuriesFinal reportBell 47G-5 · Irvine, CAThe helicopter landed hard in a field off the airport following an engine power loss. The acfr had lifted off and only traveled about 50 feet at 15 feet AGL when the power loss occurred. An engine teardown revealed that the rings on 3 cylinders had not seated…NTSB LAX83FA096Accident · No injuriesField investigationFinal reportAerospatiale AS 350 Astar · Pacoima, CAThe main rotor blades separated the tail boom during a forced landing following a total loss of power. The plt stated the acft was equipped with an experimental engine torque and temperature limiting device and this flt was to collect data concerning its…NTSB SEA83FA052Accident · Serious injuriesField investigationFinal reportMaule M-5-220C · Near Asotin, WAWhile flying in the vicinity of the snake river, the engine lost power. Emergency landing areas were limited. The plt elected to land on a road Near the river. While in a right turn to line up with the road, the acft collided with a single power line, then…NTSB MIA83FA065Accident · 1 fatalField investigationFinal reportMBB Scorpion TOO · Tallahassee, FLThe helicopter collided with trees while on a local personal flight. According to witnesses the acft was flying low overthe trees. Several loud backfires were heard and the helicopter crashed in a wooded area. The acft descended almost vertically with the…NTSB FTW83FA101Accident · No injuriesField investigationFinal reportMooney M20E · Roanoke, TXPower loss occurred about 7 min after takeoff. The plt turned back toward the arpt but was unable to reach the arpt due to a 15-20 kt headwind. The acft landed hard collapsing the landing gear after the plt mushed the acft to clear wires. Examination & flow…NTSB SEA83FYM04Accident · No injuriesFinal reportMooney M20K · Dufur, ORThe aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a…NTSB CHI83FA086Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Monroe, WIWhile cruising at 4,000 ft MSL the eng quit. During a forced landing on rolling farm terrain both main landing gear separated. The acft then slid through a barbed wire fence & caught fire. Metallurgical examination revealed a fatigue failure of the idle set…NTSB FTW83FA092Accident · No injuriesField investigationFinal reportCessna 150 · Midland, TXThe acft nosed over during an emergency landing after an engine failure. The landing was made off arpt in a cotton fieldthe nose gear dug in and the acft nosed over. The engine was torn down after the accident and it was discovered that the #3 connecting rod…