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 NYC07LA207Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Goshen, NYA loss of engine power during cruise flight for undetermined reasons.NTSB DFW07CA194Accident · Minor injuriesData collectionFinal reportNicely Kitfox Model 5 · Guthrie, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable landing terrain for the forced landing.NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA07CA239Accident · No injuriesData collectionFinal reportCessna 210L · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA253Accident · No injuriesLimited investigationFinal reportEdra Aeronautica Seastar · Kapolei, HIA loss of engine power due to fuel starvation that resulted from the pilot's inadequate preflight planning/preparation and failure to ensure that an adequate fuel supply was onboard the aircraft.NTSB NYC07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vandemere, NCThe loss of engine power due to the failure of the supercharger bearings.NTSB DEN07CA141Accident · Minor injuriesData collectionFinal reportEaa Biplane P · Parker, COThe loss of engine power for undetermined reasons. A contributing factor was the pilot's intentional maneuver into a piece of machinery.NTSB DFW07LA187Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Cary, MSThe total loss of engine power due to a power turbine failure. Contributing to the accident were the lack of suitable terrain available to pilot for the forced landing and the low altitude.NTSB ATL07LA116Accident · 2 fatalLimited investigationFinal reportNiva Thorp T-18 · Wellington, FLA loss of engine power due to a partially blocked intake manifold and water contamination of the fuel.NTSB ANC07LA086Accident · No injuriesLimited investigationFinal reportAeronca AR-15 · Clear, AKThe loss of engine power during cruise flight for an undetermined reason.NTSB CHI07CA268Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Cooksville, ILThe partial loss of engine power during the takeoff roll for undetermined reasons and the pilot's unsuccessful compensation for the tailwind conditions. Factors contributing to the accident were the tailwind and the corn crop.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB DFW07LA172Accident · No injuriesLimited investigationFinal reportCessna 172C · Pascagoula, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.NTSB LAX07LA245Accident · Minor injuriesLimited investigationFinal reportBurnham Avid Flyer · Sequim, WAa loss of engine power due to a dual ignition system failure.NTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.NTSB SEA07CA226Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Waterville, WAThe loss of engine power during takeoff for an undetermined reason. A contributing factor was the high vegetation in the field where the airplane came to rest.NTSB CHI07CA267Accident · No injuriesData collectionFinal reportSnow S-2C · Hazelton, NDThe loss of engine power for undetermined reasons.NTSB CHI07CA259Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Creston, IAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel calculations.NTSB NYC07LA187Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Chamblee, GAThe pilot’s failure to utilize all of the power available following an engine failure. Contributing to the accident were the failure of the rear engine for undetermined reasons.NTSB LAX07CA244Accident · No injuriesData collectionFinal reportBeech 36 · Jean, NVA loss of engine power for undetermined reasons.NTSB CHI07CA255Accident · No injuriesData collectionFinal reportButtles SNS-7 · Lapeer, MIThe fuel starvation for an undetermined reason, and the unsuitable terrain encountered during the forced landing. The trees were a factor.NTSB MIA07LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Andersonville, GAThe pilot's improper decision to make a 180-degree turn at low altitude to return to the departure runway following a loss of engine power during takeoff-initial climb. A factor in the accident was contamination in the carburetor.NTSB CHI07CA248Accident · No injuriesData collectionFinal reportBeech B60 · Bismark, NDThe improper fuel grade due to the improper fueling of the airplane by the fixed base operator, which led to the loss of engine power of both engines. A factor was the unsuitable terrain encountered during the forced landing.NTSB ANC07CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Anaktuvuk Pass, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during approach due to water contaminated fuel.NTSB ANC07LA071Accident · No injuriesLimited investigationFinal reportCessna 185E · Talkeetna, AKThe loss of engine power during cruise flight due to an improperly repaired airbox.NTSB DFW07LA173Accident · Serious injuriesLimited investigationFinal reportBell 206B · Grand Prairie, TXThe loss of engine power as result of the failure of one or more of the compressor blades for the 5th stage compressor for undetermined reasons. A contributing factor was the lack of suitable terrain for the pilot to execute a successful autorotation.NTSB DEN07LA130Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cooperstown, NYThe loss of engine power due to carburetor icing. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions conducive for carburetor icing.NTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB CHI07CA227Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Prophetstown, ILThe pilot's failure to accurately monitor fuel consumption during flight, which resulted in a loss of engine power due to fuel starvation/exhaustion. A contributing factor was the cornfield encountered during the forced landing.NTSB SEA07LA209Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Nampa, IDThe total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.NTSB CHI07LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Moline, ILFatigue failure of the engine cylinder during cruise flight resulting in a loss of engine power. Additional causes were the pilot's failure to maintain sufficient airspeed and the resulting inadvertent stall during the forced landing. A contributing factor…NTSB ATL07LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Sussex, NJA loss of engine power for undetermined reasons.NTSB NYC07LA170Accident · No injuriesLimited investigationFinal reportLearjet 25 · St. Augustine, FLA loss of power on both engines for an undetermined reason.NTSB CHI07LA224Accident · No injuriesLimited investigationFinal reportBeech V35B · Rockford, ILA loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the unsuitable terrain (corn field) encountered during the landing.NTSB NYC07LA171Accident · 1 fatalLimited investigationFinal reportMidget Mustang M-1 · Covode, PAA loss of engine power for undermined reasons.NTSB DFW07LA167Accident · No injuriesLimited investigationFinal reportRotorway 162F · Stratford, OKThe loss of engine power due to a seized supercharger. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA217Accident · No injuriesData collectionFinal reportChrapczynski M1 Midget Mustang · Elyria, OHThe pilot's failure to maintain proper glide speed during the forced landing after takeoff, which resulted in an inadvertent stall/mush condition and a hard landing. A contributing factor was the loss of engine power after takeoff for undetermined reasons.NTSB SEA07CA221Accident · No injuriesData collectionFinal reportBritten-Norman BN-2A-20 · Stanley, IDThe pilot's failure to verify that the airplane was refueled, which resulted in a loss of engine power from both engines due to fuel exhaustion and a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07TA203Accident · No injuriesFinal reportCessna TU206G · New Meadows, IDThe loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.NTSB DFW07LA162Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315 · Stuart, OKThe loss of engine power due to a clogged fuel tube. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA154Accident · Minor injuriesLimited investigationFinal reportWsk-Pzl Mielic M-18A · Tunica, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA206Accident · No injuriesData collectionFinal reportGrumman G-164B · Alicia, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the low altitude at which the loss of power occurred and the flooded rice field in which the airplane was landed.NTSB DEN07LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Ulysses, KSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07TA208Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.NTSB NYC07LA160Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Berkeley Townsh, NJA loss of engine power during cruise flight for undetermined reasons.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.