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 ERA12WA446Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn July 11, 2012, at 1300 Universal Coordinated Time (UTC), a Robinson R22 Beta, Brazilian registration PT-HOL, operated by Master Escola Aviacao Civil Ltda, was destroyed following a loss of in-flight control and collision with a building near Sao Paulo,…NTSB ERA12LA442Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pensacola, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA440Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Panama City, FLA total loss of engine power due to water contamination of the fuel, the pilot/owner's inadequate preflight inspection of his airplane, and his failure to maintain airplane control after the engine failure.NTSB ERA12FA438Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Moscow, TNThe non-instrument rated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation, a loss of airplane control, and subsequent impact with trees and terrain.NTSB CEN12WA685Accident · 3 fatalForeign investigationPiper PA-30 · Soyapango, El SalvadorOn July 11, 2012, at 1212 coordinated universal time, a Piper PA-30, El Salvador-registered YS-125P, operated by Escuela De Pilotos Dargonza, was destroyed when it impacted terrain near Soyapango, El Salvador. Visual meteorological conditions prevailed at the…NTSB CEN12LA428Accident · Serious injuriesLimited investigationFinal reportMchargue Buckeye Dream · Central City, NEThe pilot’s failure to maintain clearance with the powerlines during the initial takeoff climb.NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB WPR12LA325Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gooding, IDThe pilot’s failure to maintain airplane control after encountering an unexpected wind gust during landing.NTSB WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.NTSB ERA12WA463Accident · 1 fatalClass 5 · ForeignPiper PA36 · San Alberto, ColombiaOn July 10, 2012, about 1230 universal coordinated time, a Piper PA-36-375, Colombian registration HK2210, operated by Aeropenort LTDA. Agropecuaria del Norte, was substantially damaged when it collided with trees, during an aerial application flight near San…NTSB ERA12CA436Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Chester, CTThe pilot’s failure to execute a go-around following an approach that was high and fast, which resulted in a runway overrun.NTSB CEN12WA683Accident · Serious injuriesForeign investigationNorth American Rockwell OV-10B · Kemble, United KingdomOn July 10, 2012, about 1450 coordinated univeral time, a North America Rockwell OV-10B airplane, G-BZGK, impacted terrain near Kemble, United Kingdom. The pilot was seriously injured and the airplane was destroyed. The accident investigation is under the…NTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.NTSB CEN12LA492Accident · No injuriesLimited investigationFinal reportMaule M-4 · Springfield, MNThe tailwheel spring's overload failure during landing, resulting in a ground loop and runway excursion.NTSB CEN12CA436Accident · No injuriesData collectionFinal reportBeech 58 · Sugar Loaf Mountain, MIThe pilot did not complete the before-landing checklist and, subsequently, failed to extend the landing gear prior to landing. Contributing to the accident was the pilot’s distraction with his passengers’ conversation.NTSB CEN12CA426Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate landing flare, which resulted in a hard landing.NTSB WPR12FA298Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Murrieta, CAThe pilot's failure to maintain clearance from high vegetation while making a hovering turn, which resulted in a dynamic rollover.NTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…NTSB ERA12WA447Accident · 1 fatalClass 5 · ForeignCessna 208 · Sao Paulo, BrazilOn July 9, 2012, at 1700 UTC, a Cessna 208, Brazilian registration PT-OQR, was substantially damaged when it collided with a parachutist during a local skydiving flight from Boituva Airport (SDOI), Boituva Municipality, Sao Paulo, Brazil. The parachutist…NTSB ERA12LA450Accident · No injuriesLimited investigationFinal reportBeech A36 · Johns Island, SCThe pilot's failure to complete the manual emergency gear extension after a loss of electrical power. Contributing to the accident was the pilot's decision to delegate the landing gear extension to a non-pilot-rated passenger.NTSB ERA12LA445Accident · No injuriesLimited investigationFinal reportCessna 172S · Allentown, PAThe student pilot's failure to maintain directional control during a touch-and-go takeoff, which resulted in a runway excursion and a subsequent impact with a gopher hole, and the flight instructor's inadequate supervision of the student pilot and his delayed…NTSB ERA12LA435Accident · No injuriesLimited investigationFinal reportPiper PA-42 · Charleston, WVThe airplane’s encounter with a gravity-wave duct atmospheric phenomenon.NTSB ENG12WA027Incident · No injuriesForeign investigationBoeing 747 · London England, United KingdomOn July 9, 2012, at 22:08 UTC, an EL-AL Israel Airlines Boeing 747-400, registration number 4X-ELD, flight No. LY-318, powered by four Pratt & Whitney PW4056 tubofan engines, experienced a No. 4 (right outboard) engine failure 20 minutes after takefoff from…NTSB CEN12CA435Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Treynor, IAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12CA430Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Williston, NDThe pilot's failure to ensure a suitable landing surface.NTSB CEN12CA429Accident · Minor injuriesData collectionFinal reportCessna 190 · Anthony, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA12FA433Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · New Site, MSThe pilot's decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.NTSB CEN12LA424Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Bedford, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to return home.NTSB ANC12CA070Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Cantwell, AKThe right seat passenger’s inadvertent contact with the emergency fuel shutoff valve, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to provide a thorough preflight briefing to the…NTSB WPR12WA331Accident · 3 fatalForeign investigationBell 206 · Chuxiong City, China, ChinaOn July, 7 2012, about 1525 UTC, a Bell 206L, P2 HCY, crashed into the Qingshanzui Reservoir in Chuxiong City, China. The helicopter was operated by Yunnan General Aviation Co. Ltd., under the pertinent civil regulation of China. The aircraft was…NTSB ERA12CA434Accident · Minor injuriesData collectionFinal reportJones Peter M Boeing/Jones 75 · Bayport, NYThe airplane’s encounter with a wind shift to a tailwind during takeoff, which resulted in the pilot’s decision to abort the takeoff and the airplane’s subsequent runway overrun.NTSB CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.NTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…NTSB CEN12CA419Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ray Township, MIThe airplane’s collision with a deer that ran in front of the airplane during the landing roll.NTSB ANC12LA068Accident · No injuriesLimited investigationFinal reportShorey Timothy A Preceptor Stol King · North Pole, AKA total loss of engine power due to a binding drive belt while in the airport traffic pattern.NTSB WPR12CA300Accident · No injuriesData collectionFinal reportCessna T182T · Flagstaff, AZThe pilot’s inadequate landing flare after encountering a downdraft, which resulted in a hard landing.NTSB WPR12CA299Accident · No injuriesData collectionFinal reportBellanca 17-30 · Hillsboro, ORThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with an airport lighting system.NTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…NTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…NTSB ERA12LA432Accident · Minor injuriesLimited investigationFinal reportPiel Emeraude · Banner Elk, NCThe total loss of engine power for reasons that could not be determined because the engine was not examined.NTSB CEN12CA431Accident · No injuriesData collectionFinal reportSchweizer 269C · Denton, TXThe flight instructor and student pilot exceeded the helicopter's takeoff performance, which resulted in low rotor rpm and settling.NTSB ANC12CA072Accident · No injuriesData collectionFinal reportPiper PA-12 · Quinhagak, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.NTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.NTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.NTSB ANC12CA067Accident · No injuriesData collectionFinal reportCessna 207A · Kotlik, AKThe pilot's failure to maintain altitude/clearance from terrain during cruise flight at low altitude, which resulted in an in-flight collision with water. A contributing factor was the pilot’s diverted attention to adjust the engine power.NTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.NTSB WPR12CA294Accident · No injuriesData collectionFinal reportOmlin Robert G Exec 162F Rotorway · Quincy, WAThe pilot’s failure to ensure that a flag attached to the landing skid was properly secured, which resulted in its in-flight separation and contact with the tail rotor.NTSB DCA12WA109Accident · Serious injuriesForeign investigationBoeing 777-222 · Narita, Japan