NTSB investigations
3,824 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 ERA09LA456Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight inspection and failure to ensure an adequate quantity of fuel was available for the flight.NTSB ERA09LA446Accident · No injuriesLimited investigationFinal reportLobb Kenneth CH 701 · Murfreesboro, TNA total loss of engine power due to the improper installation of the alternator drive gear.NTSB CEN09LA501Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Oklahoma City, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN09CA497Accident · Serious injuriesData collectionFinal reportunknown kit · Abbeville, LAA total loss of engine power for undetermined reasons.NTSB CEN09LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Waterloo, IAA loss of engine power for undetermined reasons.NTSB WPR09LA382Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Salt Lake City, UTA total loss of engine power during cruise flight due to the failure of the crankshaft gear.NTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.NTSB CEN09LA487Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Black River Falls, WIThe loss of engine power during cruise due to the number two cylinder piston connecting rod failure for undetermined reasons.NTSB ERA09LA438Accident · No injuriesLimited investigationFinal reportChristopher John P CHR-1 · Norridgewock, MEA loss of engine power due to a broken crankshaft for undetermined reasons.NTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN09CA477Accident · No injuriesData collectionFinal reportCessna A185F · River Falls, WIThe pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.NTSB WPR09LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Firebaugh, CAA total loss of engine power due to fuel exhaustion that was due to the failure of company ground personnel to refuel the airplane. Contributing to the accident was unsuitable terrain for a forced landing.NTSB ERA09CA505Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Geneva, FLOil starvation due to air in the engine oil supply line, which resulted in engine seizure during initial climb.NTSB ERA09CA426Accident · No injuriesData collectionFinal reportCessna 150M · Lexington, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel manangement.NTSB WPR09LA369Accident · Minor injuriesLimited investigationFinal reportBrown Michael Kitfox IV · Escondido, CAA total loss of power due to an oil exhaustion induced seizure of the engine. The pilot's decision to continue flight to the original destination after becoming aware of the in-flight oil leak instead of landing at an intermediate airport to investigate the…NTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB CEN09LA494Accident · No injuriesLimited investigationFinal reportCrisman Flightstar Iisc · Malta, ILThe loss of engine power due to the separation of the flywheel, resulting in a high-cycle fatigue fracture of the crankshaft following takeoff, which resulted in a forced landing on an agricultural field.NTSB CEN09CA468Accident · No injuriesData collectionFinal reportCorvus Carone MK 1 · Lee's Summit, MOA loss of engine power for undetermined reasons.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB ERA09FA414Accident · 1 fatalField investigationFinal reportHughes 369 · Franklin, PAA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.NTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA09LA409Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Mahwah, NJA loss of engine power due to the failure of the No. 1 cylinder thru bolt hold down nuts due to corrosion.NTSB CEN09LA444Accident · 1 fatalLimited investigationFinal reportBeech TC-45J · Verdel, NEThe pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…NTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…NTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.NTSB CEN09LA442Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Boyd, TXA total loss of engine power due to the pilot's improper leaning procedures, resulting in a forced landing and collision with a fence.NTSB WPR09CA342Accident · No injuriesData collectionFinal reportMid-South Custom Craft SH-2R · Sequim, WAThe total loss of engine power due to fuel starvation as a result of the pilot's failure to reposition the fuel selector to the main tank. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB WPR09LA337Accident · Minor injuriesLimited investigationFinal reportEngineering & Research 415C · Corona, CAA total loss of engine power during cruise flight for undetermined reasons.NTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.NTSB ANC09LA065Accident · No injuriesLimited investigationFinal reportNoorduyn UC-64A · Akiachak, AKThe loss of engine power due to the failure of a crankshaft component, resulting in an off-airport landing.NTSB CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.NTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.NTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.NTSB WPR09LA340Accident · No injuriesLimited investigationFinal reportBender Kitfox · Valencia, CAThe failure and separation of a propeller blade for undetermined reasons.NTSB ERA09LA383Accident · Minor injuriesLimited investigationFinal reportRans S5 Coyote · Greeneville, TNThe pilot's failure to maintain airspeed during a forced landing. Contributing to the accident was the loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB WPR09LA336Accident · Minor injuriesLimited investigationFinal reportThomas C. Piper Murphy Rebel · Idaho Falls, IDA total loss of engine power during initial climb due to fuel starvation. The underlying reason for the fuel starvation condition could not be determined.NTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB CEN09CA408Accident · Serious injuriesData collectionFinal reportCessna 150B · Conway, ARThe total loss of engine power for undetermined reasons.NTSB ERA09LA380Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Westerly, RIThe pilot's failure to use carburetor heat resulting in a complete loss of engine power due to carburetor icing.NTSB ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.NTSB CEN09CA406Accident · Serious injuriesData collectionFinal reportNorth American T-28B · Waxahachie, TXThe total loss of engine power for undetermined reasons.NTSB ERA09WA406Accident · Serious injuriesForeign investigationPiper PA-34-200T · Imperatrize, Maranhao, BrazilOn July 3, 2009, at 2146 UTC, a Piper PA-34-200T, PT-RFU, registered to and operated by Heringer Taxi Aereo LTD, as a cargo flight,lost engine power on one engine after takeoff from Imperatriz, Maranhao Airport, Brazil. The pilot attempted to return to the…NTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.NTSB CEN09CA407Accident · No injuriesData collectionFinal reportRemos G-3/6000 · Oshkosh, WIA total loss of total engine power due to fuel exhaustion as a result of the instructor pilot's inadequate preflight inspection. Contributing to the accident was the creased fuel quantity tube.NTSB CEN09LA400Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bastrop, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly verify the fuel load prior to departure.NTSB ERA09LA372Accident · No injuriesLimited investigationFinal reportCessna 172D · Shepherdsville, KYThe mechanic's improper inspection of the mixture control cable.