Skip to content

NTSB investigations, OK

17 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

Query with SQL

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" = 354) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 354)
  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" = 354)
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 DFW06LA191Accident · No injuriesLimited investigationFinal reportCessna R182 · McAlester, OKThe in-flight fuel leak and fire as result of electrical arcing of a fuel line connecting the engine driven fuel pump and the electric fuel pump.Jul 25, 2006 · N7364T · Destroyed NTSB DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.Nov 23, 2005 · N859DA · Substantial damage NTSB FTW04LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Claremore, OKThe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain for the forced landing.Feb 22, 2004 · N30408 · Substantial damage NTSB FTW01LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKthe pilot's delay in switching the fuel selector, which resulted in fuel starvation in cruise flight.Feb 12, 2001 · N2457Q · Substantial damage NTSB FTW01LA027Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Antlers, OKthe loss of engine power resulting from carburetor icing conditions.Nov 25, 2000 · N45537 · Substantial damage NTSB FTW00LA194Accident · No injuriesLimited investigationFinal reportMooney M20R · Talihina, OKthe partial loss of engine power on takeoff, which resulted from incorrect adjustment of the fuel injector system by maintenance personnel.Jun 28, 2000 · N22166 · Substantial damage NTSB FTW98LA162Accident · Minor injuriesLimited investigationFinal reportCarter LONG-EZ · Lebanon, OKThe pilot's inadequate compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the tailwind and the pilot's failure to adequately preflight the airplane which resulted in a partial loss of engine power due to…Mar 28, 1998 · N83LE · Substantial damage NTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.Mar 10, 1997 · N65753 · Substantial damage NTSB FTW94FA074Accident · 1 fatalField investigationFinal reportAeronca 7AC · Tulsa, OKWas the inadvertent stall. Factors were the pilots failure to use carburetor heat when weather conditions existed that were conducive to carburetor icing, and his abrupt maneuver to avoid a light pole.Jan 25, 1994 · N84212 · Substantial damage NTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.Jul 3, 1992 · N4957P · Substantial damage NTSB FTW90DPJ10Accident · No injuriesFinal reportHomebuilt Midget Mustang M1 · Bristow, OKFuel starvation induced power loss, a compromised fuel vent system, and improper installation of the plumbing in the fuel vent system.Aug 3, 1990 · N40PW · Substantial damage NTSB FTW90LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Glencoe, OKThe power loss due to carburetor ice, which resulted from the pilot's failure to engage carburetor heat in a timely manner. A factor in this accident was the pilot's lack of total experience.Jan 6, 1990 · N5414P · Substantial damage NTSB FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…Dec 29, 1987 · N94546 · Substantial damage NTSB FTW88LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Mangum, OKAccording to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that…Dec 2, 1987 · N3888V · Substantial damage NTSB FTW85LA303Accident · No injuriesLimited investigationFinal reportCessna 150M · Horntown, OKThe acft experienced an intermittent power loss in cruise flt. The plt's attempts to remedy the problem were not successful and he elected to execute a precautionary landing on a road. During the landing, the acft struck a wire and veered into trees along the…Aug 1, 1985 · N187AR · Destroyed NTSB FTW85LA177Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Rosston, OKPilot stated engine lost power during takeoff climb due to a leak in the air line from the engine bleed valve. He attempted to make a forced landing but upon touchdown, due to his forward movement, the aircraft nosed over.Apr 10, 1985 · N5073F · Destroyed NTSB FTW83LA309Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elk City, OKThe acft landed short of the rwy during a night landing following a x-country. The plt stated that he was on the approach to land and attempted to add power. The engine sputtered without an increase in power. The acft touched down 5 ft short of the rwy…Jun 30, 1983 · N93624 · Substantial damage