NTSB investigations, OK
97 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 2 |
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\" = 'OK' 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\" = 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 c."eventStateOrRegion" = 'OK' 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" = 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 SEA07CA105Accident · No injuriesData collectionFinal reportCessna 150E · Shawnee, OKThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.NTSB DFW07LA080Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Ponca City, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA131Accident · No injuriesData collectionFinal reportCessna 150M · Ardmore, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA051Accident · Minor injuriesData collectionFinal reportCessna 177 · Antlers, OKThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight planning. A contributing factor was the encounter with windshear during the forced landing.NTSB DFW06CA045Accident · Minor injuriesData collectionFinal reportCessna 150L · Tulsa, OKThe pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA061Accident · Minor injuriesData collectionFinal reportMaule M-4-210C · McAlister, OKThe loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…NTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB FTW03LA167Accident · No injuriesLimited investigationFinal reportManweiler Acro Sport II · Bartlesville, OKThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion. A related factor was the lack of suitable terrain.NTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.NTSB FTW01TA084Accident · No injuriesFinal reportCessna 152 · Antlers, OKfuel exhaustion in cruise flight due to the pilot's delay in refueling. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA074Accident · No injuriesLimited investigationFinal reportCessna 182P · Tuttle, OKfuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA263Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKThe pilot's improper setting of the cockpit fuel selector, which resulted in a total loss of engine power and forced landing.NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA154Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Mcalester, OKThe pilot inadvertently stalling the airplane while attempting to avoid power lines. Factors were the loss of power on both the left and right engines as a result of water contamination in the fuel system, the pilot's inadequate preflight procedures, and the…NTSB FTW99LA010Accident · No injuriesLimited investigationFinal reportMooney M20A · Oklahoma City, OKThe loss of engine power due to fuel starvation as result of the pilot's improper placement of the fuel tank selector switch. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW98LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fairview, OKLoss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.NTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.NTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.NTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…NTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.NTSB FTW97LA064Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Muskogee, OKthe pilot's improper planning/decision and inaccurate fuel consumption calculations, which resulted in an inadequate supply of fuel, fuel exhaustion, and a subsequent forced landing at night. Darkness was a related factor.NTSB FTW97LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tulsa, OKFuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA326Accident · No injuriesLimited investigationFinal reportRockwell International S2R · Tahlequah, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Hobart, OKthe pilot became lost/disoriented, and failed to properly use information that was provided by ATC, which resulted in fuel exhaustion and an encounter with soft terrain during an emergency landing. A factor relating to the accident was: the lack of suitable…NTSB FTW96LA249Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · Tulsa, OKthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Darkness was a related factor.NTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…NTSB FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA068Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Collinsville, OKThe pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.NTSB FTW96LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Oklahoma City, OKThe student pilot's failure to use carburetor heat resulting in loss of engine power due to carburetor icing. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Guthrie, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA175Accident · No injuriesLimited investigationFinal reportBriggs Glasair III · Crescent, OKTotal non-mechanical power loss due to a fuel system vapor lock. A factor was the uneven terrain on which the forced landing was made.NTSB FTW95LA107Accident · No injuriesLimited investigationFinal reportCessna 150F · Commerce, OKFuel exhaustion as a result of the pilot failing to perform an adequate preflight inspection of the airplane. The lack of suitable terrain on which to make a forced landing was a factor.NTSB FTW95LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oklahoma City, OKThe loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.NTSB FTW95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Haskell, OKThe total loss of engine power due to contaminated fuel. Factors were the improper maintenance procedures resulting in fuel contamination, the pilot's inadequate preflight inspection, and the lack of suitable terrain available for the forced landing.NTSB FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.NTSB FTW94LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Tulsa, OKLoss of engine power following fuel starvation caused by improper tank selection by the pilot. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA094Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Duncan, OKThe pilot's selection of the wrong engine for shut down. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA083Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Ardmore, OKPilot's failure to refuel and fuel exhaustion. Factors were a fuel leak in the wing and unsuitable terrainNTSB 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 FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.NTSB DEN91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKPower loss due to fuel exhaustion and the pilot's failure to refuel. A factor was: the rough uneven terrain.