NTSB investigations, AK
8 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1982 | 2 |
|---|---|
| 1986 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1998 | 2 |
Where
Latest 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\" = 'AK' 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" = 'AK' 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 ANC98TA162Accident · Serious injuriesFinal reportHughes 369D · Homer, AKThe passenger not following the instructions given by the pilot. Contributing factors were the rising terrain and the pilot's diverted attention during the toe in landing.NTSB ANC98LA112Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate procedures/directives when he allowed a passenger to exit the cabin area while the propeller was still turning, and the passenger's failure to follow the pilot's instructions to stay away from the propeller. A factor associated with the…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 ANC93LA171Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Ptarmigan Pass, AKThe pilot inadvertently walked into a turning propeller. Factors in the accident were the soft runway which mired the airplane and the pilot's diverted attention during the attempt to free the airplane.NTSB ANC93LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Gambell, AKIntentional personal injury. Factors in the accident were: the person's psychological condition, and the lack of sufficient procedures/airport staff by the operator(s).NTSB SEA87LA030Accident · 1 fatalLimited investigationFinal reportCessna 180J · Juneau, AKThe passenger deplaned while the plt shut down the aircrafts engine. Although the plt noticed that the passenger was near the wing strut and attempted to yell at him, the passenger inadvertently walked into the wind milling propeller which struck him in the…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 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.…