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 ERA13LA370Accident · No injuriesLimited investigationFinal reportBeech C23 · Bingham, METhe pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.Aug 20, 2013 · N243RG · Substantial damageNTSB CEN13LA497Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · Zanesville, OHThe pilot’s loss of directional control during landing.Aug 20, 2013 · N727Y · Substantial damageNTSB WPR13FA380Accident · 1 fatalField investigationFinal reportNelson KR-2 · Cataldo, IDThe pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.Aug 19, 2013 · N9028Q · Substantial damageNTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.Aug 18, 2013 · N647SP · Substantial damageNTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…Aug 18, 2013 · N9201R · Substantial damageNTSB CEN13CA575Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Mariner · Lee's Summit, MOThe student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.Aug 18, 2013 · N8316D · Substantial damageNTSB CEN13CA499Accident · No injuriesData collectionFinal reportBeech 35 · Wheeling, ILThe pilot’s loss of control due to the passenger’s inadvertent application of left rudder during the takeoff roll.Aug 18, 2013 · N779RB · Substantial damageNTSB CEN13CA494Accident · No injuriesData collectionFinal reportGlobe GC-1B · Santa Teresa, NMThe pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devilAug 18, 2013 · N7BR · Substantial damageNTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…Aug 17, 2013 · N46336 · Substantial damageNTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…Aug 16, 2013 · N19UA · Substantial damageNTSB ERA13LA364Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Indian Trail, NCThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 16, 2013 · N6919B · Substantial damageNTSB CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.Aug 16, 2013 · N2070K · Minor damageNTSB CEN13LA493Accident · Serious injuriesLimited investigationFinal reportTrick Trikes Storm Trooper · Covert, MIThe student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.Aug 16, 2013 · N5157G · Substantial damageNTSB WPR13CA373Accident · Minor injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NVThe pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.Aug 15, 2013 · N110GX · Substantial damageNTSB ANC13CA080Accident · Minor injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection.Aug 15, 2013 · N2141F · Substantial damageNTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.Aug 14, 2013 · N6939K · Substantial damageNTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.Aug 14, 2013 · N8160L · Substantial damageNTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…Aug 14, 2013 · N155UP · DestroyedNTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.Aug 13, 2013 · N9607S · DestroyedNTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…Aug 12, 2013 · N3226C · Substantial damageNTSB ERA13CA362Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Fredericksburg, VAThe pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…Aug 12, 2013 · N4969J · Substantial damageNTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.Aug 12, 2013 · N15EG · Substantial damageNTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.Aug 12, 2013 · N3897Z · Substantial damageNTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.Aug 11, 2013 · N7720P · Substantial damageNTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.Aug 11, 2013 · N557BB · Substantial damageNTSB ERA13CA369Accident · No injuriesData collectionFinal reportMaule M-5-210C · Verona, NYThe pilot’s delay in applying power after a bounced landing, resulting in collision with terrain during a go-around.Aug 11, 2013 · N6617R · Substantial damageNTSB WPR13LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Overgaard, AZThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow. Contributing to the accident was inadequate maintenance of the exhaust system.Aug 10, 2013 · N9752J · Substantial damageNTSB WPR13CA375Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot’s improper flare, which resulted in a hard landing.Aug 10, 2013 · N544ER · Substantial damageNTSB WPR13CA365Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Independence, ORThe pilot's improper flare with a crosswind condition, and unsuccessful attempt to correct a bounced landing, which resulted in a runway excursion and subsequent nose over.Aug 10, 2013 · N96037 · Substantial damageNTSB CEN13LA478Accident · No injuriesLimited investigationFinal reportDouglas Brian G BA-100 · Killeen, TXThe pilot’s improper management of the fuel mixture, which resulted in an over-rich fuel mixture condition and a subsequent partial loss of engine power.Aug 10, 2013 · N27BD · Substantial damageNTSB CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.Aug 10, 2013 · N99094 · Substantial damageNTSB CEN13CA481Accident · No injuriesData collectionFinal reportSuper 18 S18-STD · Humboldt, SDThe pilot's inadvertent addition of water into the fuel system and his improper preflight inspection, which resulted in a loss of engine power due to fuel contamination.Aug 10, 2013 · N230AK · Substantial damageNTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.Aug 10, 2013 · N7811W · Substantial damageNTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.Aug 9, 2013 · N13622 · DestroyedNTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.Aug 9, 2013 · N36538 · Substantial damageNTSB CEN13LA482Accident · No injuriesLimited investigationFinal reportGlos Wallis Richard JR LONG-EZ · Schaumburg, ILThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.Aug 9, 2013 · N721EZ · Substantial damageNTSB ANC13CA077Accident · No injuriesData collectionFinal reportAviat A-1B · Arctic Village, AKThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.Aug 9, 2013 · N286AM · Substantial damageNTSB WPR13LA364Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Burlington, WAThe pilot's inadequate control inputs during a crosswind landing, which resulted in a hard landing and loss of directional control.Aug 8, 2013 · N67045 · Substantial damageNTSB WPR13CA369Accident · No injuriesData collectionFinal reportCessna 172RG · Kent, WAFailure of the certified flight instructor and student pilot to complete the landing checklist resulting in a gear-up landing.Aug 8, 2013 · N4886V · Substantial damageNTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…Aug 7, 2013 · N2195T · Substantial damageNTSB ERA13CA354Accident · No injuriesData collectionFinal reportStetson Norman B Challenger II · Orange, MAThe pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.Aug 6, 2013 · N94454 · Substantial damageNTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…Aug 6, 2013 · N3789E · Substantial damageNTSB CEN13LA463Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Vinton, IAThe pilot's operation of the helicopter at high gross weight and high density altitude while still in ground effect, which reduced the efficiency of the rotor system and the amount of lift produced, which resulted in a collision with terrain. Contributing to…Aug 6, 2013 · N83702 · Substantial damageNTSB WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.Aug 5, 2013 · N234RV · Substantial damageNTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.Aug 5, 2013 · N327FL · Substantial damageNTSB CEN13LA461Accident · 2 fatalLimited investigationFinal reportHughes 369D · Ackerly, TXThe pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.Aug 5, 2013 · N8688F · No damageNTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.Aug 5, 2013 · N3159B · DestroyedNTSB CEN13CA469Accident · No injuriesData collectionFinal reportCessna 182T · Mackinac Island, MIThe pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.Aug 5, 2013 · N3559E · Substantial damageNTSB ANC13CA073Accident · No injuriesData collectionFinal reportCessna U206F · Kokhanok, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.Aug 5, 2013 · N5364Q · Substantial damageNTSB WPR13LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Stanwood, WAThe pilot’s unstabilized approach and his subsequent failure to maintain airspeed during the aborted landing, which resulted in a stall and the airplane bouncing hard on the runway.Aug 4, 2013 · N58437 · Substantial damage