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 ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.Jul 10, 2014 · N39ZT · Substantial damageNTSB CEN14LA371Accident · 1 fatalLimited investigationFinal reportAir Command 532 · Petersburg, MIThe noncertificated pilot’s failure to maintain control of the gyroplane following a total loss of engine power due to a loose spark plug.Jul 10, 2014 · UNREG · Substantial damageNTSB CEN14LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Mt. Vernon, TXThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.Jul 10, 2014 · N9469N · Substantial damageNTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.Jul 10, 2014 · N4842G · Substantial damageNTSB CEN14LA358Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Garrison, NDExcessive wear between the power turbine shaft and quill shaft spline, which led to the disconnection of the power turbine wheel, an overspeed of the power turbine, and the subsequent loss of engine power. Contributing to the accident was maintenance…Jul 9, 2014 · N6648Q · Substantial damageNTSB ANC14LA052Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Palmer, AKThe pilot’s failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.Jul 9, 2014 · N68593 · Substantial damageNTSB WPR14LA285Accident · Minor injuriesLimited investigationFinal reportBailey-Moyes Microlights Dragonfly B Model · Buckley, WAThe pilot’s inability to maintain airplane control due to a loss of flight control effectiveness for reasons that could not be determined during postaccident examinations.Jul 8, 2014 · N7008Z · Substantial damageNTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jul 8, 2014 · N5816B · Substantial damageNTSB WPR14CA291Accident · Minor injuriesData collectionFinal reportDelconte Emidio J Kitfox Series V · Cove, ORThe pilot's failure to maintain directional control during takeoff when the airplane encountered standing water on the airstrip.Jul 8, 2014 · N68KF · Substantial damageNTSB WPR14CA288Accident · No injuriesData collectionFinal reportPiper PA 17 · Sand Point, IDThe pilot's failure to maintain directional control of the airplane during taxi.Jul 8, 2014 · N4842H · Substantial damageNTSB ERA14CA334Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's inadvertent encounter with an unanticipated convective gust front or low-level wind shear while landing, which resulted in a loss of control and subsequent hard landing.Jul 8, 2014 · N7368F · Substantial damageNTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.Jul 8, 2014 · N3732R · Substantial damageNTSB CEN14LA346Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Ansley, NEThe powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…Jul 8, 2014 · N4394V · No damageNTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.Jul 7, 2014 · N162CG · 2 aircraft · Substantial damageNTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.Jul 7, 2014 · N4602S · Substantial damageNTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.Jul 7, 2014 · N9185G · Substantial damageNTSB WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.Jul 6, 2014 · N3723T · DestroyedNTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.Jul 6, 2014 · N79ZR · Substantial damageNTSB ERA14FA328Accident · 2 fatalField investigationFinal reportCessna 150J · Topping, VAThe pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.Jul 6, 2014 · N50824 · Substantial damageNTSB ERA14CA335Accident · No injuriesData collectionFinal reportAlexander Schleicher K 7 · Mocksville, NCThe pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…Jul 6, 2014 · N9156 · Substantial damageNTSB ERA14LA338Accident · Serious injuriesLimited investigationFinal reportLawson Ronald S Explorer · East Bend, NCA total loss of engine power likely due to a failure of a rotary valve shaft seal and the pilot’s failure to detect and diagnose the impending failure during the preflight inspection.Jul 5, 2014 · N6663K · Substantial damageNTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jul 5, 2014 · N508CT · Substantial damageNTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.Jul 5, 2014 · N76850 · Substantial damageNTSB CEN14CA352Accident · No injuriesData collectionFinal reportBeech 35 33 · Mt. Vernon, ILThe pilot's failure to ensure the landing gear was extended into the fully locked position.Jul 5, 2014 · N891R · Substantial damageNTSB WPR14CA321Accident · Minor injuriesData collectionFinal reportCentrair 101A · Nephi, UTThe pilot's failure to identify the proper landing surface which resulted in an off airstrip landing and collision with rough terrain.Jul 4, 2014 · N643CA · Substantial damageNTSB CEN14LA342Accident · Serious injuriesLimited investigationFinal reportSlaughter Mike CH601-HDS · Frankston, TXThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to make a…Jul 4, 2014 · N4263 · Substantial damageNTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…Jul 4, 2014 · N1451D · Substantial damageNTSB CEN14CA343Accident · Minor injuriesData collectionFinal reportCessna 170B · Tomball, TXThe pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.Jul 4, 2014 · N170CC · Substantial damageNTSB WPR14TA278Accident · No injuriesFinal reportRockwell International 500 S · Willcox, AZThe pilot’s failure to compensate for tailwind conditions and maintain directional control during landing, which resulted in a runway excursion.Jul 3, 2014 · N101AA · Substantial damageNTSB WPR14CA280Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's inability to maintain control of the helicopter as a result of a hydraulic hose becoming entangled around the right skid.Jul 3, 2014 · N684PC · Substantial damageNTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.Jul 3, 2014 · N5KW · Substantial damageNTSB ERA14TA326Accident · Serious injuriesFinal reportCessna 336 · Mobile, ALThe pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.Jul 3, 2014 · N3804U · Substantial damageNTSB CEN14LA345Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Las Vegas, NMThe pilot's loss of airplane control during an aborted landing. Contributing to the accident was the pilot's inadequate preflight planning, which resulted in his attempt to land on a runway closed by a notice to airmen and the loss of engine power due to fuel…Jul 3, 2014 · N1175Q · Substantial damageNTSB CEN14LA336Accident · 1 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Omro, WIThe pilot’s failure to maintain adequate airspeed to compensate for a newly installed wing, which resulted in the aircraft stalling and the subsequent loss of control.Jul 3, 2014 · N2725T · Substantial damageNTSB CEN14CA344Accident · Minor injuriesData collectionFinal reportPiper PA 25-235 · Rhinelander, WIA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.Jul 3, 2014 · N8730L · Substantial damageNTSB CEN14FA337Accident · Serious injuriesField investigationFinal reportPiper PA30 · Harrison, ARThe pilot's loss of control of the airplane during initial climb because he failed to correctly compensate for the loss of power in the left engine. Contributing to the accident was water contamination in the fuel and the lack of an adequate preflight…Jul 2, 2014 · N7762Y · Substantial damageNTSB CEN14CA365Accident · Minor injuriesData collectionFinal reportCessna 182A · Geneseo, ILThe pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.Jul 2, 2014 · N2209G · Substantial damageNTSB CEN14CA338Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Olathe, KSThe pilot's failure to follow the manufacturer's engine shutdown procedure.Jul 2, 2014 · N225TV · Substantial damageNTSB ANC14FA050Accident · 1 fatalField investigationFinal reportPiper PA 12 · Anchorage, AKThe incorrect (reverse) rigging of the elevator control cables, and the pilot’s inadequate preflight inspection, which failed to detect the misrigging.Jul 2, 2014 · N3512M · Substantial damageNTSB WPR14CA277Accident · No injuriesData collectionFinal reportJones Hatz CB1 · Hysham, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind, which resulted in a ground loop.Jul 1, 2014 · N39761 · Substantial damageNTSB WPR14CA275Accident · Minor injuriesData collectionFinal reportHoffman David K Hoffman BMW Airtrike · Payette, IDThe pilot's failure to maintain adequate airspeed during the go-around which resulted in a stall.Jul 1, 2014 · N190DH · Substantial damageNTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.Jul 1, 2014 · N91331 · DestroyedNTSB CEN14LA379Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Jonesville, LAThe noncertificated pilot's failure to maintain clearance from trees.Jul 1, 2014 · UNREG · Substantial damageNTSB CEN14FA328Accident · 3 fatalField investigationFinal reportPiper PA 28-235 · Georgetown, COThe pilot’s inability to maintain a climb while maneuvering the airplane in high-density altitude conditions that degraded the airplane’s climb performance and his exceedance of the airplane’s critical angle-of-attack, which led to an aerodynamic stall and…Jun 30, 2014 · N8814W · DestroyedNTSB WPR14LA272Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350B2 · Dietrich, IDThe pilot’s sudden incapacitation from a previously undiagnosed medical condition while in cruise flight, which resulted in his inability to maintain helicopter control.Jun 29, 2014 · N350CR · Substantial damageNTSB WPR14LA271Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Big Creek, IDThe pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…Jun 29, 2014 · N132K · Substantial damageNTSB ERA14LA316Accident · Serious injuriesLimited investigationFinal reportCzech Sport Piper Sport · Peachtree City, GAThe pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…Jun 29, 2014 · N957MD · Substantial damageNTSB ERA14CA317Accident · Minor injuriesData collectionFinal reportCessna 172S · Orlando, FLThe flight instructor's failure to maintain control while taxiing in a strong gusty wind.Jun 29, 2014 · N775SP · Substantial damageNTSB WPR14LA273Accident · 1 fatalLimited investigationFinal reportSkyraider Skyraider · Lewiston, IDThe pilot's failure to maintain an adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall at too low an altitude to recover.Jun 28, 2014 · UNREG · Substantial damageNTSB WPR14CA376Accident · No injuriesData collectionFinal reportCessna 182K · Mesa, AZThe student pilot's inadequate landing flare which resulted in a loss of aircraft control and hard landing.Jun 28, 2014 · N3069Q · Substantial damage