NTSB investigations, 2012
132 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 319 |
|---|---|
| 2009 | 188 |
| 2010 | 164 |
| 2011 | 116 |
| 2012 | 132 |
| 2013 | 156 |
| 2014 | 233 |
| 2015 | 224 |
| 2016 | 279 |
| 2017 | 319 |
| 2018 | 315 |
| 2019 | 253 |
| 2020 | 158 |
| 2021 | 140 |
| 2022 | 126 |
| 2023 | 115 |
| 2024 | 115 |
| 2025 | 81 |
| 2026 | 43 |
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\", '030220'))
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", '030220')) 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 CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.NTSB CEN13LA115Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Corcoran, MNThe pilot’s improper decision to land the helicopter in a position that placed the tail rotor near tarps, which resulted in the tarps being lifted into the tail rotor, subsequent tail rotor damage, a loss of tail rotor authority, and an uncommanded tail rotor…NTSB DCA13CA066Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYan inadvertant birdstrike on approach.NTSB ERA13CA077Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Middletown, NYThe pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.NTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.NTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB WPR13GA044Accident · Minor injuriesFinal reportBell OH-58 · Altadena, CAThe landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.NTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.NTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…NTSB WPR13CA027Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hanapepe, HIThe pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.NTSB CEN13CA031Accident · No injuriesData collectionFinal reportCessna 150 · Carrollton, OHThe airplane’s collision with two deer during the takeoff roll.NTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA13CA033Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Newton, GAThe pilot’s failure to maintain clearance from power lines while maneuvering, which resulted in a hard forced landing.NTSB ANC13CA006Accident · No injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's failure to maintain clearance from terrain during takeoff.NTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB ERA13LA013Accident · Serious injuriesLimited investigationFinal reportBeaudry Phillip Aventura II · Minneola, FLA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA004Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIAn obstruction (a sleeve of cups) that lodged under the catering truck brake pedal, which prevented the driver from stopping the truck before it struck the parked airplane.NTSB WPR13LA003Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Rockport, WAThe pilot's failure to maintain sufficient rotor rpm during a precautionary landing, which resulted in a hard landing.NTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.NTSB ERA12LA589Accident · No injuriesLimited investigationFinal reportCessna 421B · Selma, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power on the right engine and a partial loss of engine power on the left engine due to fuel starvation.NTSB WPR12LA443Accident · No injuriesLimited investigationFinal reportBeech V35A · Torrance, CAThe pilot's failure to maintain directional control during taxi, which resulted in a collision with a parked vehicle.NTSB ERA12CA592Accident · No injuriesData collectionFinal reportLearjet 36A · New Haven, CTAn inadvertent collision with a deer during the takeoff roll.NTSB CEN12CA647Accident · No injuriesData collectionFinal reportEnstrom F-28A · Fort Worth, TXThe noncertificated pilot's operation of the helicopter, which resulted in the tail boom's contact with the refueling pump.NTSB ERA12LA562Accident · 1 fatalLimited investigationFinal reportRepublic RC-3 · Cedar Bluff, ALThe pilot's failure to see and avoid power lines during final approach to landing.NTSB ANC12LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Denali Park, AKThe pilot’s failure to maintain clearance from an electric transmission line during the approach to land because he was distracted by the airplane’s broken and deflected landing ski. Contributing to the accident was the in-flight failure of the right ski…NTSB CEN12LA630Accident · No injuriesLimited investigationFinal reportHalderman, Floyd G. RV-6A · Eldon, MOThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.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 WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.NTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.NTSB ANC12CA100Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 · Talkeetna, AKThe entanglement of a plastic tarp in the helicopter’s tail rotor after becoming dislodged from its securement.NTSB WPR12LA382Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Chelan, WAA loss of engine power during climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA385Accident · Serious injuriesField investigationFinal reportEaston Searey · Friday Harbor, WAThe pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.NTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.NTSB WPR12LA371Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH58 · Escalon, CAThe pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.NTSB ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.NTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB WPR12CA357Accident · No injuriesData collectionFinal reportCessna 172R · Everett, WAThe pilot’s failure to maintain directional control during takeoff.NTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.NTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.