NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) 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 FTW03LA199Accident · No injuriesLimited investigationFinal reportCessna T188C · Colorado City, TXThe loss of engine power due to failure of the crankshaft. A contributing factor was low altitude flight.NTSB CHI03LA262Accident · Serious injuriesLimited investigationFinal reportSatterlee Volksplane VP-1 · Concordia, KSThe loss of engine power for undetermined reasons. Contributing factors were the roadway, the ditch and unsuitable terrain.NTSB CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.NTSB CHI03LA256Accident · No injuriesLimited investigationFinal reportNicoson Antares MA-33 · Palmyra, WIThe loss of engine power for undetermined reasons and the pilot misjudging the descent rate during the forced landing, which resulted in the airplane landing short of the desired landing area. A factor to the accident was the fence.NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB SEA03LA163Accident · No injuriesLimited investigationFinal reportSchulze Lancair 360 · Vancouver, WALoss of engine power for undetermined reasons during the initial climb. Collision with a vehicle during landing was a factor.NTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.NTSB NYC03LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Leonardtown, MDA loss of engine power due to water contamination of the fuel. A factor was the fuel cap not being secured to the tank.NTSB FTW03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Alpine, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB NYC03LA171Accident · 1 fatalLimited investigationFinal reportStewart Hummel Bird · North Baltimore, OHThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall during an emergency landing.NTSB FTW03TA190Accident · Minor injuriesFinal reportHughes 269A · Freer, TXLoss of engine power for undetermined reasons.NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.NTSB CHI03LA226Accident · No injuriesLimited investigationFinal reportCessna 177 · Murdock, NEThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.NTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…NTSB NYC03LA165Accident · No injuriesLimited investigationFinal reportBeltram Glasair-TD · London, KYThe pilot's failure to follow published procedures, which resulted in fuel starvation during approach.NTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.NTSB IAD03LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Hampton Bays, NYA loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC03LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sandusky, OHThe pilot's failure to maintain the engine mixture control during the go-around, which resulted in a loss of power, and in-flight collision with trees.NTSB CHI03FA218Accident · Serious injuriesField investigationFinal reportRobinson R22-Beta · Flint, MIThe loss of engine power for undetermined reasons, and the pilot's inadequate decision to land on an unsuitable area.NTSB LAX03LA217Accident · Minor injuriesLimited investigationFinal reportRans S-10 Sakota/A · Paulden, AZa loss of engine power due to fuel starvation for undetermined reasons.NTSB ATL03LA118Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Hendersonville, NCThe pilot's inadequate preflight planning/preparation of fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion. A factor in the accident was pilot impairment due to alcohol consumption.NTSB SEA03LA164Accident · No injuriesLimited investigationFinal reportBeech A35 · Freeland, WAA partially blocked fuel injector which led to an over temperature condition in the cylinders resulting in a loss of engine power during cruise flight. Sandy terrain conditions for the landing was a factor.NTSB NYC03FA161Accident · 1 fatalField investigationFinal reportCessna T210L · Quakertown, PAA loss of engine power for undetermined reasons.NTSB FTW03LA187Accident · No injuriesLimited investigationFinal reportMikoyan MIG-15BIS · Little Rock, ARThe loss of engine power during takeoff for undetermined reasons.NTSB CHI03LA213Accident · 1 fatalLimited investigationFinal reportAllenberg Swick BC 12-D · Winsted, MNThe inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…NTSB IAD03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Burnet, TXThe pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…NTSB ANC03LA070Accident · No injuriesLimited investigationFinal reportHelio H-391B · Big Lake, AKA loss of engine power for an undetermined reason during takeoff initial climb, which resulted in an in-flight collision with trees.NTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…NTSB CHI03LA192Accident · Serious injuriesLimited investigationFinal reportDebay Dragonfly Mark II · Eden Prairie, MNThe pilot's intentional operation of the airplane with a known deficiency with regard to an improper carburetor calibration that led to the loss of engine power. The improperly calibrated carburetor and the trees were contributing factors.NTSB NYC03LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Linden, NJThe mechanic's improper installation of the carburetor, and his failure to secure the mixture control wire to the mixture control arm pivot bolt.NTSB CHI03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Winamac, INA loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.NTSB CHI03LA189Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby · Altus, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.NTSB CHI03LA184Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Sandusky, MIThe failure of the ignition switch leading to an engine power loss in cruise flight and the subsequent high flare during autorotation. Factors contributing to the accident were the pilot's misjudgment of the landing flare and the unsuitable terrain…NTSB LAX03LA213Accident · Serious injuriesLimited investigationFinal reportMcanally Glasair JM-1 · Hollister, CAthe pilot's failure to follow the checklist and apply the electric fuel pump prior to takeoff, which resulted in vapor lock.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.NTSB ATL03FA111Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Rockvale, TNLoss of engine power for undetermined reasons.NTSB CHI03LA176Accident · No injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164B · Dyess, ARThe loose fittings on the bleed air system which resulted in a loss of engine power, and the unsuitable terrain encountered during the forced landing. Factors to the accident were the watery and the muddy conditions and the inadequate fastening of the bleed…NTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.NTSB LAX03LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Williams, CAthe loss of engine power on takeoff for undetermined reasons.NTSB FTW03LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Gruver, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03FA107Accident · 2 fatalField investigationFinal reportPiper PA-31P · Augusta, GAThe pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…NTSB CHI03LA183Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · West Branch, MIThe loss of engine power due to the fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain the pilot encountered.NTSB DEN03LA107Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe pilot's inadequate in-flight planning/decision in which he mismanaged his fuel supply by failing to switch tanks resulting in fuel starvation and the loss of engine power. A contributing factor was the pilot's diverted attention.NTSB CHI03LA154Accident · Minor injuriesLimited investigationFinal reportBraunschmidt RV-6A · Tea, SDThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.NTSB CHI03LA155Accident · No injuriesLimited investigationFinal reportSesin EXEC90 · Searcy, ARThe unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.NTSB SEA03LA107Accident · No injuriesLimited investigationFinal reportPippert Zenith Air CH 701 · Rochester, WALoose jet in the carburetor while on climb out resulting in a loss of engine power.NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB NYC03LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Huntington, WVThe pilot's failure to position the fuel selector to a tank with adequate fuel for the flight, which resulted in a power loss due to fuel starvation and the subsequent forced landing.