Final NTSB investigations
64 cases where the sequence of events included Engine shutdown.
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '140' 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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '140' 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 ERA11LA224Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Greenwood, MSThe pilot did not obtain the proper touchdown point as a result of his decision to shut down the engine and to deploy the landing gear and flaps before the landing was assured. Contributing to the accident was his decision to overfly a closer suitable airport…NTSB ENG11IA021Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pittsburgh, PAthe flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…NTSB ENG11IA011Incident · No injuriesIncident investigationFinal reportBoeing 737 · San Francisco, CAThe probable cause of the undercowl in-flight engine fire was the insufficient installation torque of the bolts that secure the fuel manifold cover to the fuel manifold. Engine vibrations and fuel pressure cycles caused the bolts to gradually loosen further…NTSB ERA10TA215Accident · No injuriesFinal reportCessna 404 · Ponce, PRA loss of power to the right engine for undetermined reasons.NTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…NTSB CEN10LA046Accident · Serious injuriesLimited investigationFinal reportYounkin J R Mullicoupe · Siloam Springs, ARA loss of engine power due to fuel starvation for undetermined reasons.NTSB ERA10LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Fairview, NCA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA09LA469Accident · 1 fatalLimited investigationFinal reportRaytheon 58 · Teterboro, NJThe complete loss of thrust due to the second-in-command’s (SIC) inadvertent feathering of both propellers during a high-speed, low-altitude approach. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the SIC’s performance.…NTSB ERA09CA328Accident · Serious injuriesData collectionFinal reportTrick Trikes Storm Thunder · Raleigh, NCThe pilot's failure to maintain aircraft control on approach for landing.NTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.NTSB ERA09FA083Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-60 · Millington, TNThe pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.NTSB ENG08IA030IncidentIncident investigationFinal reportBoeing B747 · Jeddah, Saudi ArabiaFailure of the low pressure turbine stage 3 disk due to a design that is vulnerable to high pressure turbine unbalance-induced synchronous vibration that cannot be detected in flight, and the subsequent uncontained engine failure.NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…