NTSB investigations, 2002
222 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 257 |
|---|---|
| 1983 | 204 |
| 1984 | 161 |
| 1985 | 156 |
| 1986 | 193 |
| 1987 | 186 |
| 1988 | 136 |
| 1989 | 126 |
| 1990 | 120 |
| 1991 | 169 |
| 1992 | 142 |
| 1993 | 153 |
| 1994 | 173 |
| 1995 | 158 |
| 1996 | 178 |
| 1997 | 170 |
| 1998 | 205 |
| 1999 | 198 |
| 2000 | 169 |
| 2001 | 228 |
| 2002 | 222 |
| 2003 | 187 |
| 2004 | 177 |
| 2005 | 205 |
| 2006 | 162 |
| 2007 | 183 |
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\") = 2002
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\" = 350)
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") = 2002 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" = 350) 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 FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA067Accident · 1 fatalField investigationFinal reportBeech F-35 · Addison, TXThe pilot's mismanagement of the fuel supply by his failure to switch fuel tank positions which resulted in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Osage Beach, MOFuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees.NTSB MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB SEA03TA014Accident · No injuriesFinal reportHughes OH-6A · Snohomish, WALoss of engine power for undetermined reasons while in cruise flight. A tree was a factor.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB FTW03FA051Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · McAlester, OKThe pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…NTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.NTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB CHI03LA028Accident · No injuriesLimited investigationFinal reportWoods Velocity · Claflin, KSThe total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing.NTSB FTW03LA047Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18A · Votaw, TXA loss of engine power for undertermined reasons. Contributing factors included the unsuitable terrain for the forced landing and the lack of airspeed.NTSB LAX03LA036Accident · No injuriesLimited investigationFinal reportAsmus Exec 162F · Monterey, CAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.NTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.NTSB CHI03LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Longville, MNThe loss of engine power for undetermined reasons and the unsuitable terrain/landing area encountered by the pilot during a forced landing. The low altitude at the time of power loss was a contributing factor.NTSB NYC03FA020Accident · 1 fatalField investigationFinal reportCessna 210L · Rochester, NYA loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.NTSB SEA03FA008Accident · 2 fatalField investigationFinal reportBeech A36TC · San Andreas, CALoss of engine power during takeoff climb for undetermined reasons.NTSB LAX03FA031Accident · Minor injuriesField investigationFinal reportCessna T210L · Pacoima, CAa loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.NTSB NYC03LA017Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75 · Glade Spring, VAthe pilot's improper in-flight decision to fly at an altitude that did not allow for successful completion of a forced landing, after the engine lost power for undetermined reason(s). A factor was the unsuitable terrain.NTSB CHI03LA021Accident · Serious injuriesLimited investigationFinal reportBeech D35 · Dodge Center, MNThe loss of engine power due to a fractured engine driven pump shaft pin. The low altitude and unsuitable terrain encountered were contributing factors.NTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.NTSB SEA03LA007Accident · 1 fatalLimited investigationFinal reportRiddell IV-P · Bozeman, MTThe loss of power for undetermined reason(s) and the pilot's failure to maintain the aircraft's flying speed above the power off stall speed in the landing configuration.NTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.NTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX03LA016Accident · Minor injuriesLimited investigationFinal reportHubbard StddHmltn GlasairIIS · Chino, CAFuel starvation for undetermined reasons.NTSB FTW03LA025Accident · No injuriesLimited investigationFinal reportCessna T188C · Seminole, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.NTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.NTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…NTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.NTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.NTSB SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.NTSB CHI03LA007Accident · No injuriesLimited investigationFinal reportMadewell EAA-Biplane-P · Forest Lake, MNThe loss of engine power for undetermined reasons. A related factor was the swampy terrain.NTSB MIA03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Immokalee, FLA loss of engine power on takeoff for undetermined reasons.NTSB FTW03LA006Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti L1019 · Midland, TXThe loss of engine power resulting from a loose "B" nut on the line going from the bleed air filter to the fuel control unit. Also causal was the inadequate maintenence of the fuel control unit and filters during the last conditional inspection.NTSB LAX03LA009Accident · No injuriesLimited investigationFinal reportQuicksilver Challenger II · Porterville, CAThe loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB CHI03LA002Accident · No injuriesLimited investigationFinal reportTanner Kitfox · Coldwater, MIThe low altitude at which an undetermined loss of engine power occurred following takeoff.NTSB SEA02LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Oakley, IDFailure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…NTSB MIA02LA175Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Irvington, ALThe loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…NTSB LAX02LA298Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lucerne Valley, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.NTSB FTW02LA267Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Wellington, TXThe loss of engine power for an undetermined reason.NTSB FTW02LA265Accident · No injuriesLimited investigationFinal reportCessna 320 · Gatesville, TXThe loss of engine power to the left engine for undetermined reasons. A contributing factor was the rough and uneven terrain.NTSB ATL02LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring City, TNThe flight instructor's failure to follow standard training procedures that resulted in the loss of engine power during a simulated loss of engine power.NTSB FTW02LA261Accident · No injuriesLimited investigationFinal reportBeech V35 · Del Rio, TXThe loss of engine power due to the low-pressure pump separating internally. Contributing factors were the deterioration of the fuel pump and the lack of suitable terrain for the forced landing.NTSB FTW02LA263Accident · No injuriesLimited investigationFinal reportCessna 188A · Vincent, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369D · O'Neill, NEA loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…