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 ERA21LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orange, VAThe student pilot’s improper recovery from a bounced landing.Feb 8, 2021 · N841SP · Substantial damageNTSB DCA21LA082Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Fort Lauderdale, FLAn abrupt flight control input by the flight crew during descent that caused a flight attendant to fall and fracture their ankle.Feb 8, 2021 · N918NK · No damageNTSB CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.Feb 8, 2021 · N8080G · DestroyedNTSB ERA21LA125Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC-65 · Columbia, SCA total loss of engine power due to carburetor icing, which resulted from the student pilot’s failure to use carburetor heat.Feb 7, 2021 · N24476 · Substantial damageNTSB ERA21LA124Accident · 2 fatalClass 3 · LimitedFinal reportCessna 441 · Belvidere, TNThe pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.Feb 7, 2021 · N44776 · DestroyedNTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.Feb 7, 2021 · N348RM · Substantial damageNTSB WPR21LA106Accident · No injuriesClass 4 · LimitedFinal reportJabiru SP 250 · Thermal, CAThe pilot’s loss of directional control during landing in gusting wind conditions, which resulted in a runway excursion and nose over.Feb 5, 2021 · N7850K · Substantial damageNTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…Feb 5, 2021 · N115FP · Substantial damageNTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.Feb 4, 2021 · N8107S · Substantial damageNTSB CEN21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-50 · Weidman, MIThe pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.Feb 3, 2021 · N26811 · Substantial damageNTSB ERA21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Leicester, MAThe pilot’s failure to maintain the minimum airspeed for flight in icing conditions, which resulted in a loss of elevator control during approach due to ice accumulation.Feb 2, 2021 · N221ST · Substantial damageNTSB CEN21LA121Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182Q · Hackberry, LAThe flight instructor did not maintain control of the airplane during training maneuvers, which resulted in a rapid, steep descent and impact with terrain.Feb 2, 2021 · N4765N · DestroyedNTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.Jan 31, 2021 · N4376Q · DestroyedNTSB ERA21LA121Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Knoxville, TNThe pilot’s failure to maintain directional control of the helicopter, which resulted in rear portion of the right skid contacting the ground and a subsequent dynamic rollover.Jan 30, 2021 · N660TN · Substantial damageNTSB ERA21LA120Accident · Serious injuriesClass 4 · LimitedFinal reportRivers Lindsey Lee Vans RV6A · O'Brien, FLThe flight instructor’s improper soft field landing technique while landing on a turf runway, which resulted in a nose over.Jan 29, 2021 · N9136R · Substantial damageNTSB CEN21LA120Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Clare, MIThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and impact with terrain.Jan 29, 2021 · N22101 · Substantial damageNTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.Jan 28, 2021 · N997MC · Substantial damageNTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.Jan 28, 2021 · N217US · Substantial damageNTSB WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.Jan 27, 2021 · N9114A · Substantial damageNTSB ERA21LA117Accident · No injuriesClass 4 · LimitedFinal reportRobinson R22 · West Palm Beach, FLThe examiner’s failure to arrest the helicopter descent during a simulated engine failure maneuver and the flight instructor’s inadequate remedial action, which resulted in a hard landing.Jan 26, 2021 · N474AT · Substantial damageNTSB ERA21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Boynton Beach, FLThe pilot’s controlled flight into the ocean at night due to his unrecognized spatial disorientation. Contributing to the accident was the pilot’s distraction with the tuning of his transponder while maneuvering over an area with reduced visual references.Jan 25, 2021 · N266ND · Substantial damageNTSB ANC21LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe instructor pilot’s selection of an unsuitable snow-covered runway for landing practice, and the pilot under instruction’s failure to maintain directional control during a landing roll, which resulted in a loss of control in unpacked snow and a subsequent…Jan 25, 2021 · N4265H · Substantial damageNTSB WPR21LA096Accident · No injuriesClass 4 · LimitedFinal reportHeckel Super Sportsman · Spotted Bear, MTThe pilot’s failure to maintain aircraft control during the landing roll on an unimproved snow-covered runway which resulted in a nose-over.Jan 24, 2021 · N55BT · Substantial damageNTSB WPR21LA158Accident · 1 fatalClass 3 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and fatal passenger injury when the passenger fell out of the basket.Jan 23, 2021 · N477LB · No damageNTSB ERA21LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Terrell, NCThe pilot’s failure to retract the landing gear on the amphibious airplane prior to a water landing, resulting in a nose over and structural damage to the airframe. The mechanic’s failure to remove electrical tape from the pitot tube, the pilot’s inadequate…Jan 23, 2021 · N480F · Substantial damageNTSB ERA21LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Rockingham, NCThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing and a runway excursion.Jan 23, 2021 · N42714 · Substantial damageNTSB WPR21LA093Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Queen Creek, AZThe pilot's uncoordinated flight control inputs while entering a hover, which lead to a loss of aircraft control which resulted in the left skid making contact with the ground, causing the helicopter to roll on its side.Jan 22, 2021 · N90TG · Substantial damageNTSB CEN21LA116Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Mankato, MNThe pilot’s loss of situational awareness while landing, resulting in an impact with power lines.Jan 22, 2021 · N60BK · Substantial damageNTSB ERA21LA164Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Miami, FLThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an aerodynamic stall and impact with terrain. Also causal was the flight instructor’s inadequate remedial action.Jan 19, 2021 · N4530T · Substantial damageNTSB ERA21LA106Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA5 · Leesburg, VAThe weakened structure of the left horizontal stabilizer, which resulted in elevator flutter and subsequent partial separation of the left elevator in flight. Contributing to the accident were the lack of elevator authority while landing due to the damaged…Jan 19, 2021 · N5880L · Substantial damageNTSB CEN21LA113Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Newellton, LAThe pilot’s failure to maintain clearance from powerlines/poles and terrain while maneuvering for reasons that could not be determined based on available evidence.Jan 19, 2021 · N523BB · Substantial damageNTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.Jan 17, 2021 · N919DC · Substantial damageNTSB WPR21LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCreek Michel W Bearhawk · Elko, NVThe pilot’s unstable approach to land, which resulted in a loss of directional control and subsequent nose over. Contributing to the accident was the pilot’s decision to continue an approach in sun glare conditions.Jan 16, 2021 · N2828M · Substantial damageNTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.Jan 15, 2021 · N404N · Substantial damageNTSB WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.Jan 14, 2021 · N5930R · Substantial damageNTSB ERA21LA107Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Pell City, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer’s engine restart procedures after a total loss of engine power and his incomplete preflight…Jan 13, 2021 · N771JP · Substantial damageNTSB ERA21LA101Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Columbia, SCThe pilot's in-flight loss of airplane control due to spatial disorientation during a missed approach in instrument meteorological conditions.Jan 13, 2021 · N266DC · DestroyedNTSB CEN21LA189Accident · No injuriesClass 4 · LimitedFinal reportBeech P35 · Poplar Grove, ILThe pilot's distraction and his failure to maintain a proper glidepath on the approach, which resulted in him landing short of the runway and impacting a snowbank.Jan 12, 2021 · N436T · Substantial damageNTSB CEN21LA124Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12C · Lafayette, INThe pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.Jan 12, 2021 · N552DR · Substantial damageNTSB CEN21LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Sparta, MIThe pilot’s failure to maintain the proper glideslope during final approach, which resulted in contact with a snowbank at the approach end of the runway.Jan 12, 2021 · N35718 · Substantial damageNTSB ERA21LA102Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Vineland, NJA steep descent and impact with terrain during final approach for reasons that could not be determined.Jan 11, 2021 · UNREG · Substantial damageNTSB ERA21LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 421B · Old Bethpage, NYThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing.Jan 10, 2021 · N421DP · Substantial damageNTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.Jan 9, 2021 · N8612F · Substantial damageNTSB WPR21LA082Accident · 1 fatalClass 3 · LimitedFinal reportCessna 560 · Warm Springs, ORA loss of airplane control due to pilot incapacitation for reasons that could not be determined.Jan 9, 2021 · N3RB · DestroyedNTSB CEN21LA110Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Cushing, OKThe pilot’s decision to takeoff from unsuitable terrain which resulted in an aerodynamic stall and subsequent impact with terrain.Jan 9, 2021 · N4540C · Substantial damageNTSB CEN21LA109Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Albany, TXThe pilot’s inadequate pretakeoff checks which resulted in the magneto switch (key) remaining in the OFF position during the takeoff sequence and initial climb and the right magneto grounding intermittently.Jan 9, 2021 · N322SH · Substantial damageNTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.Jan 8, 2021 · N4344B · Substantial damageNTSB CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…Jan 4, 2021 · N325GC · DestroyedNTSB WPR21LA076Accident · No injuriesClass 4 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Santa Monica, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Jan 3, 2021 · N52NL · Substantial damageNTSB WPR21LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Moab, UTThe pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.Jan 2, 2021 · N833RT · Substantial damage