NTSB investigations, 1984
14 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\") = 1984
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") = 1984 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 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 CHI85LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chambers Island, WIThe plt reported that during takeoff upon reaching an alt of 8-10 ft AGL a down draft was encountered and the acft contacted the rwy on the rt landing gear which was in the transient position. He reported he was able to remain airborne but the rate of climb…NTSB CHI85LA047Accident · Minor injuriesLimited investigationFinal reportRockwell 114 · Strongville, OHPlt was aware runway had a pronounced dip just prior to rotation area of his acft. Passing the dip on takeoff roll, he felt a 'shimmy' which he attributed to nose gear reaction to the dip. Plt considered aborting takeoff, but felt insufficient runway…NTSB ATL85LA031Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Hogansville, GAA deplaning passenger walked into the rotating tail rotor. The passenger had been walked away from the acft by the plts brother but she returned on her own and was struck by the tail rotor.NTSB MIA85LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · West Palm Beach, FLThe plt stated that while standing on the ramp with the eng running in preparation for flt, they were having difficulty closing the acft door. A passenger got out to look for help but once out of the acft walked along the rt wing leading edge up to the eng…NTSB NYC84FNA03Accident · Serious injuriesFinal reportPiper PA-28-181 · New Bedford, MAThe rt front seat pass'g exited the acft via the rt door and went forward over the leading edge of the wing while the acft engine was idling at aprx 1200 RPM. The rotation prop struck and injuried the pass'g with serious chest, back and arm lacerations. The…NTSB NYC84LA276Incident · No injuriesLimited investigationFinal reportCessna 310II · Newark, NJAn unemployed person was trying to help load an acft. In noticing that a bill of laden had been left off the cargo he ran toward the acft which had, by this time, started engines. The plt said he saw the running man and shoved the mixtures to cut off the…NTSB MIA84LA195Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Loiza, PRThe plt had just landed at a shore site & the acft was parked with engine running when an unauthorized person walked into the tail rotor. The crew & passengers were still aboard the acft at the time of the accident.NTSB NYC84FHD04Accident · Serious injuriesFinal reportMooney M20 · Atlantic City, NJThe flt to Atlantic-city-bader field was uneventful, except the acft touched down hard during the landing. The plt taxied to the terminal & parked with the exit door facing the terminal. He elected not to shut down the eng since he intended to immediately…NTSB FTW84LA259Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Andrews, TXThe pilot stated that the helicopter was operating at 55 percent power on the gnd while awaiting the pax to board. The passenger walked into the tailrotor and received serious injuries. The plt stated that the company does not have safety procedures for…NTSB ATL84LA170Accident · 1 fatalLimited investigationFinal reportCessna 172N · Nashville, TNThe plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his…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 NYC84FHM06Accident · Serious injuriesFinal reportCessna 210N · Millbrook, NYPlt was injured while hand propping the acft.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…