NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 MIA98FA187Accident · 1 fatalField investigationFinal reportMooney M-20E · Pickens, SCA loss of engine power for undetermined reasons and the pilot not maintaining adequate clearance with objects (trees) during the emergency landing. Contributing factors were the pilot's impairment associated with the use of an antihistamine and the trees.NTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…NTSB FTW98LA281Accident · Minor injuriesLimited investigationFinal reportRockwell Commander 112 · Las Vegas, NMThe pilot's improper preflight planning/preparation for a cross country flight resulting in fuel exhaustion and subsequent loss of engine power. Factors were, unsuitable terrain, lack of total aviation experience, and lack of total experience in make/model of…NTSB FTW98LA275Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hazen, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.NTSB SEA98LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Blackfoot, IDA loss of power for undetermined reasons.NTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX98LA194Accident · No injuriesLimited investigationFinal reportScott Dragonfly · Mecca, CAThe pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.NTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.NTSB ANC98LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe total loss of engine power for undetermined reasons.NTSB ATL98LA081Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Nicklesville, GAThe loss of engine power for undetermined reason. A factor was that weather conditions were favorable for the formation of carburetor ice.NTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW98LA258Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lazbuddie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC98LA125Accident · Serious injuriesLimited investigationFinal reportBeech BE 65-80 · Malone, NYThe pilot's failure to follow emergency procedures, and his failure to maintain control of the airplane after a loss of power from one engine. Factors include fuel filter blockage, inadequate maintenance, and the pilot's lack of experience in multi-engine…NTSB ANC98LA064Accident · No injuriesLimited investigationFinal reportCessna 185F · Iliamna, AKThe loss of engine power for undetermined reasons. A factor was the hilly terrain.NTSB CHI98LA190Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Lexington, NEAn improper autorotation by the pilot in command. Factors contributing to this accident were the accumulation of ice in the carburetor resulting in a total loss of engine power, and the soft terrain.NTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.NTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.NTSB CHI98FA187Accident · 1 fatalField investigationFinal reportCessna 421 · Little Falls, MNthe pilot's continued operation with a known deficiency in equipment.NTSB CHI98LA183Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Montague, MIthe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Factors to the accident were the carburetor icing conditions and the trees.NTSB FTW98LA249Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Iowa, LApartial loss of engine power during takeoff for undetermined reason(s). The obstructions (trees & dirt bank) were related factors.NTSB FTW98LA242Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Roanoke, TXThe loss of engine power resulting from an excessively rich mixture for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA180Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Orleans, NEthe pilot selected a field with unsuitable terrain and stalled the airplane. Additional factors were the tower in the field, and engine failure due to the improper torque applied to camshaft bolts by other maintenance personnel.NTSB ANC98LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe throttle arm disconnecting from the throttle linkage to the engine as a result of inadequate inspection by company maintenance personnel. Factors associated with this accident were the company maintenance personnel not following the repetitive Service…NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB ATL98LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB CHI98LA170Accident · 2 fatalLimited investigationFinal reportKreatz Genesis · Maple Lake, MNthe pilot inadvertently stalled the airplane. A factor was the failed reduction drive belts.NTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.NTSB CHI98LA160Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Benton, KSthe pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.NTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.NTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…NTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.NTSB NYC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Farmingdale, NYThe engine's inability to provide full power, and the pilot's failure to use performance data. Factors in the accident were conditions conductive for carburetor icing at reduced power, and the unsuitable terrain during the forced landing.NTSB CHI98LA150Accident · No injuriesLimited investigationFinal reportCessna A185F · Isanti, MNthe soft terrain condition. A factor was the failure of the crankshaft.NTSB IAD98LA053Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Nashua, NHThe pilot's improper fuel management which led to fuel starvation.NTSB CHI98LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hannibal, MOa loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.NTSB FTW98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.NTSB SEA98TA074Accident · Minor injuriesFinal reportBell UH-1H · Naches, WALoss of engine power for undetermined reasons.NTSB MIA98LA154Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe loss of engine power for undetermined reasons.NTSB SEA98LA072Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Toledo, WAPartial loss of power for undetermined reasons.NTSB FTW98LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA071Accident · Serious injuriesLimited investigationFinal reportBellanca 7-GCBC · Sebring, FLThe pilot's improper handling of the airplane which led to an inadvertent stall. A factor was the loss of engine power for undetermined reasons.NTSB FTW98LA193Accident · Serious injuriesLimited investigationFinal reportLerille P & W 1937 · Lafayette, LAThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB SEA98LA064Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Sedro Wooley, WAFuel contamination and subsequent carburetor fuel flow restriction initiated by the use of an improper material (incorrect fuel hose). A factor was the trees.NTSB NYC98LA096Accident · No injuriesLimited investigationFinal reportBeech C-50 · Ford, VAA loss of engine power simultaneously on both engines as reported by the pilot, for undetermined reasons.NTSB CHI98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Canton, MIThe undetermined loss of power reported by the pilot. Contributing factors were the residential nature of the landing area and unsuitable landing terrain.NTSB ATL98LA062Accident · No injuriesLimited investigationFinal reportStewart 51 S-51D · Vero Beach, FLThe maintenance personnel failure to remove a plastic plug from the oil tank breather that resulted in the rupture of the engine oil tank. Factors were, a tailwind during the emergency landing, and a ditch on the departure end of the runway.NTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.