NTSB investigations, 2012
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB DCA12CA033Accident · Serious injuriesData collectionFinal reportAntonov AN124 · Anchorage, AKan inadvertent encounter with Clear Air Turbulence that resulted in serious injuries to two crewmembers.NTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.NTSB ANC12CA021Accident · No injuriesData collectionFinal reportBeech 99 · Anchorage, AKThe pilot's premature power reduction, which resulted in a runway undershoot.NTSB DCA12WA032Accident · No injuriesForeign investigationBoeing 747 · Tel Aviv, IsraelOn January 31, 2012, at about 1900 UTC, a B747-400F cargo airplane, registration 4X-ELF, operated be El Al Airlines, located at Ben Gurion Tel Aviv Airport, was being inspected for a hydraulic leak that occurred during the flight from Chillagoe, Australia.…NTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.NTSB WPR12LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · San Diego, CAThe pilot's failure to turn the magneto switch to the off position before moving the propeller to start the engine by hand.NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.NTSB ERA12IA166Incident · No injuriesIncident investigationFinal reportGulfstream G150 · Baltimore, MDThe pilot-in-command's failure to obtain the proper touchdown point or landing reference speed and failure to initiate a go-around when it became evident that the airplane was landing long and fast. Contributing to the incident was a lack of effective flight…NTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.NTSB ERA12CA167Accident · No injuriesData collectionFinal reportRemos G-3/600 · Sarasota, FLThe student pilot’s loss of directional control during the landing roll.NTSB WPR12CA084Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Peoria, AZThe glider pilot released from the tow airplane at a lower altitude than the planned altitude, which resulted in an off-airport landing.NTSB ERA12LA165Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Palm Beach, FLThe pilot’s in-flight misjudgment of fuel remaining resulting in fuel exhaustion and a total loss of engine power. Contributing to the accident was an inadequate fuel quantity for the flight for reasons that could not be determined during postaccident…NTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…NTSB ERA12IA169Incident · No injuriesIncident investigationFinal reportCessna 172S · Jackson, MSThe separation of the propeller blade tip due to fatigue cracking that initiated at the blade’s leading edge.NTSB ERA12CA162Accident · No injuriesData collectionFinal reportCessna 172L · Grand Isle, VTThe pilot's inability to stop the airplane on a grass runway with undetected ice.NTSB CEN12WA145Accident · 1 fatalForeign investigationPiper Piper J3C-65 · Norfolk, United KingdomOn January 28, 2012, at 1523 universal coordinated time, a Piper J3C-65, G-BHPK, was involved in an accident at the Priory Farm, Tibenham, Norfolk, United Kingdom. The pilot and passenger had completed a personal flight and had landed. After landing the pilot…NTSB CEN12LA192Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Seguin, TXA loss of engine power for undetermined reasons.NTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.NTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.NTSB CEN12WA163Incident · No injuriesClass 5 · ForeignEclipse EA500 · Eelde, NetherlandsOn January 27, 2012, at 1325 hours universal coordinated time, an Eclipse Aviation EA-500, N607LM, experienced a loss of altitude during an instrument landing system (ILS) approach to the Groningen Airport (EHGG), Eelde, Netherlands. The flight crew executed…NTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.NTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.NTSB ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.NTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…NTSB ERA12LA157Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Port Orange, FLThe total loss of engine power for reasons that could not be conclusively determined during postaccident examination.NTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…NTSB ERA12CA156Accident · No injuriesData collectionFinal reportBeech 58 · Walterboro, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident was the sunglare.NTSB DCA12WA028Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving an MD-80 that occurred on January 24, 2012. The ACAA delegated the investigation to the Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación…NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…NTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.NTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.NTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.NTSB WPR12LA096Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Brawley, CAThe failure of the main rotor mast due to fatigue cracks that originated from corrosion pits. Contributing to the accident was the operator’s failure to adhere to the manufacturer’s recommended overhaul interval for the main rotor mast.NTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.NTSB CEN13WA102Incident · No injuriesForeign investigationRobinson Helicopter R44 · Oosterschelde, NetherlandsOn January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…NTSB ANC12CA018Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Beluga, AKGround personnel's movement of cargo in windy conditions, which allowed a previously secured cargo sack to blow into the main rotor blades.NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.NTSB CEN12FA139Accident · 2 fatalField investigationFinal reportRobinson R44 II · Centerville, LAThe pilot allowed the helicopter to settle with power while maneuvering at low altitude.NTSB ERA12WA155Accident · 5 fatalForeign investigationBell 206 · Montana Auyantepui, VenezuelaOn January 18, 2012, about 1715 universal coordinated time, a Bell 206 L-4 helicopter, Venezuelan registration YV1985, was destroyed when it collided with a mountain during a sightseeing flight near Montaña Auyantepui, Parque Nacional Canaima, in the State of…NTSB CEN12WA138Accident · No injuriesForeign investigationPiper PA-31-235 · Powys, Wales, United Kingdom, United KingdomOn January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…NTSB DCA12WA029Incident · No injuriesForeign investigationBoeing 747 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 747 that occurred on January 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.NTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…NTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…NTSB ERA12LA145Accident · 2 fatalLimited investigationFinal reportPiper PA-24-180 · Brewster, MAThe flight crew’s loss of airplane control.NTSB CEN12CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Angle Fire, NMThe pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.NTSB ANC12LA017Accident · No injuriesLimited investigationFinal reportPzl-Swidnik SW-4 · Fairbanks, AKA loss of control during a simulated hydraulic emergency, which resulted in an inadvertent dynamic rollover from the which the pilot could not recover.