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 GAA23WA254AccidentClass 5 · ForeignRobinson R44 · Ilopango, El SalvadorNTSB GAA23WA216Accident · Minor injuriesClass 5 · ForeignCessna 152 · Drásov, CzechiaNTSB GAA23WA222Accident · No injuriesClass 5 · ForeignPiper PA23 · Governors Harbour, BahamasNTSB CEN23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Gardner, KSA loss of engine power due to lead fouling of a spark plug.NTSB WPR23FA275Accident · 1 fatalClass 3 · FieldFinal reportCessna T310R · Santa Fe, NMA total loss of left engine power as a result of improper installation of the aft-facing crankshaft counterweight retaining rings. Also causal was the pilot’s failure to maintain adequate airspeed following the loss of left engine power, which resulted in the…NTSB GAA23WA234Accident · No injuriesClass 5 · ForeignCessna 172 · Kohnan, JapanNTSB GAA23WA218Accident · Minor injuriesClass 4 · ForeignCessna 152 · União da Vitória, BrazilNTSB DCA23WA386IncidentClass 5 · ForeignBoeing 737 · Antalya, JordanNTSB ANC23LA053Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Ninilchik, AKA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft.NTSB ANC23LA051Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Ninilchik, AKA partial loss of engine power due to failure of the No. 1 cylinder intake valve head.NTSB GAA23WA202Incident · No injuriesClass 5 · ForeignCessna 150H · Cayo District, BelizeNTSB WPR23LA267Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Coquille Bay, ORThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with terrain.NTSB GAA23WA203Accident · No injuriesClass 5 · ForeignPiper PA25 · Arnborg, DenmarkNTSB WPR23FA256Accident · 1 fatalClass 3 · FieldFinal reportCessna 182N · St Maries, IDThe total loss of engine power due to the failure of the No. 3 exhaust valve for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of engine power.NTSB GAA23WA175AccidentForeign investigationPiper PA28 · Bournemouth, United KingdomNTSB WPR23LA239Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Alturas, CAA loss of engine power due to the failure of the right magneto distributor gear and the pilot’s decision to conduct a test flight with known mechanical issues.NTSB ERA23FA273Accident · 1 fatalClass 3 · FieldFinal reportMooney M20R · Southport, NCThe pilot’s improper decision to fly a known unairworthy airplane, which resulted in a total loss of engine power due to oil starvation.NTSB CEN23LA267Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Rockport, TXThe failure of the left engine starter adapter gear, which resulted in catastrophic damage to other engine components, and the subsequent loss of engine power.NTSB CEN23LA261Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Cedar Creek, MOA seizure of the power takeoff piston due to inadequate maintenance to the lubrication system, which resulted in a lack of oil lubrication and subsequent engine failure.NTSB GAA23WA174Accident · No injuriesClass 5 · ForeignCessna 188 · Vereda Puerto, ColombiaNTSB GAA23WA181Accident · No injuriesClass 5 · ForeignCessna 310 · Derby, AustraliaNTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.NTSB GAA23WA169Accident · No injuriesClass 5 · ForeignMD Helicopter 500 · Glenorchy, New ZealandNTSB GAA23WA155Accident · No injuriesClass 5 · ForeignCessna 175 · Aldermaston, United KingdomNTSB ERA23FA239Accident · 1 fatalClass 3 · FieldFinal reportCommander 114TC · Palm City, FLA loss of engine power for undetermined reasons, and the pilot’s subsequent loss of control, which resulted in impact with terrain.NTSB ERA23FA238Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Rougemont, NCA total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.NTSB ERA23LA231Accident · No injuriesClass 3 · LimitedFinal reportCharles D Walker Walker Curtiss JN4D · Greenville, KYThe separation of an electrical wire that powered the ignition module, rendering the ignition system inoperative, and resulting in the total loss of engine power.NTSB WPR23LA184Accident · No injuriesClass 3 · LimitedFinal reportRans S-21 · Creswell, ORA total loss of engine power caused by fatigue cracking and fracture of the crankshaft due to severe wear of the bearings.NTSB CEN23LA185Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Midland, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.NTSB GAA23WA140Accident · 7 fatalClass 3 · ForeignCessna 206 · Chiribiquete National Park, ColombiaNTSB GAA23WA142Accident · No injuriesClass 5 · ForeignPiper 28 · Jandakot, AustraliaNTSB GAA23WA134Accident · Minor injuriesClass 5 · ForeignPiper PA28 · Bogota, ColombiaNTSB GAA23WA126Accident · No injuriesClass 5 · ForeignCessna A188 · Casanare, ColombiaNTSB GAA23WA127Accident · No injuriesClass 5 · ForeignPiper PA-23-250 · San José Pinula, GuatemalaNTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB GAA23WA132Accident · No injuriesClass 5 · ForeignEmbraer EMB711 · Manoel Urbano, BrazilNTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.NTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB GAA23WA121AccidentClass 5 · ForeignCessna 210 · Mazatlan, MexicoNTSB GAA23WA197AccidentClass 5 · ForeignPiper PA-31-350 · Archerfield, AustraliaNTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.NTSB ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.NTSB GAA23WA122Accident · Minor injuriesClass 4 · ForeignCessna 172 · Chapecó, BrazilNTSB GAA23WA123Accident · Minor injuriesClass 4 · ForeignCessna T188 · Recinto Estero Claro, EcuadorNTSB DCA23WA222IncidentClass 5 · ForeignBoeing 737-823 · Belize City, BelizeNTSB GAA23WA116Accident · No injuriesClass 5 · ForeignCirrus SR-22 · Massaranduba, BrazilNTSB CEN23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Wade, OKThe total loss of engine power due to fuel contamination.NTSB GAA23WA114Accident · Serious injuriesClass 5 · ForeignPiper PA-28-140 · Scottsdene, South AfricaNTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.