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 DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.NTSB LAX03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Paula, CAThe pilot's failure to follow the checklist and switch the fuel selector to the fullest tank for landing, which resulted in fuel starvation and loss of engine power.NTSB SEA03LA017Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Rigby, IDThe pilot's selection of a fuel tank with inadequate fuel resulting in fuel starvation and a complete power loss during the initial climb. A contributing factor was the ditch which the aircraft impacted during the forced landing resulting in the collapse of…NTSB LAX03LA032Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Napa, CAthe pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.NTSB LAX03LA029Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAThe pilot's inadequate preflight inspection resulting in a loss of engine power due to water contamination of the fuel system.NTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.NTSB ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.NTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.NTSB LAX03LA014Accident · Serious injuriesLimited investigationFinal reportCessna 210C · Riverside, CAthe pilot's failure to position the fuel selector to the tank containing fuel resulting in a loss of engine power due to fuel exhaustion.NTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.NTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.NTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB NYC03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Hartwood, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.NTSB FTW03LA013Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe flight instructor's failure to refuel at an available airport when a low fuel status was identified. Factors were the flight instructor's inadequate preflight flight planning, which included improper fuel consumption calculations, the night light…NTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB NYC03FA001Accident · 1 fatalField investigationFinal reportBeagle B.206 Basset · West Carrollton, OHThe pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…NTSB CHI02LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Moorhead, MNThe inadequate fuel management by the certified flight instructor.NTSB LAX02LA296Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Valley Center, CAthe pilot's inadequate preflight planning/preparation by not verifying the fuel supply, and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the pilot's decision to initiate…NTSB LAX02LA295Accident · No injuriesLimited investigationFinal reportBell 206L-1 · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX02LA290Accident · No injuriesLimited investigationFinal reportCessna 172G · Vail, AZThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB IAD02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Edinburg, VAA loss of engine power for undetermined reasons.NTSB NYC02LA188Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Canadaigua, NYThe pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.NTSB NYC02LA185Accident · Serious injuriesLimited investigationFinal reportReiley Seawind 3000 · Bloomingburg, OHThe pilot's inadvertent use of the fuel shutoff valve which resulted in a subsequent total loss of engine power due to fuel starvation.NTSB NYC02LA182Accident · Minor injuriesLimited investigationFinal reportDuffy Vans RV-9A · Oxford, OHThe pilot's improper fuel calculations, which resulted in fuel exhaustion and a subsequent total loss of engine power. Factors included an inaccurate fuel gauge indication for undetermined reasons, the pilot's reliance on that indication, the night lighting…NTSB FTW02LA250Accident · No injuriesLimited investigationFinal reportGray Rotorway Exec 90 · Las Cruces, NMThe pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB NYC02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Belmar, NJThe improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.NTSB MIA02LA165Accident · Serious injuriesLimited investigationFinal reportCessna T337D · Fort Pierce, FLThe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB NYC02LA180Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Louisa, VAA loss of engine power for an undetermined reason.NTSB NYC02LA176Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Athens, OHThe student pilot's improper fuel management, which resulted in fuel starvation during cruise flight. A factor was the operator's failure to perform maintenance on a fuel gauge that was noted twice in a discrepancy log.NTSB LAX02LA264Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Bakersfield, CAthe pilot's improper fuel system management, which lead to fuel starvation, and a loss of engine power. A factor in the accident was the pilot's decision to continue on the second leg of the flight with the gear in the extended position, which increased the…NTSB CHI02LA260Accident · Minor injuriesLimited investigationFinal reportAnderson Kitfox Series 5 · Garden Prairie, ILThe pilot's miscalculation of fuel consumption and his operation of the fuel system beyond its limitation, which resulted in fuel exhaustion. Contributing factors were transmission wires and dark night conditions.NTSB LAX02LA263Accident · No injuriesLimited investigationFinal reportPravecek Lawrence Varieze · Rio Linda, CAthe loss of engine power caused by fuel exhaustion due to a fuel tank leak. Also causal was the inadequate maintenance performed on the repair of the fuel tank by unknown maintenance personnel.NTSB ATL02LA161Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Peachtree City, GAThe certified flight instructors failure to feather the propeller in accordance with operating procedures that resulted in loss of altitude and the in-flight collision with terrain.NTSB NYC02LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manassas, VAThe pilot's inadequate pre-flight planning, and his inadequate visual lookout while taxing on an off airport road. A factor related to the accident was the dark night conditions.NTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.NTSB DEN02LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COthe pilot's inadequate preflight preparation, which resulted in fuel exhaustion and a subsequent loss of engine power, and his failure to maintain adequate airspeed during the forced landing, which resulted in an inadvertent stall/mush. Factors included the…NTSB SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.NTSB CHI02FA247Accident · 1 fatalField investigationFinal reportCessna 172N · Shell Lake, WIThe pilot's failure to refuel the airplane prior to departure leading to fuel exhaustion during the flight, the inadequate preflight/inflight planning, and the unsuitable terrain encountered by the pilot during the forced landing attempt. Contributing factors…NTSB SEA02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bellingham, WAThe pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…NTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.NTSB CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.NTSB NYC02LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Bluffton, OHThe pilot's fuel mismanagement with his failure to position the fuel selector to the proper tank which resulted in engine fuel starvation.NTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…NTSB FTW02LA225Accident · Minor injuriesLimited investigationFinal reportSouthworth EAA Bi-Plane May Bee · West, TXThe pilot's inadequate preflight/planning inspection which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW02LA218Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Mc Allen, TXThe pilot's failure to refuel the airplane resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…NTSB LAX02LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Creston, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the dark night conditions.NTSB DEN02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COA loss of engine power due to fuel exhaustion as a result of leaking fuel caps. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB NYC02LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B · Newfield, NYThe pilot's failure to verify the amount of fuel onboard prior to departure, which resulted in a power loss due to fuel exhaustion, and subsequent hard landing. A factor was the lack of a suitable landing area under the helicopter when the power loss occurred.