NTSB investigations, 1982
11 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\") = 1982
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") = 1982 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 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…