NTSB investigations, SC
45 cases where NTSB found Aircraft power plant.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 7 |
| 2023 | 2 |
| 2024 | 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\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0105'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0105')) 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 ERA25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportJames A Gray Just Aircraft Highlander · Fountain Inn, SCA total loss of engine power for undetermined reasons.NTSB ERA24LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172K · Spartanburg, SCMaintenance personnel’s failure to follow the engine manufacturer’s maintenance guidance, which resulted in the assembly of the engine with an obstructed oil passage, a subsequent lack of lubrication to the front main bearing, and a total loss of engine power.NTSB ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.NTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.NTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…NTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.NTSB ERA22LA333Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Batesburg, SCThe fatigue failure of the crankshaft gear, resulting in a total loss of engine power.NTSB ERA22LA216Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA1 · Seneca, SCA dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.NTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.NTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.NTSB ERA20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportJust JA 30 Superstol · Clover, SCThe separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.NTSB ERA19LA143Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Edgefield, SCThe total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.NTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.NTSB ERA19LA029Accident · No injuriesLimited investigationFinal reportDiamond DA20 · Mountain Rest, SCA partial loss of engine power due to multiple discrepancies of the engine's ignition system.NTSB ERA17LA257Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Myrtle Beach, SCA loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…NTSB ERA16LA331Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Camden, SCA total loss of engine power due to the improper torqueing of the magneto, which led it to its malfunctioning in flight.NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB ERA15LA062Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Hampton, SCThe pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…NTSB ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.NTSB DCA12IA114Incident · No injuriesIncident investigationFinal reportBoeing 787 · Charleston, SCThe separation of the fan mid shaft resulted from environmentally assisted cracking under static load. Contributing to the incident was the combination of dry film lubricant applied to the fan mid-shaft and graphite grease used during assembly which made the…NTSB ERA12LA473Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Pickens, SCA total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.NTSB ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.NTSB ERA12LA267Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eastover, SCInadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…NTSB ERA12CA179Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · N. Charleston, SCThe flight instructor’s failure to apply power during a practice autorotation in order to arrest a high rate of descent, which resulted in an in-flight collision with terrain.NTSB ERA11CA373Accident · No injuriesData collectionFinal reportLeatherman Karl L Zodiac CH 601 HDS · Gray Court, SCThe total loss of engine power due to the failure of the radiator coolant supply fitting.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.NTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.NTSB ERA10LA383Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Holly Hill, SCMaintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.NTSB ERA10LA316Accident · Minor injuriesLimited investigationFinal reportMcculloch Jerry RV-4 · Pageland, SCMaintenance personnel’s improper installation and inspection of the crankshaft idler gear, which resulted in a loss of engine power.NTSB ERA10LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Moore, SCThe certificated mechanic's improper installation of a helicoil, which resulted in the separation of a sparkplug and the helicoil and led to a partial loss of engine power.NTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.NTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.NTSB ERA10LA023Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Winnsboro, SCThe flight instructor's failure to monitor the simulated emergency procedure, resulting in a hard landing. Contributing to the accident was the intentional throttle application by one of the flightcrew.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.NTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.NTSB CHI08LA162Accident · No injuriesLimited investigationFinal reportCessna 150L · Summerville, SCA total loss of engine power for undetermined reasons.NTSB NYC08LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCA loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…NTSB CHI08LA125Accident · Serious injuriesLimited investigationFinal reportRans S-12 XL · Pelion, SCA loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.