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 WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.Sep 6, 2011 · N4649L · Substantial damageNTSB WPR11CA435Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · Park City, UTThe pilot’s failure to maintain control of the balloon during the landing on uneven ground.Sep 6, 2011 · N7154E · Substantial damageNTSB DCA11CA116Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Cape Coral, FLAn encounter with convective turbulence during the descent.Sep 6, 2011 · N936WN · No damageNTSB CEN11CA685Accident · No injuriesData collectionFinal reportCessna A185F · Hays, KSThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Sep 6, 2011 · N550DP · Substantial damageNTSB CEN11CA678Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Buena Vista, COThe airplane’s diminished climb performance due to the pilot not leaning the engine mixture enough prior to takeoff in high density altitude conditions and at nearly maximum gross takeoff weight.Sep 6, 2011 · N9430J · Substantial damageNTSB CEN11CA633Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Damon, TXThe pilot’s improper fuel management during cruise flight, which resulted in a total loss of engine power due to fuel starvation.Sep 6, 2011 · N742LB · Substantial damageNTSB WPR11LA434Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Saratoga, WYA loss of engine power during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Sep 5, 2011 · N761NZ · Substantial damageNTSB WPR11CA439Accident · No injuriesData collectionFinal reportCessna 182D · Roundup, MTThe pilot's failure to maintain clearance from an obstacle during the landing flare.Sep 5, 2011 · N8772X · Substantial damageNTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.Sep 5, 2011 · N950RC · Substantial damageNTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Sep 5, 2011 · N334JH · Substantial damageNTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Sep 5, 2011 · N63RK · Substantial damageNTSB CEN11FA625Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Mt. Pleasant, WIThe pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…Sep 5, 2011 · N850SY · Substantial damageNTSB CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.Sep 5, 2011 · N548ND · Substantial damageNTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.Sep 5, 2011 · N3654M · Substantial damageNTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.Sep 5, 2011 · N5406C · Substantial damageNTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.Sep 5, 2011 · N78463 · Substantial damageNTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.Sep 4, 2011 · N316PA · Substantial damageNTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…Sep 4, 2011 · N205WW · Substantial damageNTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.Sep 4, 2011 · N7WJ · DestroyedNTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.Sep 4, 2011 · N9DZ · Substantial damageNTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.Sep 4, 2011 · N624JS · Substantial damageNTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.Sep 4, 2011 · N43220 · Substantial damageNTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.Sep 4, 2011 · N9079Z · Substantial damageNTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.Sep 4, 2011 · N36V · Substantial damageNTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.Sep 4, 2011 · N88CE · Substantial damageNTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.Sep 4, 2011 · N5934Z · Substantial damageNTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.Sep 4, 2011 · N13973 · Substantial damageNTSB ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.Sep 4, 2011 · N83283 · Substantial damageNTSB WPR11LA427Accident · No injuriesLimited investigationFinal reportStinson V77 · Tillamook, ORThe pilot’s loss of directional control while taxiing in a gusting tailwind.Sep 3, 2011 · N9112H · Substantial damageNTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…Sep 3, 2011 · N280AD · Substantial damageNTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.Sep 3, 2011 · N17S · Substantial damageNTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.Sep 3, 2011 · N7303W · Substantial damageNTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.Sep 3, 2011 · N241BD · Substantial damageNTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.Sep 3, 2011 · N7197W · Substantial damageNTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Sep 3, 2011 · N30950 · Substantial damageNTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.Sep 3, 2011 · N242BC · Substantial damageNTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.Sep 2, 2011 · N205PJ · Substantial damageNTSB WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…Sep 2, 2011 · N80033 · Substantial damageNTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.Sep 2, 2011 · N5099A · Substantial damageNTSB CEN11LA618Accident · No injuriesLimited investigationFinal reportVicari Waiex · Marion, ILThe partial loss of engine power during initial climb for undetermined reasons.Sep 2, 2011 · N100VY · Substantial damageNTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.Sep 2, 2011 · N207DR · 2 aircraft · DestroyedNTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.Sep 1, 2011 · N6249C · DestroyedNTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.Sep 1, 2011 · UNREG · Substantial damageNTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.Sep 1, 2011 · N83533 · Substantial damageNTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…Sep 1, 2011 · N875AS · Minor damageNTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.Sep 1, 2011 · N76521 · Substantial damageNTSB CEN11CA637Accident · No injuriesData collectionFinal reportAero Commander S2R · Park Rapids, MNThe loss of engine power for undetermined reasons.Sep 1, 2011 · N8962Q · Substantial damageNTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.Sep 1, 2011 · N46112 · Substantial damageNTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.Aug 31, 2011 · N338F · Substantial damageNTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.Aug 31, 2011 · N739RU · Substantial damage