NTSB investigations, GA
86 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 7 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 5 |
| 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\" = 'GA' 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" = 'GA' 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 NYC08FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Augusta, GAA loss of engine power due to the fatigue fracture of the number 2 cylinder attach studs, and the subsequent separation of the number 2 cylinder.NTSB ANC07LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Albany, GAThe loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.NTSB ATL07LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Conyers, GALoss of engine oil for undetermined reasons resulting in oil starvation, failure of the No. 1 connecting rod resulting in the total loss of engine power.NTSB ATL06LA101Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Milledgeville, GAThe improper fabrication of the oil pressure gauge line by maintenance personnel, which resulted in a loss of engine oil and total loss of engine power during cruise flight.NTSB ATL06LA061Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Folkston, GAThe total loss of engine power due to the failure of the compressor turbine blades due to high temperature exposure.NTSB ATL06LA050Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Jesup, GAThe loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…NTSB ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…NTSB ATL03LA122Accident · No injuriesLimited investigationFinal reportAir Tractor AT401B · Girard, GAA loss of engine power due to the failure of the internal supercharger blower seals.NTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.NTSB ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB MIA02LA008Accident · Minor injuriesLimited investigationFinal reportCessna T206H · LakeLanier Isl., GAThe fatigue failure of the crankshaft for undetermined reasons resulting in the total loss of engine power. A contributing factor in the accident was the unsuitable terrain encountered by the pilot during the forced landing.NTSB ATL01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homerville, GAThe improper replacement of an accessory drive component with an unapproved part by maintenance personnel, which resulted in a fatigue fracture of the component and loss of engine power. The airplane subsequently collided with power lines and trees during an…NTSB MIA01LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Winder, GAA total loss of engine power due to fatigue failure of the number two piston immediately after takeoff, resulting in collision with trees and the terrain during an emergency descent.NTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB ATL99LA112Accident · No injuriesLimited investigationFinal reportBeech 77 · Dawson, GAThe loss of engine power due to fuel starvation that resulted from a blocked fuel line check valve.NTSB ATL99LA023Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Locust Grove, GALoss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.NTSB ATL99LA017Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Cuthbert, GAThe fatigue failure of the accessory gear shaft which resulted in fuel starvation and the loss of engine power. A factors was the fuel system filter restriction.NTSB MIA99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Douglasville, GAFailure of the no. 1 cylinder exhaust valve guide due to erosion, which resulted in separation of the exhaust valve head, loss of engine power, and collision with a power pole during a forced landing on unsuitable terrain.NTSB MIA98LA242Accident · No injuriesLimited investigationFinal reportCessna 177RG · Covington, GAslippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.NTSB MIA98LA037Accident · Minor injuriesLimited investigationFinal reportCessna FR-172J · Marietta, GAA catastrophic failure of the oil cooler core which led to overboard porting of lubricating oil and subsequent engine failure.NTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…NTSB MIA97LA012Accident · Minor injuriesLimited investigationFinal reportAir Tractor 400 · Sylvester, GAWas the pilots intentional disregard for operating the engine contrary to the flight manuals for intentionally exceeding the maximum engine temperature, resulting in creep failure of one of the compressor turbine blades.NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB ATL96LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Athens, GAThe mechanic's failure to adequately inspect and repair the engine, which resulted in engine oil contamination, and the subsequent loss of engine power. A factor was the low ceiling.NTSB ATL96LA005Accident · No injuriesLimited investigationFinal reportMooney M20K · Dalton, GAOil starvation for an unknown reason, which resulted in progressive connecting rod failure and subsequent loss of engine power. Factors relating to the accident were: the unfavoable weather and light conditions (low ceiling and fog at dusk), which hampered…NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB MIA95FA223Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Dalton, GAthe pilot's improper action by turning off the right engine fuel selector valve after the left engine had failed, and her failure to maintain control of the airplane after losing power in both engines. Factors relating to the accident were: a worn rocker arm…NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.NTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.NTSB ATL95FA036Accident · 4 fatalField investigationFinal reportCessna 414 · Augusta, GAThe loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.NTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.NTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.NTSB ATL94LA053Accident · No injuriesLimited investigationFinal reportCessna T210R · Baxley, GADamage to the crankshaft internal oil tube by other maintenance persons during the engine overhaul that resulted in oil starvation.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 ATL93LA119Accident · Minor injuriesLimited investigationFinal reportWaco ATO · Alma, GAThe failure of the aircraft engine master rod bearing.NTSB ATL93LA040Accident · No injuriesLimited investigationFinal reportShaw Velocity HXB · Savannah, GAThe disengagement of the idler gear, which interrupted fuel pump operation, and resulted in the total loss of engine power. Factors were the lack of suitable terrain and the water.NTSB ATL92LA154Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Cobb, GAThe corroded, and separated, magnetic chip detector plug which allowed the loss of all engine oil and the engine's subsequent seizure. Factors were the inadequate 100 hour inspection, and the high vegetation in the forced landing field.NTSB ATL92LA141Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Americus, GAA loss of engine power due to a crack in the number three cylinder. A factor was the soft terrain at the forced landing area.NTSB ATL92IA078Incident · No injuriesIncident investigationFinal reportMaule M-5-210 · Atlanta, GAThe failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.NTSB ATL91LA162Accident · 1 fatalLimited investigationFinal reportHarold J. Eagen Pitts Special S-1C · Monroe, GAContamination and water existing in the fuel system which resulted in engine stoppage and the pilot's continued flight with a known aircraft deficiency.NTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB ATL91IA024Incident · No injuriesIncident investigationFinal reportCessna S550 · Columbus, GAA fatigue failure of a spot weld on the gas generator case, which resulted in an engine explosion.NTSB ATL91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GATotal failure of a connecting rod cap bolt which resulted in a total loss of power.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 ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…