NTSB investigations, IN
43 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 3 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2005 | 2 |
| 2007 | 3 |
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\" = 'IN' 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" = 'IN' 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 CHI08CA034Accident · Minor injuriesData collectionFinal reportGluff, Alan Zenair 200 · Greenwood, INThe total loss of engine power due to a lubricating system leak for undetermined reasons which resulted in engine seizure, and the unsuitable terrain encountered during the forced landing. Contributing factors were the plowed field and the nose gear failure…NTSB CHI07LA287Accident · No injuriesLimited investigationFinal reportMooney M20K · Fort Wayne, INA total loss of engine power due to the fatigue failure of one of the number two cylinder connecting rod bolts.NTSB CHI07CA262Accident · No injuriesData collectionFinal reportBeech BE-77 · Bloomington, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB CHI06LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Portland, INThe pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…NTSB CHI05LA226Accident · 2 fatalLimited investigationFinal reportPiper PA-28-161 · Culver, INThe loss of engine power while maneuvering due to partial failure of the left magneto, and the flight instructor's failure to maintain sufficient airspeed to avoid a stall. An additional cause was improper maintenance by company maintenance personnel,…NTSB CHI04LA005Accident · No injuriesLimited investigationFinal reportWaco CTO · Greenfield, INThe loss of engine power during cruise and subsequent fire for undetermined reasons.NTSB CHI03LA095Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Knox, INA loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.NTSB CHI00LA226Accident · 1 fatalLimited investigationFinal reportHalsmer Crazy 8 · Lafayette, INAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.NTSB CHI99LA319Accident · No injuriesLimited investigationFinal reportVan Grouw White Lightning · Greenfield, INimproper installation of the oil quick drain plug which resulted in oil exhaustion to the engine. A factor was the corn crop encountered during the forced landing.NTSB CHI98LA242Accident · No injuriesLimited investigationFinal reportBrunnemer HMB-2 · Greenwood, INA loss of engine power due to a fractured ignition coil. A factor to the accident was the soft terrain.NTSB CHI96LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.NTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.NTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.NTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.NTSB CHI92LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Knox, INThe overload failure of the #2 cylinder connecting rod. Contributing to the accident was the night light conditions and the pilot's inability to reach a suitable landing area.NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB CHI91LA173Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA1A · Evansville, INThe failure by maintenance personnel to identify the proper replacement cylinder.NTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.NTSB CHI89DET06Accident · No injuriesFinal reportDilley P51R · Hamilton, INThe failure of the #3 connecting rod. A factor was the unsuitable terrain.NTSB CHI89DEX04Accident · Serious injuriesFinal reportNorth American SNJ-5 · Sellersburg, INThe ingestion of a foreign object and subsequent supercharger impeller failure.NTSB CHI89LA063Accident · Minor injuriesLimited investigationFinal reportBeech 95-B-55 · Crothersville, INA failure of the engine due to a crankshaft counterweight failure. The pilot performed emergency procedures and executed a forced landing in an open field, where the aircraft encountered a large muddy area, bogged down and nosed over.NTSB CHI88LA234Accident · No injuriesLimited investigationFinal reportFairchild PT-19 · Converse, INDuring initial climbout after takeoff, the aircraft experienced a loss of engine power. After an unsuccessful attempt to restart the engine, the pilot executed a forced landing in a corn field. Post accident exam revealed a broken universal joint in the fuel…NTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.NTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…NTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.NTSB CHI87DEX07Accident · Serious injuriesFinal reportBoeing E75 · Mccordsville, INDuring initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the…NTSB CHI87LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Anderson, INThe plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held…NTSB CHI87DET05Accident · Serious injuriesFinal reportBannwart Maxair XP-503 · Michigan City, INWhile in cruise flight the carburetor of this amateur built aircraft became detached and the engine failed. An emergency land was attempted, however obstacles prevented a landing at primary landing site and an alternate was selected. The aircraft was unable…NTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…NTSB CHI86FEX08Accident · Minor injuriesFinal reportConner KR-2 · Hagerstown, INDrg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for…NTSB CHI86FEX06Accident · Serious injuriesFinal reportPiper PA-32-260 · Henryville, INShortly after leveling the acft off at 9000 ft MSL, the plt experienced an engine failure. During the subsequent forced landing the acft struck a tree and was further damaged during the forced landing roll. Metallurgical exam revealed the crankshaft failed…NTSB CHI85FEX03Accident · Serious injuriesFinal reportPiper PA-28-180 · Orleans, INDuring flt, the plt noted that the eng RPM dropped from 2500 to 2000. He could not restore the RPM. He then heard a loud noise from the eng compartment & the eng seized. Subsequently, the acft was damaged during an emerg landing in a corn field. A teardown of…NTSB CHI85FET02Accident · Minor injuriesFinal reportPiper PA-28-140 · Nappanee, INThe acft nosed over during a forced landing in a field following a loss of pwr on initial climb from a touch & go landing. Post accident inspection revealed the throttle lever could rotate on the throttle shaft despite the attaching bolts being tight and…NTSB CHI84LA326Accident · No injuriesLimited investigationFinal reportBede Bede 4 · Evansvile, INThe acft experienced a total power loss & the plt made a forced landing on a hwy median. The landing gear collapsed & the acft slid to a stop. Post accident inspection revealed that a large portion of the foam air filter had broken off & became lodged in the…NTSB CHI84LA186Accident · No injuriesLimited investigationFinal reportHughes 500D · Rensselaer, INHard forced landing made after loss of pwr at cruise alt of 500 ft AGL. Main rotor blades contacted tail boom. Examination disclosed fuel pump gears showed signs of corrosion. Gear teeth and end faces were severly etched and pitted. Bronze particles were…NTSB CHI84LA083Accident · No injuriesLimited investigationFinal reportCessna 150M · Pittsboro, INThe acft made a forced landing on a rough, snow covered field after the engine failed. Post accident investigation showed thet the exhaust valve on #1 cylinder punctured the cylinder.NTSB CHI83LA448Accident · No injuriesLimited investigationFinal reportHughes 369D · Indianapolis, INWhile the helicopter was cruising at about 500 ft AGL, the eng lost power. The plt turned into the wind & made an autorotative landing in a corn field. During the landing, the tail boom was severed by the main rotor blades. An exam revealed that the housing…NTSB CHI83LA413Accident · Minor injuriesLimited investigationFinal reportKuster KR-2 · New Lisbon, INThe acft made a forced landing in a cornfield after a loss of power during flt. The acft had been flying about 30 minutes. Post accident examination of the engine revealed a fuel leak around the mixture control linkage shaft. The fuelexhaustion was atttibuted…NTSB CHI82DA170Accident · Serious injuriesFinal reportPlaymate SA11A · Pendleton, INThe pilot was cruising at 2000 feet with one passenger when the engine quit. He made a forced landing in a soft soybean field and the aircraft nosed over during deceleration. The aircraft revealed the exhaust system baffles were collapsed. "Blow by" was…NTSB CHI82IA082Incident · No injuriesIncident investigationFinal reportSwearingen SA-266TC · South Bend, INThe captain reported that at lift-off above VI speed, he heard a loud pop that sounded like a tire had failed. A "bright yellowish" illumination was then seen in front of the right engine. There was insufficient runway to abort, so the takeoff was continued.…