NTSB investigations, 1996
119 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 175 |
|---|---|
| 1983 | 165 |
| 1984 | 138 |
| 1985 | 155 |
| 1986 | 126 |
| 1987 | 129 |
| 1988 | 160 |
| 1989 | 129 |
| 1990 | 123 |
| 1991 | 128 |
| 1992 | 133 |
| 1993 | 115 |
| 1994 | 129 |
| 1995 | 151 |
| 1996 | 119 |
| 1997 | 91 |
| 1998 | 78 |
| 1999 | 91 |
| 2000 | 92 |
| 2001 | 70 |
| 2002 | 54 |
| 2003 | 78 |
| 2004 | 63 |
| 2005 | 65 |
| 2006 | 62 |
| 2007 | 59 |
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 year(c.\"eventDate\") = 1996
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 year(c."eventDate") = 1996 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 LAX97LA076Accident · Minor injuriesLimited investigationFinal reportTrickle TR-4 · Davis, CAThe fatigue fracture and separation of one rod end cap bolt. A factor in the accident was the nature of the terrain for the forced landing.NTSB NYC97LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Lexington, KYfailure of #5 exhaust valve and/or #5 exhaust valve guide, which resulted in a progressive engine failure (debris puncturing the #5 piston crown, exhaust gasses entering the crankcase, loss of oil through the breather system, oil exhaustion, and subsequent…NTSB SEA97LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Friday Harbor, WAfailure of the engine (powerplant) for undetermined reason(s). A factor relating to the accident include: being over water at the time of power failure.NTSB CHI97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Red Oak, IAthe pilot's inadequate preflight and failure to make a precautionary landing. Additional factors included oil starvation and the failed connecting rod and rod bearing.NTSB FTW97LA063Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Amarillo, TXfailure of the #1 exhaust valve, which resulted in loss of engine power and a forced landing on rough/uneven terrain. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.NTSB NYC97LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Myerstown, PAfatigue failure of the connecting rod to crankshaft attachments, due to inadequate overhaul of the engine by the manufacturer, which resulted in a loss of engine power and a forced landing. Factors relating to the accident included the discharge of oil from…NTSB LAX97LA058Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Scottsdale, AZdetonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.NTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.NTSB LAX97LA039Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Hana, HIsubsequent failure of the spur adapter gearshaft (SAG), after 'retaining ring to compressor impeller machining' occurred and allowed the SAG to shift aft. The mechanism which induced the ring to impeller machining was not determined. Mountainous terrain in…NTSB LAX97LA037Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Williams, AZa foreign object in the oil system, which resulted in failure of the oil pump, oil starvation, loss of engine power, and a subsequent forced landing. Rough/uneven terrain in the emergency landing area was a related factor.NTSB CHI97LA021Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Kirksville, MOan improper maintenance overhaul by company maintenance personnel which led to a bearing failure. The soft terrain was a factor.NTSB LAX97LA031Accident · 2 fatalLimited investigationFinal reportRainey Rans S-12 · Tucson, AZa broken wire in the ignition coil, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spin and uncontrolled collision with the terrain.NTSB LAX97LA035Accident · Minor injuriesLimited investigationFinal reportAerostar YAK 52 · Fullerton, CAloss of engine power due to an undetermined internal carburetor malfunction. A factor relating to the accident was: the directions that were use for reassembly of the aircraft were written only in Russian.NTSB ATL97LA012Accident · Serious injuriesLimited investigationFinal reportDouglas C-47 · Dorado, PRfailure of the #11 cylinder on the right (#2) engine, which resulted in an in-flight fire and loss of power in that engine; and a malfunction/failure of the #2 feathering system, which led to a subsequent forced landing before the flight crew could return to…NTSB LAX97LA028Accident · Serious injuriesLimited investigationFinal reportLeibert BD-5B · Phoenix, AZloss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.NTSB ATL97LA009Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Amelia Island, FLinadequate maintenance/inspection, which resulted in a failure to detect and correct moisture contamination of the left magneto; and/or improper adjustment of the engine fuel pump output, which resulted in excessive fuel pressure.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 LAX97LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kingsburg, CAthe student pilot's use of an excessively lean mixture, which led to engine overheating, detonation, subsequent failure of the number 2 piston, and a forced landing.NTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.NTSB CHI97LA009Accident · No injuriesLimited investigationFinal reportHayes Lancair 235 · Kansas City, MOa stuck carburetor float valve which resulted in excessive fuel flow and ultimately fuel exhaustion. A factor related to the accident was the rough terrain on which the forced landing was made.NTSB LAX97LA011Accident · Serious injuriesLimited investigationFinal reportRichards Lancair IVP · Camarillo, CAThe loss of engine power for undetermined reasons.NTSB FTW97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 175B · Mount Pleasant, TXThe total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.NTSB CHI97LA004Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Nunda, SDfailure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.NTSB IAD97LA002Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunbury, PAfailure of the cluster gear attaching bolts (of which one failed from fatigue), resulting in a disconnect of the gear and loss of engine power. An obstruction (rock) in the emergency landing area was a related factor.NTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.NTSB FTW96LA396Accident · No injuriesLimited investigationFinal reportCoursey Prostar PT-2 · Rio Rancho, NMfatigue failure of the engine oil cooler coil, which resulted in an oil leak, oil starvation, loss of engine power, and a subsequent forced landing. Factors relating to the accident were: the proximity of a truck on the highway and soft terrain that was…NTSB LAX96LA341Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Santa Ynez, CAfailure of a maintenance technician to properly torque the fuel injector lines to three cylinders.NTSB ATL96LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Georgetown, SCfailure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…NTSB LAX96LA338Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAA separation of a connecting rod due to a lack of internal lubrication from a blocked oil passage after a bearing had shifted on its journal.NTSB ATL96LA127Accident · Serious injuriesLimited investigationFinal reportBeech 33 · West Palm Beach, FLThe maintenance personnel failure to properly inspect the fuel system during the last annual inspection.NTSB FTW96LA384Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Sprngs, COThe improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…NTSB FTW96LA369Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COtotal failure of the induction air control linkage (bolt), which allowed the alternate air door to close and starve the engine of air.NTSB ANC96LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Skwentna, AKcorrosion and subsequent fatigue failure of the crankshaft, which resulted in engine failure and a forced landing. Factors related to the accident were: the lack of suitable terrain for a forced landing, and the operator's non-compliance with a service…NTSB FTW96LA357Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lubbock, TXinadequate maintenance by maintenance personnel, which resulted in a total loss of engine power when the magneto disengaged from the engine. A related factor was the lack of suitable terrain for a forced landing.NTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.NTSB LAX96LA311Accident · No injuriesLimited investigationFinal reportAtkinson Varieze · Glendale, AZThe fracture and separation of the mixture control cable housing from the carburetor mounting bracket, which resulted in fuel starvation due to an overlean condition, and the pilot's failure to maintain an adequate airspeed while stretching the glide to the…NTSB NYC96IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Flushing, NYa failure of the low pressure turbine assembly for undetermined reason(s).NTSB ANC96LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAn engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.NTSB FTW96LA341Accident · No injuriesLimited investigationFinal reportAyres S-2R · Wharton, TXtotal loss of engine power due to a fractured torque sensor shaft. Factors relating to the accident were: the obstructions (fence and trees) in the emergency landing area.NTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.NTSB CHI96LA281Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164 · Grant, NEfatigue failure and subsequent catastrophic failure of the number nine cylinder. A factor was the corn.NTSB SEA96LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Astoria, ORfailure of the carburetor heat box flapper valve, and the resultant air flow restriction to the carburetor. A factor relating to the accident was: high vegetation in the area where the forced landing was executed.NTSB FTW96LA332Accident · No injuriesLimited investigationFinal reportAyres S2R-G5 · Start, LAa leak in the turbine scavenge pump oil supply line, due to chafing of its separated shield assembly, which resulted in an oil leak, oil starvation, and activation of the propeller feathering system.NTSB CHI96LA270Accident · Minor injuriesLimited investigationFinal reportGeide SPORT-A · Slater, MOfailure of a #2 connecting rod bolt, which led to a jammed connecting rod and subsequent overload separation of the #2 cylinder. A factor relating to the accident was: lack of suitable terrain for an emergency landing.NTSB ATL96FA114Accident · 1 fatalField investigationFinal reportCessna TU206A · Greer, SCThe disintegration of the number 3 piston, and the pilot's inadequate selection of terrain for the landing.NTSB FTW96LA329Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burlington, COThe total loss of engine power resulting from a cracked cylinder. A factor was the unsuitable terrain for the forced landing.NTSB CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.NTSB LAX96LA291Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Tracy, CAA loss of engine power due to the disengagement of the crankshaft gear from it's hub due to the overload shear of the eight retaining screws.NTSB LAX96LA293Accident · No injuriesLimited investigationFinal reportThompson Long EZ TR · Yucca Valley, CAFuel starvation due to the internal failure of the electric fuel pump and the subsequent fuel flow blockage to the gascolator.