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 ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.NTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB ANC10FA100Accident · 4 fatalField investigationFinal reportDehavilland DHC-2 · Katmai National Park, AKUndetermined.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB DCA10WA097Incident · No injuriesForeign investigationBoeing 737 · Venice, ItalyOn August 20, 2010, a Jet4You Boeing 737-400, registration CN-RPA, conducted an emergency descent after experiencing a rapid decompression. The flight continued on to its destination at 10,000 feet. There were no injuries to the 6 crew members onboard and the…NTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.NTSB CEN10CA499Accident · No injuriesData collectionFinal reportCessna 182P · Del Rio, TXThe pilot's failure to monitor his altitude while making a visual approach, which resulted in landing short of the runway and subsequent collision with terrain.NTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.NTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.NTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.NTSB ANC10CA075Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Talkeetna, AKThe pilot’s failure to maintain aircraft control during an off airport landing.NTSB WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.NTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA10CA436Accident · No injuriesData collectionFinal reportCessna 414 · Bedford, PAThe pilot's failure to establish a proper climb gradient during a departure in instrument meteorological conditions, which resulted in a collision with trees.NTSB CEN10LA494Accident · No injuriesLimited investigationFinal reportCessna 310F · LaGrange, INThe pilot did not maintain altitude due to his distracted attention to a vibration of unknown origin.NTSB CEN10LA489Accident · No injuriesLimited investigationFinal reportMeyers Industries 200C · Justin, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB ANC10LA074Accident · No injuriesLimited investigationFinal reportCessna U206G · Homer, AKThe loss of engine power for an undetermined reason, resulting in an off-airport emergency landing and subsequent nose over.NTSB WPR10LA411Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 · Leavenworth, WAThe pilot's failure to adequately evaluate the airport and its environment in relation to the aircraft’s performance, which resulted in the airplane's failure to attain sufficient altitude to clear trees during the initial climb.NTSB WPR10CA410Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Genesee, IDThe pilot’s failure to maintain clearance from terrain during low-altitude maneuvering.NTSB WPR10CA409Accident · No injuriesData collectionFinal reportCessna TP206B · Saint Maries, IDA loss of aircraft control during takeoff due to an inadvertent collision with a deer that ran onto the runway.NTSB ERA10LA431Accident · 1 fatalLimited investigationFinal reportMaxair MU 582 Drifter · Old Forge, NYThe pilot's failure to use the full length of the lake, which necessitated a steep turn to avoid obstacles during takeoff that resulted in an accelerated stall.NTSB ERA10CA433Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilots' inadequate fuel planning, resulting in the loss of engine power due to fuel exhaustion.NTSB ERA10CA432Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe instructor's delayed remedial action, which resulted in a loss of rotor rpm and a hard landing.NTSB CEN10LA529Accident · Serious injuriesLimited investigationFinal reportPiper Aerostar 601P · Baraboo, WIThe pilot's diverted attention during an approach for landing that resulted in an altitude loss and impact with terrain.NTSB CEN10LA496Accident · No injuriesLimited investigationFinal reportCessna 182T · Mosby, MTA partial loss of engine power for undetermined reasons during an en route climb.NTSB ANC10CA070Accident · No injuriesData collectionFinal reportChampion 7EC · Soldotna, AKThe pilot’s failure to maintain adequate airspeed during the initial climb.NTSB DCA10FA090Accident · Serious injuriesField investigationFinal reportBoeing 767 · Dulles, VAan in-flight encounter with turbulence that resulted in an injury to a cabin attendant.NTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportNTSB WPR10LA408Accident · No injuriesLimited investigationFinal reportBeech V35B · Sacramento, CAA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to ensure that the fuel cap was secured during the preflight inspection.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB WPR10LA406Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Douglas, WYThe pilot's failure to maintain clearance from the terrain while maneuvering during an aerial observation flight.NTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.NTSB ERA10CA425Accident · No injuriesData collectionFinal reportRyan Navion B · Fort Myers, FLThe binding of the trim wheel on the instrument panel and the pilot’s improper decision to depart with a known mechanical deficiency.NTSB DCA10RA085Accident · 1 fatalForeign investigationBoeing 737 · San Andres Island, ColombiaOn August 16, 2010, at 0150 UTC, an Aires B737-700, registration HK4682, crashed on approach to the San Andres Island Airport in San Andres Island, Colombia. Of the 121 passengers and 6 crew on board, preliminary reports indicate that there was one fatality…NTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.NTSB ERA10LA426Accident · Minor injuriesLimited investigationFinal reportCessna 172NA total loss of engine power for undetermined reasons.NTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.NTSB ERA10CA427Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Erwin, NCThe pilot's excessive use of spoiler on final approach, which resulted in a landing short of the runway.NTSB ENG10RA047Incident · No injuriesForeign investigationMcdonnell Douglas MD90 · Sendai, JapanOn August 15, 2010, at 16:10 Japan standard time (07:10 UTC), a Japan Air Lines Boeing MD90-30, registered in Japan as JA002D, experienced an engine fire in the right engine, an International Aero Engine (IAE) V2525-D5, shortly after takeoff from Sendai,…NTSB CEN10CA528Accident · No injuriesData collectionFinal reportClem William B III Dominator Gyrocopter · Brighton, COThe pilot's failure to maintain control of the gyroplane during landing.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.NTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.NTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.NTSB ERA10LA422Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC12-D · Harrison, METhe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.