NTSB investigations, CA
36 cases where the first occurrence was “Roll over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 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\" = 'CA' 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" = 'CA' 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 LAX07CA041Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Tulare, CAThe student pilot's improper use of the collective and cyclic control, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…NTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.NTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.NTSB LAX05CA095Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lake Arrowhead, CAthe certified flight instructor's failure to adequately compensate for wind conditions and his selection of terrain unsuitable for a safe takeoff which resulted in a dynamic rollover.NTSB LAX04CA146Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAthe student pilot's improper use of the cyclic control and the certified flight instructor's inadequate supervision, which resulted in a rollover.NTSB LAX02LA149Accident · No injuriesLimited investigationFinal reportSierra RAF 2000 GTX-SE · Lompoc, CAThe pilot's failure to compensate for wind condition.NTSB LAX01LA227Accident · No injuriesLimited investigationFinal reportBell 206B · Salinas, CAthe student's improper use of the cyclic controls and his failure to relinquish aircraft control, and the flight instructor's inadequate supervision.NTSB LAX01LA190Accident · No injuriesLimited investigationFinal reportRobinson R22B · Murietta, CAThe solo student's improper use of the flight controls that resulted in a dynamic rollover during the attempted takeoff.NTSB LAX01LA156Accident · No injuriesLimited investigationFinal reportRobinson R22 beta · Fortuna, CAThe student's improper procedure during a practice emergency that exceeded the instructor's reaction capability.NTSB LAX01LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAThe dual student's improper use of the collective and the flight instructor's inadequate supervision during the practice hovering autorotation maneuver. A factor was the underlying soft dirt terrain, which promoted the rollover event.NTSB LAX00LA016Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Soda Springs, CAThe failure of the pilot-in-command to maintain landing skid clearance during hover taxi, which resulted in a dynamic rollover.NTSB LAX98LA249Accident · No injuriesLimited investigationFinal reportBell 222B · Tranquility, CAThe pilot's delayed initiation of a go-around when the severity of the dust condition first became apparent. Contributing factors were dark night conditions and the obscuration from the dust.NTSB LAX98LA170Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Luis Obispo, CAThe flight instructor's inadequate compensation for wind conditions, and his failure to maintain aircraft control. Contributing was wind gusts.NTSB LAX98LA083Accident · No injuriesLimited investigationFinal reportRobinson R22 · Oxnard, CAThe pilot's improper use of the collective during the initiation of the rollover, which prevented the recovery from the condition.NTSB LAX97LA317Accident · Minor injuriesLimited investigationFinal reportBell 206B · Napa, CAFailure of the pilot to perform an adequate preflight, which resulted in him failing to notice and release the tie down chains.NTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.NTSB LAX95LA271Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Redlands, CAThe company's maintenance personnel improper servicing of the landing skid actuators.NTSB LAX95LA174Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Long Beach, CAthe pilot's misjudged landing flare. A factor in the accident was the illusion of a lower than actual altitude created by the high vegetation which led the pilot to flare early.NTSB LAX95LA136Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Van Nuys, CAthe operation of the helicopter with improper adjustment of the landing gear and main rotor dampers due to the inadequate maintenance inspection of the helicopter by maintenance personnel and an inadequate preflight inspection by the pilot.NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.NTSB LAX94LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sacramento, CAImproper remedial action by the student pilot. Lack of total experience is a factor.NTSB LAX92LA245Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Hanford, CAThe pilot's failure to maintain rotor RPM during the takeoff. Contributing factors were: the pilot's lack of familiarity with the aircraft and unfavorable winds that existed at the time of takeoff.NTSB LAX92LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe pilot's inadequate compensation for wind conditions, his failure to arrest the descent rate in a timely fashion, and the selection of unsuitable terrain on which to practice autorotations.NTSB LAX92LA114Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · San Ardo, CAThe pilot's decision to land in a plowed field made soft from winter rain shower activity.NTSB LAX91LA407Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Livermore, CA1) Incorrect control input by the student pilot and 2) the flight instructor's inadequate supervision of his student. A contributing factor in this accident was the unfavorable wind conditions.NTSB LAX91LA307Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · El Cerrito, CAThe instructor pilot's improper slope takeoff technique.NTSB LAX90LA303Accident · No injuriesLimited investigationFinal reportHughes 369D · Santa Monica, CAThe pilot's decision to exit the helicopter with the engine running and no one at the controls.NTSB LAX90LA210Accident · No injuriesLimited investigationFinal reportHughes 269B · Paso Robles, CAThis accident was dynamic rollover due to the terrain slope exceeding the capability of the helicopter.NTSB LAX90LA186Accident · Minor injuriesLimited investigationFinal reportHughes 269A · La Verne, CAGround resonance due to an inadequately maintained strut.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB LAX90LA091Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corona, CAHelicopter rolling over in a dirt field after the pilot was demonstrating an engine faiure and autorotation maneuver.NTSB LAX88FA085Accident · 1 fatalField investigationFinal reportBell 47G-2A1 · San Diego, CAPilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.NTSB LAX86FUG04Accident · No injuriesFinal reportRotorway Scorpion 133 · Corona, CAThe plt stated he was 'running up the engine' after making some adjustments. The helicopter was tied down when the plt lifted off to a 5 to 6 ft hover. The helicopter tipped to the right, the main rotor blades contacted the terrain and the helicopter rolled…NTSB LAX84LA173Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Riverside, CAThe acc occurred when the prospective buyer plt started to pick up the rotorcraft with too much aft cyclic. The rt rear skid dug into the ground and the acft rolled over.NTSB LAX82FA343Accident · Serious injuriesField investigationFinal reportHughes 269C · North Highlands, CAThe purpose of the flight was to conduct a rotorcraft/helicopter certified flight instructor (CFI) check ride for the pilot-in-command (PIC). The check pilot was an FAA inspector with no previous flight time in this make and model; however, he had 1816 hrs…