NTSB investigations, TX
9 cases where the first occurrence was “Rotor failure/malfunction”.
Cases per year
| 1999 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 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\" = 'TX' 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\" = 132)
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" = 'TX' 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" = 132) 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 DFW07LA197Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Fort Stockton, TXThe failure of the v-belt drive system to the main rotor for undetermined reasons. Contributing to the accident was insufficient altitude to perform a successful autorotation.NTSB DFW06LA093Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Houston, TXThe failure by maintenance personnel to secure the tail rotor driveshaft cowling after performing maintenance which resulted in a loss of tail rotor control. A contributing factor was the pilot's improper preflight inspection of the tail rotor driveshaft area.NTSB DFW06CA055Accident · No injuriesData collectionFinal reportBell 47-B3 · Dennison, TXThe in-flight separation of the stabilizer bar tube.NTSB DFW05CA163Accident · No injuriesData collectionFinal reportCarterCopter CarterCopter · Olney, TXThe pilot's inability to maintain control of the gyrocraft during a forced landing as a result of a loss of cyclic and collective control. Contributing factors were the sheared propeller drive pulley bolts, broken wire on the co-pilots cyclic boost control…NTSB FTW04TA012Accident · Minor injuriesFinal reportHughes OH-6A · Eagle Pass, TXThe failure of the aft segment of the tail rotor drive shaft for undertermined reasons. A contibuting factor was the lack of suitable terrain for the foced landing.NTSB FTW03LA104Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kingsland, TXThe loss of tail rotor drive as a result of a blanket coming in contract with the tailrotor blades, after the aft cargo door was left unsecured. Contributing factors were the lack of suitable terrain for the forced landing, and the failure of the medical…NTSB FTW01LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Raymondville, TXthe failure of the main rotor drive belts while maneuvering which resulted in a loss of main rotor drive. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA105Accident · No injuriesLimited investigationFinal reportSchweizer 300C · New Ulm, TXThe pilot's inadequate in-flight evaluation of the landing area, which resulted in the separation of the main rotor system as a result of foreign object damage.NTSB FTW99FA192Accident · 3 fatalField investigationFinal reportMBB BK-117-B2 · Fresno, TXthe loss of control during approach due to the corrosion of the T-T strap which resulted in fatigue cracking and subsequent separation of the strap and main rotor blade from the helicopter.