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 FTW96LA395Accident · Serious injuriesLimited investigationFinal reportBell 407 · Kerrville, TXThe loss of power due to the pilot's failure to comply with established procedures. Factors were a short in the FADEC wiring harness due to a manufacturing defect, and the lack of suitable terrain for the forced landing.NTSB FTW96LA392Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Boulder, COa loss of engine power due to a plugged fuel tank vent which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96FA342Accident · Serious injuriesField investigationFinal reportGrumman F9F-2 · Kalamazoo, MIThe overrun of the runway as a result of the pilot's misjudgment of speed and distance because of an unreliable airspeed indication; reason for the unreliable airspeed indication was undetermined. Contributing to the accident was the pilot's perception of a…NTSB FTW96LA391Accident · Serious injuriesLimited investigationFinal reportTubb AIR Commander 532 · Magnolia, ARThe loss of engine power due to the loss of coolant, as a result of a leak in the radiator. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.NTSB MIA96FA229Accident · 1 fatalField investigationFinal reportAero Commander 680E · Lakeland, FLfailure of the pilot to maintain minimum control speed, while returning to the airport for a precautionary landing, following a reported loss of power in one engine, which resulted in a loss of aircraft control and an uncontrolled collision with the terrain.…NTSB ANC96LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe loss of engine power for an undetermined reason. Factors associated with the accident are the soft terrain and brush in the airstrip overrun area.NTSB MIA96LA227Accident · No injuriesLimited investigationFinal reportAgusta A109A II · Flamingo, FLThe pilot being unable to stop the helicopter after encounter wet grass after making a precautionary landing in an unlit parking lot following loss of power in one engine and illumination of a transmission chip detector light.NTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…NTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.NTSB NYC96LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Hamilton Twp, NJA complete loss of engine power due to inadequate maintenance that contributed to a loose fuel line fitting, a fuel leak and subsequent fuel starvation. The uneven terrain was a factor.NTSB SEA96FA201Accident · 1 fatalField investigationFinal reportBeech D50 · Seattle, WAfailure of the pilot to follow proper emergency procedures (properly configure the airplane and feather the appropriate propeller) after loosing power in one engine, which resulted in his inability to maintain altitude until reaching an airport. Factors…NTSB NYC96LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Coatsville, PAloss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and the lack of suitable landing areas.NTSB MIA96LA215Accident · No injuriesLimited investigationFinal reportCessna 210M · Opa Locka, FLthe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation, a forced landing, and subsequent in flight collision with terrain. The lack of suitable terrain for a forced landing was a related factor.NTSB ATL96LA122Accident · Serious injuriesLimited investigationFinal reportAmerican AA5 · Crestview, FLthe pilot's improper operation of the powerplant controls.NTSB CHI96TA306Accident · Minor injuriesFinal reportHughes 269A · Cedar Rapids, IApartial blocking of the fuel injection control, and a fracture of the induction air ducting for reasons undetermined. A factor was trees.NTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.NTSB ATL96FA119Accident · 1 fatalField investigationFinal reportCessna 172H · St. Petersburg, FLAn engine malfunction for undetermined reasons. A factor was the pilot's selection of an unsuitable landing site.NTSB MIA96LA214Accident · No injuriesLimited investigationFinal reportCessna 150F · Plant City, FLa loss of engine power due to fuel contamination, resulting in a forced landing, and subsequent nose over. A factor in this accident was an inadequate aircraft pre-flightNTSB CHI96LA295Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Custer, SDloss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.NTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.NTSB SEA96FA185Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Marsing, IDloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with terrain.NTSB FTW96LA346Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Hatch, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA292Accident · No injuriesLimited investigationFinal reportCessna 210E · Clarksville, MOfuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.NTSB SEA96LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAfailure of the engine magneto drive, which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA207Accident · Minor injuriesLimited investigationFinal reportStout Glasair III · Boynton Beach, FLinadequate preflight by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB FTW96LA335Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Deer Park, TXloss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and obstructions in the emergency landing area (transmission lines and poles).NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.NTSB MIA96LA205Accident · No injuriesLimited investigationFinal reportHampson Velocity · Dublin, GAthe failure of the exhaust of the cylinder Nos. 2 and 4 at each exhaust flange for undetermined reasons. The unsuitable terrain encountered during the forced landing was a factor.NTSB SEA96LA176Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Belgrade, MTloss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.NTSB ATL96LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Smithville, TNRestricted selector valve flow that resulted in fuel starvation. A factor was the automotive fuel that adversely affected an O-ring seal in the fuel selector valve.NTSB MIA96LA197Accident · No injuriesLimited investigationFinal reportBell 47D1G · West Boca Raton, FLFailure of the pilot to apply carburetor heat following a loss of engine power due to inadequate altitude over a populated area. Contributing to the accident was the encounter with conditions favorable for carburetor icing.NTSB IAD96LA123Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Union Bridge, MDloss of engine power for undetermined reason(s).NTSB FTW96LA317Accident · Serious injuriesLimited investigationFinal reportRockwell 112TC · Santa Rosa, NMloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Brewton, ALa loss of engine power for undetermined reasons.NTSB IAD96LA121Accident · Minor injuriesLimited investigationFinal reportCorben Baby Ace C-1 · Portsmouth, OHthe pilot's inadequate preflight inspection, which resulted in a loss of engine power during the initial climb out. A related factor was the rising terrain encountered during the forced landing.NTSB FTW96LA312Accident · No injuriesLimited investigationFinal reportCessna 182A · Skiatook, OKa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA247Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dighton, KSloss of engine power for undetermined reason(s). The crop and soft terrain in the emergency landing area were related factors.NTSB FTW96LA306Accident · No injuriesLimited investigationFinal reportSmith RV4 · Mandeville, ARa loss of engine power for undetermined reasons.NTSB ATL96LA107Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Scotia, SCa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for a forced landing.NTSB CHI96LA240Accident · Minor injuriesLimited investigationFinal reportSauder Avid Flyer HH · Stoneville, SDloss of engine power for undetermined reason(s). A factor relating to the accident was: rough/uneven terrain in the emergency landing area.NTSB ATL96LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Hickory, NCEngine stoppage for undetermined reasons. A factor was the terrain furrows.NTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.NTSB MIA96LA178Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.NTSB SEA96LA148Accident · Serious injuriesLimited investigationFinal reportMooney M18LA · Beaver Marsh, ORthe loss of engine power for undetermined reason(s). A factor relating to the accident was: the presence of trees near the forced landing area.NTSB FTW96LA294Accident · Minor injuriesLimited investigationFinal reportO'Day Sonerai II-LS · Friendswood, TXa loss of engine power for undetermined reasons, and the pilot's failure to attain the proper traffic pattern altitude on the downwind leg prior to turning the base leg.NTSB FTW96LA293Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Garfield, COa reported power loss for reasons undetermined.NTSB LAX96LA262Accident · 2 fatalLimited investigationFinal reportRyan ST3KR · Santa Paula, CAa partial loss of engine power for undetermined reasons and the pilot's failure to maintain control of the airplane while maneuvering toward the runway following the power loss.