NTSB investigations
3,825 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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" = '341' 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 ERA19LA280Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Manville, NJA total loss of engine power due to the ingestion of sealant material that had loosened inside the carburetor airbox.NTSB GAA19WA589Accident · No injuriesForeign investigationCessna 172 · Baska, Krk Island, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on September 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the…NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB CEN19TA321Accident · No injuriesClass 3Final reportPiper PA46 · Gulf of MexicoA loss of engine power for undetermined reasons.NTSB CEN19LA331Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Orange, TXA total loss of engine power due to a fatigue failure of the fuel line from the fuel manifold to the No. 1 cylinder.NTSB CEN19LA320Accident · Minor injuriesClass 2 · LimitedFinal reportCirrus SR22 · Hoagland, INA catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance…NTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.NTSB CEN19LA317Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Boca Raton, FLThe total loss of engine power for reasons that could not be determined based on available evidence and the pilot’s decision to take off without fully troubleshooting the partial loss of engine power that occurred during the previous flight.NTSB CEN19LA309Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Walkerton, INThe partial loss of engine power due to fuel contamination.NTSB ERA19LA267Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Berlin, MDThe malfunction of the No. 9 pushrod, which resulted in a total loss of engine power.NTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.NTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…NTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.NTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.NTSB ERA19LA264Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Foley, ALTotal loss of engine power due to a fatigue failure of the camshaft gear.NTSB ANC19LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18 · Fairbanks, AKThe inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power.NTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.NTSB WPR19LA240Accident · No injuriesClass 3 · LimitedFinal reportScoda Aeronautical Super Petrel · Lancaster, CAThe improper sealing of both carburetor bowls, which resulted in a total loss of engine power.NTSB ERA19LA258Accident · No injuriesClass 3 · LimitedFinal reportBeech F33 · Hobe Sound, FLA bearing shift, which resulted in a loss of lubrication to the crankshaft, the failure of the crankshaft, and a total loss of engine power.NTSB WPR19LA238Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Half Moon Bay, CAA total loss of engine power for reasons that could not be determined.NTSB ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.NTSB CEN19LA281Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Grand Rapids, MNA loss of engine power after takeoff for undetermined reasons.NTSB ERA19LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 31P · East Brady, PAA total loss of left engine power for undetermined reasons.NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…NTSB CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…NTSB ERA19TA254Accident · Minor injuriesClass 3Final reportGIger Frank R Nieuport II · Talladega, ALA total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.NTSB ENG19WA032Incident · No injuriesForeign investigationAirbus A320 · Nassau, BahamasThe Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions…NTSB CEN19WA341Accident · No injuriesForeign investigationCessna 150 · Ravna Gora, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions…NTSB GAA19CA495Accident · Minor injuriesData collectionFinal reportFlight Design CT2K · Hooper, WAThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.NTSB WPR19LA222Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 601XLB · Jamul, CALoss of engine power due to an undetermined loss of electrical power to the engine control system. Contributing factors were the lack of a redundant system to provide for engine control should the engine control system be deprived of electrical power or fail.NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19WA272Incident · No injuriesForeign investigationReims Aviation Cessna F172N · Lesnovo, BulgariaOn August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…NTSB WPR19LA217Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · Prospect, ORThe failure of the counterweight retainer pin plate which resulted in a total loss of engine power.NTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.NTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19LA258Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172 · North Garden, VAA total loss of engine power due to the failure of the oil pump drive gear.NTSB CEN19LA249Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185 · Saginaw, MIMaintenance personnel’s failure to properly align the crankshaft during an engine reassembly which led to a fatigue failure of the crankshaft and the loss of all engine power.NTSB CEN19CA239Accident · No injuriesData collectionFinal reportCessna 172 · Oshkosh, WIThe pilot's improper fuel planning and decision to not divert to a closer airport when the planned flight profile changed, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportCulver LCA · Viroqua, WIA total loss of engine power due to fuel exhaustion.NTSB WPR19WA203Accident · No injuriesForeign investigationRIchards Heavylift UH-1H · Limpopo Province, South AfricaOn July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…NTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB CEN19LA231Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Breckenridge, MIA total loss of engine power due to a lack of oil in the engine. The source of the inflight oil leak could not be determined based on the available information.NTSB CEN19LA230Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Ida Grove, IAA total loss of engine power during an aerial application flight for undetermined reasons.NTSB WPR19LA192Accident · No injuriesClass 3 · LimitedFinal reportJudd Challenger II · Draper, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA19LA228Accident · No injuriesClass 3 · LimitedFinal reportPietenpol BIG Piet · Gainesboro, TNSeparation of the spinner cap for reasons that could not be determined based on available evidence, which resulted in contact and subsequent separation of the wooden propeller blade tip.NTSB WPR19LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna P206 · Cascade, IDA loss of engine power due to the pilot’s improper leaning of the engine.