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 DEN84LA239Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Naturita, COOne of the axial compressor blades separated resulting in internal engine damage and loss of engine power. Examination of the blades showed evidence of corrosion beyond acceptable limits. The engine was not equipped with an air filter or particle separator.…NTSB DEN84LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chamerlain, SDThe pilot experienced an engine failure and executed an emergency landing on a narrow road which resulted in one of the landing gear touching down on the soft shoulder. The landing gear failed and substantial damage resulted. Examination of the engine…NTSB LAX84FA407Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Goleta, CAThe plt radioed to the santa barbara tower that he was 'without power' & was going to attempt to land in an open field. However, during the forced landing, the acft collided with trees aprx 50 ft short of the field. An exam of the eng revealed that the fuel…NTSB ATL84LA230Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Georgetown, MSThe plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…NTSB DEN84LA221Accident · Minor injuriesLimited investigationFinal reportPiper 28RT-201T · Glendo, WYThe acft was damaged in a forced landing in a wooded area after the engine failed. The plt said that he was cruising at 7500 ft MSL when without warning the engine began making noises and then lost oil pressure. After the landing the enginewas examined at the…NTSB LAX84LA401Accident · No injuriesLimited investigationFinal reportBeech H18S · Honolulu, HIDuring takeoff at about 50 ft AGL & 4,000 ft down rwy 4R, the right eng lost power. According to the plt, his airspeed was 105 mph & the right eng 'popped' before it lost power. He also stated that power on the left eng deteriorated after the the right prop…NTSB LAX84LA393Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Scottsdale, AZThe eng lost power after takeoff at about 150 ft AGL & the landing gear collapsed during the forced landing. The nose landing light rubber seal had separated & entered into the carburetor causing air blockage.NTSB MKC84LA209Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · West Memphis, ARThe acft nosed over during an off arpt forced landing following an engine failure. During post accident examination the acft was found to have a cracked #7 cylinder.NTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…NTSB NYC84LA238Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau SF-27M · Grove City, PAThe motorglider lost power after takeoff. According to the plt the takeoff seemed long but he did not abort because thiswas his first self-launch and he was unsure of the operation. About 200 ft AGL a turn was made to the east to return to the arpt and the…NTSB CHI84LU006Accident · Serious injuriesFinal reportPterodactyl Fledgling · Hartford, WIThe ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…NTSB CHI84LA281Accident · No injuriesLimited investigationFinal reportJordan Henry J Acey Deucy P70 · Holly, MIWhile flying over a wooded terrain, the eng lost power. The plt selected an area with the least amount of trees for a forced landing. During the landing, the right wing tip hit a tree & plane crashed. An exam of the eng revealed that the alternator belt had…NTSB NYC84FGM05Accident · No injuriesFinal reportBell 47G-5 · Penn Run, PAThe plt was spraying a potatoe field with a lightly loaded helicopter when the eng failed. At that time, the helicopter was about 10 ft AGL in a slight right turn & at aprx 35 mph. The plt flared to stop the forward movement & landed, but the tail rotor…NTSB SEA84LA156Accident · No injuriesLimited investigationFinal reportMonett-Keating Moni · Bremerton, WAThe pilot stated he had shut down the engine several times to glide. On the last restart the engine ran for aprx 15 secsand then began to run rough and died. Attempted restarts were not successful. The aircraft failed to clear trees while attempting to land…NTSB MKC84LA198Accident · No injuriesLimited investigationFinal reportMooney M20K · Blue Springs, MOTen minutes after takeoff acft leveled at 2700 feet AGL at which time the plt leaned the mixture and set the throttle. Shortly after, manifold pressure rose above red line and the engine quit. An engine teardown revealed detonation in the #1 cylinder. The #2…NTSB ATL84LA214Accident · Serious injuriesLimited investigationFinal reportMooney M-20F · Red Bay, ALThe acft landed gear up short of the rwy in an attempt to return to the rwy after a power loss at low alt. During takeoff the arpt manager said the engine sound change was consistent with power loss from fuel starvation. FAA did a post accident engine test…NTSB ANC84LA109Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Ester, AKThe acft was landed in the tops of small spruce trees after the engine lost oil pressure and was shut down. The plt later admitted that the oil lines needed relacement on the last annual on 06-22-84 but he postponed it and later forgot to do it in the…NTSB MIA84FA196Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Niceville, FLThe acft crashed into trees short of the rwy after the engine quit on final approach. The engine failed from internal failure of the crankshaft gear retention system. A teardown revealed that the crankshaft gear bolt had backed out & the bolt head was noted…NTSB DEN84FA202Accident · 2 fatalField investigationFinal reportBeech 35 · Albuquerque, NMAccording to arpt personnel the plt was known to perform maintenance on his acft. The plt was not a licensed A&P. According to witnesses, the acft tookoff and climbed to aprx 200 to 250 ft and the eng quit. The acft climbed 'a little more', then made a left…NTSB DEN84LA204Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Page, NDEngine siezed during takeoff climb at alt of aprx 100 ft AGL. Acft contacted trees during the forced landing. Examination of engine turbo section revealed the blower section had separated as a result of bearing failure. According to a mechanic who…NTSB ATL84LKG09Accident · No injuriesFinal reportRockwell S2R · Smithville, GAThe acft contacted a dirt mound after bouncing during a forced landing after white smoke came from the engine en route to a spraying operation. The power decreased and the engine quit prior to touchdown in a field. After striking a dirt mound the acft was…NTSB ANC84IA101Incident · No injuriesIncident investigationFinal reportCessna 207A · Larsen Bay, AKAbout 12 mins after takeoff while at 2300 ft MSL, the eng began to shake, oil covered the windshield & oil pressure was lost. Subsequently, the plt made a forced landing in an area of tall grass on a river delta. During the landing, the nose gear collapsed &…NTSB DEN84LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Murdo, SDThe pilot reported the engine failed while he was in a procedure turn. The pilot made a forced landing in an open field and the acft nosed over. Examination of the engine after the accident revealed the engine 'swallowed an exhaust valve' that caused the…NTSB ATL84FLT10Accident · No injuriesFinal reportNorth American T-28 · Loudon, TNThe plt reported that he heard a loud bang in the acft eng & it lost pwr & started emmitting smoke. During a forced landing, the acft went thru 4 fences & hit a ditch, and the nose gear collapsed. A fire, which started in flt, destroyed the cockpit after the…NTSB ATL84FKG08Accident · No injuriesFinal reportCessna 177RG · Pell City, ALDuring the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…NTSB ATL84FA203Accident · 2 fatalField investigationFinal reportCamair 480 · Cumming, GAAccording to witnesses, the acft crossed a highway after taking off, entered a left turn, descended & pulled back up, then went out of control & crashed. One witness indicated that the acft entered a spin prior to crashing. An exam of the wreckage showed…NTSB DEN84LA181Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTThe acft was damaged in a forced landing after the engine quit. The plt said that several weeks prior to the accident hediscovered the fuel crossover quick drain was 'frozen' shut and would not drain. He removed the drain to lubricate it and upon…NTSB LAX84LA358Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Sacramento, CAThe plt reported that the fuel pump failed in flt & he made an emergency landing on a private strip. He said that he landed hard & the acft nosed over.NTSB FTW84LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bridgeport, TXDuring flt, the plt noted a progressive loss of eng power. The application of carburetor heat had no effect. Subsequently, a loud noise occurred & the plt shut down the eng. During a forced landing the nose gear collapsed & the acft nosed over. An exam…NTSB ATL84LA197Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Stockbridge, GAThe ultralight vehicle lost power at about 250 ft AGL, shortly after takeoff. The plt chose a field for an emergency landing. However, while avoiding the tops of trees, the ultralight lost airspeed. Subsequently, there was insufficient airspeed to flare…NTSB FTW84LA270Accident · Minor injuriesLimited investigationFinal reportBell 206B · South PeltoWhile cruising at 550 ft above the gulf of Mexico, the plt noted hi tot indications, followed by loss of N1 RPM & eng failure. An autorotation was initiated which terminated in a hard landing in 5 ft waves. One emergency float separated during the landing &…NTSB LAX84LA338Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tracy, CAThe acft lost power during takeoff & nosed over in a wheat field. An exam revealed that the #7 cylinder head was cracked from the rear spark plug hole, 3/4 of the circumference around the exhaust valve.NTSB CHI84LA217Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt. Pleasant, MIThe student plt was in the traffic pattern practicing touch-&-go landings when the eng lost power. He suspected a carburetor problem because of recent problems. He used the primer, at which time the engine responded momentarily. Subsequent, the plt made a…NTSB MKC84LA159Accident · No injuriesLimited investigationFinal reportCessna A188B · Campbell, NEDuring a forced landing in a milo field, the spray bar caught in the crop, causing the acft to pitch nose down before coming to a stop, damaging the wings and propeller.NTSB ANC84LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Igiugig, AKDuring flt, the plt heard a 'loud bang' & then the eng lost power. He transmitted a mayday call & made an emergency landing on rolling tundra. During the landing, the nose & left main gear failed & the wing & prop were damaged. An exam revealed that the eng…NTSB MKC84FA156Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wickes, ARThe acft was force landed in an open rolling field after the engine lost power. The plt said the engine produced a rattling noise and vibration before the loss of manifold pressure. Post accident examination showed a failed #3 connecting rod and cylinder.NTSB DEN84FU006Accident · 1 fatalFinal reportWeedhopper B · Beresford, SDThe ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were…NTSB FTW84LA246Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Worth, TXAcft had power loss at 2500 MSL 5 min after takeoff. A forced landing was made & the acft collided with a tree during the lndg roll. Examination of acft disclosed that the mixture control cable separated from the arm at the engine where it had been over…NTSB FTW84FA243Accident · 1 fatalField investigationFinal reportCessna 177B · Kinner, LAThe plt stated he lost eng pwr after departing the new orleans int'l arpt. The flt was unable to return to the arpt. The acft crashed in the waters of lake pontchartraih about 1 mile from the arpt. The wreckage was located and marked with a buoy. Due to high…NTSB LAX84LA311Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams, CAShortly after departing the airfield, the eng lost power & the plt was unable to restart it. He landed in a soft, freshly plowed field. After rolling about 50 ft, the acft nosed over. An exam revealed that the shaft which holds the float assembly in the…NTSB NYC84FA178Accident · 1 fatalField investigationFinal reportCessna 210E · Glen Burnie, MDBefore the flt, the plt was observed performing maintenance in the eng compartment. He was known to do some of his own maintenance which included stopping an oil gasket leak by using a sealer. While climbing after takeoff, he turned back to the departure…NTSB ANC84FA072Accident · No injuriesField investigationFinal reportPiper PA-28-235 · Egegik, AKThe acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off…NTSB LAX84FA304Accident · 1 fatalField investigationFinal reportBrubaker Q-2 · Corona, CAThe plt of a quickie Q-2 had returned to the arpt & made 2 low passes, then began a normal apch to rwy 25. When the Q-2 was on a low final, the plt of a Mooney acft turned onto the rwy & began taking off. At about that time, a ground witness heard the…NTSB LAX84FU028Accident · Serious injuriesFinal reportPioneer FLT Star · Elk Grove, CAThe ultralight was on a solo training flt when the engine stopped as the vehicle passed over the rwy. The student made a shollow bank to the right and descended into an adjacent field where she and the vehicle collided with some bales of hay. The student had…NTSB LAX84FA299Accident · Serious injuriesField investigationFinal reportCessna TR182 · Big Bear City, CAJust after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…NTSB DEN84LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wiggins, COWhile en route to a field for aerial application, an oil mist appeared on the windshield of the acft. Shortly after that, the eng progressively lost power & the plt made a forced landing in a pasture. During the landing roll, the acft hit a hole in the ground…NTSB LAX84LA296Accident · Minor injuriesLimited investigationFinal reportGinn Thorp T-18 · Lancaster, CAThe acft lost power and nosed over during a forced landing on desert terrain. An inspection of the engine showed that the automotive type filter had disintegrated and had been ingested in the carburetor. The filter was 4 years old. After the filter was…NTSB ANC84LA071Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mt Mckinley Vil, AKThe helicopter experienced an engine failure while cruising at about 600 ft AGL. The pilot made a forced landing during which the main rotor blades collided with trees. Examination of the aircraft fuel system revealed that the check valves located in the fuel…NTSB CHI84LA186Accident · No injuriesLimited investigationFinal reportHughes 500D · Rensselaer, INHard forced landing made after loss of pwr at cruise alt of 500 ft AGL. Main rotor blades contacted tail boom. Examination disclosed fuel pump gears showed signs of corrosion. Gear teeth and end faces were severly etched and pitted. Bronze particles were…NTSB FTW84LA231Accident · Minor injuriesLimited investigationFinal reportStarduster SA-300 · El Paso, TXWhile in the arpt traffic pattern for landing, the plt experienced an engine failure and landed short of the rwy. The acft collided with a sand dune. The plt stated that he had experienced a loss of fuel pressure on previous flts but had not corrected the…