NTSB investigations, 1994
13 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\") = 1994
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") = 1994 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 ANC95LA012Accident · 1 fatalLimited investigationFinal reportBell 206 · Juneau, AKThe employee's disregard for company training and policies about the dangers of helicopter rotor blades. The running aircraft with the rotors turning was a factor in the accident.NTSB LAX94LA376Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Las Vegas, NVthe pilot's failure to shut down the engine before deplaning a passenger.NTSB ATL94LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235B · Kill Devil Hill, NCThe pilot's failure to assure that the passenger did not exit the airplane while the propeller was still turning.NTSB MIA94LA190Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot-in-command's decision to intentionally exit the airplane with the engine running, and failure to maintain a clearance from the propeller. The improper aircraft preflight was a factor.NTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.NTSB FTW94LA180Accident · 1 fatalLimited investigationFinal reportCessna 182A · Roland, ARBoth the pilot and passenger's failure to follow procedure/directives.NTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB MIA94LA096Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Wimauma, FLThe failure of the person removing the chock to maintain sufficient clearance from the propeller. A contributing factor was the total lack of experience by person on ground.NTSB LAX94LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Sacramento, CAthe child's disregard for prescribed safety procedures which was compounded by the diminishing lighting conditions existing at the time, and her lack of familiarity with an aviation environment.NTSB LAX94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAA failure of the pilot-in-command to ensure that the powerplant controls were configured properly before moving the aircraft propeller. Inadequate planning/decision making was a factor in this accident.NTSB BFO94LA041Accident · 1 fatalLimited investigationFinal reportCessna 150 · Lima, OHThe failure of the passenger to maintain clerance from the propeller.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.