NTSB investigations, KS
38 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 4 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA' AND 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 DEN07LA133Accident · Serious injuriesLimited investigationFinal reportWalker Lancair IV · Sylvan Grove, KSA catastrophic engine failure due to oil starvation when an oil line to the turbocharger wastegate actuator came loose. Contributing factors in this accident were the unsuitable terrain on which to make a forced landing.NTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.NTSB CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…NTSB CHI00LA243Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Osborne, KSThe unsuitable terrain for landing encountered by the pilot during the forced landing. Factors were the failure of the number four piston and cylinder, the soft terrain, and the main landing gear overload and subsequent collapse.NTSB CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.NTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.NTSB CHI99LA183Accident · No injuriesLimited investigationFinal reportGrumman American G-164B · Goodland, KSthe fracture of the rocker arm bolt. Contributing factors were the pilot's low altitude and the crops.NTSB CHI97LA260Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSthe Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.NTSB CHI97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Elk Falls, KSfracture of the fuel selector assembly which resulted in fuel starvation.NTSB CHI97LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Leavenworth, KSfatigue failure and separation of the number 2 cylinder. A factor was the rough terrain.NTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.NTSB CHI96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Rose Hill, KSthe worn carburetor, and inadequate inspection of the aircraft by other maintenance personnel.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB CHI95LA111Accident · Minor injuriesLimited investigationFinal reportBaker Long EZE · Salina, KSfailure of the engine driven fuel pump. Factors associated with the accident were fuel starvation, insufficient altitude and soft terrain.NTSB CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.NTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.NTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.NTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.NTSB MKC89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodland, KSThe loss of engine power resulting from an exhaust valve failure. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB MKC87LA162Accident · No injuriesLimited investigationFinal reportMaxfield Pitts S-1S · Meade, KSShortly after takeoff, while depg to the se, the eng seized. All of the surrounding terrain consisted of plowed fields, so the plt tried to glide back to the arpt; however, he had insufficient speed & alt to get aligned with the rwy. Drg the lndg, the acft…NTSB MKC87LA100Accident · No injuriesLimited investigationFinal reportCessna 188 · Ottawa, KSThe acft was returning from an aerial application flt when the fuel line to the fuel filter disconnected. During the forced landing, the acft ran into a fence. The eng had been installed 100 flt hrs prior to the accident.NTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.NTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…NTSB MKC86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Wilson, KSThe pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…NTSB MKC86LA150Accident · No injuriesLimited investigationFinal reportStainbrook Avid Flyer · Salina, KSThe PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken…NTSB MKC86LA021Accident · No injuriesLimited investigationFinal reportMooney M20K · Spring Hill, KSThe pilot of this aircraft was returning from a business flight when the engine failed. During the forced landing, the aircraft rolled through a fence and then impacted a pole with one wing. The pilot stated that one connecting rod came through the side of…NTSB MKC85FCQ04Accident · Serious injuriesFinal reportRyan Navion · Blue Rapids, KSThe acft eng lost power after a 30 minute flt and a forced landing resulted in an off.-arpt acc. Witnesses at the acc site did not find any fuel in the tanks or evidence of spillage of fuel. An inspection of the eng did not reveal any discrepancies. A…NTSB MKC83FA225Accident · No injuriesField investigationFinal reportBeech 60 · Wichita, KSShortly after takeoff, the left eng began to progressively lose power & was shut down. The aircrew notified Beech tower of the problem & reported they would like to return & land. The acft was observed on final apch to rwy 18 with the gear extended & the left…NTSB MKC83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Grenola, KSWhile spraying liquid fertilizer, the plt noticed that the fuel indication was dropping rapidly. He stated that he tried to return to the departure point, but was unable. When the engine lost power, he jettisoned the remainder of his load & landed in a…NTSB MKC83IA078Incident · No injuriesIncident investigationFinal reportAero Commander 680W · Kansas City, KSThe number 2 engine failed in cruise flight. Durng descent the landing gear failed to extend. The pilot landed intentional gear up in the sod area adjacent to the runway.NTSB MKC83LA079Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Ultsses, KSThis amateur-built aircraft was being flown at 200 feet AGL on a pleasure flight when the engine quit. The pilot made a forced landing in a soft field and the aircraft nosed over. The engine quit because the fuel cap was not vented. The capwas supplied with…NTSB MKC82DA087Accident · No injuriesFinal reportPiper PA-31P · Salina, KSAccording to the pilot, the left engine began running rough at about 300 ft AGL after takeoff and the roughness was accompanied by a slight left yaw. The pilot said the left engine was producing some power so he elected not to feather the propeller. The…