NTSB investigations, ID
81 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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.\"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\" = 353)
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" = 353) 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 SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…NTSB SEA88LA145Accident · No injuriesLimited investigationFinal reportBeech K-35 · Halley, IDEngine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left…NTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.NTSB SEA87IA139Incident · No injuriesIncident investigationFinal reportBeech 55 · Rigby, IDDuring descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed…NTSB SEA86FA139Accident · Serious injuriesField investigationFinal reportHiller UH12B · Rathdrum, IDThe plt reported noticing the fuel gage was nearing empty shortly before the eng quit. The acft crashed during an attempted forced landing on a road. The plt stated he was flying the acft to his residence where it was based. Investigation revealed little fuel…NTSB SEA86LA029Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Idaho Falls, IDA total loss of power occurred during an ILS approach due to induction ice. During touchdown on 12 inches of snow a nose over occurred.NTSB SEA85FA225Accident · 3 fatalField investigationFinal reportCessna 177BII · Lolo Pass, IDThe plt failed to visually check the fuel tanks during preflt and departed with 3.4 hours flown on the pre-existing fuel supply. Fuel exhaustion occurred 1.2 hours into the flt. The plt overflew a suitable forced landing site and attempted a last minute turn…NTSB SEA85LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Pocatello, IDUpon arrival in the vicinity of his destination the plt commenced a reduced pwr descent while in conditions which were conducive to carburetor iceing. During the descent the plt applied carburetor heat with a resultant drop in RPM and, apprehensive of this…NTSB SEA85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mccall, IDThe acft was damaged during a forced landing in a fld following fuel exhaustion. The plt reported he departed yellow pine, ID, with the fuel gages indicating 1/2. Upon reaching an alt of 10,000 ft, the eng quit due to fuel exhaustion. The right fuel tank was…NTSB SEA85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Boise, IDOn final approach, the pilot's wife, also a rated pilot, was reviewing the landing check list. At item 'heaters off' she inadvertently turned fuel selectors to off. Both engines lost pwr and pilot executed a forced landing short of runway in rough terrain,…NTSB SEA85LA023Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Pocatello, IDThe acft had descended to about 900 AGL after passing through icing conditions with a light accumulation of ice. When the landing gear was lowered the acft started yawing and the acft engine instruments were flucuating. The plt thought that the engines were…NTSB SEA85LA022Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Nampa, IDFollowing a power loss-induced forced landing two days prior, the acft fuel pump and carburetor were changed and fuel lines flushed. Six hours of uneventful operations ensued before the power loss leading to this mishap occurred. Pwrloss occurred when the…NTSB SEA84LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210-5(205) · Mountain Home, IDDuring climb the rpms started to decrease. The acft was unable to maintain alt and a forced landing was made. During investigation a bogus fuel filter was found between the fuel control unit and the fuel injector. The filter was clogged with debris. The…NTSB SEA84LA118Accident · Minor injuriesLimited investigationFinal reportVarga 2150-A · Mountain Home, IDThe student plt became lost on the last leg of his x-country, solo flt. He final determined that his position was over boise, ID, about 35 mi from his destination. He turned to follow railroad tracks. About 15 min later, the eng ceased operating due to fuel…NTSB SEA84LA079Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Idaho Falls, IDThe student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…NTSB SEA84LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Burley, IDThe plt stated the engine lost power because of fuel exhaustion. A forced landing was performed in a field during which the acft contacted a ditch. The acft was flown 4.1 hrs since it had last been refueled.NTSB SEA84FA020Accident · 1 fatalField investigationFinal reportJodel-Bernier Jodel F-11 · Inkom, IDThe acft crashed during a forced landing attempt after the engine quit. The pilot reported the engine stopped while in cruise flt. It started and stopped and started a 2nd time but would not maintain flt. The pilot turned toward a hayfieldfor landing. The…NTSB SEA83FA179Accident · No injuriesField investigationFinal reportMooney M20E · Nampa, IDWhile climbing, aprx 10 miles west of the departure airport, the eng lost power. The plt attempted to glide back to the arpt. When he realized he could not reach the arpt, he selected a grassy field for an emergency landing. During the landing roll, the right…NTSB SEA83LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Driggs, IDThe plt stated that the fuel tanks were topped off on the day before he departed el monte, CA. He estimated that the acft had 534 lbs of fuel on board & consumed 80 pph during cruise at 9500 ft MSL. According to the plts operating manual, the acft had an…NTSB SEA83LA159Accident · Minor injuriesLimited investigationFinal reportVangrunsven RV-3 · Twin Falls, IDThe home built plane was one of a flt of four acft that were being flown on a cross-country flt. While en route from hillsboro, or to Twin Falls, ID, the pilots had to divert around weather. As they were approaching Twin Falls, N17RV lost power from fuel…NTSB SEA83LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Fort Hall, IDThe acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed…NTSB SEA83LA105Accident · No injuriesLimited investigationFinal reportCallair A-9B · Winear, IDThe acft collided with a fence during an off airport forced landing. The pilot was completing an aerial application pass & when the low fuel warning light came on the pilot switched tanks & turned on fuel booster. The engine quit at about 200 feet AGL.…NTSB SEA83LA077Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · American Falls, IDThe acft was damaged in an off airport forced landing due to water in the fuel. The acft took off and at 3OO feet the left engine quit. The pilot was attempting a left turn back to the airport when the right engine started to sputter. Thepilot landed straight…NTSB SEA82DA172Accident · No injuriesFinal reportCessna 188B · Lava Hot Spring, IDReportedly, the aircraft ran out of fuel during a swath run. During a forced landing, the aircraft struck a fence, then traveled about 400 ft and stopped with the nose down in a potatoe field.NTSB SEA82FYP11Accident · Serious injuriesFinal reportHiller UH-12-SOLOY · Kellogg, IDThe plt stated he had just released a load of logs & started his transition into forward flt when the eng failed. No usable fuel was on board. The plt stated the fuel gauge registered 50 pounds of fuel when the eng failed. A leak test of the fuel suction…NTSB SEA82FA122Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · 10 Nm E. Of Ken, IDThe plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.NTSB SEA82DA097Accident · Minor injuriesFinal reportMooney M20A · Twin Falls, IDDuring his preflight inspection, the pilot noted that the right fuel tank was partially full, but the left tank was nearly empty. The left tank was serviced with 12 gallons of fuel, but the pilot reported that the fuel selector was inadvertently left in the…NTSB SEA82DA085Accident · No injuriesFinal reportBell 206B · Swan Valley, IDThe aircraft crashed during an external load operation at an elevation of about 6700 ft MSL in mountainous terrain. The pilot reported that the fuel gauge indicated 8 gallons remaining when he last checked it before the accident. Reportedly, he checked his…NTSB SEA82DA020Accident · No injuriesFinal reportSikorsky S-58J · Near Kingston, IDThe aircraft was engaged in logging operations. While in a hover to pick up a second load of logs, the engine lost power. An autorotation was made into a creek bed. An inspection revealed that snow and water from the cabin interior had penetrated the cabin…