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 GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.Aug 25, 2018 · N7635F · Substantial damageNTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.Aug 25, 2018 · N4569C · Substantial damageNTSB ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.Aug 25, 2018 · N6936B · Substantial damageNTSB ANC18CA068Accident · Minor injuriesData collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll when the left main landing gear wheel got caught in a ditch, which resulted in a subsequent nose-over.Aug 25, 2018 · N5392Y · Substantial damageNTSB GAA18CA510Accident · No injuriesData collectionFinal reportMaule MX7 · Post Mills, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.Aug 24, 2018 · N524TR · Substantial damageNTSB GAA18CA508Accident · Minor injuriesData collectionFinal reportRobinson R22 · Corvallis, ORThe student helicopter pilot’s inadequate torque pedal application during practice approaches with a tailwind, which resulted in a loss of yaw control and a subsequent hard landing.Aug 24, 2018 · N4085T · Substantial damageNTSB ERA18FA230Accident · 1 fatalField investigationFinal reportAeronca 7AC · Hanson, MAA loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…Aug 24, 2018 · N65HM · Substantial damageNTSB DCA18CA272Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 757 · Philadelphia, PAThe ground service employee's inadvertent fall near the nose wheel during pushback.Aug 24, 2018 · EI-LBT · No damageNTSB GAA18CA507Accident · Minor injuriesData collectionFinal reportVans RV10 · Spring Branch, TXThe pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…Aug 23, 2018 · N110DV · Substantial damageNTSB GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.Aug 23, 2018 · N419SP · Substantial damageNTSB CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.Aug 23, 2018 · N215SF · DestroyedNTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.Aug 23, 2018 · N2880W · Substantial damageNTSB WPR18FA237Accident · 2 fatalClass 3 · FieldFinal reportChampion 7KCAB · Descanso, CAThe pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…Aug 22, 2018 · N1682G · Substantial damageNTSB GAA18CA506Accident · No injuriesData collectionFinal reportHughes 369 · Ridgeway, PAThe pilot's failure to maintain clearance from power lines during an aerial observation flight.Aug 22, 2018 · N89ZC · Substantial damageNTSB CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.Aug 22, 2018 · N4275Q · Substantial damageNTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.Aug 21, 2018 · N98146 · Substantial damageNTSB WPR18FA232Accident · 2 fatalField investigationFinal reportHughes 369 · Granger, TXThe failure of both pilots to see and avoid a power line while maneuvering at low altitude. Contributing to the accident was the flight instructor's decision to not follow the training syllabus and allow the low-level high-speed flight.Aug 21, 2018 · N530FU · DestroyedNTSB GAA18CA499Accident · Minor injuriesData collectionFinal reportEvolution Trikes Revo · Hawthorne, CAThe flight instructor’s failure to maintain lateral control of the weight-shift-controlled aircraft during the landing flare.Aug 21, 2018 · N145PT · Substantial damageNTSB WPR18TA238Accident · Serious injuriesClass 3Final reportRans S14 · Brownsville, ORThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, loss of control, and impact with terrain.Aug 20, 2018 · N140JL · Substantial damageNTSB WPR18LA233Accident · No injuriesLimited investigationFinal reportBlue Oak CCK-1865 · Deadwood, CAA loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.Aug 20, 2018 · N14CK · Substantial damageNTSB WPR18FA229Accident · 2 fatalField investigationFinal reportJames E Causey Acroduster II · Phoenix, AZAn exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.Aug 20, 2018 · N787WM · Substantial damageNTSB GAA18CA547Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, VTThe student pilot’s improper landing flare, which resulted in a bounced landing.Aug 20, 2018 · N557SP · Substantial damageNTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.Aug 20, 2018 · N6727A · Substantial damageNTSB CEN18LA341Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Granbury, TXThe pilot’s failure to maintain directional control during a crosswind landing, which resulted in the airplane exiting the runway and impacting a ditch, tree, and fence.Aug 20, 2018 · N1133T · Substantial damageNTSB WPR18TA243Accident · No injuriesFinal reportBeech 36 · Kelso, WAThe pilot's fuel mismanagement, which led to fuel starvation, a total loss of engine power, and the subsequent forced landing to a field.Aug 19, 2018 · N9031S · Substantial damageNTSB GAA18CA518Accident · Minor injuriesData collectionFinal reportRans Rans S6S · Painton, MOThe pilot's failure to maintain the proper pitch attitude during landing, which resulted in a bounced, hard landing.Aug 19, 2018 · N107SJ · Substantial damageNTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.Aug 18, 2018 · N84CP · Substantial damageNTSB GAA18CA512Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Battle Mountain, NVThe pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.Aug 18, 2018 · N8052G · DestroyedNTSB GAA18CA497Accident · No injuriesData collectionFinal reportPiper PA18 · Stony RIver, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Aug 18, 2018 · N3872Z · Substantial damageNTSB GAA18CA496Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot’s failure to maintain clearance from tree foliage on the left side of the runway during takeoff due to his focus on the right side of the runway.Aug 18, 2018 · N185MC · Substantial damageNTSB ERA18LA224Accident · No injuriesClass 3 · LimitedFinal reportGlasair SHA · Greenville, NCA total loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s misjudgment of the airplane’s glidepath during the forced landing, which resulted in the airplane touching…Aug 18, 2018 · N38WS · Substantial damageNTSB CEN18LA345Accident · No injuriesLimited investigationFinal reportCessna T210 · Tulsa, OKThe pilot's decision to take off with a known electrical problem, which resulted in the loss of electrical power, problem with the landing gear extension system, and subsequent runway excursion.Aug 18, 2018 · N6958N · Substantial damageNTSB CEN18LA344Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Addison, TXThe pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.Aug 18, 2018 · N893JA · Substantial damageNTSB CEN18FA339Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Bronson, MIThe pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.Aug 18, 2018 · N502RL · DestroyedNTSB WPR18LA226Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369 · Riverside, CAThe instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.Aug 17, 2018 · N105JL · Substantial damageNTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.Aug 17, 2018 · N4102N · Substantial damageNTSB ERA18LA227Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Mayport, FLThe failure of a fuel line due to improper installation of a fuel flow sensor, which resulted in fuel starvation and a subsequent total loss of engine power.Aug 17, 2018 · N1330Z · Substantial damageNTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…Aug 17, 2018 · N2893Q · Substantial damageNTSB GAA18CA491Accident · Minor injuriesData collectionFinal reportCessna U206 · Barter Island, AKThe pilot's failure to maintain lateral control while taxiing in gusting wind conditions.Aug 16, 2018 · N206JM · Substantial damageNTSB CEN18LA334Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Kindred, NDThe pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…Aug 16, 2018 · N3625Z · DestroyedNTSB GAA18CA520Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s failure to maintain directional control during landing in gusting wind conditions.Aug 15, 2018 · N4165Z · Substantial damageNTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.Aug 15, 2018 · N1543Y · Substantial damageNTSB GAA18CA492Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the left wing and horizontal stabilizer striking the ground.Aug 15, 2018 · N9949N · Substantial damageNTSB ERA18LA220Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Stuart, FLInadequate maintenance inspection of the airplane's nose landing gear, which resulted in a nose landing gear collapse during landing due to cracking and corrosion.Aug 15, 2018 · N425AZ · Substantial damageNTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.Aug 14, 2018 · N1085U · Substantial damageNTSB DCA18IA269Incident · Minor injuriesIncident investigationFinal reportDJI Phantom · Blacksburg, VAthe drone pilot's incorrect control inputs due to insufficient knowledge of the aircraft flight manual procedures. Contributing to the incident was the close proximity of the observers, and the decision to conduct a demonstration near the observers in a…Aug 14, 2018 · FA3HCWCR4X · Minor damageNTSB WPR18LA241Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Afton, WYThe pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.Aug 13, 2018 · N5660J · Substantial damageNTSB DCA18CA283Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A321-271N · Los Angeles, CAa tailstrike caused by inappropriate recovery technique after a bounced landing. Contributing to the accident was the failure of the radio altimeter, caused by the approach being over calm/flat water, that was not recognized by the flight crew.Aug 13, 2018 · N204HA · Substantial damageNTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…Aug 13, 2018 · N42218 · Substantial damageNTSB CEN18FA326Accident · 1 fatalField investigationFinal reportCessna 525 · Payson City, UTThe pilot's intentional flight into his residence.Aug 13, 2018 · N526CP · Substantial damage