NTSB investigations, AK
11 cases where the first occurrence was “Roll over”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1990 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 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\" = '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\" = 380)
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" = 380) 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 ANC98LA032Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350B · Soldotna, AKThe pilot's inadvertent dynamic rollover while performing a slope landing. Factors associated with the accident are the presence of rough and uneven terrain, and the pilot's improper slope landing technique.NTSB ANC97LA115Accident · Minor injuriesLimited investigationFinal reportBell 206-LIII · Wasilla, AKThe pilot's inadvertent dynamic rollover during liftoff. Factors associated with the accident were soft terrain and a snagged landing gear skid.NTSB ANC94LA064Accident · No injuriesLimited investigationFinal reportHiller FH1100 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing which resulted in a dynamic rollover. A factor was the soft landing area selected.NTSB ANC92LA065Accident · Minor injuriesLimited investigationFinal reportBell B206 II · Valdez, AKThe pilot's failure to follow the company procedures and directives. Factor was the whiteout conditions.NTSB ANC91FA001Accident · Serious injuriesField investigationFinal reportHughes 500D · Kennsington, AKThe loss of control during takeoff due to dynamic rollover. Contributing to the accident was the pilot-in-command's selection of an uneven landing area.NTSB ANC90LA119Accident · No injuriesLimited investigationFinal reportBell 206B · Goodnews Bay, AKThe pilot selected unsuitable terrain. The wet & soft tundra was a factor.NTSB SEA88LA127Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot purchased the helicopter with an undocumented modification designed to restrain the collective. Reportedly, hereceived no guidance regarding the use of the collective hold-down device. According to the aircraft manufacturer there existed no Enstrom…NTSB ANC88LA086Accident · No injuriesLimited investigationFinal reportHughes 369D · Kitoi Bay, AKThe helicopter landed with the left skid against a survey stake which protruded from the ground about 6 inches. Upon liftoff the skid did not clear the metal stake before the helicopter started moving laterally to the left. The left skid remained against the…NTSB ANC86LA096Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Alexander Creek, AKWhile landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over.NTSB ANC84LA087Accident · No injuriesLimited investigationFinal reportCessna A188B · Kantishna, AKThe acft encountered uneven terrain during landing & rolled over. There were no acft malfunctions according to the plt. The plt to date has not filed an accident report. In a telephonic interview he said he encountered the uneven terrain during landing…NTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…