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 ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…NTSB CEN21LA385Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Roads, LAA loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.NTSB CEN21LA379Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Industries DA-42 · Bellefontaine, OHThe improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA21WA207AccidentClass 5 · ForeignCessna P210N · Marbach, GermanyNTSB CEN21LA408Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Heavener, OKA total loss of engine power due to the failure of the No. 2 cylinder exhaust valve for reasons that could not be determined.NTSB GAA21WA256Accident · Minor injuriesClass 5 · ForeignCessna 152 · Peji, BoliviaNTSB WPR21LA313Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 425 · Helena, MTA flameout of both engines due to fuel starvation for reasons that could not be determined due to the airplane’s damage.NTSB GAA21WA204Accident · No injuriesClass 5 · ForeignCessna 152 · La Lumbrera, ChileNTSB ERA21LA321Accident · No injuriesClass 3 · LimitedFinal reportCubcrafters CC11-160 · Springfield, TNA loss of engine power for undetermined reasons.NTSB CEN21LA357Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Mer Rouge, LAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot and ground personnel’s miscalculation of available fuel.NTSB GAA21WA197Accident · No injuriesClass 5 · ForeignCessna 337 · Pozo Perdido, ChileNTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.NTSB GAA21WA194AccidentClass 5 · ForeignCessna 150 · Nottinghamshire, United KingdomNTSB GAA21WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Tannheim, GermanyNTSB ERA21LA310Accident · Serious injuriesClass 3 · LimitedFinal reportLiteflite PTY Dragonfly Model C · Middletown, NYThe improper installation of the carburetor, which resulted in a momentary total loss of engine power during initial climb. Contributing was the pilot’s failure to maintain control of the airplane following the initial power loss.NTSB CEN21LA343Accident · Minor injuriesClass 3 · LimitedFinal reportStinson JR. SR · Ripon, WIA total loss of engine power due to fuel starvation.NTSB GAA21WA200Accident · No injuriesClass 3 · ForeignCessna 206 · Paranam, SurinameNTSB WPR21LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Mt. Hood, ORThe total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…NTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.NTSB WPR21LA271Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Riverside, CAA total loss of engine power for reasons that could not be determined from available evidence.NTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.NTSB ERA21LA288Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Canada DHC-1 Chipmunk X · Lebanon, TNA total loss of engine power during the initial climb for reasons that could not be determined based on the available evidence.NTSB ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.NTSB GAA21WA171AccidentClass 5 · ForeignBell 412 · Ejea de los Caballeros, SpainNTSB ENG21WA032IncidentClass 4 · ForeignAirbus A220 · Copenhagen, DenmarkNTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.NTSB CEN21LA309Accident · No injuriesClass 3 · LimitedFinal reportTitan T-51D · Ashtabula, OHThe tripped engine control computer circuit breaker caused by an excessive electrical load on the system, which resulted in a complete loss of engine power during the initial climb.NTSB GAA21WA168Accident · No injuriesClass 5 · ForeignBoeing A75N1(PT17) · Luneburg, GermanyNTSB ERA21LA277Accident · No injuriesClass 3 · LimitedFinal reportVans RV7 · Pottstown, PAA total loss of power for reasons that could not be determined based on the available information.NTSB CEN21FA304Accident · 1 fatalClass 3 · FieldFinal reportFocke-Wulf FWP-149D · Killeen, TXThe total loss of engine power due to a fatigue failure of a crankshaft counterweight mounting lobe, which resulted in a counterweight separation and catastrophic secondary damage to the engine drivetrain. Contributing to the accident was the mislabeled…NTSB WPR21LA250Accident · No injuriesClass 3 · LimitedFinal reportL-Bird CCX-2000 · Hood River, ORThe total loss of engine power due to improper construction of the muffler, which resulted in separation of the internal components.NTSB GAA21WA190Accident · No injuriesClass 5 · ForeignCabri G2 · Lostallo, SwitzerlandNTSB GAA21WA152Accident · No injuriesClass 5 · ForeignCessna 208 · Teuge, NetherlandsNTSB ERA21LA267Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Easton, MDA total loss of engine power for reasons that could not be determined.NTSB WPR21LA234Accident · No injuriesClass 4 · LimitedFinal reportBolstridge Wallace R SKY Raider 1 · Nampa, IDA total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.NTSB CEN21LA287Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sedgwick, ARThe total loss of engine power due to the failure and disengagement of the torque sensor assembly front spur gear from its splined shouldered shaft due to a loose self-locking nut.NTSB GAA21WA151Accident · No injuriesClass 5 · ForeignCessna 188 · Bataypora, BrazilNTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…NTSB ERA21LA250Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · Matthews, VAThe mechanic’s failure to properly secure the oil sump drain plug during a 100-hour maintenance inspection, which resulted in a total loss of engine power due to oil starvation.NTSB CEN21LA265Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Columbus, OHThe loss of engine power due to fuel starvation resulting from sealant contamination in the wing.NTSB GAA21WA144Accident · No injuriesClass 5 · ForeignLancair 360 · Neuenrade, GermanyNTSB CEN21LA264Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Elwood, NEThe failure of the engine master rod, resulting in a total loss of engine power and a forced landing.NTSB GAA21WA143Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Auckland, New ZealandNTSB WPR21LA303Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Yelm, WAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA284Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Reserve, LAA total loss of engine power for undetermined reasons.NTSB GAA21WA142Accident · 4 fatalClass 4 · ForeignCessna 310 · RondonóPolis, BrazilNTSB GAA21WA203Incident · No injuriesClass 4 · ForeignRobinson R44 · Ma'ale Edomin, IsraelNTSB GAA21WA139IncidentClass 5 · ForeignCessna 152 · Daleszyce, PolandNTSB ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.