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 GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.NTSB CEN18WA254Accident · No injuriesForeign investigationBritten Norman BN2A · Ambergris Caye, BelizeNTSB WPR18LA194Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Salisbury, NCA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available information.NTSB ERA18LA181Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35B33 · Berlin, MDThe failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.NTSB ANC18LA051Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Anchorage, AKThe total loss of engine power due to fuel starvation for reasons that could not be determined, which resulted in impact with and subsequent sliding across terrain.NTSB WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.NTSB CEN18LA239Accident · Serious injuriesLimited investigationFinal reportSibila MH-1 · Beach City, OHThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB CEN18LA237Accident · No injuriesLimited investigationFinal reportZenith Stol CH701 · Maple Lake, MNThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.NTSB ERA18LA172Accident · No injuriesLimited investigationFinal reportMooney M20J · Monroe, NCA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.NTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.NTSB ERA18LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172D · Quinton, VAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18LA168Accident · No injuriesClass 3 · LimitedFinal reportStinson L 5 · Thomson, GAFailure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…NTSB CEN18LA225Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Cheyenne, WYA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA165Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Arecibo, PRMaintenance personnel's failure to properly apply torque to the engine through bolts, which ultimately resulted in the crankshaft failure and the total loss of engine power.NTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.NTSB CEN18LA213Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Uvalde, TXThe loose oil filter, which resulted in oil starvation and a total loss of engine power in flight.NTSB CEN18LA207Accident · No injuriesLimited investigationFinal reportCessna T210 · Clovis, NMThe total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ANC18LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Wasilla, AKA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA330Accident · No injuriesData collectionFinal reportSorensen Danny S BF9 2 · Evanston, WYThe pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustionNTSB WPR18LA156Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tonopah, NVThe pilot's failure to properly lean the fuel/air mixture and to monitor critical engine parameters during the en route climb to cruise level, which resulted in excessive engine heat and oil starvation and the subsequent catastrophic engine failure.NTSB GAA18CA312Accident · No injuriesData collectionFinal reportPiper PA 46 · Prescott, AZThe pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB CEN18LA200Accident · No injuriesClass 3 · LimitedFinal reportIrlbeck Thomas H RV 8 · Somerset, WIA total loss of engine power due to damaged and disconnected electronic ignition wires from both the main and backup batteries, which resulted in a forced landing.NTSB ERA18WA212Accident · No injuriesForeign investigationCessna 172 · Macas, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.NTSB ERA18LA155Accident · No injuriesClass 3 · LimitedFinal reportDevries WM H Kitfox Sport · Taghkanic, NYA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18WA214Accident · 1 fatalForeign investigationBell 47 · Ciudad Valles, MexicoOn May 25, 2018, at 0030 hours universal coordinated time, a Scotts Bell 47 helicopter, Mexican registration XB-OSS, impacted terrain following a loss of engine power during an aerial application flight in San Luis Potosi, Mexico. The pilot was fatally…NTSB CEN18LA189Accident · Serious injuriesClass 3 · LimitedFinal reportM-Squared Sprint 1000 · Gurdon, ARInadequate engine maintenance, which resulted in the failure of the MAG piston ring and the subsequent total loss of engine power due to a piston seizure.NTSB WPR18LA158Accident · No injuriesClass 3 · LimitedFinal reportRhoads Autogyro MTO Sport · San Manuel, AZThe fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.NTSB CEN18LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Wayne, INThe failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.NTSB CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.NTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · Shullsburg, WIA catastrophic engine failure due to improper torque on the engine through-bolt nuts, which resulted in relative movement between the crankcase halves, damage to a main journal bearing, and a loss of oil lubrication.NTSB ERA18WA166Accident · No injuriesForeign investigationPZL Swidnik SW4 · Curitibanos, BrazilThe government of Brazil has notified the NTSB of an accident involving a PZL Swidnik, SW4, helicopter that occurred on May 4, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA18WA173Incident · No injuriesForeign investigationBoeing 767 323 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.NTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…NTSB WPR18LA128Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G 164C · Maxwell, CAA total loss of engine power due to an uncommanded closing of the fuel shutoff valve, which terminated fuel to the engine. The reason for the fuel shutoff valve’s closure could not be determined based on the available information.NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.NTSB WPR18LA125Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Andover, NJA partial loss of engine power for undetermined reasons.NTSB ERA18WA274Accident · 2 fatalForeign investigationPiper PA28 · Nafpaktos, GreeceThe government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of…NTSB GAA18CA220Accident · No injuriesData collectionFinal reportPiper PA 22 · Shelby, MTThe pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.