NTSB investigations, IL
9 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' 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 CHI02LA232Accident · 1 fatalLimited investigationFinal reportBell 412 · Rantoul, ILThe congested takeoff and landing area and the low altitude flight maneuver performed by the pilot.NTSB CHI01LA167Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Ottawa, ILthe failure of the passenger to maintain clearance from the windmilling propeller after exiting the airplane.NTSB CHI96FA323Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Hampshire, ILimproper use of the mini-bike by the driver. Factors relating to the accident were: darkness, the unlighted mini-bike, and insufficient standards required by the residents of the airstrip concerning use of the taxiways at night.NTSB CHI92LA198Accident · 1 fatalLimited investigationFinal reportCessna 177B · Dwight, ILThe passenger's inattention to the propeller arc and the pilot's improper procedure in disembarking a passenger while the engine was running.NTSB CHI87DEE04Accident · 1 fatalFinal reportCessna 172 · Plainfield, ILWhile taxiing for takeoff, the aircraft became stuck in a snowbank. The pilot and passenger got out of the aircraft to free it. The passenger walked into the propeller of the running engine and received fatal injuries.NTSB CHI87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Sandwich, ILThe pilot was attempting to hand prop the aircraft due to a low battery. The engine started and the plane began moving. The aircraft struck the pilot and then traveled into a hangar door.NTSB CHI86FA129Accident · Minor injuriesField investigationFinal reportBell 222B · Chicago, ILThe aircraft had just discharged two passengers on the rooftop helipad and was preparing for departure. The aircraft was picked up to a hover and the tailrotor struck a heliport surface perimeter light. The tailrotor separated from the aircraft and the…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…NTSB CHI83LA372Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Wheeling, ILThe plt was unable to start the eng using normal procedures. He obtained the use of an APU & still could not make an electrical start. He stated that he turned the magneto & master switches off & rotated the propeller (prop) backwards 1/2 turn (to check for…