NTSB investigations, 2012
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.NTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.NTSB DCA12WA064Incident · No injuriesForeign investigationBoeing 737 - 800 · Seville, SpainThe Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) has notified the NTSB of an accident involving two Boeing 737 airplanes that occurred on April 13, 2012. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB CEN12LA245Accident · Minor injuriesLimited investigationFinal reportNelson Sydney/Nelson Diann Zodiac XL · Medina, OHA cracked fuel line, which resulted in a loss of fuel pressure and subsequent loss of engine power.NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB WPR12WA199Accident · 1 fatalForeign investigationAyres S2R · Moree, Australia, AustraliaOn April 10, 2012, at 2300 universal coordinated time, an Ayres Turbo Thrush S-2R, VH-WDD, collided with the terrain near Moree, Australia, while conducting agricultural operations. The airplane was operated by Alexander Aviation PTY LTD under the pertinent…NTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB WPR12CA163Accident · No injuriesData collectionFinal reportAvian Balloon Magnum IX · Sedona, AZThe pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.NTSB ERA12CA276Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Iuka, MSThe pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.NTSB WPR12CA162Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Henderson, NVThe pilot did not maintain directional and yaw control of the helicopter during approach and landing, which resulted in a dynamic rollover.NTSB ERA12LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLA total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.NTSB ERA12CA275Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Ruleville, MSThe pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB CEN12CA238Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Youngstown, OHThe pilot's loss of control while landing, which resulted in a ground loop.NTSB WPR12LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Casper, WYA total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…NTSB WPR12FA155Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Salinas, CAA loose portable XM-GPS antenna that migrated to the tail section of the airplane and jammed the elevator bell crank. Contributing to the accident was the pilot’s failure to account for the cockpit portable GPS antenna during preflight or postflight…NTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.NTSB WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.NTSB DCA12FA058Accident · No injuriesField investigationFinal reportBombardier DHC-8-402 · Houston, TXthe nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB WPR12FA154Accident · 1 fatalField investigationFinal reportCessna T182 · Ludlow, CAThe in-flight loss of control due to the pilot’s impairment as a result of hypoxia. Contributing to the accident was the pilot’s operation of the airplane above 12,500 feet without the aid of supplemental oxygen.NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB WPR12CA157Accident · No injuriesData collectionFinal reportFisher HP-14 Sailplane · Nampa, IDThe pilot’s incorrect positioning of the wing flaps during the landing approach, which resulted in a loss of lift and hard landing.NTSB ERA12WA298Accident · 4 fatalForeign investigationAgusta A119 · Leningradsky, RussiaOn April 6, 2012, about 1240 Universal Coordinated Time (UTC), an AgustaWestland S.p.A., A119 helicopter, Russian registration RA-01980, crashed onto a frozen lake (Yanisyarvi), Sortavalsk district, Leningradsky region, about 5 KM from camp Chernye Kamni,…NTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN12WA679Accident · 2 fatalForeign investigationRobinson R22 · Huy, BelgiumThis accident is under the jurisdiction and control of the Belgium government.NTSB ERA12CA272Accident · Minor injuriesData collectionFinal reportWielt Great Lakes 2T-1A · Warwarsing, NYThe pilot’s failure to maintain airplane control during low level maneuvering flight.NTSB ERA12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Pottstown, PAThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.NTSB CEN12LA231Accident · Serious injuriesLimited investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Ann Arbor, MIThe student pilot's failure to maintain airplane control on takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB DCA12WA061Incident · No injuriesForeign investigationBoeing 737 · Umea, SwedenOn April 4, 2012, at approximately 0950 UTC, a B737-600, registration LN-RPS, operated by Scandinavian Airlines, experienced a failure of the left bleed system while climbing through flight level (FL) 370. The climb continued with only the right system…NTSB DCA12WA060Incident · Minor injuriesForeign investigationBoeing 737 · Lugano, SwitzerlandOn April 4, 2012, at approximately 0909 UTC, a RyanAir B737-800, registration EI-DAH, operated by RyanAir, experienced a loss of cabin pressure near Lagano, Switzerland, during a scheduled passenger flight between Bergamo, Italy and Nottingham, United…NTSB CEN12LA234Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Telluride, COThe pilot's decision to land with a direct tailwind, which resulted in a loss of directional control, and his subsequent decision to attempt a go-around so late in the landing roll, which resulted in a stall.NTSB CEN12LA229Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · San Marcos, TXThe pilot's failure to ensure that he was aware of the NOTAM describing the runway closure, which resulted in a landing on the closed runway and subsequent collision with a barrier. Contributing to the accident was the failure of air traffic control personnel…NTSB CEN12LA227Accident · 1 fatalLimited investigationFinal reportGrumman F8F-1 · Breckenridge, TXThe pilot's loss of airplane control during a low-altitude aerobatic maneuver.NTSB WPR12LA152Accident · 2 fatalLimited investigationFinal reportNelson Rans S-12 · Mesa, AZThe pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.NTSB WPR12CA153Accident · Minor injuriesData collectionFinal reportCessna 172 · Johnson Valley, CAThe pilot did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane.NTSB ERA12LA296Accident · No injuriesLimited investigationFinal reportJones SA105 · New Smyrna Beach, FLThe failure of the nose landing gear wooden attachment/support structure, which resulted in collapse of the nose landing gear during taxi. Contributing to the accident was the improper design of the nose landing gear attachment structure.NTSB ERA12LA268Accident · No injuriesLimited investigationFinal reportHawker Beechcraft C90GTX · Caribbean Sea, A1A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…NTSB ERA12LA267Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eastover, SCInadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…NTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12LA228Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Corpus Christi, TXThe failure of the bolt that retained the clutch drive rod end, which resulted in a loss of main rotor drive and a subsequent hard landing.NTSB ERA12FA265Accident · Serious injuriesField investigationFinal reportSapp Larry E Seawind 3000 · Deland, FLA total loss of engine power for reasons that could not be determined because the damage and postimpact fire precluded thorough examination of the engine and its systems.NTSB ERA12CA266Accident · No injuriesData collectionFinal reportPiper PA-60-602P · Philadelphia, PAThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.