NTSB investigations
182 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases, newest first
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 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."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 CHI95LA231Accident · Serious injuriesLimited investigationFinal reportCessna 337H · Holland, MIthe passenger's improper decision to exit the airplane with the engine(s) running.NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.NTSB FTW95LA207Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe ground service person's lack of attention and failure to remain clear of the turning propeller.NTSB ATL95LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Smyrna, TNThe flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.NTSB FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.NTSB ANC95LA012Accident · 1 fatalLimited investigationFinal reportBell 206 · Juneau, AKThe employee's disregard for company training and policies about the dangers of helicopter rotor blades. The running aircraft with the rotors turning was a factor in the accident.NTSB LAX94LA376Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Las Vegas, NVthe pilot's failure to shut down the engine before deplaning a passenger.NTSB ATL94LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235B · Kill Devil Hill, NCThe pilot's failure to assure that the passenger did not exit the airplane while the propeller was still turning.NTSB MIA94LA190Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot-in-command's decision to intentionally exit the airplane with the engine running, and failure to maintain a clearance from the propeller. The improper aircraft preflight was a factor.NTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.NTSB FTW94LA180Accident · 1 fatalLimited investigationFinal reportCessna 182A · Roland, ARBoth the pilot and passenger's failure to follow procedure/directives.NTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB MIA94LA096Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Wimauma, FLThe failure of the person removing the chock to maintain sufficient clearance from the propeller. A contributing factor was the total lack of experience by person on ground.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 BFO94LA041Accident · 1 fatalLimited investigationFinal reportCessna 150 · Lima, OHThe failure of the passenger to maintain clerance from the propeller.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.NTSB BFO94LA002Accident · 1 fatalLimited investigationFinal reportFairchild SA 227-AC · Newark, NJ1) The failure of the ramp agent to follow proper procedures during the servicing of the airplane, and 2) her lack of attention to the hazards surrounding her. Factors related to the accident are 1) the pressure placed on the ramp agent to rush the servicing…NTSB MIA94LA009Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Fort Myers, FLImproper decision by the other person (pilot's mother) to go to the airplane, while the pilot was making checks in preparation for flight, and her failure to identify the hazardous condition (turning propeller).NTSB MIA94LA007Accident · 1 fatalLimited investigationFinal reportCessna 182-P · Orlando, FLThe pilot's improper procedures and his complacency during his attempts to start the engine.NTSB BFO93LA186Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Niagara Falls, NYThe pilot's failure to follow starting procedures and his inadequate preflight inspection by not removing the wheel chocks and the passenger not maintaining clearance from the propeller.NTSB ANC93LA171Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Ptarmigan Pass, AKThe pilot inadvertently walked into a turning propeller. Factors in the accident were the soft runway which mired the airplane and the pilot's diverted attention during the attempt to free the airplane.NTSB NYC93LA172Accident · 1 fatalLimited investigationFinal reportBellanca 7ECA · Ashland, NHThe pilot's improper decision to leave the airplane unattended with the engine operating.NTSB BFO93LA139Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12-65 · Sunappee, NHThe passenger's failure to follow proper procedures and inadequate supervision by the pilot.NTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.NTSB ANC93LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Gambell, AKIntentional personal injury. Factors in the accident were: the person's psychological condition, and the lack of sufficient procedures/airport staff by the operator(s).NTSB CHI93LA120Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Lee'S Summit, MOThe pilot's improper procedures during ground operations.NTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.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 MIA92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Panama City, FLThe pilot-in-command's failure to stand clear of the propeller as he rotated it by hand, resulting in the propeller rotating around due to engine compression, striking the pilot, causing him to lose his balance and fall to the ramp, resulting in serious…NTSB CHI92LA198Accident · 1 fatalLimited investigationFinal reportCessna 177B · Dwight, ILThe passenger's inattention to the propeller arc and the pilot's improper procedure in disembarking a passenger while the engine was running.NTSB ATL92LA034Accident · 1 fatalLimited investigationFinal reportCessna 177B · Memphis, TNThe passenger's failure to follow proper procedures to walk behind the airplane. Factors were the dawn light conditions and the light rain.NTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.NTSB NYC92LA028Accident · Serious injuriesLimited investigationFinal reportBeech C99 · Syracuse, NYThe failure of the co-pilot to remain clear of the rotating propeller due to diversion of attention.NTSB NYC92LA005Accident · 1 fatalLimited investigationFinal reportAerospatiale ATR-42-320 · Bridgeport, CTThe employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.NTSB FTW91LA163Accident · 1 fatalLimited investigationFinal reportChampion 7-GCB · Frankston, TXThe ground person did not understand the verbal instructions.NTSB CHI91LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · West Branch, MIThe pilot's failure to follow recommeded starting procedures/directives and precautions.NTSB LAX91LA147Accident · 1 fatalLimited investigationFinal reportde Havilland DHC6-300 · Nuuuli, AntarcticaThe inadequate lighting of the gate at the terminal and inadequate training of the security guard by company personnel. Contributing to this accident was a dark night condition.NTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.NTSB CHI91LA001Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE Jetstream 3201 · St. Louis, MOVisual outlook inadequate by the ground personnel. Contributing factors were lack of total experience in type of operation and a dusk light condition.NTSB SEA90LA192Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Troutdale, ORPassengers failure to maintain clearance from the turning propeller. A factor in the accident was his diverted attention to a helicopter on the ground nearby with the engine running.NTSB LAX90DJA03Accident · Serious injuriesFinal reportBell 206B · Oahu, HIThe passenger's failure to follow boarding instructions.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 CHI90DEM06Accident · Serious injuriesFinal reportFunk, D.D. B-85C · White Cloud, MIThe passengers disregard of the pilot's instructions and her failure to maintain clearance from the propeller.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB SEA90FA080Accident · 1 fatalField investigationFinal reportSwearingen SA226-T(B) · Coeur D'Alene, IDInadequate coordination between the pilot and the ground lineman. A factor related to the accident was: impairment of the ground lineman from consumption of alcohol.NTSB SEA90LA067Accident · Serious injuriesLimited investigationFinal reportBecker Bensen B8M · Burlington, WAThe pilot's failure to maintain clearance from the propeller.NTSB DEN90LA032Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Powderville, MTThe pilot in command left the airplane unattended with the engine running. That the pilot's son did not understand the unsafe condition is considered a contributing factor.NTSB FTW90LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Edmond, OKInadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).