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 CEN12FA606Accident · Serious injuriesField investigationFinal reportCessna 421B · Fort Worth, TXThe pilot's failure to maintain airplane control on takeoff, which resulted in an inadvertent stall. Contributing to the accident were the unlatched nose cargo door, the pilot’s diverted attention, and the pilot's mental ability to handle the emergency…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 WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.NTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.NTSB ERA12WA552Accident · Minor injuriesForeign investigationAgusta Bell 206-3B · Al Ain, United Arab EmiratesOn September 4, 2012, about 0730 coordinated universal time (1130 gulf standard time), an Augusta-Bell 206-3B, United Arab Emirates registration A6-FTB, was substantially damaged when it impacted terrain in a flight training area near Al Ain International…NTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.NTSB WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.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 WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12CA390Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Manzanita, ORThe pilot’s inadequate compensation for the crosswind during landing, which resulted in a loss of directional control.NTSB ERA12LA543Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Tillatoba, MSThe pilot's improper fuel management and his decision to continue flight in deteriorating weather conditions with low fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB DCA12WA142Incident · No injuriesForeign investigationBoeing 737 · Bonn, GermanyOn September 3, 2012, at approximately 101 UTC time, a XL Airways B737-800, registration D-AXLF, while on a non-scheduled revenue flight from Koln to Bonn, Germany, reported smoke in the cockpit and in the cabin. The flight landed safely and there were no…NTSB CEN12WA677Accident · 2 fatalForeign investigationRobinson R44 · Nyons, FranceOn September 3, 2012, about 0845 UTC, a Robinson R44 helicopter, Spanish registration EC-IVT, was destroyed when while in level cruise it departed controlled flight and impacted in mountainous terrain near Nyons, France. The pilot and a passenger on board the…NTSB CEN12CA608Accident · No injuriesData collectionFinal reportRolladen-Schneider OHG LS3-A · Navasota, TXThe pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.NTSB ANC12LA096Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21 · Willow, AKThe pilot’s failure to maintain control of the airplane after a loss of engine power during takeoff due to carburetor ice.NTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.NTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.NTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…NTSB ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.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 ERA12LA545Accident · Minor injuriesLimited investigationFinal reportCessna 172E · East Bend, NCA total loss of engine power during the initial climb after takeoff for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA541Accident · 1 fatalLimited investigationFinal reportJohnston Douglas S Safari · McVeytown, PAThe pilot's lack of proficiency and certification, which resulted in his failure to enter an autorotation when the engine lost power. Contributing to the accident was the pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent…NTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.NTSB ERA12CA569Accident · No injuriesData collectionFinal reportCessna 172S · Farmingdale, NYThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA548Accident · Serious injuriesData collectionFinal reportHandy James L Buckeye Dream Mach · West Caln, PAThe pilot’s inadequate compensation for the wind during the initial climb, which resulted in collision with a tree and terrain.NTSB CEN12LA655Accident · No injuriesLimited investigationFinal reportTL Ultralight Sro Stingsport · Longmont, COThe failure of the wood propeller blades in flight. Contributing to the accident was the owner/operator’s failure to complete required inspections on the propeller within the specified interval, which reduced the likelihood of detecting the cracks and may…NTSB CEN12LA605Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G 103 Twin II · El Paso, TXThe pilot‘s failure to maintain glider control while attempting to take off using a ground winch, which resulted in an inadvertent stall low to the ground. Contributing to the accident was the ground winch, which was unable to produce enough speed for a…NTSB CEN12LA602Accident · 1 fatalLimited investigationFinal reportAero Vodochody L39C · Davenport, IAThe loss of airplane control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded operation.NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB CEN12CA614Accident · No injuriesData collectionFinal reportCessna L-19E · Lancaster, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.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 WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.NTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.NTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.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 WPR12CA381Accident · No injuriesData collectionFinal reportCessna A185F · Gerlach, NVThe pilot's failure to maintain directional control during the takeoff roll.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 ERA12IA550Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MACompany maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…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 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 CEN12CA603Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Pittsford, MIThe student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.NTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.NTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.