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 MKC84FA016Accident · Serious injuriesField investigationFinal reportStinson 108 · Angora, NEThe plt reported that the eng began running rough, then quit while he was flying over an area of rough terrain. He reported that as he was making a forced landing, the acft came in contact with a washed out ditch, cartwheeled & hit a fence. An exam of the eng…NTSB MIA84IA024Incident · No injuriesIncident investigationFinal reportBeech BE-33A · Near Avon Park, FLWhile in cruise flight the engine failed due to a failure ofthe crankshaft. The crankshaft was not examined to determinewhy it failed. The pilot executed a forced landing to an open field.NTSB CHI84LA036Accident · No injuriesLimited investigationFinal reportJordan Acey Deucy · Chesaning, MIThis was the first flight of the homebuilt. Shortly after takeoff the eng quit due to inadequate grounding. The plt returned to the field & made a smooth landing. At the end of the roll out the anchor plate for the landing gear truss failed causing the left…NTSB FTW84FA034Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Longview, TXAs the acft was flying toward the arpt, about 1 mi away, a witness heard a loud pop or bang & then no further eng sound. The plt attempted to climb above some tall trees about 300 yds from the end of the rwy, but impacted the tops of the trees. The #1 conrod…NTSB CHI84FEE01Accident · No injuriesFinal reportPopelka BD-5 · Sugar Grove, ILThe acft had received an inspection on 9/8/83, before it was disassembled & transported from California to Illinois. On 10/27/83, the plt took off on a flt from sandwich to aurora, IL. While on a final apch to land at aurora, after a throttle reduction, the…NTSB ATL84FLT01Accident · Serious injuriesFinal reportCessna 152 · Clifton, TNAccording to the plt, he was descending from 8500 ft to 2500 ft when the eng quit without warning at aprx 4500 ft. he stated that he made a 'mayday' call & attempted to make an emergency landing in a field. However, the acft hit some trees at the edge of the…NTSB ANC84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kenai, AKThe eng quit & the plt ditched in skilak lake. The plt later stated that during the repair work after the accident he found the mixture contol dislodged from the carburetor.NTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…NTSB FTW84FA020Accident · 1 fatalField investigationFinal reportGrumman FM-2 · Houston, TXThe plt had purchased the wwii fighter about a week before the accident & it had been flown several hours during the last few days before the accident. The plt intended to shoot touch-&-go's on this flt. After takeoff the acft was observed to remain in the…NTSB DEN84LA005Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Grovont, WYThe plt reported that after taking off, the gear warning horn sounded when he retracted the gear. He continued en route while trying to get a safe indication. Subsequently, aprx 20 mi east of the departure point, he elected to entend the gear & return to the…NTSB SEA84LA003Accident · No injuriesLimited investigationFinal reportCessna T210M · Seattle, WAAfter takeoff while on a right turnout from rwy 31L, & at about 1000 ft AGL, the eng quit. The plt returned to the arpt & elected to lower the gear when he knew rwy 13L could be reached. However the left main gear failed to lock prior to touchdown & the…NTSB FTW84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Smithville, TXDuring cruise at 8,500 ft MSL the eng quit. A night emergency landing was made at an arpt that the acft had just flown over. On final approach the plt could not see thru the windshield very well due to oil building up on the windshield. The plt held the gear…NTSB DEN83FA224Accident · No injuriesField investigationFinal reportHughes 369D (500) · Provo, UTThe helicopter was on a test flt to track & balance the main rotor system & to complete a 100 hr inspection. Prior to the flt, an occasional flicker of the fuel filter light was noted, but it was thought to be a wiring problem. After taking off, the fuel…NTSB CHI83LA448Accident · No injuriesLimited investigationFinal reportHughes 369D · Indianapolis, INWhile the helicopter was cruising at about 500 ft AGL, the eng lost power. The plt turned into the wind & made an autorotative landing in a corn field. During the landing, the tail boom was severed by the main rotor blades. An exam revealed that the housing…NTSB MKC83FA225Accident · No injuriesField investigationFinal reportBeech 60 · Wichita, KSShortly after takeoff, the left eng began to progressively lose power & was shut down. The aircrew notified Beech tower of the problem & reported they would like to return & land. The acft was observed on final apch to rwy 18 with the gear extended & the left…NTSB SEA83LA205Accident · Minor injuriesLimited investigationFinal reportHughes 369B · Cougar, WAThe aircraft collided with trees and terrain during a forced landing attempt following an in-flight power loss. Subsequent engine teardown revealed failure of several components.NTSB MIA83LA238Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Clermont, FLDuring flt, the eng began running rough & oil began leaking & spreading onto the windshield. The eng subsequently failed & the plt selected an area for a forced landing, during the landing, the acft contacted trees & was damaged. An investigation revealed…NTSB LAX83FUJ17Accident · No injuriesFinal reportGulfstream-Schweizer G-164B · Queen Creek, AZThe eng lost power & the acft nosed over in a soft plowed field. The #1 cylinder articulating rod had separated.NTSB MIA83FA235Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Miami, FLSeveral days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng…NTSB CHI83LA430Accident · No injuriesLimited investigationFinal reportCessna U206F · Garden Prairie, ILWhile en route, the fuel pressure dropped, and subsequently, the eng lost power completely. During a landing in a corn field, the acft was damaged. An investigation revealed that the fuel line had separated at the flow divider. Reportedly, the eng had been…NTSB CHI83LU013Accident · Serious injuriesFinal reportKruer Pterodactyl · Wayland, MIThe plt reported that during takeoff, the eng backfired & quit when the ultralight vehicle was aprx 100 ft AGL. He made a right turn to land back on the rwy. However, he stated that a slipping turn was made which 'resulted in a steep angle of attack on…NTSB DCA83IA040Incident · No injuriesIncident investigationFinal reportBeech B-24R · Potomac, MDThe acft made a forced landing in a field of rye grass after the engine lost power. Investigation revealed that a connecting rod had failed. An FAA inspection revealed that the connecting rod retaining bolts were not properly torqued during a recent major…NTSB FTW83LA426Accident · No injuriesLimited investigationFinal reportCessna 210L · Austin, TXThe acft was landed wheels-up in an open muddy field after the engine quit. The plt said that just prior to turning downwind he reduced power and extended the landing gear. Then the RPM was increased and mixture set to full rich at which time the engine quit.…NTSB LAX83LA427Accident · Serious injuriesLimited investigationFinal reportBeech H18S · Kailua-Kona, HIAbout 1 min after takeoff, between 400-500 ft MSL & during the first power reduction, the right eng backfired. Followingsome more violent backfires the RPM went to zero. The right eng was restarted but the same result occurred. The plt attempted to feather…NTSB CHI83LA413Accident · Minor injuriesLimited investigationFinal reportKuster KR-2 · New Lisbon, INThe acft made a forced landing in a cornfield after a loss of power during flt. The acft had been flying about 30 minutes. Post accident examination of the engine revealed a fuel leak around the mixture control linkage shaft. The fuelexhaustion was atttibuted…NTSB FTW83LA414Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morse, LADuring a climbing turn after takeoff, the eng lost power & started smoking lightly. The plt dumped his chemical load & was able to clear a set of power lines. He then made a forced landing in a flooded rice field where the acft nosed over. An investigation…NTSB CHI83LA411Accident · No injuriesLimited investigationFinal reportPiper J-3 · Rockford, ILThe plt stated the engine quit, sputtered and quit again before he landed in a bean feild and nosed over. Plt who is also an A&P mechanic had been using sloshing/sealing compound (randolph tank sealer #802) in the fuel tank. After the accident the compound…NTSB FTW83LA411Accident · No injuriesLimited investigationFinal reportPiper PA28R-201T · Anton Chico, NMDuring flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…NTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…NTSB FTW83LA404Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Katy, TXThe acft was damaged in a forced landing following engine failure after takeoff. The plt stated that a supercharger bearing failure caused the engine to fail. During the landing in a flooded rice field the landing gear collapsed.NTSB ANC83LA155Accident · No injuriesLimited investigationFinal reportBell B-206B · Bettles, AKThe helicopter made a autorotative forced landing after a loss of power during cruise. The landing was made on a road and the main rotor severed the tailboom. During the post-accident investigation a leak was found in the auto valve(part number 206061634-3)…NTSB ATL83LA346Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Falkland, NCThe plt reported that during a pull-up from a swath run, the acft began to shake & lose power. He continued to climb with full throttle & was able to maintain altitude for a short time, then the eng had a total power loss. Reportedly, the acft collided with…NTSB CHI83LA397Accident · Minor injuriesLimited investigationFinal reportCarter MONNETT-MONI · Port Huron, MIWhile turning crosswind after takeoff the eng quit. The plt was unable to restart the eng & the acft collided with trees. The plt stated the acft's ignition system was the cause of the eng failure.NTSB ATL83LA341Accident · No injuriesLimited investigationFinal reportCessna A188B · Samson, ALThe acft collided with a dirt bank during a forced landing after an inflt power loss. The pilot was enroute to a field at about 500 ft AGL when the power loss occurred. The pilot did not jettison his load of chemicals. He landed on wet grass and was unable to…NTSB LAX83LA415Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Arden, NVBetween 50-100 ft AGL after takeoff the eng quit. Examination revealed that the fuel supply line between the left wing fuel tank & the fuselage had failed.NTSB FTW83LA393Accident · No injuriesLimited investigationFinal reportCessna 172N · La Porte, TXThe acft collided with a utility pole after the engine lost power shortly after takeoff. The plt reported he was cruising at 300 ft AGL on a pipeline patrol when the engine began to lose power. The plt made a forced landing and collided with a utility pole.…NTSB LAX83FA398Accident · 1 fatalField investigationFinal reportChampion 7GCAA · La Jolla, CAPrior to departure, the acft was observed being run up with the eng sputtering & backfiring quite badly. The acft returned to the hanger & 3 lower plugs were changed. The flt was then resumed. The acft was next observed off shore, with the eng sputtering &…NTSB CHI83LA391Accident · No injuriesLimited investigationFinal reportDemeter Hummer B · Linden, MIThe ultralight acft crashed after takeoff when the engine failed at about 100 ft AGL. The acft climbed to about 100 ft AGL at a distance of about 240 ft from the end of the rwy. At this point the engine quit and the pilot started a 180 degree turn toward an…NTSB ATL83LA332Accident · Serious injuriesLimited investigationFinal reportStarduster II · Wakefield, VADuring flt, the eng lost power & the propeller stopped. The passenger recalled hearing a 'ticking' sound from the eng prior to the power loss. According to the plt & the passenger, the acft stalled & began to spin as the plt tried to turn into a bean field…NTSB MKC83LA197Accident · No injuriesLimited investigationFinal reportArrow Arrow Sport · Red Oak, IADuring flt, there was a progressive loss of eng power. The plt was unable to reach the arpt & made a crash landing in a soybean fld. An investigation revealed that the #4 cylinder failed in the area of the exhaust valve rocker box.NTSB DCA83IA035Incident · No injuriesIncident investigationFinal reportBoeing 767 · Denver, COThe acft was descending from FL 410 with the throttles at idle. As power was added at FL 295 the left eng surged & exceeded max EGT. 18 secs later the right eng surged & exceeded its max EGT. The left & right engs were shut down at FL 200 & 177 respectively.…NTSB FTW83LA386Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Jonesboro, ARThe acft collided with a ditch during a forced landing after the engine quit. Enroute to a farmers field the engine failed very shortly after flame was seen emitting from the exhaust stack. Post accident examination showed that several blades in the 1st stage…NTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…NTSB CHI83LER02Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…NTSB MKC83FA190Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Farley, MOWhile on a VFR pleasure flight, at night the aircraft crashed in an open field. The landing gear was down and locked. The propeller was windmilling at touchdown but there was no indication that the engine was developing power. Examination of the engine…NTSB ANC83FA144Accident · No injuriesField investigationFinal reportBell 206L-1 · Bettles, AKAccording to the plt, the low fuel warning light illuminated when the fuel gage was indicating 200 lbs. He reported he could see the arpt lights & elected to continue the flt. After arriving, he terminated his apch to a 30 to 50 ft hover with no forward…NTSB SEA83LA169Accident · No injuriesLimited investigationFinal reportCessna 150J · Grants Pass, ORThe acft ran off the departure end of the rwy during a forced landing following engine failure during a touch and go landing. The nosewheel struck a mound of dirt and the acft nosed over. The acft had reached 40 ft AGL and 70 mph when the engine lost power…NTSB LAX83LA375Accident · No injuriesLimited investigationFinal reportCessna 150M · Palo Alto, CAThe acft nosed over in a marsh during a forced landing after an engine failure. This was a solo instructional flt. The plt said he was descending for a landing at Palo Alto when the engine began to 'lose power and run rough.' Carburetor heat did not work and…NTSB FTW83LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jennings, LAThe acft nosed over during a forced landing after the engine quit shortly after takeoff. The main landing gear mired in soft plowed earth and the acft nosed over during landing. The takeoff gross weight was 5290 lbs. After the accident the engine tear down…NTSB ATL83FIG05Accident · Minor injuriesFinal reportRockwell S2R · Massey, MDWhile en route to a customer's field, at aprx 350 ft AGL over a wooded area, the engine lost power. The plt released the load, and subsequently, he landed the acft in the tree tops. During the landing, the acft sheared off a large tree, knocked another tree…