NTSB investigations, 2010
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WPR11LA013Accident · No injuriesLimited investigationFinal reportBeech C24 · Blanding, UTThe pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.NTSB ERA11LA015Accident · No injuriesLimited investigationFinal reportCessna 172SP · Boynton Beach, FLThe loss of engine power for undetermined reasons.NTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.NTSB ENG11RA001Incident · No injuriesForeign investigationBoeing 747 · Seoul, South KoreaOn October 10, 2010, Korean Air Boeing 747-400 registered in Korea as HL7489, experienced an uncontained release of turbine material from the No. 3 engine, a Pratt & Whitney PW4056 engine. About 40 minutes after takeoff, the crew observed engine vibrations…NTSB CEN11CA026Accident · No injuriesData collectionFinal reportCessna 180 · Farmington, NMThe failure of the pilot and the flight instructor to maintain directional control of the airplane during a training maneuver.NTSB CEN11CA010Accident · Minor injuriesData collectionFinal reportMartin Curtis Zenair CH701 SP · Lonsdale, MNThe pilot's failure to maintain clearance from a power line while on approach to land.NTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.NTSB ERA11LA014Accident · 1 fatalLimited investigationFinal reportEngineering & Research Ercoupe 415-D · Lawrenceville, GAInadequate maintenance performed on the airplane, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the corrosion within the carburetor.NTSB CEN11CA039Accident · No injuriesData collectionFinal reportAeronca 7AC · Mount Vernon, MOThe pilot's loss of directional control while taxiing.NTSB WPR11LA004Accident · 1 fatalLimited investigationFinal reportBeech A35 · Blue Diamond, NVThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11LA003Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scappoose, ORThe student pilot’s failure to maintain helicopter control during the landing flare and his subsequent interference with the flight instructor's control inputs. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.NTSB ERA11CA013Accident · Minor injuriesData collectionFinal reportPiper PA28 · Louisville, KYThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and loss of engine power.NTSB CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.NTSB CEN11CA015Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Richmond, INThe pilot's diverted attention to a landing gear indicator light that led to a loss of directional control and subsequent impact with terrain while taxiing.NTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.NTSB ERA11CA012Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLAn inadvertent in-flight collision with a bird.NTSB CEN11WA013Accident · No injuriesForeign investigationCessna 501 · Veracruz, MexicoOn October 6, 2010, at an unknown time, a Cessna Citation 501 airplane, XA-TKY disappeared shortly after takeoff near Veracruz, Mexico. There were eight passengers and crew aboard the airplane when it went missing. The airplane was over water at the time of…NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB CEN11FA007Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Naperville, ILThe pilot’s failure to abort the takeoff when he realized the airplane was not attaining sufficient takeoff and climb performance. Contributing to the accident was the airplane’s partial loss of engine power due to an obstruction of the fuel servo air inlet…NTSB ERA11WA008Accident · 9 fatalForeign investigationCessna 402 · Nassau, BahamasOn October 5, 2010, about 1236 Atlantic standard time, a Cessna 402C, Bahamian registration C6-NLH, registered to and operated by Lebocruise Air Limited, crashed into Lake Killarney shortly after takeoff from the Lynden Pindling International Airport (MYNN),…NTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.NTSB CEN11CA006Accident · No injuriesData collectionFinal reportRockwell International S-2R · Texarkana, ARThe loss of engine power due to cracked engine cylinder.NTSB ERA11CA010Accident · Serious injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYThe passenger's loss of balance while deplaning.NTSB ERA11CA007Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Taylorsville, KYThe pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.NTSB WPR11FA002Accident · Serious injuriesField investigationFinal reportCessna 310 · Avalon, CAThe pilot's improper setting of the left engine fuel selector valve, which resulted in fuel starvation of the left engine immediately after takeoff. Contributing to the accident was the pilot's decision to try to depart ahead of developing weather, which…NTSB ERA11WA041Accident · 2 fatalForeign investigationPiper PA38 · Buenos Aires, ArgentinaOn October 3, 2010, about 1920 Universal Coordinated Time (UTC), a Piper PA-A-38-112, Argentinean registration LV-MNO, crashed into terrain during an instructional flight near Marcos Paz, Argentina. The local training flight originated from San Fernando…NTSB DCA11WA002Accident · No injuriesForeign investigationBoeing 767 · Bristol, United KingdomOn October 3, 2010, at 0541 UTC, a Thompson Airways Boeing 767 experienced a hard landing at Bristol International Airport (BRS), Bristol, England. The aircraft was completing a flight from Cancun International Airport (CUN), Cancun, Mexico. Upon parking,…NTSB CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.NTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.NTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ERA11WA004Accident · 6 fatalForeign investigationCessna 185 · Nazca, PeruOn October 2, 2010, about 2102 Universal Coordinated Time (UTC), a Cessna 185, Peruvian registration OB-1808, operated by Air Nasca S.A.C., on a commercial air tour flight, was substantially damaged, when it impacted terrain after a loss of power during…NTSB DCA11WA001Incident · No injuriesForeign investigationBoeing 737 · Amsterdam, NetherlandsOn October 2, 2010, Turkish Airlines flight CAI603, a Boeing 737-400, registered in Turkey as TC-TJF, overran runway 22 at Schiphol Airport (EHAM), Amstedam, the Netherlands. Only the nose landing gear exited the paved surface and the airplane was undamaged.…NTSB CEN11LA005Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Magnolia, ARThe mechanic's failure to properly install an oil drain line after he replaced a cylinder, which caused the engine to seize in flight due to a lack of lubrication.NTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.NTSB CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB CEN11CA016Accident · Minor injuriesData collectionFinal reportKevin Wilkinson Easy Eagle 1 · Central City, NEThe loss of engine power for undetermined reasons.NTSB ANC11CA001Accident · No injuriesData collectionFinal reportPiper PA-12 · Chena Hot Springs, AKThe pilot's inadequate compensation for the wind conditions during landing, which resulted in a loss of directional control and collision with trees.NTSB WPR10LA481Accident · No injuriesLimited investigationFinal reportEurocopter EC130 · Meadview, AZThe pilot's distraction with another departing helicopter while maneuvering in a hover for departure, which resulted in his failure to maintain clearance between the tail rotor and an umbrella.NTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.NTSB ERA11LA003Accident · Minor injuriesLimited investigationFinal reportYost Edwin S Glasair SH-2 · Jackson, GAThe pilot's loss of aircraft control for undetermined reasons.NTSB ERA11IA006Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe pilot-in-command's failure to attain the proper touchdown point while landing with a gusting crosswind and failure to initiate a go-around, which resulted in a landing more than halfway down the runway and a subsequent runway overrun. Contributing to the…NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB ERA11CA002Accident · No injuriesData collectionFinal reportFleet 16B · Lake City, SCThe pilot’s improper use of the brakes while taxiing.NTSB CEN11CA004Accident · No injuriesData collectionFinal reportCessna 172N · Wabash, INThe student pilot's failure to maintain proper airspeed during the landing and certificated flight instructor's failure to execute a go-around.NTSB CEN11CA003Accident · Minor injuriesData collectionFinal reportCessna 310J · St. Johns, MIThe failure by the pilot to attain/maintain a climb rate for undetermined reasons during a go-around.NTSB CEN11CA002Accident · No injuriesData collectionFinal reportGingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, INThe total loss of engine power for undetermined reasons.NTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.NTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.NTSB WPR10CA478Accident · No injuriesData collectionFinal reportRobinson R22 · Portland, ORThe student pilot's decision to hover-taxi behind a jet, resulting in the helicopter encountering jet wash and rolling over.