NTSB investigations, 2012
21 cases where the sequence of events included Abrupt maneuver.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 19 |
| 2010 | 20 |
| 2011 | 32 |
| 2012 | 21 |
| 2013 | 15 |
| 2014 | 22 |
| 2015 | 24 |
| 2016 | 37 |
| 2017 | 28 |
| 2018 | 23 |
| 2019 | 17 |
| 2020 | 7 |
| 2021 | 18 |
| 2022 | 9 |
| 2023 | 11 |
| 2024 | 12 |
| 2025 | 12 |
| 2026 | 7 |
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\") = 2012
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '270' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2012 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '270' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA13CA086Accident · Serious injuriesData collectionFinal reportCessna 172P · Murfreesboro, TNThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB CEN13LA094Accident · No injuriesLimited investigationFinal reportLsa America Allegro · Adrian, MIThe student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions.NTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.NTSB ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.NTSB ERA12FA565Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Brownsboro, ALThe pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.NTSB ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.NTSB ERA12LA557Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Washington, PAThe airplane’s encounter with a flock of geese during takeoff, which resulted in the airplane’s hard impact with the runway while the pilot maneuvered in an attempt to avoid the geese.NTSB ERA12TA538Accident · Minor injuriesFinal reportBell 407 · Bath, NYThe pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…NTSB CEN12FA561Accident · No injuriesField investigationFinal reportSavage Air Epic LT · San Saba, TXThe improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation.NTSB WPR12LA317Accident · Serious injuriesLimited investigationFinal reportHerem DR-107 · Bridger, MTThe pilot’s failure to maintain airplane control while maneuvering after takeoff.NTSB CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…NTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…NTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.NTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…NTSB CEN12LA307Accident · 1 fatalLimited investigationFinal reportDial David L Titan Tornado II · Checotah, OKThe noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.NTSB CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.NTSB CEN12CA269Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Hugo, OKThe pilot’s inadequate collective control inputs while performing a hovering autorotation, which resulted in a hard landing. Contributing to the accident was the check airman's delayed remedial action.NTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.