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 ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB CEN12LA344Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Kenmare, NDThe pilot's failure to maintain directional control during an aborted takeoff.NTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.NTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.NTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.NTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…NTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.NTSB DCA12RA084Accident · 153 fatalForeign investigationBoeing MD-83 · Lagos, NigeriaOn June 3, 2012 about 1545 hours local time, 5N-RAM, a Boeing MD-83, operated by Dana Airlines Limited as flight 992 (DAN 992), crashed into a densely populated area during a forced landing following a total loss of power in both engines while on approach to…NTSB ANC12CA050Accident · No injuriesData collectionFinal reportWalls Craig C Snowyriver Special · Chugiak, AKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB ANC12CA045Accident · No injuriesData collectionFinal reportCessna 150G · Ketchikan, AKThe pilot’s decision to take off with a quartering tailwind, which resulted in a loss of control.NTSB WPR12CA245Accident · No injuriesData collectionFinal reportCessna 180 · Wenatchee, WAThe pilot's failure to maintain directional control during takeoff in a crosswind condition.NTSB ERA12WA383Accident · 1 fatalForeign investigationPiper PA-28R-200 · São Paulo, BrazilNTSB ERA12LA380Accident · Minor injuriesLimited investigationFinal reportPittman Eddie G CGS Hawk Arrow II · Monroe, VAThe pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.NTSB DCA12WA083Accident · No injuriesForeign investigationBoeing 727 - 221F · Accra, GhanaThe Ghana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a B727 that occurred on June 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO Annex 13 as…NTSB CEN12WA338Accident · 1 fatalForeign investigationCessna 182N · Pista Aérea, MexicoNTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…NTSB ANC12LA046Accident · No injuriesLimited investigationFinal reportCessna A185F · Skwentna, AKThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power in cruise flight. Contributing to the accident was the pilot's failure to follow the checklist after the loss of engine power.NTSB WPR12LA241Accident · 1 fatalLimited investigationFinal reportWestcott Prowler Jaguar · Salinas, CAThe pilot's inability to maintain airplane control during takeoff due to an incapacitating cardiac event.NTSB DCA12WA093Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe Indonesian National Transportation Safety Committee (NTSC) has notified the NTSB of an accident involving a Boeing 737-400 that occurred on June 1, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation under the…NTSB ERA12LA373Accident · Minor injuriesLimited investigationFinal reportFaltin John R Rotorway Exec 162F · Smoketown, PAA loss of control during a post-maintenance test flight due to improper tracking of the helicopter’s main rotor blades by the pilot/aircraft builder.NTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…NTSB ERA12CA377Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Lawrence, MAThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.NTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.NTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.NTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.NTSB DCA12CA082Accident · No injuriesData collectionFinal reportBoeing 747 · Chicago, ILthe B747 Captain's failure to maintain a safe clearance between his wing and the tail of the EMB135 that was stopped on a taxiway.NTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.NTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.NTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA 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 WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…NTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.NTSB CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.NTSB ANC12CA043Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s failure to maintain directional control while landing in a gusting crosswind.NTSB WPR12WA239Accident · 1 fatalForeign investigationCessna 172 · Wentworth, Australia, AustraliaOn May 28, 2012, at 1000 universal coordinated time, a Cessna 172, VH-WLF, collided with terrain near Wentworth, Australia. The airplane was registered to a private individual and operated under the pertinent civil regulations of Australia. The pilot was…NTSB WPR12CA260Accident · No injuriesData collectionFinal reportCessna 172P · Hemet, CAThe student pilot's failure to monitor and maintain clearance from an obstacle during taxi.NTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…NTSB ERA12CA378Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Mocksville, NCThe glider pilot's failure to attain and maintain directional control during takeoff.NTSB ENG12RA023Incident · No injuriesForeign investigationBoeing 777 · Toronto, CanadaOn May 28, 2012, at 12:29 EDT (18:29 UTC), a Boeing 777-300ER, registration C-FITW, experienced a loss of power from the No. 2, right, engine, a GE Aviation GE90-115B, shortly after takeoff from the Toronto Lester B. Pearson International Airport (CYYZ),…NTSB CEN12WA366Accident · 4 fatalClass 5 · ForeignCessna 172M · Rotterdam, The Netherlands, NetherlandsOn May 28, 2012, about 0920 universal time (UTC), a Netherlands registered Cessna 172M, PH-SKJ, was destroyed when it impacted terrain about 17 nautical miles southwest of the Rotterdam The Hague Airport, The Netherlands. The pilot and three passengers were…NTSB CEN12LA324Accident · 1 fatalLimited investigationFinal reportNorth American T-6G · Perry, MIThe pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.NTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…NTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.NTSB WPR12LA246Accident · No injuriesLimited investigationFinal reportBeech B36TC · Santa Ynez, CAA loss of engine power during initial climb due to fuel starvation. Contributing to the accident were the pilot’s inadequate preflight inspection, his failure to properly diagnose the loss of engine power, and his failure to follow the appropriate emergency…NTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.NTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.NTSB WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.NTSB ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB ENG12WA038Incident · No injuriesForeign investigationAirbus A321 · CAM RANH, Vietnam, VietnamOn May 27, 2012, a Vietnam Airlines Airbus A-321-231, registration number VN-A356, powered by two International Aero Engines (IAE) V2500 turbofan engines experienced a engine crew and alerting message (ECAM) warning for a No. 2 engine stall and fire during…