NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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\" = 353) 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" = 353) 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 NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.NTSB SEA92LA081Accident · No injuriesLimited investigationFinal reportPiper J-5A · Broadus, MTFuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.NTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…NTSB ATL92LA079Accident · No injuriesLimited investigationFinal reportGuy Whisenant Skybolt · Gadsden, ALThe pilot's inadequate preflight planning and preparation, resulting in fuel exhaustion due to an inadequate fuel supply for the planned flight.NTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.NTSB LAX92LA176Accident · No injuriesLimited investigationFinal reportMcewen Dick Glasair III · Casa Grande, AZA failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…NTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.NTSB LAX92LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Delano, CAA loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to land the airplane and the soft soil condition which caused the airplane to nose over.NTSB MIA92LA106Accident · No injuriesLimited investigationFinal reportTomlinson Long EZ · Lakeland, FLThe pilot-in-command's failure to perform pretakeoff procedures and assure the fuel selector was on prior to takeoff. Contributing to the accident was the pilot's complacency.NTSB ATL92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Elizabeth City, NCInadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.NTSB LAX92FA161Accident · 1 fatalField investigationFinal reportBeech A33 · Paradise, CAThe student pilot's inadvertent use of the mixture control instead of the cowl flaps at a critical phase of flight, his misuse of the flight controls after the engine failure and the instructor's inadequate supervision of the student. Contributing factors in…NTSB MIA92LA102Accident · Minor injuriesLimited investigationFinal reportBell 47-D-1 · Fayette, MSThe pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.NTSB FTW92LA102Accident · No injuriesLimited investigationFinal reportR. W. Switzer RV-4 · Rogers, ARLoss of engine due to fuel starvation and unsuitable terrain. Factors were the pilot's failure to follow published procedures.NTSB LAX92LA159Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaaawa, HIAn engine flame out due to the pilot's intentional flight through an irrigation sprinkler system water stream in order to wash the helicopter.NTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.NTSB DEN92FA045Accident · 1 fatalField investigationFinal reportCessna T210N · Larkspur, COThe pilot's failure to flare the airplane due to his reduced forward visibility. Factors were: the pilot's improper fuel consumption calculations, his failure to proceed to an alternate airport, fuel exhaustion, and weather conditions including snow, fog, and…NTSB LAX92LA152Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAA failure of the pilot to conduct an adequate pre-flight inspection of the aircraft to ensure that the fuel supply was free of contaminates. Contributing to this accident was fuel contamination.NTSB FTW92LA097Accident · No injuriesLimited investigationFinal reportCessna R182RG · Little Rock, ARThe complete loss of engine power due to carburetor icing, and the pilot's delayed application of carburetor heat. Factors were the weather conditions which were highly conducive to carburetor icing, and the unsuitable terrain at the pilot's disposal to…NTSB FTW92LA095Accident · No injuriesLimited investigationFinal reportCessna 150F · Baytown, TXThe pilot's improper use of carburetor heat during the approach in carburetor icing conditions and his improper flare during the emergency landing.NTSB SEA92LA063Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Eugene, ORAn improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.NTSB ATL92LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Hull, GAThe pilot's inadequate preflight and inflight planning, which resulted in fuel exhaustion, and his failure to obtain a proper touchdown point, which resulted in a long landing and collision with terrain.NTSB SEA92LA062Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Elbe, WAFuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.NTSB LAX92FA141Accident · 2 fatalField investigationFinal reportMooney M20C · Redding, CAA loss of engine power due to carburetor and air filter icing, and, the pilots decision to attempt flight into known adverse weather/icing conditions.NTSB CHI92LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Munising, MIThe inadequate maintenance inspection to remove water from the fuel system, and the pilot's inadequate preflight inspection.NTSB CHI92LA111Accident · No injuriesLimited investigationFinal reportCessna 177B · Olney, ILThe pilot's failure to select carburetor heat in a timely manner, and the total loss of engine power due to carburetor ice. Related factors are carburetor icing conditions, reduced visibilities in snow, low ceilings, the dark night, and soft terrain…NTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.NTSB ATL92LA062Accident · Minor injuriesLimited investigationFinal reportWilliam D. Weeks Glasair I · Timmonsville, SCThe improper selection of the fuel sector valve to the off position by the pilot.NTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.NTSB NYC92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falmouth, KYThe failure of the pilot to adequately monitor his fuel consumption which resulted in a power loss from fuel exhaustion over unsuitable terrain. A factor related to the accident was the failure of the pilot to adequately determine the amount of fuel onboard…NTSB MIA92LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Deland, FLFailure of the pilot-in-command to maintain the proper airspeed (vs) resulting in an inadvertent stall. Factors in the accident were incorrect fuel selector position resulting in the total loss of engine power due to fuel starvation and fatigue of the pilot.NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.NTSB CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…NTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.NTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.NTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.NTSB MIA92LA180Accident · Serious injuriesLimited investigationFinal reportD.W. Owens Stitts SA3B · Winter Haven, FLFuel contamination and unsuitable terrain encountered while the pilot was attempting an emergency landing on the airport property.NTSB LAX92AMS03Accident · 2 fatalFinal reportCessna 172D · Pacific Ocean (Pacific Ocean)The failure of the pilot to adequately evaluate the weather conditions, and continued VFR flight into IMC conditions which resulted in the pilot becoming lost and disoriented. Contributing to the accident was the lack of total aeronautical experience and fuel…NTSB FTW92LA076Accident · Minor injuriesLimited investigationFinal reportAvions Fairey T-66 · Mineral Wells, TXFuel starvation due to a contaminated fuel filter. A factor was the soft terrain.NTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.NTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.NTSB FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.NTSB LAX92LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Apple Valley, CAThe pilot's failure to maintain airspeed and inadvertent stall. Contributing to this accident was engine fuel exhaustion for undetermined reasons.NTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.NTSB NYC92LA065Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Plymouth, MAThe failure of the pilot to use carburetor heat which resulted in the formation of carburetor ice and a subsequent loss of engine power and forced landing in trees.NTSB FTW92LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Conroe, TXThe pilot's inadequate preflight which resulted in water in the fuel system. A factor was the night lighting condition.NTSB ATL92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe pilot's inadequate preflight planning and his failure to refuel at his last departure point, which resulted in fuel exhaustion and engine stoppage.NTSB ANC92LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Anchorage, AKThe pilot's misjudgment of the fuel consumption of the airplane; thereby exhausting the fuel supply prematurely. Factor relating to the accident was the lack of a suitable forced landing area.NTSB DEN92LA033Accident · No injuriesLimited investigationFinal reportCessna 172N · Parshall, COImproper use of powerplant controls by the duel student and inadequate supervision by the CFI. Factors were: carburetor heat not used, deep snow covered terrain, and carburetor ice conditions.NTSB MIA92LA078Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…