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 NYC98GA093Accident · No injuriesFinal reportMcDonnell Douglas 500E · Columbus, OHloss of engine power for undetermined reason(s). Related factors were: lack of suitable terrain for an emergency landing; and high obstructions in the forced landing area.NTSB FTW98LA178Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Del Rio, TXa loss of engine power on the right engine for undetermined reasons, and the pilot's failure to maintain control of the airplane.NTSB NYC98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAloss of engine power for undetermined reason(s), which resulted in a forced landing and subsequent nose-over on uneven terrain. Uneven terrain (furrow) in the forced landing area was a related factor.NTSB NYC98FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 195 · Cape May, NJUndetermined.NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB CHI98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sabetha, KSThe loss of engine power for undetermined reasons.NTSB MIA98LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Fort Pierce, FLa loss of engine power due to fuel leakage at the fuel control, resulting in a forced landing, and subsequent impact with trees.NTSB ANC98LA033Accident · No injuriesLimited investigationFinal reportPiper J5-C · Valdez, AKThe owner/pilot mechanic's improper overhaul of the engine, and lack of proper lubricating cylinder grease. A factor in the accident was the lack of a suitable area for a forced landing.NTSB LAX98LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Sonoma, CAThe instructor pilot's inadequate in-flight planning/decision and subsequent inadequate supervision of the situation to simulate an engine failure on takeoff, as well as both pilot's not maintaining a visual lookout. A related factor was the diverted…NTSB MIA98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe total loss of engine power due to fuel starvation.NTSB SEA98LA050Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Seattle, WALoss of engine power due to a restricted fuel system filter.NTSB FTW98LA154Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tulsa, OKThe complete loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB LAX98LA122Accident · No injuriesLimited investigationFinal reportCessna TU206F · Avalon, CAContamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.NTSB NYC98LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Lockport, NYThe pilot's misjudgment of altitude and distance during a forced landing in the traffic pattern. A factor in the accident was the carburetor icing conditions.NTSB ATL98LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Marianna, FLThe failure of maintenance personnel to secure the magneto cover that resulted in water contamination and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB ATL98TA054Accident · No injuriesFinal reportCessna 172 · Arcadia, FLThe pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.NTSB SEA98IA044Incident · No injuriesIncident investigationFinal reportMooney M20K · Klamath Falls, ORThe pilot's inadequate preflight which failed to detect water contaminated fuel that subsequently led to fuel icing at altitude, blockage of fuel lines which resulted in fuel starvation. A related factor was the dark night conditions.NTSB MIA98LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Titusville, FLloss of engine power for undetermined reason(s), which resulted in a forced landing. Factors relating to the accident were: the lack of suitable terrain and obstructions in the emergency landing area.NTSB IAD98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haverhill, MAA loss of engine power due to a fractured number two cylinder exhaust valve and cracked cylinder. Contributing factors were the operator's allowance of the time between engine overhaul to be exceeded and the trees.NTSB NYC98LA068Accident · No injuriesLimited investigationFinal reportZwart KIT FOX Vixen · Weyers Cave, VAThe failure of the propeller drive train after the pilot/builder installed an improper drive belt.NTSB ATL98LA050Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Perry Foley, FLa loose (or missing) carburetor drain plug and fuel line, due to an inadequate maintenance/annual inspection, which resulted in a fuel leak, fuel exhaustion, loss of engine power, and a forced landing. The obstructions (trees in the emergency landing area)…NTSB ATL98LA049Accident · Serious injuriesLimited investigationFinal reportTankersley Europa MONO-WHEEL · Fernandina Bch, FLa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB SEA98LA038Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Stanwood, WAThe pilot's failure to apply carburetor heat. Factors included carburetor icing conditions and soft terrain in the forced landing area.NTSB ATL98FA047Accident · 2 fatalField investigationFinal reportSchweizer SA 2-37A · Green Cove Sprg, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while maneuvering the airplane for a forced landing, which resulted in an inadvertent stall, uncontrolled descent, and collision with a house boat…NTSB IAD98LA028Accident · No injuriesLimited investigationFinal reportBeech 55B · Buffalo, NYImproper use of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB IAD98LA026Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Davis, WVA loss of power due to blockage of the fuel screen and one of the four fuel injector nozzles. A contributing factor was snow covered terrain.NTSB ATL98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Deland, FLThe loss of engine power due to the pilots inadequate fuel management.NTSB CHI98LA089Accident · No injuriesLimited investigationFinal reportChinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, ILinadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…NTSB FTW98LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lone Grove, OKThe total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced…NTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.NTSB ATL98LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · New Port Richey, FLpartial loss of engine power for undetermined reasons, which led to a forced landing and collision with trees.NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.NTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.NTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.NTSB FTW98LA084Accident · No injuriesLimited investigationFinal reportHughes 269C · Riviera, TXThe total loss of engine power due to a fatigue failure of the crankshaft for undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.NTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.NTSB NYC98LA044Accident · Minor injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Oxford, CTThe loss of power for undetermined reasons.NTSB CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.NTSB SEA98LA024Accident · No injuriesLimited investigationFinal reportBell 206L · Idaho Falls, IDloss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.NTSB FTW98LA069Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mckinney, TXThe pilot's inadequate in-flight/planning decision which resulted in continued flight until fuel exhaustion. Related factors were incorrect fuel gauge readings and trees.NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.NTSB SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.NTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.NTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.NTSB SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.NTSB FTW98LA065Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Worland, WYloss of engine power for undetermined reason(s). A related factor was the rough and uneven terrain on which the forced landing was made.