NTSB investigations, CA
22 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 2003 | 3 |
| 2006 | 1 |
| 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\" = 370)
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" = 370) 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 LAX07CA214Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Clarksburg, CAThe pilot's inadequate hand-prop starting procedure and failure to secure the airplane.NTSB LAX06LA213Accident · 1 fatalLimited investigationFinal reportCessna T210M · Hayward, CAThe passenger's failure to see and avoid the rotating propeller.NTSB LAX04LA089Accident · 1 fatalLimited investigationFinal reportCessna 172L · Vacaville, CAthe pilot's inadequate hand prop starting procedure.NTSB LAX04LA045Accident · Serious injuriesLimited investigationFinal reportOMF OMF-100-160 · Van Nuys, CAthe pilot's failure to either brief the passenger about disembarking from an airplane with the propeller running or to shutdown the engine during the passenger's disembarkation. The night lighting condition and the passenger's lack of familiarity with…NTSB LAX03LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sacramento, CAthe pilot's inadequate preflight inspection and the bystander's failure to maintain clearance with the rotating propeller.NTSB LAX99LA019Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Fresno, CAThe pilot's decision to allow unescorted passengers to approach the aircraft with the engine running, and, the passenger's failure to see and avoid the rotating propeller. A factor in the accident was the low ambient lighting conditions, which would have made…NTSB LAX97LA262Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pollock Pines, CAthe passenger's failure to recognize and avoid the hazard associated with the rotating tail rotor. The operator/event organizer's lack of ground facilities or support personnel to assist/control passenger access to the helipad was a related factor.NTSB LAX94LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Sacramento, CAthe child's disregard for prescribed safety procedures which was compounded by the diminishing lighting conditions existing at the time, and her lack of familiarity with an aviation environment.NTSB LAX94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAA failure of the pilot-in-command to ensure that the powerplant controls were configured properly before moving the aircraft propeller. Inadequate planning/decision making was a factor in this accident.NTSB LAX92FA410Accident · 2 fatalField investigationFinal reportRobinson R22-B · Martinez, CAAn undetermined divergence of the main rotor from its normal plane of rotation which resulted in rotor contact to the fuselage and passenger.NTSB LAX90LA319Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Long Beach, CAThe pilot's inadequate passenger briefing, and his failure to provide proper assistance to the exiting passenger.NTSB LAX89LA127Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Malibu, CAThe failure of the passenger to follow briefed procedures and the failure of ground personnel to provide adequate assistance.NTSB LAX87LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · El Cajon, CAThe plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly…NTSB LAX85LA183Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Apple Valley, CAUpon landing & taxiing off the rwy the ATP certificated plt was unable to locate the desired acft hangar in which the acft was to be parked. The plt & his 15-year-OLD pax observed a bystander near their acft. The plt directed the pax to exit the acft & ask…NTSB LAX85FA091Accident · 1 fatalField investigationFinal reportBell 47G3B · San Diego, CAThe helicopter landed on the morred tuna boat. After toudhdown the helicopter appeared to be repositioning itself when the main rotor blades contacted the boom portion of a crane which was being utilized to load bags of salt aboard the boat.NTSB LAX84LA222Accident · Serious injuriesLimited investigationFinal reportVari EZE · Rancho, CAThe acft made a forced landing and collided with a ditch after propeller failure during climb after takeoff. The plt hadmade his propeller of fiberglass instead of recommended wood. This was the first flt with this propeller.NTSB LAX83LA459Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hawthorne, CAAfter landing at night, the plt taxied to an unlighted parking area & stopped. He stated that while he was looking for a parking space, his friends came out of the waiting room & 1 of them approached the right side of the acft. The plt said he saw his friend…NTSB LAX83FA444Accident · 1 fatalField investigationFinal reportCessna T210M · Santa Ana, CAAfter landing at night, the plt taxied to a non-illuminated ramp area & stopped to deplane the passenger, who held a student plt certificate. The purpose of the passenger deplaning in that area was for her to obtain a vehicle & meet the plt at the acft's…NTSB LAX83FA393Accident · 1 fatalField investigationFinal reportHughes 369HS · San Pedro, CAThe plt was on a mission to transport company personnel & had landed on a barge that was being used as a helipad. The barge was about 250 ft long & 75 ft wide. After arriving, the plt parked the helicopter with the tail boom as close to the edge of the barge…NTSB LAX83FUA04Accident · Serious injuriesFinal reportCessna 182 · Avalon Catalina, CAThe acft propeller struck the arm of a lineman who was assisting the plt to start the acft the plt stated that the propeller was turning slowly and he asked for help. The lineman requested that all switches be turned off and proceed toturn the propeller which…NTSB LAX83FA076Accident · 1 fatalField investigationFinal reportBeech C-99 · San Francisco, CAThe acft propeller struck a station agent who was assisting in the parking of the acft. After signaling the acft to stopthe agent placed her lighted wanes on the ramp and moved toward the stationary acft to get the wheel chocks. As she approached the chocks…NTSB LAX82DUG12Accident · Serious injuriesFinal reportSwearingen SA226-TC · Palm Springs, CAAfter starting the engines at night, a signal was given to a line service employee to disconnect the APU. While attempting to disconnect the APU, the line service employee moved into the path of the right propeller and was seriously injured.