NTSB investigations, 2004
3 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\") = 2004
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") = 2004 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 CHI05LA028Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Milwaukee, WIFailure of the ramp employee to maintain clearance to the rotating propeller resulting in inadvertent contact with a propeller blade.NTSB DFW05LA010Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF-340B · Fort Worth, TXThe ground personnel's failure to maintain clearance from the propeller. Contributing factors were the ground personnel's failure to comply with procedures/directives and the ground personnel's failure to properly use equipment.NTSB NYC04LA058Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Kelleys Island, OHThe pilot's improper decision to unload passengers and leave the airplane unattended while the engine was running, and the passenger's inadequate visual lookout, which resulted in an inadvertent encounter with a rotating propeller. A factor related to the…