NTSB investigations, 1985
10 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\") = 1985
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") = 1985 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 MKC86FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Kansas City, MOThe plt was seen to enter the acft for a short time and then get out, go to the front of the acft and pull down on the prop. The eng fired and the prop struck the pilot's head. A plt who approached the acft moments after the acdt looked into the cockpit and…NTSB CHI86FEM03Accident · 1 fatalFinal reportRobinson R22A · Grand Rapids, MIThe plt reported he flew into the wolverine power plant for the purpose of picking up a passenger to whom he was to demonstrate the helicopter's ability to survey power lines. He continued to report, shortly after landing during normal engine shut down…NTSB FTW85LA313Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Follett, TXThe passenger had deplaned to remove unnecessary articles from the aircraft and apparently was not cautioned by the PIC to be careful of the rotating propeller. As she returned to the aircraft to re-board she walked into the observed rotating propeller and…NTSB MKC85FA175Accident · Serious injuriesField investigationFinal reportCessna 150L · Lee'S Summit, MOThe plt discharged one passenger without stopping the eng & motioned to the next passenger (his wife) to come around from the front of the airplane. Subsequently, his wife walked into the propeller & received a serious injury to her arm.NTSB NYC85LA154Accident · Minor injuriesLimited investigationFinal reportMcCulloch J-2 · Cortland, NYAccording to the pilot, the rotor blade contacted the tail rudders because of insufficient rotor speed. The rotor bladeswere thrown out of track and the gyroplane lost control. The insufficient rotor RPM was due to a rotor or pulley belt stripping.NTSB CHI85FEX01Accident · Serious injuriesFinal reportCessna 404 · Indianapolis, INThe right prop struck a person who was loading freight onto the acft. The plt reported that he had started the right eng to bring it up to operating temp to deforst the windscreen. He stated the eng had been running for aprx 3 minutes when he felt something…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 BFO85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe student plt taxied the acft to the run-up area and stopped with the engine running. The passenger, a rated helicopter pilot, exited the airplane to retrieve a portable communications radio. According to the student, the passenger ducked under the wing…NTSB SEA85LA052Incident · No injuriesLimited investigationFinal reportCessna 337B · Ontario, ORPilots sister approched the rt side of the acft to speak to him. When leaving the side of the acft she walked into the front turning prop. Plt stated she had been around the acft numerous times and was aware of the engine configuration.NTSB NYC85FA052Accident · 1 fatalField investigationFinal reportHughes 500D · Newark, NJThe right front seat passenger deplaned and walked rearward to retreive his luggage from the left rear seat of the helicopter during the cooling down stage of the engine shutdown. After deplanning he proceeded rearward under the main rotor wash. When rear of…