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 WPR13LA125Accident · Minor injuriesLimited investigationFinal reportTemco D-16A · Heber, CAA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight and fuel planning.Feb 16, 2013 · N716T · Substantial damageNTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 16, 2013 · N93747 · Substantial damageNTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.Feb 16, 2013 · N15PR · Substantial damageNTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.Feb 15, 2013 · N4305D · Substantial damageNTSB ERA13LA134Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Danville, PAThe pilot’s decision to conduct a straight-in approach to the helipad, which resulted in the main rotor blade impacting a construction crane flag marker. Contributing to the accident was the erroneous information about the construction crane’s operation time…Feb 14, 2013 · N481LF · Substantial damageNTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…Feb 14, 2013 · N104DR · Substantial damageNTSB CEN13TA165Accident · Minor injuriesFinal reportBell OH-58A · Pine Springs, TXThe pilot's failure to maintain directional control while operating in conditions conducive to a loss of tail rotor effectiveness.Feb 14, 2013 · N337PW · Substantial damageNTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 14, 2013 · N7466D · Substantial damageNTSB WPR13CA124Accident · No injuriesData collectionFinal reportBeech B19 · Ephrata, WAThe student pilot's failure to maintain directional control during the takeoff ground roll in crosswind conditions, and the flight instructor's delayed remedial action.Feb 13, 2013 · N2059L · Substantial damageNTSB ERA13FA131Accident · 1 fatalField investigationFinal reportCessna T337C · New Smyrna Beach, FLMaintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…Feb 13, 2013 · N2576S · DestroyedNTSB CEN13LA171Accident · No injuriesLimited investigationFinal reportPiper PA46 · Grand Island, NEThe pilot's failure to maintain airplane control after engine start.Feb 13, 2013 · N32CA · Substantial damageNTSB CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.Feb 13, 2013 · N7824G · Substantial damageNTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.Feb 12, 2013 · N12989 · Substantial damageNTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…Feb 10, 2013 · N59518 · Substantial damageNTSB WPR13CA120Accident · No injuriesData collectionFinal reportBell 206B · Shandon, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Feb 10, 2013 · N802KA · Substantial damageNTSB WPR13CA121Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sunnyside, WAThe pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.Feb 9, 2013 · N6726J · Substantial damageNTSB ERA13CA132Accident · No injuriesData collectionFinal reportTriad International Technology RV6A · Lewisburg, TNThe pilot’s improper landing flare and failure to maintain directional control during the landing.Feb 9, 2013 · N956TT · Substantial damageNTSB ERA13CA130Accident · Minor injuriesData collectionFinal reportDratbe Shmiel Amir Classic Edge X · Miami, FLThe student pilot's decision to fly at low altitude surrounded by tree, wire, and water hazards, and his failure to maintain clearance from those obstacles.Feb 9, 2013 · N662DA · Substantial damageNTSB WPR13FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Tucson, AZThe pilot's incapacitation due to his preexisting cardiac disease, which resulted in his degraded or complete loss of ability to control the airplane.Feb 8, 2013 · N89059 · Substantial damageNTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.Feb 8, 2013 · N2269U · Substantial damageNTSB CEN13CA153Accident · No injuriesData collectionFinal reportCessna 177RG · Herington, KSThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall.Feb 8, 2013 · N88NG · Substantial damageNTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.Feb 7, 2013 · N328SP · DestroyedNTSB ERA13LA129Accident · No injuriesLimited investigationFinal reportBeech 58 · Winston-Salem, NCThe failure of the left main landing gear to fully extend due to improper rigging by maintenance personnel during a maintenance check.Feb 7, 2013 · N458P · Substantial damageNTSB DCA13IA058Incident · Minor injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Bowman, GAthe captain's inappropriate climb speed, his failure to monitor airspeed during the level off, and his inappropriate response to multiple stall warnings.Feb 7, 2013 · N261PS · Minor damageNTSB CEN13LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Forrest City, ARThe in-flight separation of the left aileron's push-pull rod and hardware. Contributing to the accident was the failure of maintenance personnel to apply proper torque to the self-locking nuts.Feb 7, 2013 · N198LA · Substantial damageNTSB CEN13LA167Accident · No injuriesLimited investigationFinal reportCessna 172L · Idabel, OKThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion.Feb 7, 2013 · N7974G · Substantial damageNTSB WPR13FA115Accident · 2 fatalField investigationFinal reportBeech E90 · Casa Grande, AZThe pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin.Feb 6, 2013 · N555FV · DestroyedNTSB WPR13CA117Accident · No injuriesData collectionFinal reportCessna 170B · Sunburst, MTThe pilot's failure to compensate for the strong, gusting wind conditions, which resulted in a loss of airplane control during takeoff.Feb 6, 2013 · N2619D · Substantial damageNTSB CEN13LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Tulsa, OKThe line technician’s failure to remove the refueling mat from the helicopter fuselage following servicing, which resulted in the mat striking the tail rotor in flight, and the pilot’s inadequate preflight inspection.Feb 6, 2013 · N276RC · Substantial damageNTSB ANC13LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Kalskag, AKThe pilot’s decision to take off into deteriorating weather conditions, which resulted in a loss of visual reference and the subsequent controlled flight into terrain. Contributing to the severity of the rear seat passenger’s injuries was the incorrect…Feb 5, 2013 · N5290J · Substantial damageNTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.Feb 3, 2013 · N8465L · Substantial damageNTSB WPR13CA114Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Worland, WYThe pilot's failure to maintain directional control during landing.Feb 1, 2013 · N83454 · Substantial damageNTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…Feb 1, 2013 · N247RB · 2 aircraft · Substantial damageNTSB CEN13LA148Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Gillett, TXA loss of tail rotor effectiveness while manuevering at low altitude.Feb 1, 2013 · N3059Q · Substantial damageNTSB CEN13CA151Accident · No injuriesData collectionFinal reportCessna 172 · Murphysboro, ILThe pilot’s failure to maintain control of the airplane during the takeoff roll.Feb 1, 2013 · N546A · Substantial damageNTSB WPR13CA107Accident · No injuriesData collectionFinal reportRobinson R22 · Kona, HIThe pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.Jan 30, 2013 · N333PJ · Substantial damageNTSB ERA13CA122Accident · Minor injuriesData collectionFinal reportAmirkhanian Shahram Charl Commander · Westminster, MDImpact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.Jan 29, 2013 · N393GX · Substantial damageNTSB CEN13CA145Accident · No injuriesData collectionFinal reportHughes 369HS · London, OHThe pilot's failure to comply with established cold weather operating procedures, which resulted in a total loss of engine power. Contributing to the accident was the pilot's excessive aft cyclic input during the landing flare, which resulted in main rotor…Jan 29, 2013 · N193M · Substantial damageNTSB CEN13LA147Accident · No injuriesLimited investigationFinal reportWebb Webb 2 · Gainsville, TXThe pilot’s failure to follow his test plan and abort the takeoff after inadvertently lifting off during a high speed taxi test. Contributing to the accident was the pilot’s lack of flight experience in the gyroplane.Jan 28, 2013 · N4844W · Substantial damageNTSB WPR13LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAThe student pilot's inadequate flight planning, which resulted in his getting lost and not being able to return to the airport before the fuel was exhausted and the engine lost power.Jan 27, 2013 · N68757 · Substantial damageNTSB ERA13CA123Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Lancaster, PAThe pilot’s failure to maintain clearance from a parked vehicle while taxiing from landing.Jan 27, 2013 · N8385S · Substantial damageNTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…Jan 27, 2013 · N5763H · Substantial damageNTSB ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.Jan 26, 2013 · N9041U · Substantial damageNTSB ERA13CA120Accident · No injuriesData collectionFinal reportMallory Christopher L RV-8 · Lake City, FLThe pilot’s failure to maintain directional control during the landing roll.Jan 26, 2013 · N492CM · Substantial damageNTSB DCA13CA043Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD11 · Denver, COthe flight crews failure to perform a takeoff performance data briefing following the final entries into the Flight Management System, which would have alerted them to the incorrect weight entry and resulting incorrect landing speeds. Contributing to the…Jan 25, 2013 · N618FE · Substantial damageNTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.Jan 24, 2013 · N18690 · Substantial damageNTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.Jan 24, 2013 · N980SS · DestroyedNTSB CEN13CA142Accident · No injuriesData collectionFinal reportCessna 172S · Peoria, ILThe pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.Jan 24, 2013 · N5113J · Substantial damageNTSB ERA13LA117Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Danbury, CTThe flight instructor’s inadequate preflight inspection in which he incorrectly estimated the airplane’s fuel quantity and his improper reliance on the fuel totalizer rather than the fuel quantity indicating and warning systems to determine the fuel on board,…Jan 23, 2013 · N140PG · Substantial damageNTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.Jan 22, 2013 · N143PG · Substantial damage