NTSB investigations, 1983
20 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 20 |
| 1984 | 14 |
| 1985 | 10 |
| 1986 | 10 |
| 1987 | 8 |
| 1988 | 6 |
| 1989 | 5 |
| 1990 | 8 |
| 1991 | 7 |
| 1992 | 4 |
| 1993 | 11 |
| 1994 | 13 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 6 |
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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983 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 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…