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 CHI84LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · East St. Louis, ILThe pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the…NTSB FTW84LA105Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Vermillion 255bWhile waiting for passengers to board the helicopter the plt heard and felt something hit the tail rotor. The eng was immediately shut down and it was revealed that a passenger had walked into the tail rotor. The passenger was was well experienced in…NTSB MKC84FA046Accident · Serious injuriesField investigationFinal reportCessna 182G · Olathe, KSThe plt was struck on the leg by the acft propeller as he pulled the propeller through during preflight. The eng had been preheated in an enclosed hanger due to the frigid temperatures. The plt stated he primed the engine and put the keyin the ignition prior…NTSB ATL84LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Spartanburg, SCThe acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.NTSB DEN84LA034Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Helena, MTThe acft propeller struck a passenger who was attemping to sweep snow off the acft. The plt's and passenger's version of mishap vary. The plt stated he instructed the passenger to stay away from the acft. The passenger stated the plt toldhim to sweep the snow…NTSB DEN84LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Yankton, SDThe plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…NTSB DEN84LA050Accident · Serious injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Richfield, UTThe acft propeller struck a 12 year old male passenger after he deplaned. The accident occurred on an unlighted ramp at about 1930 hours MST. The boy had walked forward along the fuselage to look into the cockpit when he was hit. His father was in the…NTSB LAX84LA044Accident · 1 fatalLimited investigationFinal reportCessna TU206G · Reno, NVThe pilot's body was found under the front of the acft by the propeller. All cockpit controls were in the start positionand the acft was not chocked or tied down. The payroll checks the pilot was to deliver were found in the acft.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 MIA83LA229Accident · 1 fatalLimited investigationFinal reportCessna 172I · Miami, FLThe acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…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 CHI83LA372Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Wheeling, ILThe plt was unable to start the eng using normal procedures. He obtained the use of an APU & still could not make an electrical start. He stated that he turned the magneto & master switches off & rotated the propeller (prop) backwards 1/2 turn (to check for…NTSB ATL83LKW02Accident · Serious injuriesFinal reportCessna 152 · Nashville, TNThe acft propeller struck a deplaned female passenger as she proceeded to the front of the acft prior to engine shutdown. The plt stated that his attention was primarily on the fact that the idle RPM seemed high to him and he failed to note his passenger exit…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 SEA83LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150-J · Connell, WAThe plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop.NTSB NYC83LNA03Accident · Serious injuriesFinal reportCessna 150 · Stow, MAThe acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut…NTSB FTW83LA177Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Mckinney, TXThree observers accompanied the aircrew & other passengers on a flt to transport skydivers aloft. Prior to the flt, all 3 of the observers were briefed not to exit the acft until the engines were secured. However, 1 of the 3 discussed the need to move a…NTSB MKC83FA072Accident · Serious injuriesField investigationFinal reportSwearingen SA 226TC · St. Louis, MORotating right prop struck a female child passenger who had run down the acft airstair to retrieve a doll she had dropped while climbing the airstair to board for the flt. A company attendant was stationed at the left (stopped) prop, but not on or near the…NTSB MKC83FA061Accident · Serious injuriesField investigationFinal reportBeech M35 · Cedar Rapids, IAThe acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through…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 ANC83IA007Incident · No injuriesIncident investigationFinal reportde Havilland DHC-3 · Homer, AKAfter removing the floats and reinstalling the wheels on the aircraft, the pilot received permission to take off on a roadway bridge thats spans beluga lake. The purpose of the flight was to ferry the plane to nearby Homer airport. On takeoff, the aircraft…NTSB NYC82FA230Accident · 1 fatalField investigationFinal reportBell 222 · New York, NYThe helicopter (hel) was being loaded with the engines running. The flt crew were at the ctls when the acdnt occurred. Initially, 4 paxs were escorted to the hel by a customer svc agent. As the 4 boarded, the agent retrieved their carry on baggage. Aft they…NTSB SEA82DA165Accident · 1 fatalFinal reportPiper PA-28-180C · Renton, WAPilot parked aircraft with engine running to discharge passenger. Passenger jumped off right wing into prop.NTSB FTW82DRA26Accident · Serious injuriesFinal reportCessna 150 · Friendswood, TXThe pilot of N150WM was giving free rides to guests. He taxied to the active runway after a landing and discharged a passenger. A female passenger walked out to the airplane to get in but due to the fact she had previously rode, the pilot asked her to let…NTSB ANC82DAG48Accident · 1 fatalFinal reportMaule M-5 · Nera Kenai, AKThe passenger was struck by the propeller while he was attempting to assist in beaching the float plane. The pilot stated that as he beached the aircraft and was shutting down the engine, the passenger (contrary to repeated instructions) exited the cabin.…NTSB FTW82FRA25Accident · Serious injuriesFinal reportCessna 177RG · Houston, TXAfter returning from a short cross-country, the pilot taxied to his parking spot. His car was park on one side of the aircraft's parking spot and another car was on the opposite side. The pilot's wife deplaned to move his car while the aircraft engine was…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.NTSB LAX82DA147Accident · 1 fatalFinal reportS.N.I.A.S. AS350 · Gold Strike, NVThe helicopter had just returned from a sightseeing tour of the grand canyon. The pilot reported that the passengers wanted to get out while the helicopter was undergoing its two-minute, cool-down period. The pilot escorted four of the passengers from the…NTSB CHI82DA111Accident · Serious injuriesFinal reportBeech 95 · Pontiac, MIIt was dark and the temperature was about 20 degrees when the pilot and two passengers arrived at the plane. The pilot had started the right engine before the passengers arrived, but the left engine failed to start in the cold temperature. The pilot was…NTSB CHI82DA079Accident · Serious injuriesFinal reportMooney M20J · Crystal, MNWhile attempting to start the eng, the pilot could not get the starter to engage. He asked the passenger to get out and rotate the propeller to a different location in hopes of getting the starter to engage. With the magnetos and master switch off, the prop…NTSB FTW82DA076Accident · Serious injuriesFinal reportBell 12 · Mustang Blk A11While the helicopter was at flight idle waiting for the next load of passengers to board, a passenger, who had been trained in helicopter safety, walked into the rotor blades. The passenger was attempting to pass behind the tail rotor when he was struck in…