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 GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.May 17, 2015 · N8634U · Substantial damageNTSB CEN15CA236Accident · No injuriesData collectionFinal reportCessna 150C · Durango, COThe total loss of engine power due to carburetor icing.May 17, 2015 · N1924Z · Substantial damageNTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.May 17, 2015 · N83330 · Substantial damageNTSB ANC15CA027Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Homer, AKThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's decision to continue the approach to landing while distracted and his failure to complete the landing checklist.May 17, 2015 · N4079H · Substantial damageNTSB WPR15LA165Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Carlsbad, CAThe pilot’s inadvertently turning on the starter switches, which turned off the generators and resulted in a loss of electrical power and gear-up landing. Contributing to the accident was the pilot’s failure to follow the emergency procedures for a loss of…May 16, 2015 · N505SP · Substantial damageNTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.May 16, 2015 · N7099R · Substantial damageNTSB GAA15CA079Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Princeton, NJThe pilot's failure to maintain directional control during the landing, resulting in a runway excursion.May 16, 2015 · N16491 · Substantial damageNTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.May 16, 2015 · N1105L · Substantial damageNTSB GAA15CA074Accident · No injuriesData collectionFinal reportMaule MX 7-180C · Sharps Chapel, TNCollision with an obstacle during the landing roll, which resulted in a loss of control and subsequent runway excursion and tree strike.May 16, 2015 · N567HW · Substantial damageNTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.May 16, 2015 · N9032P · DestroyedNTSB ANC15CA026Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Talkeetna, AKThe private pilot's failure to maintain clearance from a spruce tree during final approach, which resulted in a loss of control and hard landing. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.May 16, 2015 · N7347D · Substantial damageNTSB CEN15LA233Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Piggott, ARThe loss of engine power due to a malfunctioning magneto. Contributing to the accident was maintenance personnel's improper use of a drill bit instead of a timing pin during magneto installation, which resulted in a section of the drill bit breaking off and…May 15, 2015 · N164CS · Substantial damageNTSB WPR15FA161Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Juntura, ORThe pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.May 14, 2015 · N5042P · Substantial damageNTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.May 14, 2015 · N741CD · Substantial damageNTSB ERA15LA210Accident · Serious injuriesLimited investigationFinal reportAviat Pitts S-2B · Tullahoma, TNThe pilot’s inadequate visual lookout, which resulted in his airplane landing on top of the other airplane.May 14, 2015 · N110PS · 2 aircraft · Minor damageNTSB ANC15CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Anchorage, AKThe pilot's excessive use of brakes to maintain directional control, which resulted in a nose over.May 14, 2015 · N2998P · Substantial damageNTSB WPR15LA160Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Maxwell, CAThe pilot’s improper preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.May 13, 2015 · N8875H · Substantial damageNTSB GAA15CA080Accident · No injuriesData collectionFinal reportPilatus PC12 - 45 · Crownpoint, NMThe pilot's failure to extend the landing gear before landing.May 13, 2015 · N811VM · Substantial damageNTSB GAA15CA076Accident · No injuriesData collectionFinal reportCessna 170B · Bentonville, ARThe flight instructor's failure to maintain directional control, which resulted in a ground loop on takeoff.May 13, 2015 · N3488C · Substantial damageNTSB GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.May 12, 2015 · N56074 · Substantial damageNTSB ERA15LA212Accident · No injuriesClass 2 · LimitedFinal reportGates Lear Jet 35 · Newport News, VAThe flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…May 12, 2015 · N80PG · Substantial damageNTSB GAA15CA067Accident · No injuriesData collectionFinal reportMaule M 4-220C · Rigby, IDThe pilot's failure to maintain directional control of the airplane during landing roll.May 11, 2015 · N2058U · Substantial damageNTSB GAA15CA065Accident · No injuriesData collectionFinal reportChampion 7ECA · Quincy, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.May 10, 2015 · N6096F · Substantial damageNTSB CEN15LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Dighton, KSThe pilot's failure to follow the Preflight checklist and his inadequate preflight inspection, during which he failed to detect the water contamination of the fuel, which resulted in a partial loss of engine power during initial climb.May 10, 2015 · N879JA · Substantial damageNTSB WPR15LA159Accident · Minor injuriesLimited investigationFinal reportGarlick UH-1B · Kettle Falls, WAA total loss of engine power due to foreign object (towel) ingestion. Contributing to the accident was maintenance personnel’s inadequate postmaintenance inspection of the engine.May 8, 2015 · N46969 · Substantial damageNTSB WPR15FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172S · Davenport, CAUndetermined because the airplane was not located.May 8, 2015 · N191TGNTSB GAA15CA069Accident · No injuriesData collectionFinal reportBuhlmann Howard HB-1 · Canandaigua, NYThe pilot's failure to land beyond the marked runway threshold, which resulted in a collision with a culvert and a loss of control on the ground.May 8, 2015 · N170HB · Substantial damageNTSB ERA15CA209Accident · No injuriesData collectionFinal reportCessna 150D · Balsam Grove, NCThe pilot's decision to attempt an off airport takeoff, and failure to maintain adequate clearance during the initial climb in crosswind conditions, which resulted in a collision with trees.May 8, 2015 · N5981T · Substantial damageNTSB WPR15FA158Accident · 2 fatalField investigationFinal reportPiper PA 46 350P · Spokane, WAThe mechanic's incorrect installation of two aileron cables and the subsequent inadequate functional checks of the aileron system before flight by both the mechanic and the pilot, which prevented proper roll control from the cockpit, resulting in the pilot's…May 7, 2015 · N962DA · DestroyedNTSB GAA15CA064Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe landing airplane pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground collision with a taxiing airplane.May 7, 2015 · N5144H · 2 aircraft · Substantial damageNTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.May 7, 2015 · N127AE · Substantial damageNTSB GAA15CA061Accident · Minor injuriesData collectionFinal reportHughes TH 55 · Morganton, NCThe flight instructor's delayed flare during a simulated auto rotation, which resulted in a tail rotor strike and rollover.May 5, 2015 · N7089S · Substantial damageNTSB ERA15LA205Accident · Minor injuriesLimited investigationFinal reportJerome D Fischer RV-7 · Bartow, GAThe pilot's use of the improper fuel grade for the engine, which resulted in detonation, engine damage, and loss of engine power.May 5, 2015 · N364SJ · Substantial damageNTSB CEN15LA222Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Basile, LAThe pilot’ failure to maintain adequate clearance from trees while maneuvering during an aerial application flight.May 5, 2015 · N4221G · DestroyedNTSB ANC15CA024Accident · No injuriesData collectionFinal reportRobert M. Jones Zenith CH 701 · Palmer, AKThe pilot's excessive descent rate and subsequent hard landing during the landing flare/touchdown.May 5, 2015 · N669RJ · Substantial damageNTSB GAA15CA068Accident · No injuriesData collectionFinal reportCessna 180 · Hartland, MEAbnormal runway contact which precipitated a loss of control and nose-over.May 4, 2015 · N2724X · Substantial damageNTSB GAA15CA066Accident · No injuriesData collectionFinal reportCessna 177B · Roxboro, NCThe pilot's failure to monitor the airplane's movement and maintain control of the airplane.May 4, 2015 · N1102C · Substantial damageNTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.May 4, 2015 · N88FX · Substantial damageNTSB DCA15CA118Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Phoenix, AZthe CRJ900 captain's misjudgment of the clearance between their horizontal stabilizer and the B757 winglet.May 4, 2015 · N932LR · Substantial damageNTSB CEN15LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-235 · Huntington, INThe pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.May 4, 2015 · N8703W · Substantial damageNTSB ANC15LA076Accident · No injuriesClass 3 · LimitedFinal reportAirbus AS-350 · Hamilton, MTThe pilot's excessive collective application during an autorotation. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.May 4, 2015 · N504WD · Substantial damageNTSB GAA15CA057Accident · Minor injuriesData collectionFinal reportCessna 182T · St Marys, PAThe pilot's decision to rotate the propeller by hand without properly securing the airplane.May 3, 2015 · N53310 · Substantial damageNTSB ERA15FA203Accident · 1 fatalField investigationFinal reportCessna 172 · Penn Yan, NYThe student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.May 3, 2015 · N3969L · Substantial damageNTSB CEN15CA223Accident · No injuriesData collectionFinal reportPiper J3C-65 · De Kalb, ILThe pilot's loss of positional awareness while taxiing, resulting in a collision with a parked and unoccupied airplane. Contributing to the accident was the pilot's difficulty seeing over the nose of the airplane, his preoccupation with trying to control the…May 3, 2015 · N98656 · Substantial damageNTSB WPR15LA155Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Crescent Lake, ORThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…May 1, 2015 · N2514N · Substantial damageNTSB GAA15CA059Accident · No injuriesData collectionFinal reportCessna 180K · Pearland, TXThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.May 1, 2015 · N66048 · Substantial damageNTSB GAA15CA073Accident · No injuriesData collectionFinal reportCessna 182T · Newburyport, MAThe pilot's failure to recover from a bounced landing, which resulted in substantial damage to the airplane during the runway overrun.Apr 30, 2015 · N9085Q · Substantial damageNTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.Apr 30, 2015 · N65813 · Substantial damageNTSB GAA15CA056Accident · No injuriesData collectionFinal reportWilliam D Durkee RV-6 · Tunica, MSThe pilot's failure to maintain directional control during the takeoff roll.Apr 30, 2015 · N91WD · Substantial damageNTSB GAA15CA053Accident · Minor injuriesData collectionFinal reportAero SP Z O O AT 4 LSA · Colorado Springs, COThe pilot's decision to perform aerobatic maneuvers in an airplane not certified for aerobatic flight, which resulted in a loss of control and collision with terrain.Apr 30, 2015 · N344UA · Substantial damage