NTSB investigations
1,858 cases where the sequence of events included Loss of engine power (partial).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA25WA067Accident · No injuriesClass 5 · ForeignPiper PA31 · Canelillos, ChileNTSB ERA25LA098Accident · Minor injuriesClass 3 · LimitedPreliminary reportMontaer Ltda Montaer MC01 · Miramar, FLOn January 19, 2025, about 1410 eastern standard time, a Montaer MC-01, N916VS, was substantially damaged when it was involved in an accident near Miramar, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR25LA084Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Prescott, AZOn January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB GAA25WA074Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Paracatu, BrazilNTSB DCA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Atlanta, GASubstantial injury to a passenger sustained during evacuation.NTSB GAA25WA054Accident · Minor injuriesClass 3 · ForeignCessna 188 · Colon, EcuadorNTSB GAA25WA043Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Los Lagos, ChileNTSB ERA25FA076Accident · 1 fatalClass 3 · FieldPreliminary reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTOn December 12, 2024, about 1846 eastern standard time, a Costruzioni Aeronautiche Tecnam P2008, N298PM, was substantially damaged when it was involved in an accident near Greenwich, Connecticut. The commercial pilot was fatally injured, and the private pilot…NTSB GAA25WA039Accident · Serious injuriesClass 5 · ForeignCessna Cessna FA 150L · Watorowo, PolandNTSB WPR25LA054Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150L · Glen Avon, OROn December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ENG25WA013OccurrenceClass 5 · ForeignBoeing 737-9 · Cancún, MexicoNTSB ENG25WA010IncidentClass 5 · ForeignAirbus A320 · Aukland, New ZealandNTSB CEN25LA054Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1B · Brenham, TXA partial loss of engine power due to an obstructed induction system from a mud dauber nest.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB CEN25LA041Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 F · Blaine, MNA loss of engine power that resulted in a hard landing.NTSB ERA25LA041Accident · Minor injuriesClass 3 · LimitedFinal reportAnderson Kitfox 4 · New Castle, PAA partial loss of engine power due to a split fuel line that resulted in a fuel leak and reduced fuel supply to the aft carburetor.NTSB GAA25WA017Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Zona-Bananera-Magdalena, ColombiaNTSB ENG25WA002OccurrenceClass 5 · ForeignTextron Beech G58 · Okayama, JapanNTSB CEN25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Denton, TXThe partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind.NTSB CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB ERA25LA011Accident · No injuriesClass 3 · LimitedFinal reportSaint Glasair II SFT · Forest, VAThe installation of a non-failsafe coupler that resulted in the separation of the throttle cable from the throttle arm and a subsequent partial loss of engine power.NTSB GAA25WA009Accident · Minor injuriesClass 5 · ForeignCessna U206 · Barinas, VenezuelaNTSB CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.NTSB ERA25LA002Accident · 1 fatalClass 3 · LimitedPreliminary reportFokker D Viii Replica · Rhinebeck, NYOn October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was…NTSB WPR25LA001Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Bakersfield, CAOn October 2, 2024, about 1347 Pacific daylight time, a Cirrus SR22, N752B, was substantially damaged when it was involved in an accident near Bakersfield, California. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA24LA392Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · LaGrange, GAImproper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.NTSB GAA24WA305Incident · No injuriesClass 5 · ForeignRobinson R44 · Warsaw, PolandNTSB GAA24WA291Accident · Minor injuriesClass 5 · ForeignGrumman G164 · Rivera, UruguayNTSB DCA24WA313IncidentClass 5 · ForeignDouglas DC9 · Maiquetia, VenezuelaNTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB CEN24LA350Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Englewood, COA partial loss of engine power due to fuel-oil contamination of the fuel injection servo.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB CEN24LA341Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D · Trojan, SDThe partial loss of engine power due to a loose magneto and subsequent impact with terrain.NTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB GAA24WA275Accident · No injuriesClass 5 · ForeignCessna 152 · Daszewice, PolandNTSB GAA24WA267Accident · No injuriesClass 5 · ForeignRobinson R66 · Poblacion, ChileNTSB GAA24WA322Accident · 1 fatalClass 5 · ForeignWassmer WA54 · Chartres, FranceNTSB CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB GAA24WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Provincia de Neuquén, ArgentinaNTSB CEN24LA301Accident · Minor injuriesClass 3 · LimitedFinal reportTailwind W10 · West Livingston, TXA partial loss of engine power due to carburetor ice.NTSB ERA24LA333Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Egg Harbor City, NJA partial loss of engine power due to the fatigue failure of the alternate air valve, which separated and partially obstructed the engine’s induction system.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB ENG24WA027OccurrenceClass 5 · ForeignAirbus A321 · Toluca, MexicoNTSB CEN24LA269Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-36-375 · Avoca, NEA partial loss of engine power due to the loose left magneto which resulted in erratic engine timing.NTSB ERA24FA301Accident · 1 fatalClass 3 · FieldFinal reportCessna 402B · Aguadilla, PRThe pilot’s decision to operate the airplane with known maintenance discrepancies, which resulted in a total loss of right engine power. Contributing to the outcome was the pilot’s failure to maintain airspeed while returning to the airport with a single…NTSB ERA24LA299Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 8GCBC · Frankford, DEA partial loss of engine power resulting from cylinder detonation and a cracked spark plug, which resulted in a forced landing and impact with terrain.NTSB GAA24WA237Accident · No injuriesClass 5 · ForeignCessna 150 · Vern-sur-Seiche, FranceNTSB GAA24WA204Accident · Minor injuriesClass 5 · ForeignCessna A188 · Cienaga, ColombiaNTSB ANC24LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland-Kenmore DHC-2 · Juneau, AKA partial loss of engine power during initial climb due to a cracked cylinder.