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 FTW95LA107Accident · No injuriesLimited investigationFinal reportCessna 150F · Commerce, OKFuel exhaustion as a result of the pilot failing to perform an adequate preflight inspection of the airplane. The lack of suitable terrain on which to make a forced landing was a factor.NTSB LAX95LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Buckeye, AZa loss of engine power for undetermined reasons.NTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.NTSB FTW95FA101Accident · 1 fatalField investigationFinal reportBeech A36 · Wallisville, TXFuel starvation due to improper positioning of the fuel tank selector, which resulted in loss of engine power. Factors related to the accident were: darkness and a lack of suitable terrain for the forced landing.NTSB FTW95LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, ARFuel exhaustion due to the pilot's failure to refuel. Factors were the pilot's disorientation and lack of suitable terrain for a forced landing.NTSB ANC95LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Anvik, AKThe pilot's failure to follow the procedure in the pilot's operating handbook concerning the uneven distribution of fuel, and starvation of the fuel intake line by unporting.NTSB ATL95LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Burlington, NCThe pilot's improper pre-flight inspection, in that he failed to visually confirm the fuel quantity prior to departure.NTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.NTSB FTW95LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Brownsville, TXThe fuel starvation loss of engine power due to the pilot's improper use of the fuel tank selector. Factors were the pilot's qualification and the lack of suitable terrain for landing.NTSB BFO95FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Miamisburg, OHThe pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.NTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.NTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.NTSB ATL95LA032Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Union City, TNThe improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.NTSB CHI95LA064Accident · Minor injuriesLimited investigationFinal reportNorth American F-51D · Round Lake, ILfuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.NTSB NYC95LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Huber Heights, OHThe pilot's inadequate inflight decision/planning, which resulted in fuel exhaustion and the loss of engine power. A factor is the pilot's inadequate preflight planning.NTSB LAX95LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · North Las Vegas, NVthe pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.NTSB FTW95LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oklahoma City, OKThe loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.NTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.NTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.NTSB NYC95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wheeling, WVThe student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.NTSB MIA95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLIn flight planning decision delay by the pilot-in-command in that he failed to divert to an alternate airport before loss of engine power due to fuel exhaustion.NTSB MIA95LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe failure of the pilot-in-command to insure the aircraft contained enough fuel to complete the flight resulting in engine failure due to fuel exhaustion.NTSB MIA95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLThe pilot-in-command became lost and operated the aircraft until fuel exhaustion.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB ATL95LA027Accident · Minor injuriesLimited investigationFinal reportAero Commander 500S · Millington, TNThe pilot's inadequate preflight of the aircraft, in that he did not ensure that there was adequate fuel for the flight, which resulted in fuel exhaustion.NTSB ATL95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Myrtle Beach, SCThe pilot's failure to properly pre-flight the airplane to ensure the left fuel tank cover was properly secured.NTSB SEA95LA026Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Kent, WAFuel starvation due to the unporting of the useable fuel supply, and the pilot's failure to follow the airplane's published engine starting procedures after the loss of fuel flow during descent. Factors contributing to the accident are the pilot's lack of…NTSB FTW95LA058Accident · No injuriesLimited investigationFinal reportCessna 177 · Katy, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the unsuitable terrain at the pilot's disposal for the forced landing.NTSB ANC95LA014Accident · No injuriesLimited investigationFinal reportBell 206B · Kenai, AKThe pilot's failure to follow the information in the flight manual concerning the use of the particle separator kit and deflector kit when operating in falling snow. Factors were the rough terrain in the forced landing area and no installation of the…NTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…NTSB MIA95LA029Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Lakeport, FLFailure of the pilot to reposition the fuel selector after total loss of engine power due to fuel starvation. Contributing to the accident was her lack of total experience.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 ATL95LA018Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · High Point, NCThe inadvertent deactivation of the engine ignition system by the pilot, which resulted in loss of engine power.NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.NTSB LAX95LA040Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Santa Monica, CAfuel starvation to both engines due to the CFI's inadequate fuel consumption calculations during the flight, and his failure to ensure that adequate fuel existed in the main tanks to complete the traffic pattern circuit.NTSB FTW95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Haskell, OKThe total loss of engine power due to contaminated fuel. Factors were the improper maintenance procedures resulting in fuel contamination, the pilot's inadequate preflight inspection, and the lack of suitable terrain available for the forced landing.NTSB SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB LAX95LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150K · El Monte, CAfuel exhaustion due to the failure of both pilots to ensure that an adequate supply was on board prior to departure.NTSB NYC95LA024Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Goode, VAthe inadequate preflight by the pilot, resulting in engine failure due to water ingestion.NTSB CHI95LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Alton, ILthe pilot's failure to refuel. Factors associated with the accident were unsuitable terrain, the vehicle and building which the airplane contacted, and the dark night conditions.NTSB BFO95LA012Accident · No injuriesLimited investigationFinal reportBeech A23 · Campbellsville, KYthe mechanic's improper maintenance adjustment, which involved the misalignment of the fuel selector handle with the fuel selector valve. Related factors are the pilot's inadequate fuel management, and the rough/uneven terrain.NTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.NTSB FTW95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Radium Springs, NMFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor was the lack of suitable terrain available for the forced landing.NTSB LAX95FA029Accident · Serious injuriesField investigationFinal reportCessna 421A · Sparks, NVThe pilot's improper use of the fuel selector and subsequent fuel starvation.NTSB NYC95LA019Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Westfield, MAthe pilot's improper in-flight planning and inaccurate fuel consumption calculations, resulting in fuel exhaustion and the subsequent forced landing at night.NTSB LAX95LA024Accident · Serious injuriesLimited investigationFinal reportKaman HH-43F · Willits, CAthe pilot's improper fuel consumption calculations resulting in fuel exhaustion. The hilly terrain was a factor in this accident.NTSB FTW95LA035Accident · Minor injuriesLimited investigationFinal reportCessna T-210M · Tyler, TXLoss of engine power due to inadequate fuel management and fuel starvation. A factor was the lack of suitable terrain available for the forced landing.NTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.NTSB MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.NTSB CHI95LA022Accident · No injuriesLimited investigationFinal reportCessna 210A · Manhattan, KStotal loss of engine power for reason(s) undetermined. A factor was the dark night.