NTSB investigations, 2012
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 ERA13LA015Accident · Serious injuriesLimited investigationFinal reportVelline'S Breezy RLU-1 · Madison, GAThe pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…NTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.NTSB ENG13RA002Incident · No injuriesForeign investigationAirbus A330 · Paris, France, FranceOn October 11, 2012, a TAM Linhas Aéreas Airbus A330-223, Brazilian registration number PT-MVE, flight number JJ8055, experienced an No. 2 (left) engine (a Pratt & Whitney PW4168 turbofan) failure after take-off from Charles De Gaulle (CDG) airport, Paris…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 CEN13CA035Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 90A · Albuquerque, NMThe balloon pilot's encounter with higher-than-expected wind velocity, which resulted in a hard landing and passenger injury.NTSB CEN13CA018Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 90A · Albuquerque, NMThe passenger’s inadequate brace position for the balloon landing, which resulted in a serious injury.NTSB WPR13FA008Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Laramie Peak, WYThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB ENG13WA001Incident · No injuriesForeign investigationBeech 1900 · Lyon, FranceOn October 09, 2012, at 9:40 am local time, a Beechcraft 1900, F-GOPE, operated by Hex'Air, experienced a elevator trim system failure after take-off at Lyon-Saint Exupery airport(LFLL), France. A post flight inspection revealed that the elevator trim forward…NTSB CEN13CA026Accident · Minor injuriesData collectionFinal reportMace Justin I Dragonfly · Durango, COThe pilot’s delayed decision to perform a go-around, which resulted in the airplane impacting trees. Contributing to the accident was the pilot’s inexperience in the accident airplane and his encounter with conditions that exceeded his capabilities.NTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.NTSB ERA13CA016Accident · No injuriesData collectionFinal reportCessna 172P · Cedar Key, FLThe pilot's failure to attain the proper touchdown point, which resulted in a runway excursion.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 WPR13LA007Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH25M · Kamuela, HIThe pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.NTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB WPR13FA006Accident · Minor injuriesField investigationFinal reportGarlick Helicopters UH-1H · Shady Cove, ORThe separation of the tail rotor gearbox and tail rotor assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs.NTSB WPR13CA012Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Bishop, CAThe pilot's inadequate compensation for the variable wind conditions and his failure to maintain directional control.NTSB CEN13IA008Incident · No injuriesIncident investigationFinal reportMueller Michael Walter Challenger II CW SPC · Sandwich, ILA total loss of engine power due to significant engine corrosion. Contributing to the accident was inadequate engine maintenance.NTSB ERA13WA156Accident · 1 fatalForeign investigationCessna 172S · Izmir, TürkiyeOn October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…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 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 ERA13CA011Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Beltzville, PAThe flight instructor’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA13CA010Accident · Minor injuriesData collectionFinal reportMoulton Howard Wells ULTRA-PUP · Lyman, METhe accumulation of ice in the automotive engine’s carburetor, which resulted in a loss of engine power.NTSB DCA13WA174Incident · No injuriesForeign investigationCessna 210 - N · Outjo, NamibiaOn October 6, 2012 about 1400 UTC, V5-YUL, Cessna 210N, had a partial loss of engine power followed by a precautionary landing near Outjo, Namibia. Visual meteorological conditions existed at the time. None of the 4 occupans were injured. The airplane was not…NTSB CEN13FA006Accident · 4 fatalField investigationFinal reportBeech A36 · Mabank, TXThe pilot's loss of airplane control while maneuvering in instrument meteorological conditions.NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.NTSB ENG15WA014Incident · No injuriesForeign investigationBoeing 737 - 73V · Incheon, South KoreaOn October 5, 2012, an Easter Jet Boeing 737-700 powered by two CFM 56-7B20 turbofan engines experienced a No. 2 engine failure while climbing through 22,500 feet after takeoff from Gimpo International Airport, Seoul, South Korean. The flight crew shutdown…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 CEN13FA003Accident · 1 fatalField investigationFinal reportBell 407 · Intracoastal City, LAThe pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.NTSB CEN13CA005Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB ERA13LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Parkersburg, WVThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA13CA009Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Cumming, GAThe operation of the powered parachute by a non-certificated pilot, and his failure to maintain directional control during the initial climb, which resulted in a collision with trees.NTSB WPR13WA014Accident · 1 fatalForeign investigationRobinson R22 · Halls Creek, Australia, AustraliaOn October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…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 ERA13WA030Accident · 1 fatalForeign investigationPiper PA25 · Juquiá Municipality, BrazilOn October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…NTSB ERA13CA008Accident · No injuriesData collectionFinal reportSanders Ben G III DR-107 · Warrenton, VAThe pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB CEN13FA002Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Gary, INThe pilot's loss of control during an instrument approach due to spatial disorientation. Contributing to the accident were deficient approach control services and the pilot's loss of positional awareness.NTSB ERA13WA085Accident · No injuriesForeign investigationThrush S2R-T34 · Naranjal, EcuadorOn October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…NTSB ERA13LA005Accident · No injuriesLimited investigationFinal reportCessna 310I · Burlington, VTThe collapse of the left main landing gear due to a failure of the left main gear bellcrank pin for reasons that could not be determined because the pieces of the fractured bellcrank pin were not located.NTSB CEN13CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Eden Prairie, MNThe pilot’s inadequate braking action and decision to abort the landing near the departure end of the runway. Contributing to the accident was the pilot’s attempt to land near the midpoint of the runway.NTSB WPR12LA441Accident · Minor injuriesLimited investigationFinal reportTeam MINI-MAX · Chula Vista, CAA complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…NTSB ANC12CA115Accident · No injuriesData collectionFinal reportCessna 182A · Port Lions, AKThe pilot's decision to take off with ice- and snow-contaminated wings.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB ERA12LA584Accident · 1 fatalLimited investigationFinal reportKeuthan Buccaneer II · Granite Quarry, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA12WA159Accident · No injuriesForeign investigationBoeing 777 · Rome, ItalyOn September 30, 2012, about 1305 Coordinated Universal Time (UTC), a Boeing 777-200 sustained damage to the forward left passenger door and aircraft structure when a jetbridge was moved during boarding operations at Rome Fiumicino Airport, Rome, Italy. There…NTSB CEN12WA664Accident · 6 fatalForeign investigationCessna 414A · Innsbruck, AustriaNTSB CEN12LA669Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Nocona, TXThe noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.