NTSB investigations, 2012
102 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 62 |
|---|---|
| 2009 | 62 |
| 2010 | 79 |
| 2011 | 84 |
| 2012 | 102 |
| 2013 | 78 |
| 2014 | 82 |
| 2015 | 81 |
| 2016 | 120 |
| 2017 | 126 |
| 2018 | 175 |
| 2019 | 124 |
| 2020 | 83 |
| 2021 | 45 |
| 2022 | 55 |
| 2023 | 50 |
| 2024 | 51 |
| 2025 | 69 |
| 2026 | 29 |
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\" = '900' 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" = '900' 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 WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.NTSB CEN13CA117Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Chicago, ILThe presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.NTSB ERA13LA076Accident · 1 fatalLimited investigationFinal reportCassutt Sport Racer · Collegedale, TNImpact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.NTSB ERA13LA072Accident · Serious injuriesLimited investigationFinal reportHansen David Daniel RV-4 · Carthage, NCA partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…NTSB WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.NTSB ERA13CA067Accident · Serious injuriesData collectionFinal reportRadley Vincent Quicksilver Sport 2S · King George, VAThe pilot’s failure to maintain directional control during taxi.NTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.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 ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.NTSB ERA13LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Mansfield, MAThe pilots’ failure to apply carburetor heat during takeoff, which resulted in a partial loss of engine power due to the formation of carburetor ice.NTSB ERA13CA051Accident · No injuriesData collectionFinal reportCessna 150L · Seneca Falls, NYThe pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.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 ERA13IA036Incident · No injuriesIncident investigationFinal reportCessna 560XL · Nantucket, MAThe incorrect installation of the left main gear aft trunnion pivot pin by maintenance personnel, which resulted in separation of the aft portion of the left main gear trunnion from the aft trunnion fitting and minor damage to the airplane.NTSB CEN13CA027Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Helena, OKThe pilot's failure to properly secure the cyclic and to stop the main rotor system before exiting the helicopter, which resulted in the main rotor blades striking the tail rotor driveshaft.NTSB DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.NTSB ANC13FA001Accident · 1 fatalField investigationFinal reportGrumman G-44 · Aleknagik, AKThe pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.NTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.NTSB ERA13LA012Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Birmingham, ALThe pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…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 ERA12CA588Accident · Minor injuriesData collectionFinal reportHenrie Raymond Zenith CH 701 Stol · Ashland, MSThe pilot’s inadequate compensation for crosswind conditions during initial climb, which resulted in an impact with trees and terrain.NTSB ERA12CA580Accident · No injuriesData collectionFinal reportSikorsky S-76C · Theodore, ALThe pilot's failure to maintain adequate obstacle clearance while taxiing.NTSB WPR12LA433Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Firebaugh, CAThe pilot’s decision to continue the takeoff after the engine stopped producing its full-rated torque while operating in high-density altitude conditions and his subsequent failure to maintain clearance from the power transmission wires.NTSB ERA12FA572Accident · 1 fatalField investigationFinal reportCessna 172S · Land O'Lakes, FLThe pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.NTSB WPR12CA429Accident · Minor injuriesData collectionFinal reportPiper PA-14 · Emmett, IDThe pilot’s failure to maintain clearance from terrain.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 CEN12CA618Accident · No injuriesData collectionFinal reportBeech V35 · Decatur, TXThe pilot's inattention during the landing roll, which resulted in retraction of the landing gear instead of the flaps.NTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.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 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 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 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 ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB CEN12CA607Accident · No injuriesData collectionFinal reportNorth American AT-6F · Council Bluffs, IAAn unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.NTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.NTSB CEN12FA579Accident · 1 fatalField investigationFinal reportLee Paul SQ 2000 · Pierre, SDThe airplane's entry into a pilot-induced oscillation and the pilot’s loss of airplane control during the takeoff initial climb. Contributing to the accident was the left entrance door opening in flight for undetermined reasons.NTSB CEN12CA631Accident · No injuriesData collectionFinal reportPowrachute Pegasus · Luling, TXCollision with a powerline resulting from the pilot's not maintaining adequate clearance while on a day VFR approach to land.NTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB ERA12CA531Accident · No injuriesData collectionFinal reportCessna 172P · Lyman, MSThe pilot's loss of directional control during takeoff as a result of his attempt to close an unsecured cockpit window.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 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 CEN12LA545Accident · Serious injuriesLimited investigationFinal reportDykas Kitfox Series 7 · Monroe, MIThe inadequate descent angle flown by the pilot during a final approach for landing, which resulted in an in-flight collision with a power line.NTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.NTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.NTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.NTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.NTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.