NTSB investigations

19,008 cases where NTSB found Personnel issues.

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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
  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 WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.Aug 1, 2014 · N3597T · Substantial damageNTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…Aug 1, 2014 · N116LK · DestroyedNTSB CEN14CA460Accident · No injuriesData collectionFinal reportAviat Husky · Steamboat Springs, COThe student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.Aug 1, 2014 · N776BC · Substantial damageNTSB ANC14CA057Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Illiamna, AKThe pilot's inadequate landing technique that resulted in a landing area overrun. Contributing was the glassy water conditions.Aug 1, 2014 · N87808 · Substantial damageNTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…Jul 31, 2014 · N147MP · Substantial damageNTSB CEN14FA399Accident · 1 fatalField investigationFinal reportZimmerman Breezy · Oshkosh, WIThe pilot’s failure to maintain airplane control during landing while the air traffic controller was simultaneously coordinating the landing of three airplanes on the same runway, which resulted in the airplane exiting the runway and impacting a parked ground…Jul 31, 2014 · N3AZ · Substantial damageNTSB CEN14CA422Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Warsaw, INThe pilot failed to maintain directional control during landing.Jul 31, 2014 · N8160A · Substantial damageNTSB CEN14CA405Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Oakdale, LAThe pilot's excessive braking on landing, which resulted in a loss of control.Jul 31, 2014 · N199MA · Substantial damageNTSB CEN14CA404Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Traverse City, MIThe pilot's loss of directional control during landing, resulting in a runway excursion and the airplane nosing over.Jul 31, 2014 · N8461D · Substantial damageNTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.Jul 31, 2014 · N7194H · Substantial damageNTSB ANC14LA058Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 · Talkeetna, AKThe pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…Jul 31, 2014 · N62197 · Substantial damageNTSB WPR14CA328Accident · No injuriesData collectionFinal reportBeech A36 - Undesignat · San Carlos, CAThe pilot's failure to maintain directional control during taxi.Jul 30, 2014 · N17856 · Substantial damageNTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.Jul 30, 2014 · N6004U · Substantial damageNTSB DCA14LA137Accident · No injuriesLimited investigationFinal reportBoeing 757 · San Diego, CAthe first officer's failure to maintain the correct airspeed and pitch attitude during landing that resulted in a tailstrike.Jul 30, 2014 · N553UA · Substantial damageNTSB CEN14LA465Accident · No injuriesLimited investigationFinal reportBell 206B · Spring, TXThe pilot's distraction by a cell phone call, which led to his failure to perform an exterior check of the helicopter and resulted in a tie-down strap remaining attached to the main rotor during the engine start.Jul 30, 2014 · N866H · Substantial damageNTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.Jul 30, 2014 · N82PR · Substantial damageNTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.Jul 29, 2014 · N66358 · Substantial damageNTSB CEN14LA433Accident · No injuriesLimited investigationFinal reportSutton William J Stits Playmate SA11A · Bridgeport, TXThe pilot’s loss of airplane control during takeoff after encountering rapidly changing wind conditions.Jul 29, 2014 · N76WS · Substantial damageNTSB CEN14LA398Accident · Serious injuriesLimited investigationFinal reportHughes 369D · West Liberty, OHA total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.Jul 29, 2014 · N89ZC · Substantial damageNTSB CEN14CA429Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Minden, NEThe pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.Jul 29, 2014 · N502NR · Substantial damageNTSB CEN14CA402Accident · No injuriesData collectionFinal reportCessna 182R · Pine Bluff, ARThe inadvertent aerodynamic stall during landing in crosswind conditions.Jul 29, 2014 · N9836H · Substantial damageNTSB WPR14CA317Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hazelton, IDThe pilot's failure to maintain aircraft control during takeoff roll in variable wind conditions.Jul 28, 2014 · N802TY · Substantial damageNTSB ERA14LA363Accident · 1 fatalLimited investigationFinal reportTemco GC 1B · Yulee, FLThe pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.Jul 28, 2014 · N1CY · Substantial damageNTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.Jul 28, 2014 · N8883C · Substantial damageNTSB WPR14LA315Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 C · Susanville, CAThe pilot’s failure to follow the checklist while starting the engine and to lock the engine primer plunger, which resulted in the partial loss of engine power during cruise flight in high density altitude conditions.Jul 27, 2014 · N2013H · Substantial damageNTSB ERA14LA362Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s…Jul 27, 2014 · N8826C · Substantial damageNTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.Jul 27, 2014 · N2275G · Substantial damageNTSB CEN14LA393Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Pueblo, COA total loss of engine power due to fuel starvation, which resulted from the pilot’s improper fuel management and resulted in a forced landing on unsuitable terrain.Jul 27, 2014 · N72CW · Substantial damageNTSB WPR14CA314Accident · No injuriesData collectionFinal reportCessna 182Q · Warren, IDThe pilot's attempt to depart on an unpaved road, which he mistook for the unpaved runway. Contributing to the accident was the fact that the road and the runway were conjoined for the first few hundred feet of the runway.Jul 26, 2014 · N624M · Substantial damageNTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.Jul 26, 2014 · N248SP · DestroyedNTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.Jul 26, 2014 · N240SJ · Substantial damageNTSB CEN14CA392Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Caputa, SDThe student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.Jul 26, 2014 · N5530K · Substantial damageNTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.Jul 26, 2014 · N400HU · Substantial damageNTSB WPR14LA313Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVThe airplane flight crew’s failure to exercise the necessary vigilance and precautions and yield the right of way to the landing helicopter, which resulted in the airplane colliding with the helicopter. Contributing to the accident was the helicopter pilot’s…Jul 25, 2014 · N154GC · 2 aircraft · Substantial damageNTSB ERA14LA368Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C G-164B · Bonifay, FLA partial blockage of the No. 2 bearing oil nozzle jet by bearing material, which resulted in oil starvation and the subsequent failure of the No. 2 bearing and total loss of engine power.Jul 25, 2014 · N425LS · Substantial damageNTSB CEN14LA397Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US A-180 · Questa, NMThe hard landing after both burner pilot lights extinguished during the landing approach. Contributing to the accident was the pilot's inability to relight the burner pilot lights.Jul 25, 2014 · N65059 · No damageNTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…Jul 25, 2014 · N161SH · Substantial damageNTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.Jul 24, 2014 · N8159Z · Substantial damageNTSB WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.Jul 23, 2014 · N949FM · Substantial damageNTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…Jul 23, 2014 · N4425W · Substantial damageNTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…Jul 23, 2014 · N47149 · Substantial damageNTSB ERA14CA353Accident · No injuriesData collectionFinal reportJannakos Gregory P Zodiac 601 HDS · Lawrenceville, GAThe pilot's inadequate flare, which resulted in a hard landing.Jul 23, 2014 · N4399 · Substantial damageNTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.Jul 23, 2014 · N730GU · Substantial damageNTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…Jul 22, 2014 · N5225C · Substantial damageNTSB WPR14LA307Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Auburn, WAA collapse of the nose landing gear for reasons that could not be determined based on the available information.Jul 22, 2014 · N60PB · Substantial damageNTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.Jul 22, 2014 · N1066R · Substantial damageNTSB CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…Jul 22, 2014 · N4453P · Substantial damageNTSB WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…Jul 21, 2014 · N66255 · Substantial damageNTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.Jul 21, 2014 · N84754 · DestroyedNTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.Jul 21, 2014 · N3997Z · Substantial damage