NTSB investigations, AK
14 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1987 | 1 |
|---|---|
| 1989 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 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\" = 100)
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" = 100) 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 ANC03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's abrupt, excessive pull-up during an intentional low level maneuver, and his failure to maintain adequate airspeed which resulted in an inadvertent stall and subsequent collision with the water.NTSB ANC02FA064Accident · 1 fatalField investigationFinal reportDenzer RAF 2000 · Palmer, AKThe pilot's abrupt liftoff during takeoff, and his failure to correct a pilot-induced-oscillation during takeoff initial climb which resulted in the main rotor blades striking the tail mounted rudder, and an in-flight loss of control. A factor in the accident…NTSB ANC02LA061Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Shageluk, AKThe pilot's failure to maintain a proper glide path. A factor associated with the accident was the pilot's diverted attention.NTSB ANC01LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe flight instructor's inadequate supervision of the flight during the landing flare. A factor in the accident was the student's abrupt airplane control.NTSB ANC00LA132Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-3 · Ketchikan, AKThe pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…NTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.NTSB ANC00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's excessive application of heel brakes. A factor associated with this accident was the pilot's lack of experience in the make and model of airplane.NTSB ANC98LA155Accident · No injuriesLimited investigationFinal reportPiper PA-12 · New Stuyahok, AKThe pilot's selection of an unsuitable takeoff area and his intentional ground loop maneuver. A factor associated with the accident was trees.NTSB ANC98FA079Accident · 1 fatalField investigationFinal reportCessna 185 · Big Lake, AKThe pilot's performance of a low level maneuver. Factors were the pilot's overconfidence in his personal ability, his lack of experience in the type of airplane, and his failure to maintain adequate clearance from terrain.NTSB ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…NTSB ANC97LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Fairbanks, AKThe pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…NTSB ANC96LA113Accident · No injuriesLimited investigationFinal reportSportsman 2+2 · Wasilla, AKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/mush. A factor associated with the accident was the pilot's low altitude skidding maneuver.NTSB ANC89FA084Accident · 1 fatalField investigationFinal reportStinson 108-2 · Wasilla, AKPilot failed to operate the aircraft within its recommended parameters, resulting in loss of control and a stall-spin into the water.NTSB ANC87FA043Accident · No injuriesField investigationFinal reportBell 47G-2 · Anchorage, AKA flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…