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 WPR13FA393Accident · 1 fatalField investigationFinal reportStuart Vortex · Scappoose, ORThe student pilot's unintentional takeoff followed by his failure to maintain control of the gyroplane during the landing approach. Contributing to the accident was the student pilot’s lack of both flight training and flight experience and his lack of a solo…Aug 31, 2013 · N43259 · DestroyedNTSB WPR13CA394Accident · No injuriesData collectionFinal reportHenderson Michael E Glastar · Sequim, WAThe pilot's improper soft field landing technique, and failure to maintain aircraft control during the landing.Aug 31, 2013 · N789MH · Substantial damageNTSB ERA13IA396Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Chesapeake, VAMaintenance personnel’s inadequate inspection and compliance with a Federal Aviation Administration airworthiness directive, which resulted in an undetected corroded and cracked stabilator turnbuckle and the subsequent failure of the turnbuckle and loss of…Aug 31, 2013 · N2091W · No damageNTSB ERA13CA399Accident · No injuriesData collectionFinal reportBreezer 912ULS2 · Lakeland, FLThe student pilot’s improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear.Aug 31, 2013 · N5625Y · Substantial damageNTSB CEN13LA524Accident · Serious injuriesLimited investigationFinal reportStemme S10-VT · Mackinaw City, MIThe mechanic’s failure to inspect the tightness of the bolts that connected the flexible disk to the driveshaft, which resulted in the failure of these components.Aug 31, 2013 · N389BD · Substantial damageNTSB CEN13FA517Accident · 3 fatalField investigationFinal reportRobinson R44 II · Caballo, NMThe pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.Aug 31, 2013 · N3156U · Substantial damageNTSB ANC13FA091Accident · 1 fatalField investigationFinal reportPiper PA-18A · Nikolai, AKThe pilot’s improper decision to load the airplane beyond its allowable takeoff weight and center of gravity limits, which resulted in a loss of control during the initial climb. Contributing to the accident was the external load and the downwind takeoff.Aug 31, 2013 · N4581A · DestroyedNTSB ERA13FA388Accident · 1 fatalField investigationFinal reportCessna 172 · Limington, MEAn impairing medical event of undetermined origin that led to a loss of control during takeoff.Aug 30, 2013 · N8063B · Substantial damageNTSB ERA13CA416Accident · No injuriesData collectionFinal reportCessna U206F · Rumney, NHThe pilot's failure to ensure that the amphibious airplane's landing gear was properly configured for a landing on water and his failure to properly configure the airplane during the attempted go-around.Aug 30, 2013 · N208LH · Substantial damageNTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.Aug 30, 2013 · N202SH · Substantial damageNTSB ERA13CA393Accident · No injuriesData collectionFinal reportCessna 172E · Apex, NCThe pilot's failure to attain the proper touchdown point on the runway, which resulted in a runway overrun and subsequent aircraft noseover.Aug 30, 2013 · N3513S · Substantial damageNTSB ERA13CA392Accident · Minor injuriesData collectionFinal reportCessna 172L · McComb, MSThe pilot’s failure to maintain adequate airspeed during approach to landing, which resulted in an aerodynamic stall and subsequent loss of control.Aug 30, 2013 · N7892G · Substantial damageNTSB ERA13CA389Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Blairsville, GAThe pilot’s decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.Aug 30, 2013 · N447JP · Substantial damageNTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…Aug 29, 2013 · N9089N · DestroyedNTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.Aug 29, 2013 · N6065P · Substantial damageNTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.Aug 29, 2013 · N2253U · Substantial damageNTSB ANC13FA090Accident · 2 fatalField investigationFinal reportChampion 7ECA · Sutton, AKThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and collision with terrain. Contributing to the accident was the pilot’s use of marijuana, which likely degraded his psychomotor…Aug 29, 2013 · N9624S · Substantial damageNTSB WPR13LA390Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Payson, AZA partial loss of engine power due to an overtemperature event that thermally damaged the turbine blades and vanes, which resulted in a hard landing.Aug 28, 2013 · N2018R · Substantial damageNTSB CEN13LA523Accident · No injuriesLimited investigationFinal reportBell-Transworld Helicopter Cor 47G-2 · Wichita Falls, TXThe delayed remedial action by the flight instructor during a simulated autorotation, which resulted in a hard landing.Aug 28, 2013 · N8051E · Substantial damageNTSB ERA13LA382Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake Model 250 · Middle Grove, NYMaintenance personnel’s application of insufficient torque to the No. 6 cylinder connecting rod bolts during overhaul, which resulted in the fatigue fracture of the connecting rod and a subsequent total loss of engine power.Aug 27, 2013 · N522WB · Substantial damageNTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.Aug 27, 2013 · N1574Q · Substantial damageNTSB CEN13FA509Accident · 1 fatalField investigationFinal reportCessna 421C · Paris, ILThe pilot's failure to abort the takeoff during the ground roll after detecting the airplane's degraded performance. Contributing to the accident was the pilot's decision to attempt a flight with a known problem with the left engine and the likely partial…Aug 27, 2013 · N229H · DestroyedNTSB ANC13CA086Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's loss of control of the airplane during takeoff, resulting in a ground loop.Aug 27, 2013 · N2583C · Substantial damageNTSB WPR13FA388Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Desert Center, CAThe pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.Aug 26, 2013 · N61VT · Substantial damageNTSB ERA13LA381Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe pilot’s incapacitation due to a seizure during taxi.Aug 26, 2013 · N5232D · Substantial damageNTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.Aug 26, 2013 · N744KA · Substantial damageNTSB ERA13LA380Accident · Minor injuriesLimited investigationFinal reportPiper PA46R-350T · Cat Cay, BahamasThe pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…Aug 25, 2013 · N720JF · Substantial damageNTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…Aug 25, 2013 · N83863 · DestroyedNTSB ERA13CA378Accident · Minor injuriesData collectionFinal reportCessna 172R · Shelter Island, NYThe pilot did not attain the proper touchdown point on the runway, which resulted in a runway excursion.Aug 25, 2013 · N392ES · Substantial damageNTSB ERA13CA375Accident · Minor injuriesData collectionFinal reportMark C Pauls RV-7A · Cortland, NYA partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.Aug 25, 2013 · N411AK · Substantial damageNTSB CEN13LA506Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Franklin, ILThe failure of both pilots, one of whom was noncertificated, to maintain adequate visual lookout while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the pilots’ inadequate communication about their intended…Aug 25, 2013 · N5164G · 2 aircraft · Substantial damageNTSB CEN13CA522Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Iowa City, IAThe pilot failed to maintain directional control of the airplane while landing.Aug 25, 2013 · N5761Z · Substantial damageNTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.Aug 25, 2013 · N5538B · Substantial damageNTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 25, 2013 · N4888Z · Substantial damageNTSB WPR13LA385Accident · Minor injuriesLimited investigationFinal reportRobert Golding Tbirdii · Bakersfield, CAThe failure of the two pilots to adequately planflight, particularly regarding their roles and responsibilities, which resulted in their failure to maintain sufficient altitude to clear power lines during a low pass.Aug 24, 2013 · N31683 · Substantial damageNTSB WPR13FA386Accident · Serious injuriesField investigationFinal reportPiper PA 28 · Tehachapi, CAThe pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.Aug 24, 2013 · N32582 · Substantial damageNTSB WPR13CA387Accident · No injuriesData collectionFinal reportTL Ultralight Stingsport · Burlington, WAThe pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in a nose gear collapseAug 24, 2013 · N9494 · Substantial damageNTSB ERA13LA374Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Marco Island, FLThe pilot’s improper pitch trim setting before takeoff, which resulted in the airplane’s rapid, nose-high pitch at takeoff and the pilot’s subsequent loss of control.Aug 24, 2013 · N3700H · Substantial damageNTSB ERA13CA377Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s decision to depart with a known deficiency following a hard landing. Contributing to the accident was an anomaly of the airplane’s nosewheel steering that could not be replicated during post-accident examination.Aug 24, 2013 · N98923 · Substantial damageNTSB CEN13LA503Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Concord, WIThe pilot's failure to properly plan for a maximum performance takeoff by not fully addressing the elevated density altitude or the nonstandard runway surface conditions and his failure to properly configure the airplane's flap setting for the accident…Aug 24, 2013 · N5131D · Substantial damageNTSB ANC13LA085Accident · No injuriesLimited investigationFinal reportCessna U206F · Tokotna, AKA total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic’s application of insufficient torque on the cylinder through bolts.Aug 24, 2013 · N35952 · Substantial damageNTSB ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…Aug 24, 2013 · N18699 · Substantial damageNTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…Aug 23, 2013 · N4922P · Substantial damageNTSB WPR13LA383Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madera, CAThe pilots' inadequate fuel planning, which resulted in the airplane departing with insufficient fuel to complete the planned flight, and their failure to recognize that discrepancy en route, which resulted in a total loss of engine power due to fuel…Aug 22, 2013 · N2578L · Substantial damageNTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.Aug 22, 2013 · N740SP · Substantial damageNTSB CEN13LA504Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's failure to properly set the engine power for takeoff, which resulted in the airplane subsequently settling into terrain.Aug 22, 2013 · N8402K · Substantial damageNTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.Aug 22, 2013 · N975BW · Substantial damageNTSB CEN13CA498Accident · No injuriesData collectionFinal reportCessna 172S · Indianapolis, INThe pilot's inadequate monitoring on the airplane's airspeed during the go-around, resulting in a stall.Aug 21, 2013 · N45EF · Substantial damageNTSB ANC13LA081Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe pilot’s failure to maintain adequate airspeed during initial climb after takeoff, which resulted in a subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a slight tailwind.Aug 21, 2013 · N7807K · Substantial damageNTSB WPR13CA381Accident · Minor injuriesData collectionFinal reportCessna 172E · Meeteetse, WYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.Aug 20, 2013 · N516MA · Substantial damage