NTSB investigations, SC
16 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 3 |
| 2004 | 1 |
| 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\" = 'SC' 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\" = 352)
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" = 'SC' 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" = 352) 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 ATL06LA060Accident · Serious injuriesLimited investigationFinal reportJust Highlander · Walhalla, SCThe pilot and owner/builders failure to determine the reason for partial loss of engine power resulting in loss of engine power due to fuel system contamination on a subsequent flight.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB MIA98FA250Accident · 5 fatalField investigationFinal reportPiper Aerostar 600 · N. Myrtle Beach, SCThe pilot's failure to maintain airspeed (Vs) during a single engine approach resulting in an inadvertent stall. Factors contributing to the accident were a fatigue crack in the exhaust pipe in the right engine, the aircraft weight and balance was exceeded,…NTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…NTSB MIA98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Graniteville, SCfailure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.NTSB ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.NTSB ATL95LA134Accident · Minor injuriesLimited investigationFinal reportStafford Aerosport Scamp · Abbeville, SCThe improper engine overhaul which resulted in metal contamination of the engine assembly.NTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.NTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB ATL90LA159Accident · No injuriesLimited investigationFinal reportCessna 172 · Ridge Spring, SCThe failure of the maintenance facility/owner to follow standard preventive maintenance procedures. A factor was the pilot's failure to extend the flaps during the forced landing.NTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…NTSB ATL88FA211Accident · Serious injuriesField investigationFinal reportCessna 175 · Ninety Six, SCThe pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The…NTSB ATL88LA161Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Greenwood, SCThe plt reported that the engine RPM began to drop. Shortly after he took off from an open field. He opened the throttle further in an attempt to regain RPM but the engine did not respond. The helicopter subsequently crashed onto a bldg roof as the plt…NTSB ATL86LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Surfside Beach, SCDuring first banner tow of the day, plt reported that the eng lost power during initial climb after the banner was hooked. The banner was released and acft descended into trees 1 mile from the pick-up point. Inspection of the eng confirmed a magneto ignition…NTSB ATL83LA297Accident · No injuriesLimited investigationFinal reportHughes 269B · Summerville, SCThe helicopter was being used in controlled burning of timberland. While being operated at an alt of aprx 20 ft over wind rows of organic material, there was a partial loss of eng power. The plt stated that he was unable to maintain a hover, so he landed on…