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 ERA10LA421Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Key West, FLThe non-instrument-rated pilot's spatial disorientation during night, over-water, low-ambient-light conditions, which resulted in the airplane impacting the ocean.NTSB ERA10CA420Accident · Minor injuriesData collectionFinal reportCessna 150A · West Liberty, KYThe pilot's premature turn toward trees during the initial climb. Contributing to the accident was the airplane's high gross weight and density altitude that precluded a normal takeoff and climb.NTSB CEN10LA487Accident · No injuriesLimited investigationFinal reportShpakow Thomas SA 750 · Brighton, COThe radio-controlled airplane operator’s decision to maneuver his airplane outside of the designated operating area, resulting in a collision with a bi-plane. Contributing to the accident was the lack of a formally designated spotter.NTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.NTSB CEN10CA485Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Mack, COThe flight instructor's failure to maintain control of the helicopter during a practice autorotation, which resulted in a hard landing.NTSB CEN10CA480Accident · Serious injuriesData collectionFinal reportBuckeye Industries Dream Machine · Seymour, INAn inadvertent encounter with turbulence which exceeded the performance capability of the powered parachute.NTSB CEN10CA479Accident · No injuriesData collectionFinal reportBeech A23-19 · Wichita, KSThe pilot’s loss of airplane control while landing with a gusting wind.NTSB WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR10CA401Accident · Minor injuriesData collectionFinal reportCessna 180D · Hillsboro, ORA loss of engine power due to fuel starvation resulting from unporting when the pilot entered into a slip during the turn to the final approach leg.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB ERA10CA419Accident · No injuriesData collectionFinal reportSchweizer SGS 1-34 · Groveland, FLThe pilot’s failure to attain the proper approach path to the runway, resulting in landing short of the runway.NTSB CEN10LA482Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Put-in-Bay, OHA total loss of engine power while on final approach for undetermined reasons.NTSB CEN10LA477Accident · No injuriesLimited investigationFinal reportBell 206B · Rocky Mount, MOA dynamic rollover inadvertently induced by the pilot during landing.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB ERA10WA428Accident · 4 fatalForeign investigationRobinson R44 · Milazzo, ItalyOn August 12, 2010, about 0600 Universal Coordinated Time (UTC), a Robinson R44, Italian registration I-KOST, operated by Intesa Leasing, Rent and Fly, as a personal flight, collided with a building and the ground during takeoff from a private field at…NTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.NTSB ERA10CA417Accident · No injuriesData collectionFinal reportPiper PA-25-260 · St. Petersburg, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN10LA492Accident · Serious injuriesLimited investigationFinal reportInfinity Infinity · Little Rock, ARThe failure of the control lanyard for undetermined reasons.NTSB CEN10LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Winnfield, LAA loss of engine power due to fuel exhaustion.NTSB ANC10FA069Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s continued visual flight into instrument meteorological conditions and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain.NTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.NTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB CEN10LA475Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Silver City, NMThe pilot's loss of directional control during takeoff and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.NTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB WPR10LA395Accident · No injuriesLimited investigationFinal reportEmbraer EMB-145XR · Salt Lake City, UTAn in-flight collision with a bird while on the downwind leg of the traffic pattern during a visual approach.NTSB WPR10LA393Accident · Minor injuriesLimited investigationFinal reportPiper PA18A · Billings, MTThe pilot's inadequate compensation for the wind conditions and failure to maintain lateral and directional control of the airplane during landing.NTSB ERA10LA424Accident · No injuriesLimited investigationFinal reportW.H. Hunnicutt Hobo · Fletcher, NCA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site.NTSB ERA10LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Eastman, GABoth pilots’ failure to use emergency checklist procedures for restarting the engine after the loss of engine power due to fuel starvation.NTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.NTSB CEN10WA471Accident · No injuriesForeign investigationCirrus Design SR20 · Oxfordshire, United KingdomNTSB WPR10CA394Accident · Minor injuriesData collectionFinal reportCessna 170 · Salt Lake City, UTThe pilot’s failure to maintain aircraft control during the landing roll.NTSB ERA10CA413Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe student pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ERA10CA412Accident · No injuriesData collectionFinal reportMooney M20M · Poughkeepsie, NYThe pilot's improper flare which resulted in a hard landing, loss of directional control and runway excursion.NTSB ERA10CA411Accident · No injuriesData collectionFinal reportPiper PA28 · Marshfield, MAThe pilot's failure to maintain clearance from a vehicle while taxiing. Contributing to the accident was his inadequate visual lookout.NTSB DCA10LA083Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170 100 SE · Summit, MSthe abrupt maneuver that was appropriately initiated to comply with the TCAS resolution advisory caused by the momentary projected loss of separation from converging traffic. Contributing to the accident was a passenger's decision to disregard the seatbelt…NTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…NTSB ANC10CA072Accident · No injuriesData collectionFinal reportPiper J5C · Skwentna, AKThe pilot's failure to maintain directional control during landing, and his selection of unsuitable terrain for landing.NTSB WPR10FA388Accident · 1 fatalField investigationFinal reportDiamond HK36 · Bend, ORAn condition, which could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation, that prompted the pilot to discontinue the flight. Contributing to the accident…NTSB WPR10CA431Accident · No injuriesData collectionFinal reportHemmer MINI-MAX 1600R · Davis, CAThe airplane’s encounter with the wake turbulence of another aircraft.NTSB WPR10CA392Accident · No injuriesData collectionFinal reportCessna 172P · San Jose, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR10CA391Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Bridgeport, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10CA390Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe pilot’s failure to maintain aircraft control during final approach, resulting in a hard landing.NTSB ERA10WA415Accident · 1 fatalForeign investigationHughes 369 · Minsk, BelarusOn August 8, 2010, at 1249 coordinated universal time (1549 local time), a Hughes 369, German registration D-HDWM, was destroyed when it impacted terrain at Borovaya Airfield (UMMB), near Minsk, Belarus. The German pilot was fatally injured. The helicopter…NTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.NTSB ERA10CA407Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Aguadilla, PRThe pilot's inadequate preflight performance calculations, which resulted in the overweight helicopter's lack of hover capability out of ground effect.NTSB ERA10CA406Accident · Minor injuriesData collectionFinal reportCessna 172 · Chattanooga, TNThe student pilot's improper execution of the go-around procedure.NTSB CEN10RA511Accident · No injuriesForeign investigationPiper PA-28 · San Jose, Costa RicaOn August 8, 2010, a Piper PA-28-180, TI-AGR, was substantially damaged following an in-flight fire during a departure from the Tobias Bolaños Palma International Airport (MRPV), Favorita Norte, Pavas, Costa Rica. The pilot, the sole occupant was not injured.…NTSB CEN10LA484Accident · Serious injuriesLimited investigationFinal reportRammel Thomas W Searey · Cokato, MNSeparation of the composite skin on one of the three propeller blades that resulted in an in-flight vibration, and the pilot's failure to maintain clearance with the water while maneuvering to avoid obstacles in preparation for a precautionary landing.