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 CHI82FEG02Accident · Serious injuriesFinal reportPiper PA-24-250 · Pleasant Hill, OHWhile enroute, the pilot elected to climb over the weather rather than fly through it. At about 12,000 ft MSL over the weather, he encountered an engine problem. He initiated emergency procedures and informed dayton approach control of his problem. Unable to…NTSB MIA82DA046Accident · No injuriesFinal reportHoward 500 · Ft. Lauderdale, FLThe pilot stated that partial power failure of the left engine combined with torque and a crosswind caused a loss of directional control approximately 100 yards into the takeoff roll.NTSB LAX82DVA12Accident · No injuriesFinal reportGrumman G-164B · Valley Home, CAThe pilot reported that during takeoff, there was a partial loss of engine power and the aircraft settled back to the ground. The aircraft touched down on soft terrain about 1/4 mile from the runway and flipped over. The aircraft caught on fire and burned…NTSB ATL82FKW04Accident · Minor injuriesFinal reportCessna 182P · Nashville, TNAfter entering a long final approach for landing, the engine lost power. While attempting to restart the engine, the pilot noted that he had not previously turned on the carburetor heat. He was unable to start the engine and maneuvered the plane to land in a…NTSB CHI82DA037Accident · No injuriesFinal reportErcoupe 415-C · Brownsburg, INThe pilot reported that during his visual approach for landing, he used full carburetor heat and cleared his engine during the base turn. While entering his final approach, he was too high and reduced his power below 1000 RPM for about 10 to 20 seconds. He…NTSB CHI82DA034Accident · No injuriesFinal reportBell 206L-1 · Indianapolis, INThe engine lost power during a night flight while enroute to obtain fuel. The low RPM audio and warning light were noted when the loss of power occurred. The pilot entered an autorotative descent and turned to land on an interstate highway. As he started to…NTSB NYC82FFA03Accident · Minor injuriesFinal reportPiper PA-22 · Lake Placid, NYDuring takeoff, the engine lost power at about 250 ft AGL. At that time, the aircraft was about half way down the 4200 ft runway. The pilot applied carburetor heat and full flaps with the intention of landing on the runway. As the aircraft touched down on the…NTSB LAX82DA055Accident · No injuriesFinal reportMooney M20J · Avalon, CAThe pilot stated that upon touchdown at santa catalina airport she discovered that the trim was stuck. As the aircraft reached midfield the pilot elected to make a go-around. During climbout while passing through 1700 feet the pilot stated that she smelled…NTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…NTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…NTSB MKC82DA018Accident · Minor injuriesFinal reportCessna 182P · Topeka, KSDuring an aerial line patrol flight the pilot encountered low stratus clouds and started to return to billard airport when the engine ceased to operate. The pilot attempted to restart the aircraft but could not. A forced landing was made into a mowed pasture…NTSB SEA82FYM08Accident · Serious injuriesFinal reportBeech C23 · Orchards, WADuring a descent with the carburetor heat on, the pilot added power 2 times to verify the engine performance. No difficulty was noted. However, when the throttle was advanced to level off at 1800 ft MSL, the engine sputtered and lost power. The pilot was…NTSB LAX82FUJ24Accident · Minor injuriesFinal reportCessna 182P · Sunflower, AZThe pilot reported that he had throttled back below cruise power to survey one of his business locations. Reportedly, he moved the throttle forward to climb, but was unable to get full power. He stated that he gradually lost power and airspeed, and…NTSB SEA82DA018Accident · No injuriesFinal reportCessna 140 · Spokane, WAAfter an annual inspection, the pilot made a thorough ground check and taxied out for a test flight. During takeoff, the engine lost power at about 50 ft AGL. The pilot landed on the runway overrun in about 9 inches of crusted snow and the plane nosed over.…NTSB ATL82FKQ09Accident · Minor injuriesFinal reportCessna 414 · Aberdeen, MSThe non-instrument rated pilot crashed about 3 hrs after taking off with 4 1/2 hours of fuel on board. He crashed while attempting an off-airport landing in a large field. The field was located less than half way to his destination. The sheriff reported…NTSB LAX82FUQ07Accident · Minor injuriesFinal reportCessna TU206F · Mojave, CAThe pilot stated that he departed on the flight for the purpose of meeting with realtors. The meeting concerned a parcel of land. The pilot said he was circling the land at 500 to 700 ft AGL when he experienced a complete loss of power and attempted a forced…NTSB ATL82FLG08Accident · No injuriesFinal reportMooney M-20J · Hilton Head, SCDuring takeoff at about 200 to 300 feet the engine malfunctioned and the pilot elected to make a gear up landing. Investigation revealed that the left wing fuel tank contained over a quart of water. Water and a red substance similar in appearance to tank…NTSB FTW82FRJ07Accident · Minor injuriesFinal reportBellanca 17-30A · Homer, LADuring an IFR flight at 5000 ft MSL, the engine began running rough. The pilot attempted to restore power, but eventually, the engine began to windmill with no apparent thrust. Unable to maintain altitude, the pilot descended through a cloud layer and broke…