NTSB investigations, 2010
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB ERA11WA090Accident · 2 fatalForeign investigationHawker Beechcraft TC-45J · Nassau, BahamasOn December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…NTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB ERA11LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · St. ThomasThe pilot's failure to maintain an adequate visual lookout while taxiing.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB DCA11WA018Incident · No injuriesForeign investigationBoeing 737 · Rio De Janiero, BrazilThe aircraft stopped to climb to cruising level at level 330, because the pilots realized that the pressurization system was not working properly. The "CABIN RATE OF CLIMB" was indicating +500ft/min, the "ALT CABIN INDEX" 8.0, and the differential pressure…NTSB CEN11IA111Incident · No injuriesIncident investigationFinal reportCessna 560XL · Birmingham, ALThe manufacturer's inadequate initial design and inadequate subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during operations in subfreezing temperatures, resulting in a loss of rudder authority…NTSB CEN11IA108Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Columbus, OHThe failure of water to properly drain through the fuselage drain holes, thus becoming trapped and freezing around the flight control cables, which resulted in the loss of control authority to the airplane's ailerons, elevator, and rudder.NTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.NTSB DCA11WA067Incident · No injuriesForeign investigationBoeing 747 · Medina, Saudi ArabiaOn December 12, 2010, a Boeing 747-400, Saudi registration HZ-AWA1, serial number 27672, operated by Alwafeer Air as flight 1336, exited the left side of the runway after landing at Prince Mohammed Airport, Medina, Saudi Arabia. Two of the right hand main…NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.NTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.NTSB CEN11WA269Accident · No injuriesForeign investigationEurocopter AS-350-B2 · Pickle Lake, Ontario, CanadaOn December 10, 2010, about 0900 eastern standard time, a Canadian registered Eurocopter AS-350-B2, C-FORS, operated by Forest Helicopters, sustained substantial damage during an autorotation landing after a loss of engine power during takeoff near Pickle…NTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB OPS11IA173Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Covington, KYThe local controller's distraction with a helicopter south of the field.NTSB ERA11WA089Accident · 4 fatalForeign investigationBeech 95-B55 · Bom Jesus do Galho City, BrazilOn December 9, 2010, about 2135 universal coordinated time, a Hawker Beech Aircraft 95-B55, Brazilian registration PT-LEU, experienced an engine failure, impacted the terrain, and was destroyed by a post crash fire in Bom Jesus do Galho City, Minas Gerais,…NTSB CEN11WA107Accident · No injuriesForeign investigationCessna 750 · Finningley, United KingdomOn December 9, 2010, at 1022 hours universal coordinated time, a Cessna 750, G-CDCX, sustained substantial damage when the right main landing gear collapsed during landing at Robin Hood Doncaster Sheffield Airport (EGCN), Finningley, South Yorkshire, United…NTSB CEN11WA105Accident · 2 fatalForeign investigationRobinson R22 · Tourrettes-sur-Loup, FranceOn December 9, 2010, at 0755 coordinated universal time, a Robinson R22, United Kingdom registered G-CBVL, operated by Spiral Wing, Ltd., was destroyed when it impacted mountainous terrain under unknown circumstances near Tourrettes-sur-Loup, France. Visual…NTSB CEN11LA102Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Willard, OHA total loss of engine power during cruise flight due to fatigue failure of a cylinder exhaust spring.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyOn December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…NTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.NTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.NTSB ERA11CA080Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Canal Point, FLPilot fatigue due to lack of sleep resulting in incapacitation (falling asleep) and ground contact while maneuvering at a low altitude.NTSB DCA11WA017Incident · No injuriesForeign investigationBoeing B737 · Brasilia, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 8, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB CEN11IA114Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 40 · Colorado Springs, COFatigue failure of the nose wheel fork, which resulted in separation of the nose wheel.NTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB ENG11WA006Incident · No injuriesForeign investigationBoeing 777 · Lisbon, Portugal, PortugalOn December 6, 2010, at 11:15 local time, an Angola Airlines (TAAG)Boeing 777-2M2ER, powered by two General Electric GE90-94B Turbofan engines experienced a No. 2 (right) engine low pressure turbine failure after takeoff from the Lisbon International Airport…NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB CEN11LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-47UF · Chicago, ILThe Boeing 747 first officer’s failure to maintain clearance from another airplane while taxiing due to his inadequate judgment of the distance between the airplanes.NTSB WPR11CA072Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Pullman, WAThe pilot's delayed application of carburetor heat while maneuvering, which resulted in a partial loss of engine power.NTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.NTSB CEN11LA097Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Gulf of MexicoA total loss of engine power for undetermined reasons.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB WPR11LA071Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Pago Pago, AntarcticaThe airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.NTSB DCA11WA013Accident · No injuriesForeign investigationBeech 1900 · Maputo, MozambiqueOn December 3, 2010, about 2040 UTC, a Beech 1900C, C9-AUO, operated by Kaya Airlines, crashed into terrain during landing approach at Maputo International Airport, Maputo, Mozambique. Instrument meteorological conditions prevailed at the time. Of the 17…NTSB CEN11LA101Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Claremore, OKA loss of engine power on both engines for undetermined reasons.NTSB WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.NTSB WPR11LA069Accident · 1 fatalLimited investigationFinal reportSabre Trike · Peoria, AZAn in-flight loss of control for undetermined reasons.NTSB ERA11LA079Accident · Minor injuriesLimited investigationFinal reportEasler Kelly Rans S6ES · St. Augustine, FLA total loss of engine power during initial climb for undetermined reasons.NTSB CEN11LA090Accident · 1 fatalLimited investigationFinal reportSoutherland Freebird Litesport U · Decatur, ILThe pilot's reported inability to control his amateur-built airplane for undetermined reasons after the airplane inadvertently became airborne while conducting a high-speed taxi.NTSB CEN11LA089Accident · No injuriesLimited investigationFinal reportCessna 180 · Omaha, NEA loss of engine power due to a stuck check valve in the carburetor acceleration pump, resulting in an improper fuel mixture when the pilot attempted to add power.NTSB CEN11CA104Accident · No injuriesData collectionFinal reportCessna 172R · Warrensburg, MOA hard landing for undetermined reasons.NTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.