NTSB investigations, SC
7 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2023 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '333' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '333' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB ERA18LA258Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Georgetown, SCA loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.NTSB ERA16LA030Accident · No injuriesLimited investigationFinal reportHughes 369D · Marion, SCA momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control.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 ERA09IA315Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Greenville, SCA pitch control malfunction for undetermined reasons.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.