NTSB investigations
9 cases where NTSB found Rotorcraft flight control, general.
Cases per year
| 2008 | 5 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2022 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01046700')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01046700')) 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 WPR22LA146Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Phoenix, AZThe pilot’s failure to maintain helicopter control while on the ground when his attention was diverted, which resulted in a dynamic rollover.NTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.NTSB WPR14CA006Accident · Minor injuriesData collectionFinal reportSiemens Rotorway Exec 162F · Nampa, IDA flight control malfunction during cruise flight for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.NTSB WPR12LA219Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Twin Falls, IDThe pilot's inability to maintain helicopter control during cruise flight due to the failure of the No. 2 main rotor Lamiflex bearing. Contributing to the accident was the pilot's decision to operate the helicopter with a known deficiency and the helicopter’s…NTSB ERA09CA045Accident · No injuriesData collectionFinal reportRandall Amanda Rotorway · Middletown, DEThe student pilot’s excessive use of cyclic during the engine run-up. Contributing to the accident were the student pilot’s lack of overall experience and the gusting wind conditions.NTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…NTSB DFW08TA066Accident · Minor injuriesFinal reportHughes OH-6 · Valentine, TXThe contract mechanic's failure to properly secure the castellated nut that attached the governor lever control rod to the idler bell crank. Contributing to the accident was the lack of maintenance oversight by the operator.NTSB SEA08CA059Accident · No injuriesData collectionFinal reportBell 206 B2 · La Verna, CAThe pilot's improper preflight planning which resulted in a jammed cyclic control while maneuvering.NTSB SEA08CA065Accident · No injuriesData collectionFinal reportRobinson R-22 · Riverside, CAThe pilot's misjudged landing flare and improper use of the collective control.