NTSB investigations, ID
39 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 6 |
| 1987 | 3 |
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 5 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 1 |
| 2006 | 1 |
Where
Latest cases
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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND 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 SEA06CA190Accident · No injuriesData collectionFinal reportColtrin RV-6 · Burley, IDA loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.NTSB SEA03FA179Accident · No injuriesField investigationFinal reportAero Commander Callair A-9B · Driggs, IDA loss of engine power due to the improper installation of a counterweight roller pin retaining washer circlip, leading to the circlip coming out of its groove and the counterweight roller pin coming in contact with two of the engines connecting rods.…NTSB SEA03FA169Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Webb, IDAn over temperature condition within the gas generator turbine which led to first stage turbine blade fatigue as well as first stage blade track warping and consequent blade tip rub. The fatigue and blade tip rub ultimately led to blade separation and failure…NTSB SEA03LA129Accident · No injuriesLimited investigationFinal reportCessna 182J · Athol, IDThe failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…NTSB SEA03LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Boise, IDThe failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the…NTSB SEA02LA161Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Rigby, IDThe failure of one or more compressor turbine blades resulting in a shutdown of the engine during initial climb resulting in a forced landing. Contributing factors were the eroded condition of the compressor turbine guide vane nozzles and the ditch which the…NTSB SEA02LA123Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Weiser, IDThe fracture of the number 3 cylinder exhaust pushrod resulting in the exhaust valve's inability to open during the exhaust cycle and the subsequent engine stoppage. Contributing factors were the ditch and elevated roadway which the aircraft crossed during…NTSB SEA01LA121Accident · Minor injuriesLimited investigationFinal reportKaman HH-43B · Mullan, IDThe development of multiple fatigue cracks which ultimately resulted in the fracture of the 1st stage gas producer turbine rotor sealing disc. Factors contributing to the accident were mountainous/hilly and unsuitable terrain conditions.NTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.NTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.NTSB SEA97LA195Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Elk City, IDOil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.NTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.NTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.NTSB SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.NTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.NTSB SEA94LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDEngine failure after loss of oil due to a ruptured oil line.NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…NTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.NTSB SEA89LA162Accident · No injuriesLimited investigationFinal reportCessna TU206G · Moore, IDFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Contributing to the accident was a fence.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB SEA87LA163Accident · No injuriesLimited investigationFinal reportCessna T-207 · Mccall, IDDuring climb out to cruise altitude the pilot noticed a drop in manifold pressure and a loss of oil pressure. The pilot was in the process of attempting to reach an airstrip when the oil pressure dropped to zero followed by a total loss of power. An off…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 SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…NTSB SEA86LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B · Kimberly, IDA forced landing with a rollover onto snow occurred due to the number 3 cylinder rod failing.NTSB SEA85LA204Accident · No injuriesLimited investigationFinal reportWelch Avid Flyer · Bonner'S Ferry, IDThe plt reported that during takeoff, the eng seized as the acft was climbing thru about 350 ft AGL over the end of the rwy. He stated that the acft was in a maximum climb when the eng seized & immediately went into a power off stall. He recovered from the…NTSB SEA85LYA01Accident · No injuriesFinal reportRockwell S2R · Caldwell, IDAn aero commander S2R had been modified by the installation of an air research TPE-331-43A power plant. During an aerial application flight the pilot heard a loud bang and experienced a loss of power. Investigation revealed the first stage turbine whee, part…NTSB SEA85LA187Accident · No injuriesLimited investigationFinal reportGrumman 164A · Shelley, IDThe safety broke in the carburetor and the seat backed out causing fuel starvation. The carburetor had been overhauled 350 hours prior to the accident.NTSB SEA85LA140Accident · Serious injuriesLimited investigationFinal reportCessna 188A · Pocatello, IDDuring aerial application the aircrafts engine ceased operating. During engine tear down it was discovered that the engine's #2 connecting rod was broken and had come through the top of the crankcase. Recommended overhaul time is 1200 hours. This engine had a…NTSB SEA85LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt had finished spraying a field & was returning to the ag strip when the eng failed. He made an emerg landing in a barley field which was muddy & soft. During the landing roll, the wheels sank in the terrain & the acft nosed over. An exam revealed that…NTSB SEA84FA063Accident · 2 fatalField investigationFinal reportEnstrom 280C · Middleton, IDThe acft collided with the terrain during a test flt. Witnesses observed the acft rotate about 180 degrees about its vertical axis go nose low and descend vertically to the ground. A noise change described as a 'sputter' or tone change' was heard during this…NTSB SEA83LA102Accident · Serious injuriesLimited investigationFinal reportCessna TRI82 · Idaho Falls, IDDuring takeoff, the engine lost power after the plt started to make a turn at aprx 500 ft AGL. An emergency landing was made in a plowed field with the gear & flaps retracted. After touchdown, the acft slid aprx 100 yards, then stopped in a canal. An…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 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 SEA82FYA07Accident · Serious injuriesFinal reportHughes 369HS · Gooding, IDWhile making a turn at the end of a swath run, the pilot heard a bang and then noticed a loss of engine power. He entered an autorotative landing from a low altitude at low airspeed. Subsequently, the helicopter landed hard and rolled over on its right side.…