NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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\" = 351) 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" = 351) 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 DEN90LA193Accident · Serious injuriesLimited investigationFinal reportCessna 310J · Colorado Spring, COThe loss of power on one engine due to excessive fuel pressure and the pilot's feathering of the wrong propeller. Factor(s) were: operation of aircraft with known deficiencies by pilot and operator.NTSB ATL90LA172Accident · No injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALInadequate engine overhaul procedures which allowed the installation of the engine plug without safety wire to hold it in place, and which resulted in oil starvation of the engine.NTSB SEA90GA180Accident · 1 fatalFinal reportBell 204B · Keller, WAThe total loss of engine power due to turbine blade separation while the pilot was operating in the aircraft at a gross weight that exceeded performance specifications for existing meteorological conditions. Factors include the failure or inability to…NTSB NYC90DEI02Accident · Serious injuriesFinal reportGrumman AA5B · Beachwood, OHThe engine failure due to an improper engine overhaul performed by unqualified persons. The unsuitable terrain was a factor.NTSB FTW90DRA08Accident · No injuriesFinal reportBlaine Laux Pitts S-1 · Edna, TXA power loss due to failure of a connecting rod bolt. A factor was the soft terrain in which the forced landing was performed.NTSB NYC90FA215Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Montgomery, NYAn inadequate preflight by the pilot which resulted in a power loss due to fuel exhaustion.NTSB MIA90LA181Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Opa-Locka, FLEngine failure due to lack of oil supply to the number 3 cylinder connecting rod for undetermined reasons. This allowed the connecting rod end cap to separate through the case resulting in oil exhaustion.NTSB NYC90LA208Accident · No injuriesLimited investigationFinal reportPiper J5 CUB · Douglas, MAA total engine failure when the #3 exhaust valve failed, causing internal damage to the engine. Factors related to the accident were: the pilot had to make a forced landing in unsuitable terrain.NTSB LAX90DUG09Accident · Minor injuriesFinal reportMiles Atwood 1 · Chino, CALoss of engine power due to a fuel line separation.NTSB NYC90DFJ04Accident · No injuriesFinal reportSchweizer Grumman G-164A · Wayland, NYA cracked engine cylinder assembly, which resulted in loss of engine power.NTSB FTW90FA171Accident · 1 fatalField investigationFinal reportCessna 320 · Center, TXThe pilot's failure to maintain minimum control speed (VMC) and lack of qualification/training in multi-engine aircraft, which resulted in loss of aircraft control. A factor related to the accident was: failure of the left engine turbocharger, which resulted…NTSB CHI90LA249Accident · No injuriesLimited investigationFinal reportRyan PT-22A · Greenville, MISeparation of a loose cylinder assembly in flight, and unsuitable terrain encountered during the execution of a forced landing.NTSB SEA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Florence, ORThe failure of an engine cylinder head. Collision with a log during the landing was a factor related to the accident.NTSB NYC90FA199Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Mattapan, MAThe pilot's improper in-flight planning/decision, which resulted in his failure to maintain control of the aircraft. Factors related to the accident were: failure of the left fuel control unit, and the adverse weather conditions.NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB NYC90DHD03Accident · Minor injuriesFinal reportHeinrichs Rand KR-2 · Barnegat, NJThe loss of engine power due to magneto failure.NTSB ANC90LA147Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B · Juneau, AKFailure of the free turbine intermediate pinion driven gear and subsequent disintegration of the free turbine assembly.NTSB LAX90LA289Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Goleta, CAThe loss of engine oil pressure for undetermined reasons.NTSB DEN90DQA03Accident · No injuriesFinal reportPiper PA-25-235 · Fabens, TXEngine failure due to shorting of the magneto's 'p' lead, and failure of the exhaust manifold.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB LAX90LA284Accident · No injuriesLimited investigationFinal reportMooney M20C · Lodi, CAThe pilot to continue his flight with a unresolved deficiency in the aircraft powerplant resulting in total failure of the powerplant.NTSB SEA90LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Wenatchee, WAImproper installation of the oil filter gasket by maintenance personnel resulting in loss of engine oil and seizure of the engine.NTSB ATL90FA157Accident · 1 fatalField investigationFinal reportBeech E18S · Greenwood, SCThe pilot's improper emergency procedure by shutting down the wrong engine, which resulted in a forced landing. Factors related to the accident were: failure of the number three intake valve in the right engine due to fatigue, and trees in the emergency…NTSB MIA90FA166Accident · Serious injuriesField investigationFinal reportRockwell 680-E · Titusville, FLThe pilot's decision to continue the flight with a known unairworthy mechanical condition resulting in a subsequent loss of engine power and forced landing.NTSB LAX90DXQ03Accident · Minor injuriesFinal reportAir Tractor AT-401 · Tule Lake, CAAn engine failure due to mechanical failure of the distributor.NTSB ANC90FA134Accident · 3 fatalField investigationFinal reportHelio Courier H-295 · 40 Se Bettles, AKThe failure and separation of the #5 connecting rod bolt and cap which resulted in the rupture of the engine housing and subsequent engine fire due to oil spillage, and an inadequately mounted vertical fin/stabilator. A contributing factor was the inadequate…NTSB ATL90IA154Incident · No injuriesIncident investigationFinal reportDassault DA20F · Chamblee, GAThe right fuel control unit malfunctioned and allowed the engine speed to decrease below idle speed (45%) which resulted in an engine fire. Factors in the incident were: the improper rigging of the fuel control unit during installation, and the flight crew's…NTSB ANC90LA129Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Naked Island, AKA left engine failure for undetermined reasons.NTSB SEA90LA152Accident · No injuriesLimited investigationFinal reportBoson Starduster TOO · Pinedale, WYThe loss of engine power due to failure of the ignition coil, and the lack of suitable terrain for a forced landing. Failure of the ignition coil resulting in a total loss of engine power. The lack of suitable terrain was a factor related to the accident.NTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.NTSB DEN90FA166Accident · No injuriesField investigationFinal reportCessna 208A · Ruidoso, NMEngine failure due to failure of the gas producer and power turbine assemblies. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB LAX90DVA07Accident · 1 fatalFinal reportAir Tractor AT-401 · San Joaquin, CAThe failure of the no. 4 cylinder head.NTSB CHI90LA198Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ozark, MOTotal loss of engine power due to #2 turbine shaft bearing failure. A factor related to the accident was: none suitable terrain.NTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.NTSB ATL90LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Sanford, NCThe failure of the no.1 piston, for undetermined reasons, which resulted in a complete loss of engine power. A factor to the accident was, the forced landing in a soft field.NTSB CHI90DEE08Accident · No injuriesFinal reportRonald D. Cothern Quickie · Plainfield, ILSeparation of an ignition lead, resulting in loss of engine power. A factor in the accident was the pilot's inadequate preflight inspection.NTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.NTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.NTSB ANC90FA117Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Farewell, AKAn internal engine failure due to a thermal fatigue failure of the 1st stage turbine wheel as a result of overtemperature. The high rough/uneven terrain prevented a successful autorotation.NTSB DEN90FA159Accident · 1 fatalField investigationFinal reportCessna P210R · Ogden, UTFailure of the #1 piston due to pre-ignition/detonation in the #1 cylinder, and inadequate visual lookout by the pilot (his failure to see-and-avoid the obstruction). The obstruction (power line) was a related factor.NTSB NYC90FA156Accident · No injuriesField investigationFinal reportBell 206 B3 · Teterboro, NJFailed power turbine shaft. Factors in the accident were corrosion on the power turbine shaft and inadequate manufacturer's service bulletins.NTSB LAX90LA247Accident · No injuriesLimited investigationFinal reportBeech A-35 · Santa Ynez, CAAn engine failure due to fuel leakage from a ruptured diaphram in the carburetor; failure of the aircraft owner to comply with the manufacturer's recommended component overhaul intervals.NTSB DEN90IA154Incident · No injuriesIncident investigationFinal reportAerospatiale A-300B4 · Denver, COEngine failure due to turbine wheel failure, induced by fatigue.NTSB ANC90LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKTotal loss of engine power caused by the failure of the piston rod assemblies.NTSB ANC90LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKA power loss due to a fatigue failure of the #5 exhaust rocker arm.NTSB ATL90LA138Accident · Minor injuriesLimited investigationFinal reportBell BH-47G · Seagrove, NCFailure of a number four connecting rod bolt for an undetermined reason.NTSB MIA90LA146Accident · No injuriesLimited investigationFinal reportAyres S-2R · Fort Pierce, FLEngine failure due to failure of the engine driven fuel pump shaft due to undetermined reasons.NTSB ANC90LA098Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Caribou Lake, AKA power loss caused by the failure of a piston cylinder.NTSB ANC90FA097Accident · Serious injuriesField investigationFinal reportCessna 206 · Fairbanks, AKThe failure of the wristpin caused the separation of the connecting rod from the piston and subsequent seizure of the engine. A factor was unavailability of a suitable forced landing area.