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 WPR14LA177Accident · Serious injuriesLimited investigationFinal reportAirplane Factory Ltd The Sling · Daggett, CAThe pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.Apr 30, 2014 · N511NG · Substantial damageNTSB ANC14CA025Accident · No injuriesData collectionFinal reportCessna 182J · Cooper Landing, AKThe pilot's failure to correctly use carburetor heat, resulting in a loss of engine power and collision with terrain.Apr 30, 2014 · N3024F · Substantial damageNTSB WPR14CA178Accident · Minor injuriesData collectionFinal reportElemdorf 1002 · Rexburg, IDThe pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.Apr 29, 2014 · C-FOWD · Substantial damageNTSB OPS14IA007Incident · Minor injuriesIncident investigationFinal reportBoeing 757 · Powhatan, VAThe air traffic controller’s failure to provide required advisories about significant radar-observed convective precipitation along both airplanes’ flight routes and the air route traffic control center’s lack of a program to ensure that air traffic…Apr 29, 2014 · UNK · Minor damageNTSB ERA14CA225Accident · Minor injuriesData collectionFinal reportLake LA-4 · Chapin, SCThe pilot's improper flare, which resulted in abnormal contact with the water and separation of the right pontoon..Apr 29, 2014 · N1029L · Substantial damageNTSB ERA14CA213Accident · No injuriesData collectionFinal reportBeech 76 · Fort Pierce, FLThe instructor's failure to obtain the proper touchdown point in a multiengine airplane, during a single-engine approach in a strong gusty headwind.Apr 29, 2014 · N6756X · Substantial damageNTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.Apr 28, 2014 · N923LA · Substantial damageNTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…Apr 28, 2014 · N8700E · DestroyedNTSB ANC14CA024Accident · No injuriesData collectionFinal reportCessna 120 · Fairbanks, AKThe pilot's loss of directional control during landing, resulting in a ground loop.Apr 28, 2014 · N77336 · Substantial damageNTSB WPR14LA173Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Adelanto, CAThe commercial pilot’s improper control inputs, which resulted in a loss of helicopter control during takeoff.Apr 27, 2014 · N606BP · Substantial damageNTSB WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.Apr 27, 2014 · N4962U · 2 aircraft · DestroyedNTSB ERA14CA229Accident · No injuriesData collectionFinal reportGingras Michel Aventura II · Punta Gorda, FLThe pilot's failure to maintain clearance from the water while operating at a low altitude.Apr 27, 2014 · N543MG · Substantial damageNTSB ERA14CA215Accident · Serious injuriesData collectionFinal reportSchleicher Alexander K 7 · Benton, TNThe pilot's distraction with traffic on the runway, and his subsequent failure to retract the air brakes prior to touchdown, which resulted in a hard landing.Apr 27, 2014 · N1002Z · Minor damageNTSB ERA14CA211Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Woodbine, NJThe flight instructor's delayed reaction to the loss of directional control, which resulted in a ground loop.Apr 27, 2014 · N4615Y · Substantial damageNTSB ERA14CA210Accident · Minor injuriesData collectionFinal reportJerome A Baak CH 601XL · Sumter, SCThe total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.Apr 27, 2014 · N121JN · Substantial damageNTSB CEN14LA218Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wann, OKThe pilot's inadequate preflight inspection and planning and inflight fuel management, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing in an area of unsuitable terrain.Apr 27, 2014 · N3078Y · Substantial damageNTSB CEN14FA219Accident · 1 fatalField investigationFinal reportBellanca 17 30A · Sweetwater, TXThe pilot’s inadequate inflight fuel management, which led to a loss of engine power due to fuel exhaustion or starvation.Apr 27, 2014 · N9759E · Substantial damageNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB ERA14LA212Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Taylorsville, NCThe pilot’s improper approach, which resulted in a long landing right of the runway centerline and the airplane’s subsequent collision with a riding mower that would have been difficult for the pilot to see due to its color and the nose-high attitude of the…Apr 26, 2014 · N9122E · Substantial damageNTSB ERA14IA237Incident · No injuriesIncident investigationFinal reportCessna 525 · Port Orange, FLThe pilot's failure to attain a proper touchdown point during landing and his failure to go around when he recognized that he would not be able to stop the airplane on the runway, which resulted in a runway excursion.Apr 26, 2014 · N300ET · Minor damageNTSB CEN14LA222Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Cleburne, TXThe student pilot's failure to maintain tail rotor clearance from terrain while transitioning to a hover taxi and the instructor pilot's inadequate remedial action to prevent the impending tail rotor contact.Apr 25, 2014 · N90636 · Substantial damageNTSB CEN14CA223Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Liberty, MOThe pilot's failure to maintain directional control while operating in gusty wind conditions at a low altitude.Apr 25, 2014 · N32VB · Substantial damageNTSB OPS14IA005Incident · No injuriesIncident investigationFinal reportEmbraer EMB 145XR · Newark, NJThe local controller’s failure to comply with Federal Aviation Administration separation requirements for aircraft operating on intersecting runways.Apr 24, 2014 · N11176 · 2 aircraft · No damageNTSB CEN14LA228Accident · Serious injuriesLimited investigationFinal reportBrecher Rotorway Exec · Richwood, OHThe flight instructor’s inadequate autorotation, which resulted in a hard landing and postcrash fire. Contributing was the flight instructor’s lack of experience in performing an autorotation in the accident make and model of helicopter.Apr 24, 2014 · N43691 · Substantial damageNTSB ERA14CA209Accident · No injuriesData collectionFinal reportCessna T206H · Gilford, NHThe pilot misjudged the float equipped airplane's altitude while maneuvering above the surface of a lake, which resulted in a float inadvertently contacting the water. Contributing to the accident were the glassy water conditions and pilot's lack of recent…Apr 22, 2014 · N262ME · Substantial damageNTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Apr 22, 2014 · N35553 · Substantial damageNTSB CEN14LA213Accident · Serious injuriesLimited investigationFinal reportCrow Mustang II · Morton, TXThe pilot's improper landing flare after encountering a gusting crosswind and his inadequate recovery from the subsequent bounced landing.Apr 22, 2014 · N48MK · Substantial damageNTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.Apr 22, 2014 · N51990 · Substantial damageNTSB ANC14CA023Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Kenai, AKThe pilot's loss of directional control during takeoff, resulting in a collision with terrain and ground loop.Apr 22, 2014 · N9299D · Substantial damageNTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…Apr 21, 2014 · N7880Y · Substantial damageNTSB ERA14CA205Accident · Minor injuriesData collectionFinal reportCirrus Design SR20 · Sanford, FLThe student pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was his failure to compensate for torque, P-factor, and the reported crosswind conditions.Apr 21, 2014 · N497DA · Substantial damageNTSB CEN14LA221Accident · No injuriesLimited investigationFinal reportAmerican AA 1 · Peyton, COThe loss of directional control during takeoff for reasons that could not be determined due to the extent of fire damage.Apr 21, 2014 · N481HY · DestroyedNTSB ERA14CA203Accident · Minor injuriesData collectionFinal reportEvolution Revo · Concord, NHThe student pilot's failure to maintain control during a go around, which resulted in a collision with terrain.Apr 20, 2014 · N2264X · Substantial damageNTSB ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.Apr 19, 2014 · N82206 · Substantial damageNTSB ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.Apr 19, 2014 · N2219T · Substantial damageNTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…Apr 19, 2014 · N594T · Substantial damageNTSB CEN14CA242Accident · No injuriesData collectionFinal reportCessna 170A · Huron, SDThe pilot's inadequate flare resulting in a hard landing.Apr 19, 2014 · N9285A · Substantial damageNTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.Apr 19, 2014 · N298AB · Substantial damageNTSB CEN14CA203Accident · Minor injuriesData collectionFinal reportPiper PA-28 · Kalamazoo, MIAn inadvertent stall during gusting crosswind conditions.Apr 19, 2014 · N38240 · Substantial damageNTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.Apr 18, 2014 · UNREG · Substantial damageNTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.Apr 18, 2014 · N9421X · Substantial damageNTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.Apr 14, 2014 · N851RC · Substantial damageNTSB WPR14FA167Accident · 1 fatalField investigationFinal reportSands Helicycle · Reno, NVThe pilot’s failure to maintain control of the helicopter while in the traffic pattern.Apr 13, 2014 · N78CS · Substantial damageNTSB WPR14CA170Accident · No injuriesData collectionFinal reportPiper PA 18S-150 · Browning, MTThe pilot's failure to maintain directional control during the landing roll which resulted in a veer off the airstrip and collision with a ditch.Apr 13, 2014 · N7884D · Substantial damageNTSB ERA14LA199Accident · Serious injuriesLimited investigationFinal reportAircraft Industries A.S. L33 Solo · Bunn, NCThe pilot’s failure to maintain airspeed while approaching the airport, which resulted in a stall/mush.Apr 13, 2014 · N318BA · Substantial damageNTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 13, 2014 · N2875D · Substantial damageNTSB CEN14FA198Accident · 1 fatalField investigationFinal reportBeech C24 · Denton, TXThe pilot mistakenly manipulated the airplane's mixture knob rather than the propeller control knob during the descent, reducing the airplane's mixture knob to where the fuel-air mixture to the engine was too lean, which caused the engine to fail, and the…Apr 13, 2014 · N23984 · Substantial damageNTSB WPR14CA166Accident · Serious injuriesData collectionFinal reportPiper PA 18-135 · Kent, ORThe pilot's failure to maintain aircraft control during takeoff.Apr 12, 2014 · N1394Y · Substantial damageNTSB ERA14CA201Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Blountstown, FLThe pilot's inadequate compensation for the tailwind conditions and failure to maintain directional control during landing.Apr 12, 2014 · N2297L · Substantial damageNTSB CEN14LA199Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 C · Cookson, OKThe pilot’s failure to properly secure the primer, which resulted in the loss of engine power during takeoff.Apr 12, 2014 · N2788H · Substantial damage