NTSB investigations, SC
19 cases where NTSB found Maintenance.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 3 |
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\", '020620'))
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", '020620')) 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 ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.NTSB ERA23LA289Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Anderson, SCThe mechanics’ improper torquing of the main rotor blade dampers, which resulted in a ground resonance event during 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 ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB ERA19TA216Accident · No injuriesClass 3Final reportCessna 180 · Pickens, SCMaintenance personnel’s improper installation of the right main landing gear brake assembly, which resulted in the loss of control during landing.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 ERA17LA235Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Greenwood, SCThe pilots' inadequate preflight inspection, during which they failed to adequately verify the quantity of fuel, which resulted in fuel exhaustion, a subsequent total loss of power to both engines, and a forced landing into trees. Contributing to the accident…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 ERA14CA210Accident · Minor injuriesData collectionFinal reportJerome A Baak CH 601XL · Sumter, SCThe total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.NTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.NTSB ERA14FA049Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Graniteville, SCThe pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…NTSB ERA13LA410Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Woodrow, SCA failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.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 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 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 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 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.