NTSB investigations, 2011
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\") = 2011 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") = 2011 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 CEN11WA619Accident · No injuriesForeign investigationCessna 206 · Kumla, SwedenOn August 28, 2011, at 1606 UTC, a Cessna U206E, Swedish registration SE-FMU, was substantially damaged when the airplane lost engine power during parachute jump operations and impacted terrain during a forced landing in a field near Kumla, Sweden. The pilot…NTSB CEN11WA617Accident · 4 fatalForeign investigationRobinson R44 · St. Ferdinand, CanadaOn August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…NTSB CEN11LA688Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Berryville, TXThe pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB ERA11CA474Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot's landing at an unapproved location, which resulted in a ground fire from the engine exhaust.NTSB CEN11CA600Accident · No injuriesData collectionFinal reportCessna 182C · Grand Marais, MNThe pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.NTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.NTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…NTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.NTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.NTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB WPR11LA436Accident · No injuriesLimited investigationFinal reportTubbs S/Performance PA-18 225DD · Mile Hi Landing Strip, IDThe collapse of the left landing gear during landing for undetermined reasons.NTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.NTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.NTSB CEN11CA640Accident · No injuriesData collectionFinal reportCessna T210M · Cahokia, ILA failure of a spring in the main landing gear actuation system that prevented the landing gear from extending.NTSB ANC11CA086Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Beluga Lake, AKThe pilot's decision to takeoff with an unfavorable wind which resulted in a loss of directional control, and collision with terrain.NTSB ERA11CA471Accident · No injuriesData collectionFinal reportPayne/Foster Glasair · Ocala, FLThe failure of the tailwheel locking mechanism to remain engaged while landing in a crosswind, which resulted in a loss of directional control and runway excursion.NTSB ANC11CA085Accident · No injuriesData collectionFinal reportMaule M-5-210C · Tok, AKThe pilot's failure to go-around soon enough to preclude the necessity of a forced landing due to the airplane's inability to outclimb ascending terrain.NTSB WPR11FA404Accident · Serious injuriesField investigationFinal reportCessna 150G · Cavanaugh Bay, IDThe pilot’s failure to maintain adequate airspeed during an attempt to execute a go-around with a tailwind condition, which resulted in an aerodynamic stall and spin.NTSB WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.NTSB CEN11LA593Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Monango, NDThe pilot did not maintain adequate separation from a tree during the aerial-application flight.NTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.NTSB CEN11LA558Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Alpine, TXThe pilot’s improper flare which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to fly the airplane with a known mechanical deficiency.NTSB CEN11CA589Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Matthews, MOThe pilot's failure to maintain control of the airplane during takeoff.NTSB WPR11LA401Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cabazon, CAA total loss of left engine power due to the failure of the aft crankshaft counterweight retaining washer for reasons that could not be determined during postaccident examinations.NTSB WPR11LA400Accident · No injuriesLimited investigationFinal reportCessna 182Q · Alton, UTThe pilot’s failure to abort the takeoff in a timely manner, which resulted in insufficient altitude to clear obstructions.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR11FA395Accident · 1 fatalField investigationFinal reportMaule M-7-235C · Brookings, ORThe pilot’s improper decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in a collision with trees while on approach for landing.NTSB WPR11CA406Accident · No injuriesData collectionFinal reportCessna A185F · Polson, MTThe pilot's failure to maintain directional control during landing.NTSB WPR11CA398Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Los Banos, CAThe pilot's failure to maintain clearance from the power poles while maneuvering during low-altitude operations.NTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.NTSB CEN11LA606Accident · 1 fatalLimited investigationFinal reportBoeing A75N1(PT17) · Mt. Clemens, MIThe wing walker’s decision to release his grip of the airplane during an attempted aerial transfer from airplane to helicopter before both aircraft achieved the proper relative positioning for the transfer.NTSB CEN11LA588Accident · Minor injuriesLimited investigationFinal reportHendryx Steve/Wiley Ross Super Rebel · La Porte City, IAThe improper assembly of the aileron cable by the airplane builder.NTSB CEN11LA585Accident · 1 fatalLimited investigationFinal reportAero Commander Callair A-9B · Marshall, MIThe towplane pilot's loss of control during an aerotow operation due to the glider pilot's inability to maintain a proper position behind the towplane while encountering turbulence on initial climb.NTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB ANC11LA084Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKA loss of directional control during landing due to a rock lodged in the main landing gear wheel brake, resulting in a runway excursion and collision with terrain.NTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.NTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…NTSB ERA11LA469Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 180A · Lewiston, METhe separation of the inflation tank gas line due to an improperly positioned valve o-ring. Contributing to the accident was the use of an unapproved inflation tank.NTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.NTSB ERA11FA467Accident · 2 fatalField investigationFinal reportCessna 172M · Titusville, PAThe flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.NTSB ERA11CA478Accident · No injuriesData collectionFinal reportCano Dave Avid Flyer Mkiv · Smithville, TNThe pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.NTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.NTSB DCA11RA097Accident · No injuriesForeign investigationBoeing 737 · Resolute, CanadaOn August 20, 2011, about 1230 central daylight time (local), a Boeing 737-200, Canadian registration CGNWN, operated by First Air in a combination passenger/freight configuration as flight 6560 and equipped with Pratt & Whitney JT8D engines, impacted terrain…NTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.NTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.NTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.