NTSB investigations, TX
12 cases where the first occurrence was “Roll over”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 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\" = 380)
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" = 380) 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 DFW07CA096Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · Spring, TXThe student pilot's improper use of the flight controls resulting in dynamic rollover. Contributing factors were the delayed remedial action by the flight instructor and the uneven, muddy terrain conditions.NTSB FTW02LA268Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Del Rio, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the reported gusting wind conditions.NTSB FTW02LA080Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Encino, TXThe pilot's failure to maintain aircraft control during lift off from a transport trailer resulting in dynamic rollover of the helicopter.NTSB FTW01LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Damon, TXthe pilot's failure to maintain helicopter control during takeoff to a hover, which resulted in a dynamic rollover.NTSB FTW99LA048Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · San Angelo, TXthe rollover during take off for undetermined reasons.NTSB FTW96LA244Accident · No injuriesLimited investigationFinal reportHughes 269 · Dallas, TXThe student pilot's encounter with dynamic rollover while hovering. Factors were the prevailing high winds and the inadequate supervision provided by the flight instructor.NTSB FTW90LA061Accident · No injuriesLimited investigationFinal reportRobinson R22 · San Angelo, TXInadequate preflight by the pilot by not identifying and removing the tie-down.NTSB FTW89LA079Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Padre Island, TXThe pilot's decision to fly in adverse weather condition. The adverse weather was a related factor.NTSB FTW88LA073Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Decatur, TXThe non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…NTSB FTW84LA308Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Henderson, TXThe instructor plt stated that the student plt landed the helicopter. As the helicopter touched down and was still light on its skids the student applied left cyclic control and the helicopter started to roll towards the left. The student plt froze on the…NTSB FTW82DA381Accident · Minor injuriesFinal reportRobinson R-22 · Austin, TXDuring practice autorotation with power recovery student was late in applying power and aircraft touched down and rolled over. Instructor tried to recover but was also too late in application of remedial action.NTSB FTW82DA073Accident · No injuriesFinal reportBell 47G · Dallas, TXThe pilot attempted to land on a narrow flatbed trailer. He stated that he encountered some buffeting from the wind funneling between two hangars. On his third attempt to position the helicopter on the trailer, the right skid slipped off. The main rotor…