NTSB investigations, SD
14 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 2004 | 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\" = 351)
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" = 351) 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 CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.NTSB CHI97LA004Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Nunda, SDfailure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.NTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.NTSB CHI94DTK02Accident · No injuriesFinal reportAyres S2R · Letcher, SDthe loss of engine power due to the failure of the engine driven fuel pump and shaft.NTSB DEN90FA055Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rapid City, SDFailure of the pilot to maintain adequate airspeed (VMC), which resulted in a loss of aircraft control. A factor related to the accident was: fatigue failure of a coupling shaft in the #1 engine, which resulted in loss of power in that engine.NTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.NTSB DEN88LA180Accident · No injuriesLimited investigationFinal reportBell 206B · Sturgis, SDThe plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump…NTSB DEN88LA145Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58J · Sioux Falls, SDN62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…NTSB DEN86FTK03Accident · 1 fatalFinal reportPiper PA-25 · Badger, SDThe acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…NTSB DEN84LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chamerlain, SDThe pilot experienced an engine failure and executed an emergency landing on a narrow road which resulted in one of the landing gear touching down on the soft shoulder. The landing gear failed and substantial damage resulted. Examination of the engine…NTSB DEN84LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Murdo, SDThe pilot reported the engine failed while he was in a procedure turn. The pilot made a forced landing in an open field and the acft nosed over. Examination of the engine after the accident revealed the engine 'swallowed an exhaust valve' that caused the…NTSB DEN84FU006Accident · 1 fatalFinal reportWeedhopper B · Beresford, SDThe ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were…NTSB DEN83LA165Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Interior, SDWhile on a sight-seeing flt over a park, the plt heard a loud noise & the helicopter shuddered & lost power. At that time, the acft was over a canyon, so the plt looked for the flatest area to land & began an autorotation. During the landing, the helicopter…NTSB DEN82FTK04Accident · No injuriesFinal reportCallair A-9B · Sioux Falls, SDThe eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.