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 LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB DEN99LA149Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402A · Mead, COThe pilot's failure to follow proper approach to landing procedures as outlined in the Airplane Flight Manual. A factor was the 6-foot tall corn stalks.NTSB SEA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Freeland, WAThe pilot-in-command's improper use of carburetor heat and overload of the nose gear assembly during the forced landing. Contributing factors were carburetor icing conditions, the ditch and fence.NTSB CHI99LA286Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Evansville, INfuel exhaustion due to the flight instructor's improper in-flight decision. A factor was the ditch.NTSB DEN99LA139Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Elizabeth, COA forced landing on unsuitable terrain following a total loss of power for non mechanical reasons. Factors were the pilot's failure to follow emergency procedures for restarting the engine, operating the aircraft with known deficiencies, and inaccurate…NTSB SEA99LA133Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Renton, WAA loss of engine power for undetermined reasons. A factor was insufficient altitude available to return to the departure runway following the loss of power.NTSB CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB CHI99LA268Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Edelstein, ILan inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.NTSB FTW99LA206Accident · No injuriesLimited investigationFinal reportMooney M20J · Mount Pleasant, TXThe separation of the fuel line fitting as a result of fatigue. A factors was the lack of suitable terrain for a forced landing.NTSB MIA99LA205Accident · No injuriesLimited investigationFinal reportCessna R172K · Pontotoc, MSa complete loss of engine power due to the failure of the oil pressure pump, resulting in oil starvation, a forced landing and subsequent nose over.NTSB CHI99LA257Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Jetmore, KSThe pilot's use of improper procedures by not following the helicopter manufacturer's recommended engine RPM reduction procedures during autorotations. A factor was the pilot not attaining the proper rotor RPM during the autorotation practice.NTSB CHI99LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Salina, KSthe inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.NTSB ATL99LA114Accident · No injuriesLimited investigationFinal reportMaule M-5-200 · St.Simons, GAThe inadequate installation of the magneto assembly by other maintenance personnel that in resulted the separation from the engine and the subsequent loss of engine power. A factor was the swampy terrain condition.NTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB MIA99LA201Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLa loss of engine power due to a stuck exhaust valve which resulted in a forced landing, the subsequent impact with the ground, and nose over.NTSB LAX99LA256Accident · No injuriesLimited investigationFinal reportCessna 172E · Emeryville, CAThe pilot's inadequate in-flight planning and inadequate fuel consumption calculations, resulting in a total loss of engine power due to fuel exhaustion. Factors were the pilot's failure to have all appropriate flight manuals aboard the airplane and the low…NTSB SEA99LA125Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · American Falls, IDA loss of engine power for undetermined reasons, and overload of the (right) main landing gear. A contributing factor was the rough terrain.NTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.NTSB FTW99LA198Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · Fort Worth, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.NTSB CHI99LA254Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNthe premature gear retraction and proper runway alignment not maintained during takeoff by the pilot. An additional cause was the proper descent rate not maintained by the pilot. Contributing factors were the carburetor icing conditionsNTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.NTSB ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.NTSB CHI99LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boscobel, WIthe pilot's improper approach to landing. Factors included the carburetor icing, the delayed use of carburetor heat, the unsuitable terrain for landing, and the ditch.NTSB ANC99LA093Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingham, AKThe inadequate preflight by the pilot, which failed to detect water contamination of the airplane's fuel.NTSB ANC99LA105Accident · No injuriesLimited investigationFinal reportNix Avid Flyer · Chugiak, AKA loss of engine power for an undetermined reason.NTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.NTSB NYC99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Falmouth, KYA stuck intake-valve on the number one cylinder which resulted in a loss of engine power.NTSB SEA99FA112Accident · 1 fatalField investigationFinal reportBeech A23 · Eatonville, WAImproper fuel management which led to fuel starvation.NTSB CHI99LA255Accident · Minor injuriesLimited investigationFinal reportBuss Avid Flyer Mark IV · New London, WIthe inadequate preflight planning/preparation by the pilot. Factors to the accident were the powerplant seizing and the misjudged flare by the pilot.NTSB FTW99LA186Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Gheens, LAThe loss of engine power due to fuel starvation as result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB SEA99LA111Accident · No injuriesLimited investigationFinal reportWalentine RV4 · Creswell, ORA foreign material/substance was ingested into the carburetor which resulted in a power loss.NTSB LAX99LA246Accident · No injuriesLimited investigationFinal reportSmith Avid Stol Hauler · S. Lake Tahoe, CAA loss of engine power for undetermined reasons.NTSB FTW99LA187Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Wallis, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lyons, KSThe pilot's inadequate fuel management leading to fuel exhaustion.NTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.NTSB SEA99LA101Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Auburn, WATotal mechanical failure of the hydraulic tappet. A factor was an overdue major overhaul per manufacturer's recommendations.NTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.NTSB FTW99LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Houston, TXThe pilot's failure to maintain the proper descent rate during a forced landing, which resulted in a runway undershoot. Factors were the total loss of engine power for an undetermined reason and the dusk light conditions.NTSB DEN99LA110Accident · No injuriesLimited investigationFinal reportCessna 182A · Salt Lake City, UTA total loss of engine power (nonmechanical) for reasons undetermined. Factors were the existence of conditions conducive to carburetor icing, and unsuitable terrain on which to make a forced landing.NTSB MIA99LA192Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rock Springs, NC**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB LAX99LA237Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Williams, CAThe pilot's inadequate preflight planning and verification that fuel was available for the intended flight. A factor was the fuel quantity false indication.NTSB ATL99FA102Accident · 2 fatalField investigationFinal reportBeech BE-58 · Atlanta, GAThe loss of engine power for undetermined reasons, and the pilot's failure to follow emergency procedures that resulted in the uncontrolled collision with trees.NTSB ANC99LA084Accident · No injuriesLimited investigationFinal reportJasper THUNDERBIRD-2C · Chugiak, AKThe failure of the pilot in command to maintain the proper rate of descend and flare, following an engine failure for undetermined reasons.NTSB SEA99LA093Accident · Minor injuriesLimited investigationFinal reportModrow Avid Flyer · Poulsbo, WAEngine seizing due to failure of main bearing assemblies. Factors include foreign material in the labyrinth sleeve, and a stall encountered while the pilot was attempting his emergency landing.NTSB NYC99LA156Accident · Serious injuriesLimited investigationFinal reportCessna 185E · East Haddam, CTThe loss of engine power due to water in the fuel system.NTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.NTSB SEA99LA089Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Tetonia, IDA failure of the right magneto drive gear shaft. Factors include the absence of any suitable terrain on which to perform an emergency landing, and the rough/uneven condition of the terrain on which the pilot was forced to land.NTSB MIA99LA186Accident · Serious injuriesLimited investigationFinal reportRobert R. Callahan Exec 90 · Lutz, FLThe excessive cyclic input by the non-qualified passenger during the autorotative landing following a reported loss of engine power. A factor in the accident was the inadequate preflight of the helicopter by the unqualified pilot for his failure to detect…NTSB NYC99FA150Accident · 1 fatalField investigationFinal reportCanadair F-86E · Mount Holly, NJA failure in the fuel transfer system which resulted in fuel starvation and subsequent loss of engine power.