NTSB investigations, 1992
229 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 344 |
|---|---|
| 1983 | 386 |
| 1984 | 389 |
| 1985 | 341 |
| 1986 | 311 |
| 1987 | 276 |
| 1988 | 311 |
| 1989 | 296 |
| 1990 | 322 |
| 1991 | 250 |
| 1992 | 229 |
| 1993 | 254 |
| 1994 | 219 |
| 1995 | 220 |
| 1996 | 217 |
| 1997 | 212 |
| 1998 | 166 |
| 1999 | 160 |
| 2000 | 159 |
| 2001 | 116 |
| 2002 | 124 |
| 2003 | 140 |
| 2004 | 121 |
| 2005 | 115 |
| 2006 | 102 |
| 2007 | 111 |
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\") = 1992
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\" = 353)
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") = 1992 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" = 353) 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 ATL93LA044Accident · No injuriesLimited investigationFinal reportCessna 182A · New Ellenton, SCInadequate preflight planning and preparation by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Factors were trees in the emergency landing area.NTSB ATL93LA043Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Smithville, TNThe failure of the pilot to follow pilot manual procedures by slipping the aircraft with inadequate fuel available, which resulted in fuel starvation. Factors were the inadequate fuel supply on the aircraft and the failure of the pilot to refuel.NTSB NYC93LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Bowling Green, KYThe pilot's inadequate inflight planning and decision which resulted in fuel exhaustion and the loss of engine power.NTSB FTW93LA057Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Weatherford, TXAn engine failure for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Slaton, TXThe total loss of engine power due to fuel starvation as a result of improper fuel tank selection. A factor the unsuitable terrain.NTSB LAX93LA072Accident · No injuriesLimited investigationFinal reportCessna 180K · Fullerton, CAThe airplane's owners (including the pilot) poor maintenance and the pilot's inadequate preflight inspection. Contributing to this accident was the deteriorated overwing fuel caps seals and the tailwind.NTSB NYC93LA050Accident · Serious injuriesLimited investigationFinal reportBeech F-35 · Collegeville, PAThe pilot's failure to follow the before landing check list in the pilot operators handbook in not selecting the fullest fuel tank for landing, which resulted in fuel starvation and subsequent engine failure.NTSB FTW93LA053Accident · No injuriesLimited investigationFinal reportCessna 210L · Allen, TXThe pilot's improper fuel tank selection and the subsequent loss of engine power due to fuel starvation. A factor was the lack of suitable terrain.NTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.NTSB SEA93LA044Accident · No injuriesLimited investigationFinal reportCessna 414A · Rexburg, IDThe pilot did not select the remaining fuel supply. Factors include a deteriorated fuel selector valve.NTSB NYC93LA048Accident · No injuriesLimited investigationFinal reportCessna 182 · Readington, NJThe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice.NTSB MIA93FA031Accident · 5 fatalField investigationFinal reportBeech 65 · Orlando, FLThe pilot's failure to feather the propeller to maintain altitude following a loss of power of the left engine. The power loss was due to an improperly maintained fuel system. In addition, the right engine lost power for an undetermined reason(s).NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB LAX93LA069Accident · 1 fatalLimited investigationFinal reportLydick LONG-EZ · Tucson, AZThe pilot's failure to maintain an airspeed or power setting sufficient to maintain engine rotation during the low speed demonstration. A factor in the accident was the insufficient altitude to affect an engine restart once the propeller stopped turning.NTSB ATL93LA035Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Savannah, GAThe pilot's poor preflight and inflight planning.NTSB NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.NTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.NTSB BFO93LA015Accident · No injuriesLimited investigationFinal reportMooney M20K · Orange, VAWater contamination in the fuel, and inadequate preflight inspection.NTSB FTW93LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Tryon, OKPower loss due to fuel starvation and the pilots improper selection of the off position on the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB LAX93GA053Accident · No injuriesFinal reportCessna 404 · Tucson, AZThe pilot's inflight decision to deviate from the airplane's engine manual and the pilot's operating handbook by maintaining the fuel mixture at full rich throughout the mission and rapidly descending the airplane which resulted in both engine's losing total…NTSB FTW93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Orleans, LALoss of engine power due to fuel exhaustion. Factors were the inaccurate fuel consumption calculations and the unsuitable terrain.NTSB FTW93LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hamlin, TXThe pilot's failure to switch fuel tanks and his failure to perform the prescribed emergency procedures following the fuel starvation induced engine failure. A factor was the lack of suitable terrain for the emergency landing.NTSB ATL93LA027Accident · No injuriesLimited investigationFinal reportMooney M20D · Darien, GAThe pilot's inadequate in-flight planning which resulted in fuel exhaustion. Factors were fog and the pilot's failure to use available en route weather sources.NTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.NTSB LAX93LA037Accident · 1 fatalLimited investigationFinal reportCessna TU206G · Ruby, AZFuel exhaustion due to inaccurate preflight planning.NTSB CHI93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Marshall, ILAn inadequate preflight inspection of the airplane by the pilot.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB FTW93LA034Accident · No injuriesLimited investigationFinal reportTodd Goudeau KR-2 · San Marcos, TXPower loss due to carburetor icing. Factors were the unsuitable landing area and no carburetor deice system installed on the powerplant.NTSB MIA93LA014Accident · Minor injuriesLimited investigationFinal reportBell 47-G3-B1 · Palm Beach, FLThe pilot's inadequate preflight planning. A factor was the pilot's failure to maintain rotor RPM during the autorotation.NTSB ATL93LA018Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnson City, TNThe pilot's improper management of the fuel system.NTSB ATL93FA016Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Snow Hill, NCThe pilot's failure to use carburetor heat, which resulted in loss of engine power. Factors were the carburetor icing conditions, and the dark night lighting conditions.NTSB FTW93LA023Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hillsboro, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB NYC93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Great Barrington, MAThe inadequate pre-flight by the pilot ensuring fuel cap security. A factor in this accident was the pilots complacency in fuel management.NTSB NYC93LA027Accident · No injuriesLimited investigationFinal reportCessna 177 · Morgantown, WVThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing on a highway.NTSB ATL93LA014Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Cumming, GAThe pilot's failure to use the fuel boost pump when the engine malfunctioned during take off.NTSB NYC93LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Petersham, MAThe imprpoer maintenance procedures which resulted in engine failure and subsequent forced landing on unsuitable terrain.NTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.NTSB FTW93LA013Accident · Minor injuriesLimited investigationFinal reportBeech V35E · Laguna, NMFailure of the pilot to select the proper fuel tank and resultant fuel starvation power loss. A factor was the unsuitable terrain.NTSB CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB FTW93FA008Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Chatham, LAThe inadvertent stall and spin. Factors were the power loss due to fuel starvation, the dark night, and his failure to use the boost pump for engine restart.NTSB ATL93LA010Accident · No injuriesLimited investigationFinal reportCessna 172P · Buford, GAFuel exhaustion due to the pilot's inadequate inflight planning.NTSB NYC93LA008Accident · No injuriesLimited investigationFinal reportCessna 152 II · Milford, NHThe instructor pilots improper in-flight planning, and his failure to maintain a proper glide path to the forced landing area. A factor in this accident was the instructor's decision to shut down the engine during a 'simulated' engine failure .NTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).NTSB NYC93LA006Accident · Minor injuriesLimited investigationFinal reportSmitrovich SE-5A Replica · Harwinton, CTA forced landing in unsuitable terrain, following a power loss due to fuel exhaution. Factors related to the accident were the failure of the pilot to refuel the airplane prior to departure and his improper fuel consumption calculations which led to fuel…NTSB CHI93LA004Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mountain, WIThe pilot's failure to refuel the airplane.NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB ATL93LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Aliceville, ALMaintenance personnel's failure to properly secure the fuel line from the fuel pump to the fuel injector during the engine installation, which resulted in a complete engine failure.NTSB ANC93LA001Accident · No injuriesLimited investigationFinal reportChampion 7EC · Eureka, AKThe pilot-in command's inadequate preflight inspection which resulted in a power loss due to ice in the fuel system.