Final NTSB investigations, 2011

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
    AND c.\"completionStatus\" = 'Completed'
  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.

NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…Nov 24, 2011 · N690SM · DestroyedNTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…Nov 24, 2011 · N534P · Substantial damageNTSB CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.Nov 24, 2011 · N8700M · Substantial damageNTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.Nov 24, 2011 · N203MK · Substantial damageNTSB CEN12LA087Accident · No injuriesLimited investigationFinal reportAviat A-1B · Gainesville, TXThe right main gear tire contacting the brake caliper, which resulted in an uncommanded brake effect on the wheel.Nov 23, 2011 · N252U · Substantial damageNTSB CEN12CA084Accident · No injuriesData collectionFinal reportCessna 550 · Moline, ILThe pilot's failure to maintain clearance from the parked, unoccupied airplane while taxiing. Contributing to the accident was the guidance provided by the marshaller.Nov 23, 2011 · N544PS · Substantial damageNTSB CEN12CA081Accident · No injuriesData collectionFinal reportFenton Davis DA-2A · Center, TXThe pilot’s inadequate compensation for gusty, crosswind conditions while landing, which resulted in a loss of directional control. Contributing to the accident was the pilot's lack of familiarity with the airplane.Nov 23, 2011 · N808F · Substantial damageNTSB ANC12CA010Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKA broken wheel/ski clevis pin, which allowed the ski to pivot upward and strike the right wing lift strut.Nov 23, 2011 · N121EE · Substantial damageNTSB ERA12CA082Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brooksville, FLThe pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.Nov 22, 2011 · N497DA · Substantial damageNTSB CEN12LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Princeton, MNThe inadequate installation of the threaded insert in the No. 2 cylinder spark plug hole by maintenance personnel, which resulted in a loss of engine power during initial climb.Nov 22, 2011 · N6436P · Substantial damageNTSB CEN12CA085Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Bulverde, TXThe pilot's improper glidepath while on final approach.Nov 22, 2011 · N26067 · Substantial damageNTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.Nov 20, 2011 · N131PM · Substantial damageNTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.Nov 20, 2011 · N9569Q · Substantial damageNTSB ERA12CA078Accident · No injuriesData collectionFinal reportBray Verle G JR Kitfox IV 1200 · Bunn, NCThe pilot did not attain a proper touchdown point while attempting to land with a tailwind and delayed his decision to abort the landing.Nov 20, 2011 · N6844B · Substantial damageNTSB CEN12LA076Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · New Orleans, LAA loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.Nov 20, 2011 · N211CD · Substantial damageNTSB CEN12FA073Accident · 1 fatalField investigationFinal reportSkykits Savannah VGW · Plato Center, ILThe noncertificated pilot’s decision to fly the airplane without receiving any flight instruction in the airplane, which resulted in his failure to maintain sufficient airspeed during takeoff and the subsequent aerodynamic stall.Nov 20, 2011 · N61XT · Substantial damageNTSB WPR12LA045Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boulder City, NVThe pilot's failure to maintain directional control while taxiing with a gusting crosswind.Nov 19, 2011 · N9016K · Substantial damageNTSB ERA12LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Mulberry, FLThe pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…Nov 19, 2011 · N99168 · Substantial damageNTSB ERA12CA079Accident · No injuriesData collectionFinal reportBeech C-45G · Lyman, MSThe collapse of the right main landing gear during landing due to an encounter with soft terrain.Nov 19, 2011 · N75Q · Substantial damageNTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.Nov 19, 2011 · N80775 · Substantial damageNTSB WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.Nov 18, 2011 · N741SB · Substantial damageNTSB WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.Nov 18, 2011 · N357 · Substantial damageNTSB ERA12CA075Accident · No injuriesData collectionFinal reportBellanca 17-30A · Pine Mountain, GAThe pilot's inadequate directional control during landing, which resulted in a runway excursion.Nov 18, 2011 · N39836 · Substantial damageNTSB ERA12FA074Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Ulysses, PAThe total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…Nov 17, 2011 · N54552 · Substantial damageNTSB ERA12CA076Accident · No injuriesData collectionFinal reportCessna A150M · Ormond Beach, FLThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control.Nov 17, 2011 · N9890J · Substantial damageNTSB CEN12LA071Accident · Serious injuriesLimited investigationFinal reportJuve Richard G Zodiac CH601 HDS · Clinton, ARThe inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.Nov 17, 2011 · N274 · Substantial damageNTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.Nov 17, 2011 · N7746W · Substantial damageNTSB CEN12LA066Accident · Minor injuriesLimited investigationFinal reportPiaggio Aero Industries P180 · Flint, MIThe captain's failure to maintain directional control during landing with one engine inoperative. Contributing to the accident was an improperly installed clevis pin in the left engine power lever, the crew’s delay in accurately identifying their heading, and…Nov 16, 2011 · N168SL · Substantial damageNTSB WPR12LA039Accident · Serious injuriesLimited investigationFinal reportWilliams Helicopter UH-1H · Grand Canyon, AZThe loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.Nov 15, 2011 · N502AW · Substantial damageNTSB WPR12CA043Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Baker, CAThe pilot's delayed decision to perform an aborted landing.Nov 15, 2011 · N497AC · Substantial damageNTSB CEN12LA074Accident · No injuriesLimited investigationFinal reportBeech S35 · Elkhart Lake, WIThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Nov 15, 2011 · N5858S · Substantial damageNTSB WPR12LA036Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodburn, ORThe pilot’s failure to maintain ground clearance while maneuvering with an external load line.Nov 14, 2011 · N16HA · Substantial damageNTSB WPR12CA035Accident · Serious injuriesData collectionFinal reportCameron Balloons A-315 · Vacaville, CAThe balloon’s encounter with increased wind, which resulted in a hard landing and passenger injury.Nov 13, 2011 · N65400 · No damageNTSB ERA12FA068Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Boynton Beach, FLThe right seat pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane.Nov 13, 2011 · N661FT · Substantial damageNTSB CEN12CA078Accident · No injuriesData collectionFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Carbondale, ILThe main rotor blade’s contact with the vertical stabilizer during the engine shutdown in strong, gusty wind conditions.Nov 13, 2011 · N330SL · Substantial damageNTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.Nov 12, 2011 · N24350 · Substantial damageNTSB CEN12LA061Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Gladewater, TXThe pilot’s failure to maintain control of the airplane during the landing and attempted go-around in a gusty crosswind.Nov 12, 2011 · N531MH · Substantial damageNTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.Nov 12, 2011 · N3606C · Substantial damageNTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.Nov 12, 2011 · N3051F · Substantial damageNTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.Nov 11, 2011 · N180LV · Substantial damageNTSB ERA12CA291Accident · Serious injuriesData collectionFinal reportNorth American SNJ-6 · Kissimmee, FLThe passenger’s fall from the airplane during a normal egress.Nov 11, 2011 · N452WA · No damageNTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.Nov 11, 2011 · N13584 · Substantial damageNTSB CEN12CA062Accident · Minor injuriesData collectionFinal reportBeech 58 · Connersville, INThe pilot's failure to maintain directional control of the airplane during landing.Nov 11, 2011 · N6685S · Substantial damageNTSB ANC12TA008Accident · No injuriesFinal reportBellanca 8GCBC · Delta Junction, AKIce accretion in the main landing gear wheel brakes, which prevented the main landing gear wheels from rotating on landing, which resulted in the airplane nosing over.Nov 11, 2011 · N88417 · Substantial damageNTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…Nov 10, 2011 · N11QV · Substantial damageNTSB DCA12CA043Accident · No injuriesData collectionFinal reportAirbus Industrie A320 211 · Minneapolis, MNIn-flight collision with birds during initial climb, which resulted in substantial damage to the aircraft.Nov 10, 2011 · N331NW · Substantial damageNTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.Nov 10, 2011 · N337LC · DestroyedNTSB CEN12CA079Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · College Station, TXThe total loss of engine power from both engines, which resulted from fuel exhaustion due to the pilot’s inadequate pre-flight preparation.Nov 10, 2011 · N8188R · Substantial damageNTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.Nov 9, 2011 · N5089Q · Substantial damageNTSB ERA12LA069Accident · No injuriesLimited investigationFinal reportGrenier Raymond Vans Aircraft RV-8 · Nashua, NHThe right main landing gear collapse due to the overload fracture of the hardware for reasons that could not be determined during postaccident testing and examination.Nov 9, 2011 · N220RG · Substantial damage