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 OPS11IA054Incident · No injuriesIncident investigationFinal reportDassault FALCON900EX · Teterboro, NJThe pilot of the F900 overshooting of the final approach course, which conflicted with traffic in the pattern. Contributing to the accident was the lack of appropriate coordination between the tower controller and the approach controller.NTSB ERA11WA031Accident · 5 fatalForeign investigationCessna TU206G · Medellin, ColombiaOn October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…NTSB ERA11CA034Accident · Minor injuriesData collectionFinal reportBoeing A75 · Douglas, GAA nose-over due to excessive brake application.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB WPR11CA028Accident · No injuriesData collectionFinal reportCessna 195 · Wells, NVThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.NTSB CEN11CA038Accident · No injuriesData collectionFinal reportCessna 182L · Mancelona, MIA loss of engine power in flight due to the failure of the engine's No. 5 piston.NTSB WPR11WA020Accident · 2 fatalForeign investigationCessna 172 · Durham Downs, Australia, AustraliaOn October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…NTSB WPR11IA019Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZThe overextension of the main cabin door due to difficulty opening the door because the power-assist motor cable was lodged within the main cabin door assembly.NTSB ERA11LA025Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Warren, VTThe pilot's inadvertent deployment of the airbrake handle past the upper limit of its normal operating range, which resulted in binding of the controls.NTSB ERA11IA026Incident · No injuriesIncident investigationFinal reportShort Bros. & Harland Shorts SC7 Skyvan · Fort Lauderdale, FLThe flightcrew’s failure to maintain directional control while initiating an engine reverse after landing.NTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.NTSB CEN11FA029Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Sebewaing, MIThe pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.NTSB ANC11LA004Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sitka, AKA lightning strike which resulted in substantial damage to the elevator.NTSB ERA11LA023Accident · Serious injuriesLimited investigationFinal reportBobo Christopher J Loehle 5151 · Southern Pines, NCThe reported fluttering of the wings in flight and the pilot's subsequent in-flight loss of control for undetermined reasons.NTSB ERA11FA021Accident · 1 fatalField investigationFinal reportSiai-Marchetti S.205/22R · Farmingdale, NYA loss of engine power during a low approach for undetermined reasons.NTSB ERA11CA077Accident · Serious injuriesData collectionFinal reportAntares MA-33M R582 · Rising Fawn, GAThe student pilot's failure to relinquish control of the weight-shift control aircraft to the certified flight instructor, which resulted in an inadvertent stall.NTSB ERA11CA035Accident · No injuriesData collectionFinal reportBoeing PT17 · Fayetteville, WVThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA11CA024Accident · Minor injuriesData collectionFinal reportCessna 180 · Summner, METhe pilot's failure to maintain adequate airspeed while on final approach resulting in an aerodynamic stall and a subsequent hard landing.NTSB CEN11CA035Accident · Minor injuriesData collectionFinal reportBorne Charles A III RV-4 · Los Lunas, NMThe pilot's improper flare, which resulted in a hard landing and loss of directional control.NTSB CEN11CA032Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rose Hill, KSThe pilot's improper touchdown point during landing, which resulted in a runway overrun.NTSB WPR11LA017Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Cottonwood, AZThe paraglider pilot's failure to see and avoid the hot air balloon, which resulted in a midair collision.NTSB WPR11CA018Accident · Minor injuriesData collectionFinal reportDeitz Avid Flyer MK4 · Colville, WAThe pilot's failure to compensate for a wind gust and maintain runway alignment during final approach to land, which resulted in an in-flight collision with a tree.NTSB ERA11LA022Accident · 2 fatalLimited investigationFinal reportNewcomer RV6 · Monticello, GAThe pilot's loss of aircraft control during the initial climb.NTSB CEN11CA028Accident · Minor injuriesData collectionFinal reportWeddington Double Eagle · Temple, TXThe loss of engine power for undetermined reasons.NTSB CEN11CA022Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COThe student pilot’s failure to maintain directional control of the helicopter during landing.NTSB ANC11CA003Accident · No injuriesData collectionFinal reportPiper PA-12 · Merrill Field Airport, AKThe certificated flight instructor's failure to apply the correct remedial actions to maintain directional control during the takeoff roll.NTSB ERA11WA032Accident · 4 fatalForeign investigationCessna 172N · Malaga, ColombiaOn October 15, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna 172N, Columbian registration HK4631, operated by Aerolineas Alas de Columbia, impacted terrain near the town of Malaga, Santander, Columbia. The flight was en route from Lebrija,…NTSB CEN11WA070Accident · 8 fatalForeign investigationBell 212 · Minatitlan Veracruz, MexicoThe government of Mexico has notified the NTSB of an accident involving a BELL 212 helicopter that occurred on October 15, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN11RA024Accident · 4 fatalForeign investigationBeech A36 · Ensenada, MexicoOn October 15, 2010, at 2200 coordinated universal time (1400 local), a Beech A36, US registered N212DB, owned by Lyon Roger C Trustee and piloted by an instrument rated private pilot, was destroyed when it impacted terrain under unknown circumstances near…NTSB CEN11GA020Accident · 1 fatalFinal reportBell 206B · Clarkson Valley, MOThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…NTSB CEN11CA037Accident · No injuriesData collectionFinal reportCessna 182K · Henderson, TXThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in a hard landing.NTSB CEN11CA021Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Almyra, ARThe pilot’s improper touchdown point and delayed decision to execute a go-around, which resulted in a runway overrun and collision with terrain.NTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.NTSB WPR11LA015Accident · Serious injuriesLimited investigationFinal reportMischke BD-5B · Burlington, WAThe failure of the sprag clutch during takeoff, resulting in a loss of engine thrust.NTSB CEN11WA096Accident · No injuriesForeign investigationPiper PA36 · Alcora, SpainOn October 14, 2010, about 0945 coordinated universal time (UTC), a Piper PA-36 agricultural airplane, EC-EJR, lost engine power and conducted a forced landing near Alcora, Spain. The airplane was substantially damaged and the pilot was not injured. This…NTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.NTSB CEN11LA023Accident · Serious injuriesLimited investigationFinal reportBell 206B · Newton, TXThe pilot’s attempted takeoff with the fuel hose attached to the helicopter and the pilot and ground crew’s failure to accurately communicate.NTSB CEN11CA030Accident · No injuriesData collectionFinal reportConrad Theodore J Thorp T-18 · Fredericksburg, TXThe malfunction of the throttle clamp, which resulted in the pilot's inability to control the engine's power setting.NTSB WPR11CA014Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Palm Springs, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop.NTSB WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.NTSB ERA11CA018Accident · Minor injuriesData collectionFinal reportLong EZ · Leesburg, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB DCA11WA003Accident · 8 fatalForeign investigationLockheed L-100 · Kabul, AfghanistanOn October 12, 2010, about 1505 UTC, a Trans Afrique Airlines (under contract to National Air Cargo) Lockheed L-100, registration 5X-TUC, impacted terrain while maneuvering to land at Kabul International Airport (OAKB), Kabul Afghanistan. The two flight crew…NTSB WPR11LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Portland, ORThe pilot's inadequate preflight inspection and failure to ensure adequate fuel was onboard for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA017Accident · No injuriesData collectionFinal reportCessna 120 · Falls Village, CTThe pilot’s failure to abort the takeoff, which resulted in an in-flight collision with terrain.NTSB CEN11LA014Accident · Serious injuriesLimited investigationFinal reportDrake Ronald A Acro Sport 1 · Fowlerville, MIThe pilot's loss of control during a go-around maneuver following a bounced landing. Contributing to the accident was the pilot's limited experience in the make and model airplane.NTSB CEN11CA071Accident · No injuriesData collectionFinal reportGrumman G-164 · Michigan, NDThe pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.NTSB CEN11CA017Accident · Serious injuriesData collectionFinal reportLuscombe 8D · Clarrisa, MNThe partial loss of engine power for undetermined reasons.