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 CEN20LA265Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado · Marksville, LAThe student pilot’s failure to ensure sufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion, which resulted in impact with terrain.Jul 2, 2020 · N5082N · Substantial damageNTSB CEN20LA258Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Bridgeport, TXMaintenance personnel’s inadequate inspection, which resulted in a total loss of engine power due to a restricted air intake-induction system.Jul 2, 2020 · N6530W · Substantial damageNTSB ANC20CA063Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Nikolai, AKThe pilot's improper decision to depart from an unsuitable off-airport surface which resulted in a departure area excursion and impact with trees.Jul 2, 2020 · N6252M · Substantial damageNTSB ERA20LA234Accident · 1 fatalClass 3 · LimitedFinal reportEvektor Aerotechnik Sportstar · Ocala, FLThe pilot’s impairment or distraction due to an acute stroke, which resulted in an unstabilized approach and subsequent loss of airplane control during landing.Jul 1, 2020 · N820NG · Substantial damageNTSB ERA20CA236Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Meadville, PAThe pilot's distraction while taxiing, which resulted in a taxiway excursion.Jul 1, 2020 · N9127H · Substantial damageNTSB ERA20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Chesapeake, VAThe student pilot's improper landing flare and failure to recover from the ensuing bounced landing, which resulted in a runway excursion.Jul 1, 2020 · N9391H · Substantial damageNTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.Jul 1, 2020 · N19AS · DestroyedNTSB CEN20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18A-150 · Brainerd, MNThe pilot's decision to land on a shortened field and his incorrect brake application. Contributing was the flight instructor's lack of oversight.Jul 1, 2020 · N7684D · Substantial damageNTSB WPR20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV-8 · McMinnville, ORThe pilot's failure to maintain directional control during takeoff which resulted in a collision with a runway marker.Jun 29, 2020 · N998HG · Substantial damageNTSB ERA20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177 · Pittsfield, MAThe pilot’s improper landing flare, which resulted in a hard, bounced landing, and substantial damage to the airplane’s fuselage.Jun 29, 2020 · N29334 · Substantial damageNTSB ERA20CA233Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 8 · Perkasie, PAThe pilot’s loss of directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and collision with a ditch.Jun 29, 2020 · N408RV · Substantial damageNTSB ERA20CA231Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · South Bay, FLThe pilot's loss of airplane control during the approach, which resulted in an aerodynamic stall and impact with vegetation and terrain.Jun 29, 2020 · N42190 · Substantial damageNTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.Jun 28, 2020 · N7530B · Substantial damageNTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.Jun 28, 2020 · N811MS · Substantial damageNTSB ANC20CA062Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCK-1865 · Juneau, AKThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.Jun 28, 2020 · N153CC · Substantial damageNTSB CEN20LA248Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32R · Zavalla, TXThe non-certificated pilot’s poor decision-making as he attempted to land at an unlit airstrip in night instrument conditions, which resulted in the airplane’s collision with terrain short of the runway.Jun 27, 2020 · N315AM · DestroyedNTSB CEN20CA254Accident · Minor injuriesClass 4 · Data collectionFinal reportVolmer VJ22 · Erie, MIThe pilot's failure to ensure that the amphibious airplane’s wheels were retracted before attempting a water landing, resulting in a nose over during touch down. Contributing to the accident was the lack of a checklist available to the pilot.Jun 27, 2020 · N59262 · Substantial damageNTSB CEN20CA253Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 23 · Davenport, IAThe pilot's failure to properly configure the airplane for takeoff, which resulted in the exceedance of the airplane's critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.Jun 27, 2020 · N18873 · Substantial damageNTSB ERA20LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Coconut Creek, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to recognize the illumination of the low-fuel caution light.Jun 25, 2020 · N5013G · Substantial damageNTSB CEN20CA251Accident · No injuriesClass 4 · Data collectionFinal reportSonex Onex · Minneapolis, MNThe pilot's hard landing on the airplane's nosewheel, which jammed the steering, and resulted in a runway excursion and impact with runway lights.Jun 25, 2020 · N951X · Substantial damageNTSB CEN20CA250Accident · No injuriesClass 4 · Data collectionFinal reportHatz Hatz CB 1 · Red Wing, MNThe pilot's failure to perform a go around following a bounced landing that resulted in an aerodynamic stall.Jun 25, 2020 · N35JA · Substantial damageNTSB WPR20LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Imnaha, ORThe pilot’s excessively high pitch attitude and failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and impact with terrain. Contributing to the accident was the pilot’s fatigue and…Jun 24, 2020 · N9169G · Substantial damageNTSB WPR20LA193Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · Upland, CAThe inflight separation of the propeller assembly due to a fatigue fracture of the crankshaft. Contributing to the accident was the pilot’s restricted visibility during landing, which resulted in an excessive approach speed, a long landing, and subsequent…Jun 24, 2020 · N274DR · Substantial damageNTSB WPR20CA198Accident · No injuriesClass 4 · Data collectionFinal reportMaule M7 · Yellow Pine, IDThe pilot's improper approach airspeed and landing flare, which resulted in a bounced landing, and subsequent nose over.Jun 24, 2020 · N288BC · Substantial damageNTSB WPR20CA195Accident · Minor injuriesClass 4 · Data collectionFinal reportCapella XLS · Liberty, UTThe pilot's failure to maintain clearance from a fence post during the initial climb.Jun 24, 2020 · N18XX · Substantial damageNTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.Jun 24, 2020 · N958HP · Substantial damageNTSB CEN20CA247Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC19-180 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. The pilot being fatigued likely contributed to his failure to maintain directional control during the landing roll.Jun 24, 2020 · N97LL · Substantial damageNTSB WPR20CA231Accident · No injuriesClass 4 · Data collectionFinal reportChad Lewis Kitfox Super Sport · St Anthony, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion, contact with the airport perimeter fence, and subsequent nose over.Jun 23, 2020 · N338RW · Substantial damageNTSB WPR20CA192Accident · Serious injuriesClass 4 · Data collectionFinal reportNorth Wing Uum Scout X-C · Rochester, WAThe pilot’s failure to maintain adequate airspeed while on final approach in turbulent conditions, which resulted in an aerodynamic stall and subsequent hard landing.Jun 23, 2020 · N417HW · Substantial damageNTSB ERA20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, and failure to recover from the ensuing bounced landing, which resulted in a subsequent nose landing gear collapse.Jun 23, 2020 · N5314M · Substantial damageNTSB CEN20CA244Accident · Serious injuriesClass 4 · Data collectionFinal reportCoyote S-6ES · Pisgah, IAThe uncertificated pilot's failure to attain/maintain a proper angle-of-attack during an initial climb that resulted in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2020 · N7764W · Substantial damageNTSB ERA20CA226Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Shelby, NCThe pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.Jun 22, 2020 · N1718Q · Substantial damageNTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.Jun 22, 2020 · N7955V · Substantial damageNTSB ERA20CA223Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Monroe, NCThe pilot's inadequate assessment of the landing area, which resulted in the airplane's encounter with tall weeds during landing and a subsequent nose-over.Jun 22, 2020 · N3681Z · Substantial damageNTSB CEN20CA240Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer 269C · Sheffield, TXThe pilot's failure to maintain adequate clearance from a fence while hovering.Jun 21, 2020 · N298TH · Substantial damageNTSB ERA20CA222Accident · No injuriesClass 4 · Data collectionFinal reportBeech 77 · Elizabethton, TNThe student pilot's decision to continue from visual flight into instrument meteorological conditions, which resulted in a collision with trees and mountainous terrain.Jun 20, 2020 · N3815Z · Substantial damageNTSB CEN20CA238Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · Cambridge, OHThe pilot’s failure to maintain directional control during landing, which resulted in the airplane exiting the runway and striking a ditch.Jun 20, 2020 · N856L · Substantial damageNTSB ERA20CA227Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Churchville, MDThe student pilot's improper landing flare and improper recovery from a bounced landing in gusty wind conditions, which resulted in a hard landing.Jun 19, 2020 · N21585 · Substantial damageNTSB CEN20CA236Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 1730A · Martinton, ILThe pilot's improper decision to conduct an off-field precautionary landing.Jun 19, 2020 · N244HW · Substantial damageNTSB WPR20LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Coeur D Alene, IDImproper maintenance of the landing gear system which resulted in a partial gear collapse during landing.Jun 18, 2020 · N6602B · Substantial damageNTSB ERA20LA220Accident · 1 fatalClass 3 · LimitedFinal reportRobinson R66 · Pikeville, NCThe pilot’s failure to see and avoid a small diameter wire during low altitude agricultural spraying operations. Contributing to the accident was the pilot’s insufficient property survey.Jun 18, 2020 · N4QW · Substantial damageNTSB WPR20CA185Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 6 · Clovis, NMThe pilot's improper landing flare which resulted in a hard, bounced landing, and subsequent runway excursion. Contributing to the accident was the airplane’s aft center of gravity at the time of the accident.Jun 17, 2020 · N1407W · Substantial damageNTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…Jun 17, 2020 · N25449 · Substantial damageNTSB CEN20LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT402 · Pine Bluff, ARThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and a loss of airplane control. Contributing was a partial loss of engine power for undetermined reasons.Jun 17, 2020 · N1532H · Substantial damageNTSB CEN20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCX-2000-0086 · Gypsom, COThe pilot's failure to maintain airplane control during landing in gusting wind conditions.Jun 17, 2020 · N339KT · Substantial damageNTSB CEN20CA233Accident · No injuriesClass 4 · Data collectionFinal reportPiper J3C-65 · Mount Victory, OHThe pilot's inadequate planning, and his failure to secure the airplane prior to hand-starting the engine.Jun 17, 2020 · N25702 · Substantial damageNTSB ANC20CA061Accident · No injuriesClass 4 · Data collectionFinal reportBeech A36 · Chignik Lagoon, AKThe pilot's improper approach, which resulted in a long landing and a runway overrun.Jun 17, 2020 · N777AK · Substantial damageNTSB WPR20CA184Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Maricopa, AZThe pilot's failure to extend the airplane’s retractable landing gear before landing.Jun 16, 2020 · N117KP · Substantial damageNTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.Jun 16, 2020 · N879JA · Substantial damageNTSB CEN20CA232Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Ely, MNThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapse during a gusty landing.Jun 16, 2020 · N27RZ · Substantial damage