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 IAD99FA023Accident · 1 fatalField investigationFinal reportArmbruster MINI-500 · Midland, VAthe improper repair of the engine following a previous engine seizure which resulted in the loss of engine power over unsuitable terrain.NTSB LAX99FA038Accident · 1 fatalField investigationFinal reportCessna T210L · Oakland, CAThe pilot-in-command's inadequate fuel management which led to fuel starvation and subsequent loss of engine power. Also causal was the pilot's failure to maintain adequate altitude and his ostentatious display.NTSB LAX99LA035Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Upland, CALoss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.NTSB IAD99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Melfa, VAThe loss of engine power for undetermined reasons.NTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA027Accident · Minor injuriesLimited investigationFinal reportMooney M20J · San Angelo, TXThe total loss of engine power due to the magneto failure resulting from oil contamination when the bearing plate retainer screw fractured due to improper manufacturing. Factors were the lack of suitable terrain for the forced landing, and the dark night…NTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.NTSB ATL99LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Statesboro, GAThe pilot's failure to use carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB ANC99LA011Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Willow, AKA loss of engine power due to an undetermined reason. A factor associated with the accident was unsuitable terrain for a forced landing.NTSB FTW99LA017Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Scott, ARThe disengagement of the crankshaft gear due to the maintenance personnel not installing the gear lockplate at the last engine overhaul, resulting in the loosening of the gear retaining bolt, and the subsequent fracture of the gear alignment dowel. A factor…NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA011Accident · No injuriesLimited investigationFinal reportWilson Teenie TWO · Abilene, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Toughkenamon, PAThe pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.NTSB FTW99LA003Accident · No injuriesLimited investigationFinal reportBeech M35 · Carter, OKFuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…NTSB SEA98LA190Accident · No injuriesLimited investigationFinal reportCessna 150L · Bonners Ferry, IDImproper maintenance by an outsourcing facility which resulted in a lack of identification of scoring of the interior of the #3 cylinder rocker shaft bosses. The scoring resulted in a fatigue fracture and subsequent permanent closure of both intake and…NTSB SEA98LA193Accident · No injuriesLimited investigationFinal reportCessna T-50 · Missoula, MTA quick drain was open due to the pilot's inadequate preflight.NTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.NTSB CHI98LA367Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Schofield, WIThe inadvertent deactivation of the fuel selector and the emergency procedure not followed by the pilot-in-command. The tree was a contributing factor.NTSB CHI98LA363Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Lamar, MOthe pilot improperly positioned the fuel selector to the closed position causing fuel starvation.NTSB FTW98LA410Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mart, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB ATL98LA129Accident · No injuriesLimited investigationFinal reportConvair 240 · Loiza, PRThe loss of power in the No. 2 engine for undetermined reasons, and the inability of the pilot to establish a climb and/or maintain altitude. A factor was the incompletely feathered No. 2 propeller..NTSB CHI98LA360Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Amery, WIA loss of engine power due to fatigue failure of the crankshaft from frictional heating for undetermined reasons. A related factor was the unsuitable terrain.NTSB NYC98LA195Accident · No injuriesLimited investigationFinal reportCessna 172D · Louisville, KYThe student pilot's failure to perform a preflight inspection of the airplane before his first solo flight, and inadequate supervision by the certified flight instructor, which resulted in fuel exhaustion.NTSB CHI98FA353Accident · 1 fatalField investigationFinal reportBarklage Revolution Mini 500 · Cahokia, ILA loss of engine power due to cold seizure of the power-takeoff cylinder. A factor contributing to the accident was the power lines.NTSB SEA98LA181Accident · Serious injuriesLimited investigationFinal reportKelly Kolb Mark III · Cashmere, WAFuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB ATL98LA124Accident · No injuriesLimited investigationFinal reportCessna 150E · Bradenton, FLThe loss of engine power for undetermined reasons.NTSB FTW98LA396Accident · Serious injuriesLimited investigationFinal reportDempsey Skybolt TD8 · Dundee, TXHard landing due to the pilot's improper landing flare. Factor were the fuel exhaustion due to the pilot's failure to refuel, and his lack of familiarity with the airplane.NTSB MIA98LA244Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Malone, FLa loss of engine power due to a chaffed ignition wires, resulting in a forced landing and subsequent impact with trees.NTSB ANC98LA143Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homer, AKA total loss of power in the right engine for undetermined reasons.NTSB NYC98LA182Accident · Serious injuriesLimited investigationFinal reportPiper J3L-65 · Morristown, VTA loss of engine power for undetermined reasons.NTSB MIA98FA237Accident · 1 fatalField investigationFinal reportGlasair SH-2R · Panama City, FLThe pilot's failure to maintain a proper descent rate during a precautionary landing following a loss of engine power for undetermined reasons.NTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB MIA98LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Kill Devil Hill, NCFailure of the number one cylinder exhaust valve resulting in loss of engine power and a forced landing on unsuitable terrain at which time the aircraft nosed over.NTSB MIA98LA232Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe dual-student's attempt to perform a go-around after a reported loss of power in the left engine during landing flare and his failure to relinquish the controls to the instructor when control was lost during the go-around resulting in the aircraft rolling…NTSB SEA98LA172Accident · No injuriesLimited investigationFinal reportBeech V35B · Sagle, IDThe pilot's inadequate in-flight planning/decision which led to fuel starvation.NTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…NTSB FTW98LA366Accident · No injuriesLimited investigationFinal reportCessna 152 · Garland, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB ANC98LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Chugiak, AKThe loss of engine power for an undetermined reason.NTSB LAX98LA272Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-20-A1 · Woodland, CAThe pilot's failure during a preflight inspection to detect the damaged propeller from the previous hard landing. The damaged propeller degraded the climb performance capability of the airplane.NTSB MIA98LA227Accident · No injuriesLimited investigationFinal reportMooney M-20F · Rockhill, SCThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.NTSB MIA98LA224Accident · Minor injuriesLimited investigationFinal reportLesemann Pulsar XP · Fort Pierce, FLThe pilot's improper fuel management during a cross country flight which resulted in a total loss of engine power during the approach for landing and subsequent in-flight collision with wires and terrain.NTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.NTSB MIA98LA221Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Marco Island, FLThe pilot's inadequate fuel management which led to fuel exhaustion. A related factor was the pilot's improper use of the flight controls during autorotation.