NTSB investigations, 2007
6 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\") = 2007
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") = 2007 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 NYC08LA028Accident · 1 fatalLimited investigationFinal reportBell 407 · Morristown, TNThe pilot's failure to maintain adequate clearance from the idling main rotor blade. Contributing to the accident was the pilot's failure to comply with the manufacturer's procedure for securing the helicopter.NTSB LAX07LA270Accident · 1 fatalLimited investigationFinal reportHughes 369D · Ellensburg, WAThe passenger's inadequate visual lookout and failure to maintain clearance from the rotating main rotor disc while the helicopter was hovering. An uphill terrain condition was a factorNTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB LAX07CA214Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Clarksburg, CAThe pilot's inadequate hand-prop starting procedure and failure to secure the airplane.NTSB DFW07CA069Accident · Serious injuriesData collectionFinal reportCessna 172 · Lancaster, TXThe spectator's inadvertent contact with the turning propeller while the airplane was standing with the engine operating. A contributing factor was the dark night conditions.