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 MIA07LA072Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Lakeland, FLThe pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…NTSB DFW07TA089Accident · Minor injuriesFinal reportPiper PA-18 · Sweetwater, TXThe loss of engine power due to the failure of the throttle lever/linkage. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA096Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Ravenna, OHThe pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.NTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07CA085Accident · No injuriesData collectionFinal reportPiper PA-18 · Tulare, CAThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA086Accident · No injuriesData collectionFinal reportBrantly Helicopter B2 · Vernon, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA091Accident · Serious injuriesLimited investigationFinal reportHaddan Sonerai IIL · Fort Atkinson, WIThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons. A low altitude and an inadvertent stall were factors.NTSB ATL07LA052Accident · Minor injuriesLimited investigationFinal reportBell 47G2A · Huntsville, ALThe loss of engine power due to undetermined reasons.NTSB CHI07FA084Accident · 2 fatalField investigationFinal reportBeech 58 · Munster, INThe fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…NTSB SEA07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Crescent Lake, ORThe loss of a significant amount of engine power for undetermined reasons. Factors include no suitable place in which to make an emergency landing, and densely forested, mountainous/hilly terrain.NTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.NTSB MIA07LA058Accident · 2 fatalLimited investigationFinal reportUnknown Kolb Mark III · Panama City, FLThe failure of the pilot to maintain airspeed resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the loss of engine power for undetermined reasons.NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.NTSB SEA07LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Bellingham, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for a forced landing, and the trees.NTSB SEA07LA059Accident · Minor injuriesLimited investigationFinal reportBarnhart RV-6 · Auburn, WAA loss of engine power due to the obstruction of the engine's air inlet by a fabricated neoprene seal, and inadequate maintenance by unknown maintenance personnel. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DFW07CA066Accident · No injuriesData collectionFinal reportBell ARH-70 Exp. · Mansfield, TXFuel starvation due to blockage in a fuel system check valve which was the result of the improper assembly of fuel boost pump by company maintenance personnel.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB ANC07LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe partial loss of engine power for an undetermined reason during takeoff, which resulted in an aborted takeoff and collision with trees.NTSB ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA062Accident · 2 fatalLimited investigationFinal reportHallburg Amphibian S21D · Grinnell, IAThe inadequate preflight planning/preparation by the pilot in command and the fuel exhaustion during cruise flight. An additional cause was the inadequate forced landing procedure. A contributing factor was the tailwind.NTSB SEA07LA056Accident · Minor injuriesLimited investigationFinal reportMartin/Harris Harmon Rocket · Troutdale, ORA total loss of power for undetermined reasons just as the aircraft was maneuvering to enter the downwind for landing. The absence of a suitable landing location was a factor in the accident.NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB DFW07LA061Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Fulshear, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB DFW07CA060Accident · No injuriesData collectionFinal reportTanker DR-107 One Design · Rockwall, TXA loss of engine power for an undetermined reason during a go-around, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA07LA043Accident · No injuriesLimited investigationFinal reportRyan Navion · Marco Island, FLA reported loss of engine power shortly after takeoff for undetermined reasons.NTSB CHI07LA070Accident · Minor injuriesLimited investigationFinal reportReisinger Sonerai II L · Alma, MIThe loss of engine power during takeoff-initial climb for an undetermined reason. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB SEA07LA048Accident · Serious injuriesLimited investigationFinal reportNavion G Model · El Centro, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.NTSB SEA07LA041Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Lyman, WAThe pilot's intentional flight into adverse weather conditions, which resulted in a loss of engine power during hover due to snow and ice ingestion. Factors associated with the accident are the pilot's delayed remedial actions, and snow and icing conditions.NTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB DFW07CA044Accident · No injuriesData collectionFinal reportCessna 150M · Eastland, TXThe partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB SEA07LA037Accident · Minor injuriesLimited investigationFinal reportCavalier F51D Mustang · Rexburg, IDThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB MIA07LA028Accident · No injuriesLimited investigationFinal reportCessna 150K · Cape Coral, FLThe pilot's in-flight encounter with carburetor ice and inadequate remedial action which resulted in the engine ceasing to operate and a forced landing and damage to the airplane during the landing.NTSB DFW07FA039Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Jay, OKThe loss of engine power for undetermined reasons and the pilot's improper decision to extend the landing gear for the water landing. Contributing factors were the prevailing night conditions and the lack of suitable terrain for the forced landing.NTSB ATL07LA028Accident · Minor injuriesLimited investigationFinal reportScharnhorst RV-4 · Hoschton, GAThe failure of the manufacturer to safety wire the purge valve stop screw during maintenance resulting in a total loss of engine power in cruise flight due to fuel starvation. This resulted in a forced landing, on-ground collision with a berm/terrace, and…NTSB CHI07LA038Accident · No injuriesLimited investigationFinal reportBeech B36TC · Peoria, ILThe loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.NTSB ATL07CA027Accident · Serious injuriesData collectionFinal reportPiper J-2 · Williamson, GAThe pilot's inadequate preflight inspection which resulted in fuel exhaustion a subsequent total loss of engine power.NTSB NYC07FA043Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Charlottesville, VAA loss of engine power for undetermined reasons.NTSB DEN07CA035Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Falcon, COloss of power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing, unsuitable terrain available on which to make a forced landing and the tree.NTSB DFW07CA035Accident · No injuriesData collectionFinal reportPiper J3C-65 · Humnoke, ARThe loss of engine power during initial takeoff climb for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.NTSB LAX07LA048Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Las Vegas, NVA loss of power in the right engine due to fuel starvation. The fuel starvation was the result of the pilot's improper fuel selector position setting.NTSB ATL07LA021Accident · Serious injuriesLimited investigationFinal reportTennyson Howard Baslee DR-1 · Macon, GAThe pilot/owner's improper design change which resulted in a blocked carburetor inlet and a loss of engine power.NTSB NYC07LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Bardstown, KYThe loss of engine power for undetermined reasons.