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 DCA13WA011Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaOn October 20, 2012 about 1150 Coordinated Universal Time (UTC), a loss of separation occurred when a Boeing operated by KLM Royal Dutch Airlines and an Embraer operated by Finnair came within 4.2 nautical miles laterally and 700 feet vertically of each other…NTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.NTSB CEN13CA017Accident · Serious injuriesData collectionFinal reportHunthrop Autogyro MTO Sport · Bourland, TXThe pilot's decision to fly the gyroplane in gusty wind conditions that exceeded his limitations and his resultant loss of control during takeoff.NTSB ANC13CA006Accident · No injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's failure to maintain clearance from terrain during takeoff.NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.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 DCA13WA007Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaOn October 19, 2012, Sriwijaya Air flight SJ182, a Boeing 737-4Q8, registration PK-CKN (msn 26281 built 1992), sustained damage after it overran the runway on landing at Supadio Airport, Pontianak, Indonesia, and reportedly suffered a nose undercarriage…NTSB DCA13WA005Incident · No injuriesForeign investigationBoeing 737 · Glasgow, United KingdomOn October 19, 2012, at 0655 UTC time, a Boeing 737-800, registration G-GDFJ, operated by Jet2.com as a scheduled passenger flight LS177 between Glasgow, Scotland and Alicante, Spain, rejected the takeoff due to smoke in the cabin. The aircraft stopped on the…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 WPR13LA015Accident · No injuriesLimited investigationFinal reportBeech N35 · Phoenix, AZA loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.NTSB WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA018Accident · No injuriesData collectionFinal reportAlbright Stan Kitfox Super Sport · Twin Bridges, MTThe airplane builder’s failure to rig the flight controls correctly, which resulted in a loss of control after takeoff.NTSB ERA13CA047Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Plymouth, MAThe pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB WPR13CA016Accident · Serious injuriesData collectionFinal reportBoeing 737-3H4 · Las Vegas, NVThe flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.NTSB ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.NTSB DCA13WA012Incident · No injuriesForeign investigationBoeing 737 · Canberra, AustraliaOn October 17, 2012, about 2045 local time, a Boeing 737-838, registration VH-VXB, descended below the assigned altitude and below the minimum safe altitude for the area of operation. Air traffic control received a minimum safe altitude warning. The incident…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 CEN13WA014Accident · 3 fatalForeign investigationLake 250 · Pickle Lake, Ontario, CanadaOn October 16, 2012, about 1930 central daylight time, a Lake model 250, Canadian registration C-GZLC, impacted terrain during approach near Pickle Lake, Ontario, Canada. The pilot and two passengers were fatally injured. A third passenger was seriously…NTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.NTSB CEN13IA024Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Elyria, OHThe manufacturing defects in the main landing gear leg, which resulted in its eventual failure.NTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB ANC13WA088Incident · No injuriesForeign investigationMooney M20J · Wonju, South KoreaOn October 17, 2012, at 1703 local time, a Korean registered Mooney M20J airplane, HL1062, had a loss of engine power, and an off airport landing about 7 miles northwest of the Wonju Airport, Republic of Korea. The airplane was operated by Korea Aerospace…NTSB ERA13WA031Accident · 1 fatalForeign investigationRobinson R-44 · Moscow, RussiaNoneNTSB ERA13LA024Accident · Serious injuriesLimited investigationFinal reportCashmer Philip M Sonex · Crossville, TNThe pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB DCA13WA003Incident · No injuriesForeign investigationBombardier CL600 2C10 · Lorient, FranceOn 16 October, 2012, at approximately 1923 UTC (2123 local time), a Canadair CRJ-700, registration F-GRZE, operated by Britair as flight 5937 from Paris to Lorient (France), landed on Lorient Airport runway 25, and proceeded to overrun the end of the runway,…NTSB CEN13LA015Accident · Serious injuriesLimited investigationFinal reportYoung Robert Herman Woody Pusher · Cloverdale, INThe total loss of engine power due to carburetor icing.NTSB WPR13LA011Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Parker, AZThe pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…NTSB WPR13FA013Accident · 1 fatalField investigationFinal reportAeropro CZ A240 · Half Moon Bay, CAThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB WPR13FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Marana, AZThe pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.NTSB CEN13WA140Accident · Serious injuriesForeign investigationPiper PA34 · Victoriaville, CanadaOn October 15, 2012, at 1402 eastern daylight time, a Piper PA-34-200, Canadian registration C-GNAS, owned and operated by Nadeau Air Service, was substantially damaged when it impacted terrain near Victoriaville, Quebec, Canada, following a catastrophic…NTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.NTSB ANC13FA004Accident · 1 fatalField investigationFinal reportGrumman Aircraft ENG C-1A · Willow, AKThe pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.NTSB ERA13LA020Accident · 2 fatalLimited investigationFinal reportAirborne Windsports PTY XT-912 · Winter Haven, FLThe pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.NTSB DCA13RA001Accident · Serious injuriesForeign investigationBoeing 737 · Antalya, TürkiyeThe Directorate General of Civil Aviation (DGCA), of the Republic of Turkey, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on October 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA…NTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.NTSB ERA13TA021Accident · Minor injuriesFinal reportBell OH-58A · Jackson, TNA loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA022Accident · No injuriesLimited investigationFinal reportHughes/Helicopter Assocs 369A · West Chester, PAThe pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…NTSB ERA13LA019Accident · 3 fatalLimited investigationFinal reportPiper PA-23-250 · Charlotte AmalieThe pilot's attempted visual flight rules (VFR) flight into marginal VFR conditions on a dark night over water and his failure to maintain sufficient altitude, which resulted in the airplane’s controlled flight into water. Contributing to the accident was the…NTSB DCA13WA177Incident · No injuriesForeign investigationBoeing 737 · Tabing, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an accident involving a Boeing 737 that occurred on October 13, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the Indonesia KNKT's…NTSB DCA13WA002Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Sao Paulo, BrazilNTSB ANC13FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-18-150 · Kenai, AKUndetermined. The airplane and pilot were not found.NTSB ERA13LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Allentown, PAThe operator's failure to perform magneto inspections per the manufacturer's recommendations and failure to comply with the engine manufacturer's recommended time interval for engine overhaul, which resulted in defects in the magnetos going undetected and the…NTSB ERA13LA018Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Yorktown, NYThe pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.NTSB CEN13FA010Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 II · Blanco, TXThe pilot's loss of helicopter control as a result of spatial disorientation due to dark night conditions and marginal visual flight rules weather conditions.NTSB ERA13LA043Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 42 NG · Palm Coast, FLThe pilot’s failure to maintain adequate airspeed, which resulted in a hard landing.NTSB ERA13FA017Accident · Serious injuriesField investigationFinal reportArion Lightning · Chuckey, TNThe pilot’s inadequate preflight planning, which resulted in an attempted takeoff at a high gross weight, near the limit of its aft center of gravity, and with the airplane incorrectly configured with fully extended flaps. Contributing to the accident was the…NTSB ERA13CA028Accident · No injuriesData collectionFinal reportCessna 172RG · Mobile, ALThe pilot’s failure to perform the before landing checklist and extend the landing gear before touchdown. Contributing to the accident was the designated pilot examiner’s inadequate remedial action.NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB ERA13WA108Incident · No injuriesForeign investigationSikorsky S61 · Carauari, BrazilOn October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…