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 ERA21LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Milton, FLThe pilot’s failure to attain a proper touchdown point and his landing with a high approach speed, which resulted in a runway overrun.Dec 6, 2020 · N78329 · Substantial damageNTSB ERA21LA065Incident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Leesburg, VAThe pilot’s loss of directional control during landing in crosswind conditions. Contributing to the loss of control was the significantly underinflated nose landing gear tire.Dec 6, 2020 · N282ST · Minor damageNTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…Dec 6, 2020 · N2674H · Substantial damageNTSB CEN21LA075Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32 · Windom, MNThe pilot’s spatial disorientation shortly after takeoff into night instrument meteorological conditions, which resulted in loss of airplane control and subsequent impact with terrain.Dec 6, 2020 · N8178Y · DestroyedNTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.Dec 5, 2020 · N371MP · Substantial damageNTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.Dec 4, 2020 · N737NB · Substantial damageNTSB ANC21LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Juneau, AKThe solo student pilot’s failure to maintain directional control during taxi in strong crosswind conditions, which resulted in a loss of control and subsequent impact with a ditch.Dec 3, 2020 · N4900C · Substantial damageNTSB CEN21LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna 551 · Lufkin, TXThe pilot’s decision to land on a runway that did not provide enough length to stop the airplane given the wet surface conditions, resulting in a runway excursion.Dec 2, 2020 · N48DK · Substantial damageNTSB CEN21LA079Accident · No injuriesClass 4 · LimitedFinal reportHutson Star-Lite · San Antonio, TXThe pilot’s decision to land on a soft terrain which resulted in the failure of the nose landing gear.Dec 1, 2020 · N322SL · Substantial damageNTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.Nov 30, 2020 · N9879T · DestroyedNTSB WPR21LA155Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · St. George, UTThe pilot’s failure to maintain control of the balloon and a member of the ground crews entanglement with a tether rope, which resulted in a serious injury when they fell to the ground after the balloon unexpectedly ascended.Nov 29, 2020 · N9051Y · No damageNTSB ERA21LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bellefonte, PAThe pilot's failure to maintain directional control while landing, which resulted in a runway excursion.Nov 29, 2020 · N8056N · Substantial damageNTSB ERA21LA060Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Northhampton, NYThe pilot’s loss of airplane control during an off-airport landing on soft sand, which resulted in a nose over.Nov 29, 2020 · N9721N · Substantial damageNTSB ERA21LA058Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Georgetown, DEThe pilot’s failure to maintain airplane control while on landing in gusting crosswind conditions.Nov 28, 2020 · N7596B · Substantial damageNTSB CEN21LA069Accident · Minor injuriesClass 4 · LimitedFinal reportGlobe GC1A · Ottawa, KSThe student pilot’s failure to maintain attain proper pitch attitude of the airplane causing it to exceed its critical angle of attack, enter an aerodynamic stall, and subsequently impact terrain, and his poor decision making and lack of experience that led…Nov 28, 2020 · N3318K · Substantial damageNTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.Nov 28, 2020 · N5242W · Substantial damageNTSB CEN21LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hollister, MOThe pilot’s failure to maintain proper airspeed control during an instrument approach in instrument meteorological conditions, which led to a bounced landing, collapsing the nose landing gear, and resulting in substantial damage.Nov 26, 2020 · N182PP · Substantial damageNTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…Nov 26, 2020 · N87LW · Substantial damageNTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…Nov 25, 2020 · N8125U · 2 aircraft · Substantial damageNTSB ERA21LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot’s failure to maintain a proper glidepath while on approach to the runway, and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with a tree on final approach.Nov 24, 2020 · N23NJ · Substantial damageNTSB ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.Nov 24, 2020 · N5566J · Substantial damageNTSB ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.Nov 24, 2020 · N35AW · DestroyedNTSB ERA21LA052Accident · 1 fatalClass 3 · LimitedFinal reportLancair Legacy FG · Hollywood, FLThe pilot/owner’s failure to properly reinstall the number 1 cylinder spark plug, which resulted in a partial loss of engine power during the initial climb. Contributing was the pilot's exceedance of the airplane’s critical angle of attack during an attempted…Nov 23, 2020 · N3UH · Substantial damageNTSB CEN21LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Gilliam, LAThe non-instrument rated pilot’s encounter with poor weather conditions resulting in his performing a precautionary landing to a cornfield and subsequently nosing over.Nov 23, 2020 · N2569M · Substantial damageNTSB ERA21LA051Accident · Serious injuriesClass 4 · LimitedFinal reportJ&J Ultralights Sea-Wing · Placida, FLThe pilot/owner’s improper preflight inspection of the weight-shift trike, which resulted in a loss of control at takeoff due to an improperly adjusted wingtip.Nov 22, 2020 · N947RC · Substantial damageNTSB WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.Nov 21, 2020 · N878AH · Substantial damageNTSB WPR21FA057Accident · 1 fatalClass 3 · FieldFinal reportBlevins Kamron Odyssey · Arlington, WAThe pilot’s loss of airplane control for reasons that could be determined based on available evidence.Nov 20, 2020 · N562TB · DestroyedNTSB ERA21LA049Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Lititz, PAThe pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.Nov 20, 2020 · N9086W · Substantial damageNTSB CEN21LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lawrence, KSThe student pilot’s improper landing flare/touchdown which resulted in a hard landing.Nov 20, 2020 · N99HV · Substantial damageNTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.Nov 19, 2020 · N6203F · Substantial damageNTSB CEN21LA064Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · El Paso, TXThe pilot’s loss of control on takeoff during a touch and go landing, which resulted in a runway excursion.Nov 19, 2020 · N5XY · Substantial damageNTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.Nov 18, 2020 · N442JP · Substantial damageNTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.Nov 18, 2020 · N734JF · Substantial damageNTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.Nov 17, 2020 · N82V · Substantial damageNTSB CEN21LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Johnson City, KSThe pilot’s improper decision to fly the airplane at too low an altitude resulting in the airplane impacting terrain.Nov 17, 2020 · N2376N · Substantial damageNTSB ERA21LA042Accident · Serious injuriesClass 3 · LimitedFinal reportRepublic RC3 · Advance, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 16, 2020 · N451E · Substantial damageNTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.Nov 16, 2020 · N18666 · DestroyedNTSB WPR21LA058Accident · Minor injuriesClass 3 · LimitedFinal reportAir Creation Tanarg · Pahrump, NVThe pilot’s failure to maintain control while maneuvering at low altitude.Nov 15, 2020 · N912U · Substantial damageNTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.Nov 15, 2020 · N9111 · Substantial damageNTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.Nov 14, 2020 · N8278B · Substantial damageNTSB WPR21LA055Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · San Bernardino, CAA total loss of engine power due to fuel contamination. Contributing to the accident was an inadequate preflight inspection.Nov 14, 2020 · N757PY · Substantial damageNTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.Nov 14, 2020 · N311SV · Substantial damageNTSB ERA21LA043Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS355 · Hammonton, NJThe pilot's decision to continue the takeoff with a perceived mechanical deficiency.Nov 14, 2020 · N712CA · Substantial damageNTSB DCA21LA024Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL600 2C10 · Phoenix, AZThe flight attendant’s use of improper procedures when opening the main cabin door.Nov 14, 2020 · N778SK · No damageNTSB WPR21LA054AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe pilot’s incorrect automated landing profile selection, which resulted in an impact with a runway trench. Contributing to the accident was the pilot receiving instruction's and instructor's failure to spot the incorrect landing profile selection during…Nov 13, 2020 · CBP233 · DestroyedNTSB WPR21LA053Accident · No injuriesClass 4 · LimitedFinal reportAir Creation Buggy · Benson, AZThe non-rated pilot’s unstable approach and failure to maintain aircraft control, which resulted in a hard landing and collision with terrain.Nov 13, 2020 · N2764N · Substantial damageNTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.Nov 12, 2020 · N721P · Substantial damageNTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.Nov 12, 2020 · N939CP · DestroyedNTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.Nov 12, 2020 · N3535A · Substantial damageNTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…Nov 12, 2020 · N7306H · Substantial damage