NTSB investigations, 2012
41 cases where NTSB found Aircraft capability.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 46 |
| 2010 | 45 |
| 2011 | 55 |
| 2012 | 41 |
| 2013 | 37 |
| 2014 | 36 |
| 2015 | 55 |
| 2016 | 46 |
| 2017 | 37 |
| 2018 | 28 |
| 2019 | 27 |
| 2020 | 28 |
| 2021 | 20 |
| 2022 | 27 |
| 2023 | 31 |
| 2024 | 23 |
| 2025 | 20 |
| 2026 | 8 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010610'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010610')) 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 WPR13FA061Accident · 3 fatalField investigationFinal reportPiper PA28 · Aurora, UTThe pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…NTSB CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB CEN13LA023Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Sturtevant, WIThe pilot's decision to continue the landing after touching down long and on a wet runway that reduced the airplane’s braking capability, which resulted in an overrun.NTSB CEN13CA022Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Loop, TXThe pilot’s inadequate performance calculations, which resulted in an overweight takeoff for the conditions and the subsequent hard impact with terrain.NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB CEN12LA678Accident · Minor injuriesLimited investigationFinal reportInfinity 2003 · Merrill, MIThe pilot's improper decision to attempt a takeoff from midfield, resulting in a collision with trees at the departure end of the field.NTSB CEN12LA659Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 210S · Albuquerque, NMThe failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…NTSB ERA12FA567Accident · Minor injuriesField investigationFinal reportBeech 400 · Macon, GAThe pilot’s failure to maintain proper airspeed, which resulted in the airplane touching down too fast on the wet runway with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the landing overrun were the flight crewmembers’…NTSB WPR12FA395Accident · 1 fatalField investigationFinal reportSkykits USA Savannah ADV · Murtaugh, IDThe pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…NTSB CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.NTSB WPR12FA378Accident · 2 fatalField investigationFinal reportAircraft Mfg & Development CH 2000 · Nephi, UTThe pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA12CA523Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Bedford, PAThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around. Contributing to the accident was the pilot's failure to shutoff the carburetor heat during the attempted go-around and the weight at which the airplane was…NTSB WPR12LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · McCall, IDThe flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.NTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.NTSB CEN12CA542Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Harvey, NDThe pilot’s decision to take off with the airplane over its maximum gross weight on a turf runway and with a tailwind, and his subsequent failure to maintain airplane control.NTSB WPR12CA342Accident · Serious injuriesData collectionFinal reportPiper PA18 · McNeal, AZThe pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high…NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB ERA12LA503Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Homerville, GAThe loss of engine power due to debris within the engine-driven fuel pump.NTSB CEN12LA445Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro SportCruiser · Waynesville, OHThe airplane's collision with fence posts during an aborted takeoff due to a sudden change in wind direction.NTSB CEN12CA454Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jenks, OKThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway overrun and impact with obstructions.NTSB WPR12LA321Accident · No injuriesLimited investigationFinal reportLoflin RV-7A · Novato, CAThe partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s failure to…NTSB CEN12LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Elkader, IAThe pilot's failure to attain the proper touchdown point while landing on the wet grass runway.NTSB WPR12LA302Accident · 1 fatalLimited investigationFinal reportBunch COZY-CANARDIII · Winslow, AZThe pilot’s failure to maintain airplane control during climb in high-density altitude conditions and with the airplane’s weight in excess of its maximum allowable gross weight.NTSB CEN12CA431Accident · No injuriesData collectionFinal reportSchweizer 269C · Denton, TXThe flight instructor and student pilot exceeded the helicopter's takeoff performance, which resulted in low rotor rpm and settling.NTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.NTSB WPR12LA283Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Stanley, IDThe pilot’s inadequate preflight planning and decision to takeoff at a density altitude outside of the airplane’s takeoff performance envelope, with a tailwind, and near the airplane’s maximum gross weight, which resulted in the airplane’s inability to climb…NTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…NTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…NTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.NTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.NTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…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 WPR12FA203Accident · 1 fatalField investigationFinal reportM Squared Breese · Whitewater, CAThe pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.NTSB WPR12LA205Accident · Serious injuriesLimited investigationFinal reportInfinity 2000 · Hurricane, UTThe pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.NTSB ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB CEN12CA264Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Cheyenne Wells, COThe pilot’s inadequate compensation for the wind conditions during takeoff.NTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.NTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.