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 LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.NTSB MIA94FA008Accident · Serious injuriesField investigationFinal reportBeech 60 · Miami, FLInadequate preflight by the pilot, and his failure to assure that proper maintenance/annual inspection was attained. Factors related to the accident were: water and other contamination in the fuel supply, lack of continuity in two ignition leads, loose left…NTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.NTSB SEA94LA011Accident · No injuriesLimited investigationFinal reportCessna 172M · Longbranch, WAThe instructor pilot's failure to follow procedures. Factors include carburetor icing conditions and soft terrain in the landing area.NTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.NTSB NYC94LA006Accident · No injuriesLimited investigationFinal reportCessna T210F · Frederick, MDThe mechanic's inadequate inspection and the pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, resulting in a loss of engine power and a forced landing.NTSB FTW93LA275Accident · No injuriesLimited investigationFinal reportKelm Zenair CH-701 · South Bend, ARThe engine power loss for undetermined reasons. A factor was the lack of available runway onto which the forced landing could be executed.NTSB SEA93LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Salt Lake City, UTA power loss for undetermined reasons. Factors include a fence, an animal, and a ditch in the landing roll path.NTSB FTW93FA267Accident · 1 fatalField investigationFinal reportPiper PA-31P · San Antonio, TXFailure by the pilot-in-command to maintain VMC following takeoff. Factors were: partial loss of power to one engine for undetermined reason, and lack of total experience in aircraft type.NTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.NTSB LAX93LA358Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Napa, CAThe loss of engine power for undetermined reasons. The rough/uneven terrain was a factor in this accident.NTSB ATL93LA158Accident · Serious injuriesLimited investigationFinal reportBeech A-23-19 · Resaca, GANot determined.NTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.NTSB ATL93LA152Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe failure of the engine exhaust valve which resulted in the loss of engine power. The soft terrain in the landing area was a factor.NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB BFO93LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stowe, VTThe pilot's improper in-flight planning/decision. A related factor in the accident was: the partial loss of engine power for an undetermined reason.NTSB SEA93LA191Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bryce Canyon, UTLoss of engine power for an undetermined reason. Factors related to the forced landing were: high density altitude and rough terrain.NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB ATL93LA149Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Tuscaloosa, ALFouled spark plugs on the number 2 and 3 cylinders, and a lack of compression on the number 1 and 4 cylinders, which resulted in a loss of engine power. A factor was the high vegetation at the forced landing site.NTSB BFO93FA153Accident · Serious injuriesField investigationFinal reportMooney M20J · Mitchellville, MDCorrosion in the fuel control unit, which resulted in fuel starvation and loss of engine power. Related factors were: inadequate maintenance, and the lack of suitable terrain for an emergency landing.NTSB BFO93LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caribou, MELoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB DEN93LA106Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palisade, COPartial power loss during approach for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Tulsa, OKThe loss of engine power and engine fire for undetermined reasons.NTSB NYC93LA175Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Meriden, CTThe loss of engine power for undetermined reasons.NTSB NYC93LA170Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Skaneateles, NYThe improper installation of the engine oil filter, and the subsequent loss of oil and engine power, resulting in forced landing and collsion with trees.NTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.NTSB CHI93LA333Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Custer Park, ILFuel contamination of unknown origin, that resulted in fuel system blockage and fuel starvation. A related factor was: high obstructions near the end of the runway.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB ATL93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Hilton Head Is, SCA loss of engine power for undetermined reasons.NTSB NYC93LA164Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Westerly, RIThe loss of engine power for undetermined reasons, and the subsequent forced landing and collision with soft terrain.NTSB MIA93LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rome, MSLoss of engine power for an undetermined reason. A factor related to the accident was: failure of the pilot to use all available runway for takeoff.NTSB MIA93FA180Accident · 2 fatalField investigationFinal reportGlasair SH-2F · Ocala, FLThe pilot-in-command's failure to maintain airspeed (vso) during a forced landing, resulting in an in-flight loss of control (stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot-in-command's improper positioning…NTSB CHI93LA328Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Wilber, NEthe loss of engine power for an undetermined reason.NTSB LAX93LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-220 · Pacific Ocean (Pacific Ocean)The loss of oil pressure to both engines for undetermined reasons.NTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.NTSB ANC93LA150Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Galena, AKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain on which to make a forced landing.NTSB NYC93LA147Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stonington, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin, and the pilot's improper use of the carburetor heat which resulted in the accretion of carburetor ice. A factor was carburetor icing conditions.NTSB NYC93LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, METhe loss of engine power for undetermined reasons.NTSB NYC93FA145Accident · 2 fatalField investigationFinal reportCurtiss-Wright Travel AIR 4000 · Marlboro, NJThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and inflight collision with the terrain.NTSB CHI93LA313Accident · No injuriesLimited investigationFinal reportCessna 150M · Blue Rapids, KSthe loss of engine power for an undetermined reason.NTSB MIA93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cape Canaveral, FLLoss of engine power for an undetermined reason.NTSB FTW93LA230Accident · No injuriesLimited investigationFinal reportAero Commander S2R · England, ARA partial loss of engine power for undetermined reasons.NTSB NYC93LA141Accident · Minor injuriesLimited investigationFinal reportGera Nieuport II · Somerville, NJThe loss of engine power for undetermined reasons.NTSB CHI93LA304Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Coffeyville, KSUndetermined.NTSB SEA93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Dayton, WAThe loss of engine power, undetermined. A factor relating to the accident was a fence in the flt path.NTSB SEA93LA161Accident · No injuriesLimited investigationFinal reportBell B206BII · Lake Powell, UTA power loss for undetermined reasons. Factors include landing in water.NTSB CHI93LA278Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · West Plains, MOThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB MIA93LA164Accident · Serious injuriesLimited investigationFinal reportMaxair AVR-582 · Wimauma, FLThe pilot-in-commands failure to maintain airspeed while making a forced landing following loss of engine power resulting in the aircraft stalling and descending uncontrolled to the ground.NTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.NTSB MIA93LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA reported partial loss of engine power for undetermined reasons, resulting in a forced landing and subsequent ditching in the ocean.