NTSB investigations, 2000
92 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\") = 2000
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") = 2000 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 DEN01LA029Accident · No injuriesLimited investigationFinal reportCessna 172E · Salt Lake City, UTthe lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.NTSB FTW01LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, TXthe loss of engine power during cruise flight due to the fatigue fracture of the compressor coupling adapter. A contributing factor was the high sea condition existing for the forced landing.NTSB FTW01LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Gainesville, TXthe loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…NTSB CHI01LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…NTSB NYC01LA029Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Prosperity, PAThe failure of the dual magneto ignition system points to open.NTSB FTW01LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Almyra, ARthe loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.NTSB FTW01FA017Accident · 1 fatalField investigationFinal reportAerospatiale AS-350BA · E. Cameron 200the loss of engine power due to an internal engine oil leak that started an internal engine fire and the pilot's inadequate autorotation which resulted in a hard landing. A contributing factor to the accident was the rough water condition.NTSB LAX01FA027Accident · Serious injuriesField investigationFinal reportGrumman American AA-5A · Gardena, CAThe engine lost power for undetermined reasons.NTSB LAX01LA025Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350BA · Kamuela, HIA total loss of engine power due to the failure of the engine manufacturer's repair station personnel to install a circlip during engine overhaul, which resulted in the turbine assembly aft support bearing becoming dislodged and seized on the shaft. A factor…NTSB IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.NTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD01LA002Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Philadelphia, PAA hole in the #4 piston for undetermined reasons which resulted in engine oil starvation and engine stoppage.NTSB DEN01LA002Accident · Serious injuriesLimited investigationFinal reportHughes 369FF · Baggs, WYimpact with terrain following a total loss of engine power due to fatigue failure of the turbine-to-compressor coupling. A contributing factor was the unsuitable terrain for a forced landing.NTSB SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…NTSB LAX00LA345Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CALoss of engine power due to failure and separation of the number one connecting rod.NTSB FTW00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Saspamco, TXthe failure of the #3 and #4 connecting rods. A contributing factor was the lack of suitable terrain condition for the forced landing.NTSB LAX00LA350Accident · No injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZSeparation of the forward spark plug due to wear damage to the cylinder head threads. A factor in the accident was traffic on the highway and the pilot having to maneuver to avoid the traffic.NTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.NTSB ATL00LA087Accident · No injuriesLimited investigationFinal reportGrumman G164A · Dillon, SCA total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.NTSB NYC00IA250Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJThe sequential failure of the 2nd-stage low pressure turbine nozzle locks, which allowed the 2nds stage turbine nozzle segments to rotate within the low pressure turbine case, machining a hole whereby the nozzle segments exited the engine. A factor was the…NTSB DEN00LA159Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Fe, NMUnsuitable terrain for a forced landing. Factors were a complete loss of power due to a stuck needle valve in the carburetor.NTSB CHI00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Superior, NEthe cracked number 7 cylinder exhaust valve. A factor relating to this accident was the tree.NTSB FTW00FA245Accident · 1 fatalField investigationFinal reportCessna 421C · Hunt, TXthe loss of left engine power as a result of the owner's failure to overhaul the engine before further flight after the lubrication system was found contaminated with metal. Contributing factors were the pilot's decision to fly the aircraft with a…NTSB DEN00LA157Accident · Serious injuriesLimited investigationFinal reportPhelps Rans S-12 Airaile · Buffalo, WYthe lack of suitable terrain for the forced landing. Contributing factors were the power failure due to a failed rod bearing, and down draft weather condition.NTSB IAD00FA076Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kennebunkport, MEFracture of the #4 connecting rod for undetermined reasons, which resulted in a loss of engine power. A factor was the forced ocean ditching.NTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.NTSB CHI00LA247Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wallace, NEthe fractured number three exhaust push rod assembly and the unsuitable terrain encountered by 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 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 LAX00LA277Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Boulder City, NVThe fatigue fracture and separation of the No. 6 cylinder fuel injector line due to the company maintenance personnel's failure to comply with an Airworthiness Directive. A factor in the accident was the company's decision to operate the aircraft in…NTSB LAX00LA275Accident · Minor injuriesLimited investigationFinal reportSteel/Vans RV6 · Winnemucca, NVA loss of power due to overheating resulting from the failure of the engine build-up facility to install a vernatherm.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB DEN00LA143Accident · No injuriesLimited investigationFinal reportMooney M20J · Espanola, NMThe lack of suitable terrain for a forced landing. A factor was a complete loss of power due to mechanical failure.NTSB LAX00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selma, CAA cracked plastic fuel selector handle that precluded proper engagement of the internal mechanism to fully select a port, and left it in an intermediate position, restricting the fuel supply to the engine, which subsequently lead to a loss of engine power.NTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB MIA00LA215Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCA loss of engine power due to failure of the No. 4 cylinder connecting rod during the first flight following engine overhaul for undetermined reasons. Contributing to the accident was unsuitable terrain.NTSB FTW00LA200Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Moscow, TXthe failure of the power output reduction gear to the propeller. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA258Accident · No injuriesLimited investigationFinal reportCessna 205 · Tacna, AZThe piston and rings in cylinder No. 1 failed resulting in a total loss of engine power. The pilot made a forced landing on a road and the airplane's wing collided with a road sign.NTSB MIA00LA196Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Selma, ALThe improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…NTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB SEA00LA121Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · West Linn, ORImproper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…NTSB SEA00LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kennewick, WAA failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…NTSB CHI00LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Saint Vincent, MNthe failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.NTSB LAX00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Mayer, AZthe total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.NTSB MIA00IA191Incident · No injuriesIncident investigationFinal reportDassault F2TH Falcon · Fort Lauderdale, FLthe fatigue failure of the rivets used to secure the inner casting forward static seal to the 1st-stage low-pressure turbine support/nozzle assembly. The failure of the rivets allowed the forward static seal to machine a groove into the 2nd-stage…NTSB SEA00LA116Accident · Serious injuriesLimited investigationFinal reportDavis/Crouch Avid MK IV · Concrete, WAFracture of the engine's #1 connecting rod, resulting in a total loss of engine power. Factors were an engine overheat condition experienced at an undetermined time, and no suitable terrain for a forced landing.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.