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 ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…NTSB ERA10LA506Accident · Serious injuriesLimited investigationFinal reportCirrus SR22 · Mathias, WVThe pilot's loss of control of the airplane during an instrument approach in turbulent weather conditions.NTSB CEN10WA583Incident · No injuriesClass 5 · ForeignCessna 680 · Bedfordshire, United KingdomOn September 30, 2010, at 0825 universal coordinated time (UTC), a Cessna 680, G-CJCC, operated by Bookajet, experienced a left main bus electrical system fault, approximately 20 minutes after taking off from Luton Airport (EGGW), en route to the Milas-Bodrum…NTSB WPR10IA482Incident · No injuriesIncident investigationFinal reportBeech F90 · Idaho Falls, IDThe partial retraction/collapse of the main landing gear during the landing roll for undetermined reasons.NTSB ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.NTSB CEN10LA586Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Deming, NMThe loss of engine power for undetermined reasons.NTSB CEN10CA578Accident · No injuriesData collectionFinal reportCessna 172B · Oconomowoc, WIThe pilot's selection of unsuitable terrain for landing the float-equipped airplane on a turf runway.NTSB ANC10CA103Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe student pilot's selection of unsuitable terrain for an off-airport landing, resulting in the airplane nosing over.NTSB WPR10LA477Accident · Minor injuriesLimited investigationFinal reportEccker Hurricane Hauler · Jamul, CAThe loss of engine power during cruise flight due to engine seizure as a result of lack of lubrication from excessive carbon buildup on the piston rings.NTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.NTSB ENG10IA055Incident · No injuriesIncident investigationFinal reportBombardier CL600 2B19 · Milwaukee, WIThe failure of the left main landing gear (MLG) to extend normally and manually for reasons that could not be conclusively determined.NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB CEN10CA577Accident · No injuriesData collectionFinal reportCessna T182T · Downers Grove, ILThe pilot's improper airspeed during landing, which resulted in a runway overrun, and his delayed decision to execute a go-around.NTSB CEN10CA576Accident · No injuriesData collectionFinal reportCessna 172M · Belle Plaine, MNThe pilot's loss of directional control due to an encounter with soft terrain while landing.NTSB WPR10FA473Accident · 1 fatalField investigationFinal reportHawker Beechcraft F33 · Phoenix, AZA partial loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC10CA099Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Kenai, AKThe student pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during cruise flight.NTSB WPR10CA471Accident · No injuriesData collectionFinal reportCessna 195 · Prescott, AZThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion.NTSB WPR10CA470Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.NTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.NTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.NTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.NTSB CEN10CA569Accident · Minor injuriesData collectionFinal reportCentral Ohio Dragonfly Clubllc DRAGONFLY-C · Orient, OHThe pilot's failure to disconnect the tow bridal line prior to takeoff.NTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…NTSB ERA10CA505Accident · No injuriesData collectionFinal reportCessna 172S · Franconia, NHThe pilot’s delay in initiating a go-around, which resulted in an in-flight collision with a fence.NTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoNTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.NTSB CEN10LA566Accident · Minor injuriesLimited investigationFinal reportHolmes Gary Don Rutan LONG-EZ · Yellow Springs, OHThe loss of engine power for undetermined reasons.NTSB CEN10LA558Accident · 1 fatalLimited investigationFinal reportWorthington Rotorway · Pattison, TXThe pilot's failure to maintain main rotor rpm, which resulted in an uncontrolled descent and collision with terrain.NTSB CEN10CA562Accident · Minor injuriesData collectionFinal reportCessna 172M · Point Lookout, MOThe pilot receiving instruction's failure to attain the proper touchdown point and execute a go-around and the CFI’s delayed remedial action, which resulted in a runway overrun.NTSB WPR10WA484Accident · 1 fatalForeign investigationChampion 8KCAB · Bandung, Indonesia, IndonesiaOn September 24, 2010, at 0312 universal coordinated time, an American Champion Super Decathlon 8KCAB, PK-NZP, collided with terrain while performing an inverted aerobatic maneuver at low altitude during an air show at Husein Sastranegara Airport, Bandung,…NTSB WPR10CA469Accident · No injuriesData collectionFinal reportPiper PA-18-150 · White Sulphur Springs, MTThe pilot's failure to maintain control of the airplane during a go-around in turbulent wind conditions, which resulted in a collision with trees.NTSB ERA10TA501Accident · Minor injuriesFinal reportEurocopter AS-350 · Covington, GAThe flight instructor's loss of control of the helicopter during the intentional demonstration of a low speed, hydraulics-off maneuver, that was warned against in the helicopter manufacturer's flight manual.NTSB ERA10LA499Accident · Serious injuriesLimited investigationFinal reportBell OH-58A · Taylorsville, MSA total loss of engine power while maneuvering at low altitude for undetermined reasons.NTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.NTSB ENG12RA005Accident · Minor injuriesForeign investigationAirbus A319 - 132 · Palermo (Sicily), ItalyNTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB CEN10FA557Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Woodruff, WIThe pilot's decision to attempt an instrument approach in turbulent night instrument meteorological conditions with a recently-identified deficiency with his instrument flight proficiency, which resulted in a loss of airplane control as a result of spatial…NTSB CEN10CA570Accident · Minor injuriesData collectionFinal reportSix Chuter SR7 Skye Ryder · Sarcoxie, MOThe non-rated pilot's failure to maintain aircraft control during landing.NTSB ANC10CA098Accident · No injuriesData collectionFinal reportCessna 180C · Anchorage, AKThe pilot's failure to compensate for the gusting wind during takeoff, which resulted in a loss of control and impact with water.NTSB ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB ERA10CA513Accident · No injuriesData collectionFinal reportPiper PA34 · Northampton, MAThe pilot's improper recovery from a bounced landing.NTSB ENG10RA054Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn September 25, 2010, a Southern Air Transport Boeing 747-281F, Reg. No. N758SA, experienced an uncontained LPT failure of the GE CF6-50 engine in the No. 3 position during taxi for takeoff from Frankfurt International Airport, Frankfurt, Germany. The No. 3…NTSB CEN10LA555Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pocahontas, ARThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the weight of the airplane and the high ambient temperature.NTSB WPR10CA467Accident · Minor injuriesData collectionFinal reportSport Plane Dynamics Lightning · Glendale, AZThe pilot's improper flare, which resulted in a bounced landing and loss of directional control.NTSB ERA10TA493Accident · Minor injuriesFinal reportBell 412 · Brooklyn, NYThe fatigue fracture of the reduction gearbox output drive gear, which resulted in the loss of power output from the engines to the helicopter rotor blade system and a subsequent forced landing. The fracture of the output drive gear was caused by a fatigue…NTSB ERA10CA497Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Castle, VAThe pilot's delayed decision to abort the takeoff, which resulted in a collision with terrain.NTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.NTSB DCA10WA098Incident · No injuriesForeign investigationMcdonnell Douglas MD-11F · Kabul, AfghanistanOn Sept 22, 2010, a World Airways MD-11 scraped the right wingtip during a go-around at Kabul Afghanistan. The aircraft had minor damage and there were no injuries. The investigation is being conducted by the Civil Aviation Authority of Afghanistan. All…NTSB CEN10LA563Accident · No injuriesLimited investigationFinal reportCessna 172S · Longmont, COThe pilot's inadequate landing flare and improper recovery from a bounced landing.