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 GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.Dec 5, 2018 · N839AL · Substantial damageNTSB ERA19LA063Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Moscow, PAA total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…Dec 4, 2018 · N618G · Substantial damageNTSB GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.Dec 3, 2018 · N65773 · Substantial damageNTSB DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.Dec 3, 2018 · N868NN · No damageNTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.Dec 1, 2018 · N79HP · DestroyedNTSB DCA19CA035Accident · Minor injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2B19 · New York, NYthe captain initiating a cross bleed start while under tow.Dec 1, 2018 · N202PS · Substantial damageNTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.Nov 30, 2018 · N27838 · Substantial damageNTSB ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.Nov 30, 2018 · N3995Y · DestroyedNTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…Nov 30, 2018 · N941JM · Substantial damageNTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.Nov 29, 2018 · N3619M · Substantial damageNTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…Nov 29, 2018 · N7751Y · DestroyedNTSB GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.Nov 28, 2018 · N343BZ · Substantial damageNTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.Nov 28, 2018 · N54058 · Substantial damageNTSB GAA19CA084Accident · Serious injuriesData collectionFinal reportPiper PA28 · Casa Grande, AZThe student pilot's failure to maintain a proper glidepath during the approach, which resulted in impact with a fence and terrain.Nov 28, 2018 · N5668W · Substantial damageNTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.Nov 28, 2018 · N909CA · Substantial damageNTSB GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.Nov 28, 2018 · N552TC · 2 aircraft · Minor damageNTSB GAA19CA078Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Americus, GAThe pilot's failure to see and avoid a power line during an agricultural application flight.Nov 28, 2018 · N843WA · Substantial damageNTSB CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.Nov 27, 2018 · N113TA · DestroyedNTSB GAA19CA075Accident · No injuriesData collectionFinal reportDarren M. Vinelli Sopwith PUP · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll in gusting tailwind conditions.Nov 26, 2018 · N1916Z · Substantial damageNTSB GAA19CA073Accident · No injuriesData collectionFinal reportBeech C23 · Porterville, CAThe pilot's improper landing flare, which resulted in an abnormal landing and subsequent porpoise.Nov 25, 2018 · N66710 · Substantial damageNTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…Nov 24, 2018 · N781FE · No damageNTSB GAA19CA094Accident · No injuriesData collectionFinal reportCirrus SR22 · Greenville, SCThe pilot's improper landing flare with a gusting, right quartering headwind, which resulted in a hard landing.Nov 23, 2018 · N82SN · Substantial damageNTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.Nov 23, 2018 · N50340 · Substantial damageNTSB ERA19TA067Accident · No injuriesClass 3Final reportBeech A36 · Summerland Key, FLThe pilot’s inadvertent retraction of the landing gear during landing rollout, resulting in a landing gear collapse.Nov 23, 2018 · N41VK · Substantial damageNTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.Nov 23, 2018 · N7081Q · Substantial damageNTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.Nov 22, 2018 · N21621 · Substantial damageNTSB GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.Nov 21, 2018 · N512EA · Substantial damageNTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.Nov 21, 2018 · N579CP · Substantial damageNTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…Nov 20, 2018 · N27LA · Substantial damageNTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.Nov 20, 2018 · N607FT · 2 aircraft · Substantial damageNTSB WPR19LA029Accident · No injuriesClass 3 · LimitedFinal reportBKF Backcountry Supercub · Casper, WYThe seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.Nov 19, 2018 · N59BK · Substantial damageNTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.Nov 19, 2018 · N322JS · 2 aircraft · Substantial damageNTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 18, 2018 · N667J · Substantial damageNTSB GAA19CA063Accident · No injuriesData collectionFinal reportRobinson R44 · Knox City, TXThe pilot's failure to maintain adequate airspeed with a tailwind, which resulted in the helicopter settling with power, and his subsequent incorrect collective application while attempting to recover, which resulted in a loss of helicopter control due to a…Nov 18, 2018 · N4167Y · Substantial damageNTSB CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.Nov 18, 2018 · N441CX · DestroyedNTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.Nov 17, 2018 · N4137W · Substantial damageNTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.Nov 17, 2018 · N111TA · Substantial damageNTSB ERA19FA049Accident · 1 fatalClass 2 · FieldFinal reportLancair Legacy RG · Gainesville, GAThe pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…Nov 17, 2018 · N8448J · Substantial damageNTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…Nov 17, 2018 · N232VA · Substantial damageNTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…Nov 17, 2018 · N4817M · Substantial damageNTSB CEN19FA028Accident · 2 fatalField investigationFinal reportNorth American P51 · Fredericksburg, TXThe pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.Nov 17, 2018 · N4132A · DestroyedNTSB WPR19FA026Accident · 2 fatalClass 2 · FieldFinal reportZenith CH601 · Overgaard, AZThe pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.Nov 16, 2018 · N322JL · Substantial damageNTSB WPR19FA025Accident · 2 fatalClass 2 · FieldFinal reportCessna 182 · Redding, CAThe pilot's spatial disorientation and subsequent loss of control after takeoff in dark night instrument meteorological conditions.Nov 16, 2018 · N2629R · Substantial damageNTSB GAA19CA064Accident · No injuriesData collectionFinal reportCessna 182 · Charlotte, NCThe pilot's improper landing flare, which resulted in a hard landing.Nov 16, 2018 · N8903X · Substantial damageNTSB ERA19TA051Accident · Minor injuriesFinal reportCessna E162 · Franklin, NCThe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.Nov 16, 2018 · N70252 · Substantial damageNTSB ERA19FA047Accident · 2 fatalClass 2 · FieldFinal reportBell OH 58C · Verbena, ALThe pilot's improper decision to conduct a low-level flight over a river, and his failure to see and avoid power lines, which resulted in the helicopter's impact with power lines and the water.Nov 16, 2018 · N510CP · Substantial damageNTSB WPR19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Presidio, TXThe student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.Nov 14, 2018 · N1715J · Substantial damageNTSB GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.Nov 14, 2018 · N264PC · Substantial damageNTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.Nov 13, 2018 · N5023G · Substantial damageNTSB GAA19CA056Accident · No injuriesData collectionFinal reportGuimbal Cabri · Newberg, ORThe pilot under instruction's failure to maintain directional control and the flight instructor's delayed remedial action.Nov 13, 2018 · N370PA · Substantial damage