NTSB investigations, SD
24 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 2 |
| 2006 | 1 |
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\" = 'SD' 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" = 'SD' 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 CHI06FA067Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Pierre, SDThe loss of engine power during takeoff-initial climb due to the pilot's failure to correctly position the fuel selector, which resulted in fuel starvation and a forced landing.NTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB CHI04CA091Accident · No injuriesData collectionFinal reportCessna C-180 · Aberdeen, SDThe pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…NTSB CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.NTSB CHI99FA089Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Belle Fourche, SDinadequate preflight planning/preparation, refueling not performed, and aircraft control not maintained by the pilot. The inadvertent stall by the pilot was an additional cause. Fuel exhaustion was a contributing factor.NTSB CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.NTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.NTSB CHI95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Clark, SDthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's excessive braking.NTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.NTSB CHI91DTK03Accident · 1 fatalFinal reportWag-Aero Super Cuby · Roscoe, SDThe pilot's inadvertent stall and inadequate remedial action. Associated factors are the pilot's lack of recent total experience and inadequate preflight planning/preparation.NTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.NTSB CHI90LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, SDThe pilot in command's improper in flight planning which resulted in fuel exhaustion and a forced landing in a field at which time the aircraft nosed over.NTSB DEN88FA186Accident · 2 fatalField investigationFinal reportLuscombe 8A · Dimock, SDThe plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked…NTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…NTSB DEN86LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Pierre, SDPlt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to…NTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…NTSB DEN85FTK03Accident · No injuriesFinal reportCessna 152 · Tea, SDThe student & instructor plt (CFI) were practicing landings. After making 3 touch-&-go landings, the eng lost power at aprx 200 ft AGL as they were on their 4th takeoff. The CFI reported that he turned the acft about 25 deg in an attempt to glide to a bean…NTSB DEN85LA073Accident · No injuriesLimited investigationFinal reportCessna 180A · Sioux, SDAcft departed winnepeg at 1035 and landed at grand forks, ND, at 1150. Departed grand forks, ND, at 1305 and the accident occurred at 1524. 4 miles nw of Sioux falls, SD, the plt reported a rough running engine which subsequently quit. A forced landing was…NTSB DEN85LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Alexandria, SDThe acft made a forced landing in a plowed field after the engine failed. The plt reported that during cruise flt he heard a faint knock from the engine compartment. He reduced power and called fss. Almost immediately the engine began to vibrate. The plt…NTSB DEN84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Redfield, SDThe pilot reported he exhausted his fuel supply while engaged in aerial application. The power loss occurred as the aircraft was in a turn and ground impact occurred. In an accident report, the plt suggested that he should have had an operable fuel gage &…NTSB DEN83FTK04Accident · Serious injuriesFinal reportPiper PA-28-181 · Box Elder, SDBefore reaching his destination, the plt contacted apch control & reported that he was about 40 mi away & was low on fuel. About 10 min later, the acft ran out of fuel. The plt stated that he 'could possibly make ellsworth' but the controller told him that…NTSB DEN83LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Brandt, SDThe acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…NTSB DEN83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Red Owl, SDBefore the flt the student pilot had checked the fuel by the gages only and had not drained the fuel sumps. He thought he had enough fuel to fly from the ranch to the training school arpt to refuel. The engine quit at 100 ft AGL after takeoff. About 1-1/2…NTSB DEN82DA173Accident · No injuriesFinal reportCessna A188B · Britton, SDWhen the pilot departed to spray the last field for that day, he estimated that he had 19 to 20 gallons of fuel remaining. He figured it would take about 16 to 17 gallons of fuel to complete the job. About 1 hr later, as he was returning to land, the engine…