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 ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.Aug 3, 2022 · N88550 · Substantial damageNTSB CEN22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Melville, LAThe pilot improperly monitored the operating environment which resulted in a collision with a tree located in the middle of a field.Aug 3, 2022 · N41850 · Substantial damageNTSB ANC22LA082Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Kokhanok, AKThe pilot's failure to maintain directional control of the airplane during takeoff operations.Aug 3, 2022 · N65223 · Substantial damageNTSB ERA22FA351Accident · 2 fatalClass 3 · FieldFinal reportSmith Aerostar 600 · South Haven Charter Township, MIA loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.Aug 2, 2022 · N9784Q · DestroyedNTSB ERA22FA350Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502 · Cheneyville, LAThe pilot’s loss of control after exceeding the airplane’s critical angle of attack for reasons that could not be determined.Aug 2, 2022 · N9184Q · Substantial damageNTSB CEN22LA381Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Port Alsworth, AKA hard landing that occurred at an unknown time and date, which resulted in substantial damage.Aug 2, 2022 · N317AK · Substantial damageNTSB ERA22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Wauchula, FLThe pilot’s failure to maintain directional control after landing. A contributing factor was a degraded left main landing gear wheel assembly.Aug 1, 2022 · N119ED · Substantial damageNTSB CEN22LA352Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Washington, LAThe pilot’s failure to maintain clearance from a wire during an aerial application of a field.Aug 1, 2022 · N407CT · Substantial damageNTSB CEN22LA379Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Joliet, ILThe pilot’s inadequate landing flare, which resulted in a hard, bounced landing.Jul 31, 2022 · N3519Y · Substantial damageNTSB CEN22LA350Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marshall, MOThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.Jul 31, 2022 · N458SG · Substantial damageNTSB ERA22LA353Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Columbus, OHThe pilot’s improper landing flare, which resulted in a bounced landing and a collapse of the left main landing gear.Jul 30, 2022 · N9162K · Substantial damageNTSB CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.Jul 30, 2022 · N3260V · Substantial damageNTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.Jul 30, 2022 · N6587E · Substantial damageNTSB CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.Jul 30, 2022 · N2902N · Substantial damageNTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.Jul 30, 2022 · N6212Y · Substantial damageNTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.Jul 30, 2022 · N501MW · DestroyedNTSB WPR22LA289Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fairbank's, AKThe student pilot's failure to maintain directional control during the takeoff roll.Jul 29, 2022 · N4493B · Substantial damageNTSB ERA22LA348Accident · 1 fatalClass 3 · LimitedFinal reportCASA C212 · Raeford, NCThe airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.Jul 29, 2022 · N497CA · Substantial damageNTSB ERA22FA343Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter AS350 · Andalusia, ALThe pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.Jul 29, 2022 · N124LN · Substantial damageNTSB CEN22LA369Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Evansville, INThe pilot’s improper landing flare in gusting winds, which resulted in a hard landing and the nose gear collapsing.Jul 29, 2022 · N5200S · Substantial damageNTSB CEN22LA353Accident · Serious injuriesClass 3 · LimitedFinal reportSonex Sonex · River Falls, WIThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 29, 2022 · N1557S · Substantial damageNTSB CEN22LA348Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sturgeon Lake, MNThe pilot’s failure to maintain directional control during takeoff from a gravel driveway resulting in an impact with a tree.Jul 29, 2022 · N42584 · Substantial damageNTSB WPR22LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s improper decision to takeoff from an unimproved airstrip with a high density altitude which degraded its climb performance and led to a collision with vegetation off the end of the airstrip.Jul 28, 2022 · N82735 · Substantial damageNTSB ERA22LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Dillingham, AKMaintenance personnel’s failure to detect and correct improper rudder control system alignment, the resulting interference with the pulley’s rotation, and the accelerated corrosion and wear of the control cable, which ultimately led to its failure in flight.Jul 28, 2022 · N6908M · Substantial damageNTSB CEN22LA372Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-3 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll which resulted in a runway excursion and collision with a ditch.Jul 28, 2022 · N320KT · Substantial damageNTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.Jul 28, 2022 · N79KM · 2 aircraft · Substantial damageNTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.Jul 28, 2022 · N719TF · Substantial damageNTSB CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.Jul 28, 2022 · N3027J · Substantial damageNTSB ANC22LA062Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Anchorage, AKThe pilot’s failure to maintain directional control during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with equipment.Jul 28, 2022 · N6165V · Substantial damageNTSB WPR22LA292Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · San Diego, CAThe student pilot’s unstable approach and inadequate flare which resulted in a hard, bounced landing.Jul 27, 2022 · N41757 · Substantial damageNTSB WPR22LA284Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier BD-100-1A10 · San Francisco, CAAn inflight upset resulting in serious injury to the cabin attendant following an autopilot disconnect for reasons that could not be determined based on the available information.Jul 27, 2022 · N557XJ · No damageNTSB ERA22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Barnstable, MAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun in gusting wind conditions.Jul 27, 2022 · N7437G · Substantial damageNTSB ERA22LA341Accident · No injuriesClass 4 · LimitedFinal reportGarlick OH-58A+ · Bloomsburg, PAThe pilot's inadequate preflight planning and visual lookout, which resulted in impact with a powerline.Jul 27, 2022 · N132HD · Substantial damageNTSB ERA22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Mariner · Hollywood, FLInadequate maintenance of the helicopter’s tail rotor blades, which resulted in a failure of the tail rotor drive system, and an inflight loss of yaw control from which the flight instructor was unable to recover.Jul 27, 2022 · N42WC · Substantial damageNTSB CEN22LA440Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Merrill, WIThe student pilot's failure to maintain adequate roll control during takeoff with a quartering tailwind.Jul 27, 2022 · N2240L · Substantial damageNTSB CEN22LA374Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot’s failure to maintain proper approach glide path, which resulted in a collision with a berm.Jul 27, 2022 · N4210Z · Substantial damageNTSB ANC22LA064Accident · Serious injuriesClass 3 · LimitedFinal report5 Rivers SQ-2 · Soldotna, AKA total loss of engine power due to carburetor icing, which resulted from the pilot's failure to use carburetor heat while operating in conditions conducive to the formation of carburetor ice.Jul 27, 2022 · N58SQ · Substantial damageNTSB ERA22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS365 · Hamilton, OHThe pilot’s decision to continue the landing without having visually identified wires that were known to be in the vicinity of the landing zone, which resulted in a collision with the wires while attempting an off-airport landing in dark night visual…Jul 26, 2022 · N520CF · Substantial damageNTSB ERA22FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Portland, ARThe failure of both pilots to see and avoid the other airplane during aerial application and ferry operations.Jul 26, 2022 · N749LA · 2 aircraft · DestroyedNTSB ANC22LA063Accident · Serious injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in the wing exceeding its critical angle of attack, a loss of control and impact with the water.Jul 26, 2022 · N9776R · Substantial damageNTSB ANC22LA061Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210 · Aniak, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose-over.Jul 26, 2022 · N4743T · Substantial damageNTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.Jul 25, 2022 · N497SU · Substantial damageNTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…Jul 25, 2022 · N192MH · DestroyedNTSB ERA22LA335Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Calhoun, GAThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in a loss of directional control, a runway excursion, and substantial damage to the airplane.Jul 25, 2022 · N199KS · Substantial damageNTSB CEN22LA340Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620A · Stewart, MNThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 25, 2022 · N4651W · Substantial damageNTSB CEN22LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna T310R · Oshkosh, WIThe pilot’s loss of control while landing.Jul 24, 2022 · N731AJ · Substantial damageNTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.Jul 24, 2022 · N60ED · Substantial damageNTSB CEN22LA332Accident · Minor injuriesClass 4 · LimitedFinal reportCessna L-19E · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.Jul 24, 2022 · N3946K · Substantial damageNTSB WPR22LA271Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · San Jose, CAThe pilot’s inadequate preflight inspection and fuel management, which resulted in fuel starvation, a total loss of engine power, and an impact with terrain.Jul 23, 2022 · N300BH · Substantial damageNTSB WPR22LA270Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33 · Livingston, MTThe student pilot’s improper landing flare, and the instructor’s lack of remedial action.Jul 23, 2022 · N2482W · Substantial damage