NTSB investigations, 2010
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2010 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") = 2010 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 CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.NTSB WPR10LA354Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe pilot's loss of directional control while attempting to move the helicopter laterally without first lifting it fully off its landing platform.NTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.NTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…NTSB DCA10WA078Incident · No injuriesForeign investigationBoeing 757 - 212 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-200 that occurred on July 16, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…NTSB WPR10LA352Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NVThe passenger's failure to maintain clearance from a turning propeller. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.NTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.NTSB ERA10FA359Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · North Myrtle Beach, SCThe pilot's failure to maintain aircraft control while maneuvering in instrument meteorological conditions around a thunderstorm. Contributing to the accident was the pilot's lack of recent actual instrument experience.NTSB ERA10CA368Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · St. Petersburg, FLThe pilot's loss of directional control while taking off with a crosswind.NTSB DCA10FA076Accident · Serious injuriesField investigationFinal reportBoeing 767 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with clear air turbulence.NTSB CEN10LA401Accident · 1 fatalLimited investigationFinal reportKlemme William H Zenith CH 701 · Iowa Falls, IAThe pilot’s failure to maintain adequate airspeed while on final approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the model of airplane.NTSB CEN10CA411Accident · Minor injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Blackstone, ILThe helicopter encountered a dust devil at a low altitude during the aerial application flight.NTSB ANC10LA061Accident · No injuriesLimited investigationFinal reportPiper PA-14 · King Salmon, AKThe pilot's failure to use continuous carburetor heat while operating in carburetor icing conditions, resulting in carburetor ice and subsequent partial loss of engine power.NTSB ANC10CA091Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · Skwentna, AKThe pilot's inadequate crosswind compensation, which resulted in a loss of directional control.NTSB WPR10LA349Accident · No injuriesLimited investigationFinal reportCessna 310K · El Monte, CAThe pilot’s failure to maintain directional control during the takeoff ground roll.NTSB WPR10CA350Accident · No injuriesData collectionFinal reportCessna 170 · Truckee, CAThe pilot’s failure to maintain directional control during an aborted landing, resulting in a collision with obstacles.NTSB CEN10LA416Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Krum, TXA total loss of engine power in flight due to carburetor icing.NTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.NTSB CEN10FA392Accident · 3 fatalField investigationFinal reportBeech 35C33 · Tolar, TXThe pilot's failure to maintain control of the airplane while maneuvering at night over a rural area, due to spatial disorientation.NTSB CEN10CA400Accident · Serious injuriesData collectionFinal reportCessna 182R · Thayer, INA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually check the fuel supply prior to takeoff.NTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.NTSB CEN10LA403Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Hutto, TXThe loss of engine power due to fuel starvation as a result of the pilot's failure to visually verify his fuel quantity prior to the flight.NTSB CEN10FA394Accident · 4 fatalField investigationFinal reportBeech 58 · St. Ignace, MIThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons.NTSB CEN10CA402Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Independence, IAThe pilot's failure to pay attention to the power lines and his subsequent failure to maintain clearance from the corn field during the aerial application flight.NTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…NTSB ANC10CA060Accident · No injuriesData collectionFinal reportCessna 172N · Palmer, AKThe pilot's decision to fly towards rising terrain that exceeded the climb capability of the airplane.NTSB ANC10CA059Accident · No injuriesData collectionFinal reportCessna 180J · Kakhonak, AKThe pilot's decision to take off in unfavorable wind conditions.NTSB WPR10LA345Accident · No injuriesLimited investigationFinal reportCessna 177 · Chino, CAThe pilot’s inadequate fuel planning which resulted in a loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA10LA357Accident · No injuriesLimited investigationFinal reportBeech 58 · LaGrange, GAThe pilot not allowing sufficient time for fuel spill vapors to dissipate before starting the engine. Contributing to the accident was the inadequate maintenance of the fuel cap.NTSB ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.NTSB CEN10LA399Accident · No injuriesLimited investigationFinal reportBeech V35A · Truth or Consequences, NMA total loss of engine power for undetermined reasons.NTSB CEN10FA382Accident · 3 fatalField investigationFinal reportCessna 421 · Tulsa, OKThe pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.NTSB CEN10CA391Accident · No injuriesData collectionFinal reportAir Tractor AT602 · Lake Village, ARThe pilot's failure to maintain clearance from the wires during the aerial application pass.NTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.NTSB WPR10CA344Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Dutch John, UTThe pilot’s inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB WPR10CA342Accident · No injuriesData collectionFinal reportPiper PA32RT · Sedona, AZThe pilot’s failure to maintain runway alignment during approach and subsequent loss of directional control during landing.NTSB ERA10CA352Accident · No injuriesData collectionFinal reportVans RV8 · Port Orange, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN10CA407Accident · No injuriesData collectionFinal reportAeronca 7AC · Santa Fe, NMThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.NTSB CEN10CA406Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Muncie, INThe pilot's failure to see and avoid the power line during an aerial application flight.NTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.NTSB CEN10CA395Accident · No injuriesData collectionFinal reportBell OH-58A · Roswell, NMThe pilot's failure to maintain clearance from transmission wires.NTSB CEN10CA388Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Waynesville, OHThe student pilot's delayed decision that resulted in insufficent altitude to return to the departure airport.NTSB CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.NTSB WPR10LA343Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Whitehall, MTA loss of engine power for undetermined reasons.NTSB CEN10LA404Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Deshler, OHA loss of engine power for undetermined reasons.