NTSB investigations
2,826 cases where the defining event was Loss of engine power (total).
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '341') 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 ERA22LA241Accident · No injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik Sportstar · Lancaster, OHThe improper installation and subsequent failure of the pushrod O-rings, which resulted in failure of the No. 4 connecting rod due to oil starvation.NTSB GAA22WA182Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Lost City, AustraliaNTSB GAA22WA179AccidentClass 5 · ForeignBell 206 · Cruziero do Sul, BrazilNTSB GAA22WA175Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Clan Airfield, South AfricaNTSB GAA22WA220Accident · No injuriesClass 5 · ForeignCessna 172 · Augsburg, GermanyNTSB ERA22LA216Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA1 · Seneca, SCA dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.NTSB GAA22WA186Accident · No injuriesClass 5 · ForeignCessna 182P · Trinidad, BoliviaNTSB ERA22LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Toms River, NJLoss of engine power due to the throttle linkage becoming disconnected in flight due to improper maintenance.NTSB CEN22LA187Accident · No injuriesClass 3 · LimitedFinal reportNorth American AT-6D · Fredericksburg, TXA total loss of engine power due to a failure of the No. 1 cylinder.NTSB GAA22WA167AccidentClass 5 · ForeignBeech 36 · Staad, SwitzerlandNTSB GAA22WA176Accident · 5 fatalClass 5 · ForeignCessna 207 · Carrefour, HaitiNTSB GAA22WA164Accident · No injuriesClass 5 · ForeignCirrus SR22 · Picarra, BrazilNTSB GAA22WA161Accident · Serious injuriesClass 5 · ForeignReims F172 · Hodenhagen, GermanyNTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.NTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…NTSB ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB GAA22WA152IncidentClass 5 · ForeignPiper PA-28-181 · Havre-Saint-Pierre, CanadaNTSB WPR22LA133Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Dennis Allen Varieze · Mojave, CAThe failure of the carburetor intake Sceet tubing, which resulted in a total loss of engine power.NTSB CEN22LA157Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Rayville, LAA loss of engine power for a reason that could not be determined based on available information.NTSB ERA22LA169Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Smithfield, NCMaintenance personnel’s failure to set the correct engine timing after the replacement of a cylinder head and exhaust camshaft before the accident flight, which resulted in a total loss of engine power.NTSB CEN22LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna L-19E · Sunflower, MSThe total loss of engine power for reasons that could not be determined.NTSB GAA22WA135Incident · No injuriesClass 5 · ForeignBeech A100 · La Guaira, VenezuelaNTSB GAA22WA131Accident · Serious injuriesClass 5 · ForeignPiper PA28-140 · Bragança Paulista, BrazilNTSB GAA22WA126Accident · Serious injuriesClass 5 · ForeignAyres SRT34 · Antioquia, ColombiaNTSB GAA22WA134Incident · No injuriesClass 5 · ForeignBeech 95B55 · San Fernando, ArgentinaNTSB GAA22WA130Accident · No injuriesClass 5 · ForeignCessna 150 · BragançA Paulista - Sp, BrazilNTSB ERA22LA155Accident · No injuriesClass 3 · LimitedFinal reportAircraft Designs Stallion · Ridgeland, SCA loss of sufficient electrical power to the engine’s electronic fuel injection/ignition system for undetermined reasons, which resulted in a total loss of engine power.NTSB CEN22LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Heavner, OKA total loss of engine power due to oil exhaustion which resulted from improper engine maintenance.NTSB ERA22LA146Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Waco, GAThe failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.NTSB WPR22LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Desert Camp, CAThe airplane’s loss of engine power due to carburetor icing.NTSB GAA22WA119Accident · 1 fatalClass 5 · ForeignPiper PA25 · Eldorado, BrazilNTSB GAA22WA118Accident · No injuriesClass 5 · ForeignMooney M20F · Balsas, BrazilNTSB ERA22LA131Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Miami Beach, FLA loss of engine power due to a stuck valve, which resulted in an autorotation and a hard landing in water.NTSB GAA22WA107Accident · Serious injuriesClass 3 · ForeignPiper PA28 · La Condensa, ColombiaNTSB GAA22WA104Accident · No injuriesClass 5 · ForeignCessna 152 · Concepción ( CLCP ), BoliviaNTSB GAA22WA098AccidentClass 5 · ForeignPiper PA-32-300 · Wiston East Sussex, United KingdomNTSB GAA22WA141Accident · Minor injuriesClass 5 · ForeignPiper PA23 · Hertfordshire, United KingdomNTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB GAA22WA068Accident · Minor injuriesClass 4 · ForeignCessna 402B · Berry Islands, BahamasNTSB GAA22WA067Accident · 2 fatalClass 5 · ForeignPiper PA-32-260 · Chame, PanamaNTSB ERA22LA099Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20C · Southeast Arcadia, FLThe total loss of engine power for reasons that could not be determined based on the available evidence for this investigation.NTSB GAA22WA062Accident · No injuriesClass 5 · ForeignCessna A188 · Yopal, ColombiaNTSB ERA22LA097Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 207 · Marathon, FLA total loss of engine power due to the failure of the No. 2 bearing, which resulted in the No. 2 connecting rod failing due to fatigue, high heat, and stress.NTSB CEN22LA089Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Iron Mountain, MIThe total loss of engine power after takeoff for undetermined reasons.NTSB GAA22WA053IncidentClass 5 · ForeignPiper PA34 · Newcastle, IrelandNTSB GAA22WA055Accident · Minor injuriesClass 5 · ForeignMcdonnell Douglas 500 · Unteriberg, SwitzerlandNTSB GAA22WA051Accident · No injuriesClass 3 · ForeignRobinson R66 · Boca de Yuma, Dominican RepublicNTSB GAA22WA076Accident · No injuriesClass 5 · ForeignCessna 172 · Pallisa-KAGWARA, Uganda