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 ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.Sep 18, 2023 · N1451U · Substantial damageNTSB WPR23FA345Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Reno, NVThe failure of both the Race 14 and Race 6 pilots to see and avoid each other while in the airport traffic pattern. Contributing to the accident was both pilots’ failure to fly the standard downwind and base legs.Sep 17, 2023 · N2897G · 2 aircraft · Substantial damageNTSB CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.Sep 17, 2023 · N6398G · Substantial damageNTSB ANC23LA082Accident · No injuriesClass 4 · LimitedFinal reportHelio H-295 · Fairbanks, AKThe pilot’s encounter with windshear during initial climb out, which resulted in a loss of control.Sep 17, 2023 · N713C · Substantial damageNTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.Sep 17, 2023 · N907W · Substantial damageNTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.Sep 16, 2023 · N46WR · Substantial damageNTSB ANC23LA085Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Johnson River, AKThe ground crew’s failure to remain clear of a tag line during sling load operations, resulting in his entanglement.Sep 16, 2023 · N297SH · No damageNTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.Sep 16, 2023 · N1755P · Substantial damageNTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.Sep 15, 2023 · N57TJ · Substantial damageNTSB CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.Sep 15, 2023 · N853HT · DestroyedNTSB ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.Sep 14, 2023 · N5269G · Substantial damageNTSB ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.Sep 14, 2023 · N2880S · Substantial damageNTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…Sep 13, 2023 · N2796H · Substantial damageNTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.Sep 13, 2023 · N529ER · Substantial damageNTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.Sep 13, 2023 · N95250 · Substantial damageNTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…Sep 13, 2023 · N109T · Substantial damageNTSB CEN23FA409Accident · 1 fatalClass 3 · FieldFinal reportThrush S2R-T660 · Ardoch, NDThe pilot’s failure to maintain clearance from a guy wire during an aerial application flight.Sep 12, 2023 · N710TY · Substantial damageNTSB ANC23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Healy, AKThe pilot’s selection of an unsuitable landing site, resulting in a nose over.Sep 12, 2023 · N34VV · Substantial damageNTSB CEN23LA414Accident · Minor injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Fortuna, MOThe non-certificated pilot’s failure to maintain the unregistered powered parachute’s clearance from power lines.Sep 11, 2023 · UNREG · Substantial damageNTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.Sep 11, 2023 · N4900C · Substantial damageNTSB WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…Sep 10, 2023 · N873HL · DestroyedNTSB ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.Sep 10, 2023 · N124UA · Substantial damageNTSB CEN23LA406Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Elk Grove Village, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing. Also causal was the pilot’s decision to go around with minimum fuel.Sep 8, 2023 · N220KW · Substantial damageNTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 7, 2023 · N234RA · Substantial damageNTSB ERA23LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Norwood, MAThe pilot’s failure to fly an appropriate glide path during the landing approach, which resulted in a collision with approach lights and the ground short of the intended runway.Sep 7, 2023 · N400RW · Substantial damageNTSB DCA23LA445Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Hebron, KYAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Sep 7, 2023 · N37531 · No damageNTSB CEN23LA408Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Berryville, ARThe pilot’s failure to maintain aircraft control during the attempted go-around.Sep 7, 2023 · N603CT · Substantial damageNTSB CEN23LA404Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Arcola, TXThe instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.Sep 7, 2023 · N8372F · Substantial damageNTSB WPR23LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna T210H · Santa Rosa, CAThe pilot’s failure to configure the landing gear during the landing approach.Sep 6, 2023 · N2210R · Substantial damageNTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.Sep 6, 2023 · N81GX · Substantial damageNTSB CEN23FA401Accident · 2 fatalClass 3 · FieldFinal reportCessna 150K · Huntsville, TXA partial loss of engine power due to fuel starvation caused by a fuel system blockage, and the flight instructor’s subsequent failure to maintain adequate airspeed after the loss of engine power, which resulted in the airplane exceeding its critical angle of…Sep 6, 2023 · N6059G · Substantial damageNTSB WPR23LA340Accident · No injuriesClass 3 · LimitedFinal reportRutan Long-EZ · Bullhead City, AZThe pilot’s improper flair resulting in a hard landing.Sep 5, 2023 · N58JB · Substantial damageNTSB ANC23LA071Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · King Salmon, AKThe failure of both pilots to see and avoid while en route, which resulted in a midair collision.Sep 5, 2023 · N193AL · 2 aircraft · Substantial damageNTSB CEN23LA402Accident · No injuriesClass 3 · LimitedFinal reportVans RV14 · Orchard, TXThe failure of an alternator belt and the builder/previous owner’s incorrect electrical wiring of the airplane’s other alternator, which resulted in a total loss of electrical and engine power.Sep 4, 2023 · N14NP · Substantial damageNTSB CEN23LA398Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-12 · Crystal, MNThe pilot’s improper landing flare, which resulted in a bounced landing and an overstress fracture of the nose landing gear strut.Sep 4, 2023 · N321BT · Substantial damageNTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.Sep 4, 2023 · N467TE · Substantial damageNTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.Sep 3, 2023 · N192HH · Substantial damageNTSB ERA23LA389Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Baltimore, MDThe pilot’s failure to maintain control of the airplane during the aborted landing, which resulted in a collision with a taxiway light.Sep 3, 2023 · N74TR · Substantial damageNTSB ERA23FA358Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR20 · Toms River, NJThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion), which resulted in impact with trees and terrain.Sep 3, 2023 · N420PB · DestroyedNTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.Sep 3, 2023 · N5254D · Substantial damageNTSB CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Sep 3, 2023 · N1374F · Substantial damageNTSB ANC23LA069Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall and loss of airplane control.Sep 3, 2023 · N723AK · Substantial damageNTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…Sep 2, 2023 · N6834W · Substantial damageNTSB WPR23LA333Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Three Rocks, CAThe airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.Sep 1, 2023 · N61373 · Substantial damageNTSB WPR23LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Coolidge, AZThe pilot's failure to extend the landing gear before landing.Sep 1, 2023 · N440DM · Substantial damageNTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.Sep 1, 2023 · N2480Y · Substantial damageNTSB CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.Sep 1, 2023 · N172SP · Substantial damageNTSB WPR23LA331Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Ennis, MTThe pilot's failure to extend the landing gear before landing.Aug 31, 2023 · N92NJ · Substantial damageNTSB CEN23LA392Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Midlothian, TXThe pilot’s failure to maintain directional control during landing which resulted in the right main landing gear collapse.Aug 31, 2023 · N11648 · Substantial damageNTSB CEN23LA389Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 530FF · Liberty Hill, TXThe pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.Aug 31, 2023 · N530JR · Substantial damage