NTSB investigations, GA
181 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND 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 ATL95FA021Accident · 1 fatalField investigationFinal reportBeech 95B55 · Mableton, GAThe pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.NTSB ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.NTSB ATL94LA144Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hephzibah, GAThe pilot's inadequate preflight of the aircraft, resulting in fuel exhaustion, and his improper flare of the helicopter during the autorotation, resulting in a hard landing.NTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.NTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.NTSB ATL94LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Stockbridge, GAThe partial blockage of the induction air filter because of water soaking, which resulted in a loss of engine power, and the failure of maintenance personnel to properly wash the aircraft.NTSB ATL94GA038Accident · Serious injuriesFinal reportHughes 269C · Atlanta, GAThe inadvertent closing of the fuel shutoff valve by the pilot. A factor in the accident was the failure of the pilot to maintain rotor RPM during the autorotation.NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.NTSB ATL93LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Sylvania, GAWas the pilot's failure to properly plan sufficient fuel for the flight which resulted in fuel exhaustion short of the destination airport.NTSB ATL93LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108/U · Mccaysville, GAThe loss of engine power for undetermined reasons.NTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.NTSB ATL93LA035Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Savannah, GAThe pilot's poor preflight and inflight planning.NTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.NTSB ATL93LA027Accident · No injuriesLimited investigationFinal reportMooney M20D · Darien, GAThe pilot's inadequate in-flight planning which resulted in fuel exhaustion. Factors were fog and the pilot's failure to use available en route weather sources.NTSB ATL93LA014Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Cumming, GAThe pilot's failure to use the fuel boost pump when the engine malfunctioned during take off.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB ATL93LA010Accident · No injuriesLimited investigationFinal reportCessna 172P · Buford, GAFuel exhaustion due to the pilot's inadequate inflight planning.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB ATL92LA135Accident · No injuriesLimited investigationFinal reportCessna 182 · Kennesaw, GAThe inadequate preflight planning by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.NTSB ATL92LA129Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Donalsonville, GAThe pilot's inadequate preflight inspection of the aircraft, and his failure to detect water in the aircraft fuel system.NTSB ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.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 ATL92FA026Accident · Minor injuriesField investigationFinal reportCessna 210H · Carrollton, GAThe contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.NTSB ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.NTSB ATL91LA153Accident · No injuriesLimited investigationFinal reportCessna T188C · Quitman, GAA total loss of engine power due to fuel starvation. The reason for the fuel starvation was not determined.NTSB ATL91LA141Accident · Serious injuriesLimited investigationFinal reportMaridon Starduster TOO · Locust Grove, GAFuel exhaustion which resulted from the failure of the pilots to refuel the airplane. A factor was the local pilot's having become lost.NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.NTSB ATL91FA064Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Lawrenceville, GAThe poor inflight planning by the pilot which resulted in fuel exhaustion. Factors related to this accident were the unfavorable winds, the dark night, and the inoperable airport runway lights.NTSB ATL91FA035Accident · 1 fatalField investigationFinal reportBeech B95 · Austell, GAThe loss of engine power which resulted from the pilot's failure to properly use the carburetor heat. The pilot failed to maintain flying speed during the emergency descent which resulted in a stall on final approach. A factor in the accident was weather…NTSB ATL91LA029Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Senoia, GAImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion. Factors to the accident were the dark night operation and the collision with utility lines.NTSB ATL91FA018Accident · 1 fatalField investigationFinal reportCessna 182E · Blairsville, GAFuel exhaustion resulting in engine stoppage, and the pilot's failure to obtain fuel earlier in the flight.NTSB ATL91LA010Accident · No injuriesLimited investigationFinal reportCessna A150K · Dublin, GAThe pilot's inadequate preflight planning and preparation, in that he did not ensure that enough fuel was on board to complete the flight.NTSB ATL90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brookley, GAFuel exhaustion. Factors include improper planning/decision by the pilot-in-command.NTSB ATL90FA145Accident · Serious injuriesField investigationFinal reportCessna 340 · Atlanta, GAThe pilot-in-command's inadequate fuel management, in that he did not select main fuel tanks prior to this approach. This resulted in fuel starvation to the engines, and the subsequent loss of all engine power.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.NTSB ATL90DKG03Accident · No injuriesFinal reportCorben BABY-ACE · Griffin, GAAn improper fuel system (installed by the home builder), and continued operation of the aircraft with a known deficiency, which resulted in fuel starvation.NTSB ATL90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Villa Rica, GAFuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.NTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.NTSB ATL90LA090Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Jonesboro, GALoss of engine power because of carburetor icing conditions. A factor in the accident was the pilot's improper use of carburetor heat.NTSB ATL90LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Canon, GAImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions, and soft terrain.NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.