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 SEA94FA051Accident · 1 fatalField investigationFinal reportCessna 140 · Lopez, WAThe pilot/owner's improper installation of the oil temperature sensing bulb, the total loss of all engine oil, and the shearing of a connecting rod cap.NTSB NYC94LA045Accident · No injuriesLimited investigationFinal reportCessna 206A · Williamsburg, VAan exhaust valve failure that created a hole in the piston, which allowed the complete loss of engine oil, resulting in the subsequent forced landing.NTSB LAX94LA076Accident · No injuriesLimited investigationFinal reportHughes 369D · Waimea, Kauai, HIAn inadequate engine compressor cleaning procedure specified in the manufacturer's service letter, which resulted in the total loss of engine power due to contamination, blockage, and collapse of the fuel nozzle inlet screen. Factors in the accident were: the…NTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.NTSB ATL94LA027Accident · Minor injuriesLimited investigationFinal reportWonder VAN'S Acft RV-6 · Ridgeland, SCImproper installation of the magnetos by maintenance personnel, which allowed the right magneto to come loose, oil to escape from the engine, and subsequent oil starvation.NTSB LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.NTSB LAX94LA046Accident · No injuriesLimited investigationFinal reportCessna 182 · Colusa, CAwas the poor major overhaul conducted by maintenance personnel by failing to properly service the cam shaft. The camshaft gears fatigue which led to its ultimate failure, the dark night conditions, and the power lines were factors in this accident.NTSB MIA94LA017Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLTotal failure of the crankshaft due to fatigue resulting in a forced landing and subsequent hard landing.NTSB CHI94LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Rockford, ILA loose fuel line fitting, due to improper maintenance, which resulted in an interuption of fuel to the engine.NTSB ATL94FA011Accident · 5 fatalField investigationFinal reportPiper PA-32RT-300T · Wrens, GAWas the fatique failure of the idler gear which resulted in the complete loss of engine power. A factor was the dark night.NTSB LAX94LA034Accident · Minor injuriesLimited investigationFinal reportSilver KR2 · Fontana, CAthe separation of an engine coolant hose which resulted in a complete loss of engine power.NTSB NYC94IA023Incident · No injuriesIncident investigationFinal reportBell 206L · New York, NYInadequate maintenance which resulted in the improper alignment of the 'O' ring on the spur adapter gear drive which caused lack of lubrication and wear of the gear drive and the disengagement of the compressor and turbine.NTSB LAX94IA018Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-605R · Los Angeles, CAa separation of the number 6 stage high pressure compressor disk for an undetermined reason.NTSB LAX94LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Hilo, HIthe failure of the right engine's magnetos for undetermined reasons and the resulting overtemperature of the remaining left engine.NTSB LAX94FA006Accident · 2 fatalField investigationFinal reportCessna 182M · Seligman, AZthe separation of the carburetor float and needle valve from the upper half of the carburetor bowl, due to improper installation of the float kit.NTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.NTSB FTW93LA271Accident · No injuriesLimited investigationFinal reportCessna 310Q · Edgewood, NMA propeller control unit failure, and loss of the pilot's option to feather the propeller. A factor was the lack of suitable terrain for a forced landing.NTSB SEA93LA213Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Detroit Lake, ORFailure of a second stage turbine wheel too low for a successful autorotation. Factors include a tree in the approach path.NTSB CHI93LA371Accident · No injuriesLimited investigationFinal reportPiper PA-60-601 · Lone Rock, WIInadequate maintenance and excessive airspeed during the landing approach.NTSB LAX93LA356Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Oracle, AZFailure of the crankshaft due to fatigue.NTSB CHI93LA364Accident · No injuriesLimited investigationFinal reportCessna 172P · Fieldon, ILPartial failure (deterioration) of the #1 piston pin plug, which resulted in contamination of the lubricating system and failure of the #3 connecting rod.NTSB LAX93FA352Accident · 1 fatalField investigationFinal reportScaled Composites 158-8 · Lemmon Valley, NVOil starvation and connecting rod failure in the right engine, and a resultant fuel fed fire.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.NTSB BFO93LA164Accident · No injuriesLimited investigationFinal reportCessna 402B · Eau Claire, PAThe separation of the number four cylinder on the airplane's left engine for undetermined reasons. A factor in the accident was the rough/uneven terrain.NTSB CHI93LA345Accident · No injuriesLimited investigationFinal reportBeech P35 · Ottumwa, IAan oil leak in the oil filter adapter. A factor was landing in a crop field.NTSB NYC93FA177Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-40 · S. Charleston, WVwas improper emergency procedures by the pilot which resulted in the shutdown of an operative engine, following a power loss due to a failed torque sensor in the other engine, which resulted in a total power loss approach, landing, and overrun.NTSB ATL93LA148Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Knoxville, TNInadequate annual inspection procedures for the fuel system, which resulted in fuel starvation due to blockage of the fuel floscan transducer. A factor was insufficient FAA inspection standards/requirements.NTSB NYC93LA168Accident · No injuriesLimited investigationFinal reportPiper PA-25-225 · Chesapeake, VAThe loosening of the crankshaft geardrive as a resulted of a sheared bolt and guide pin which resulted in the loss of engine power. A factor was a forced landing on a crop field.NTSB MIA93FA183Accident · Serious injuriesField investigationFinal reportCessna 402C · Andytown, FLThe failure of the pilot to feather the propeller when the engine lost power, and his failure to follow the emergency procedure checklist. Contributing to the accident was the inadequate design of the fuel tank float valves which allowed for excessive wear…NTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).NTSB FTW93LA243Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Lafayette, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.NTSB NYC93LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Hope Valley, RIThe engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.NTSB LAX93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Showlow, AZA total loss of engine power due to a separation of the mixture control balljoint assembly at the carburetor mixture arm and subsequent forced landing.NTSB SEA93FA178Accident · No injuriesField investigationFinal reportEnstrom F-28C · Seattle, WAShorted magneto condensers. Factors include a hidden obstruction in the landing area, and a reduction in rotor RPM from attempting to avoid the obstruction.NTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.NTSB NYC93FA154Accident · 1 fatalField investigationFinal reportCessna 182A · East Moriches, NYEngine failure due to a fatigue failure of the no.3 piston. The fatigue failure was a result of inadequate manufacturing. In addition, the pilot made an improper decision during the forced landing in attempting to stretch his approach in order to reach the…NTSB FTW93LA234Accident · No injuriesLimited investigationFinal reportCessna 177B · Grand Prairie, TXLoss of engine power due to fuel starvation as a result of a leaking fuel line. The fuel line was not the correct part as a result of a misidentification by Cessna.NTSB FTW93LA228Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXPilot's failure to maintain proper rotor RPM, the delayed flare, and improper touchdown. Factors were total failure of the power turbine due to oil starvation to the #8 bearing assembly.NTSB ATL93LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moncks Corner, SCFailure of the number one cylinder at the cylinder flange radius.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB DEN93LA092Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Galveston, TXThe disconnection of the throttle linkage and the resultant power loss. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA219Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Vidor, TXControl cable separation due to the throttle power lever linkage not being secured by retainer resultant from improper installation. A factor was a lack of suitable terrain for the forced landing.NTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.NTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.NTSB ATL93LA134Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ashford, ALThe failure of the engine supercharger assembly, which resulted in a loss of engine power. A factor was the trees at the forced landing site.NTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.