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 CEN18LA183Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Stoneburg, TXThe pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.May 19, 2018 · N369GK · DestroyedNTSB GAA18CA285Accident · No injuriesData collectionFinal reportCessna 182 · Wickenburg, AZThe pilot’s failure to maintain directional control during the landing roll.May 18, 2018 · N4964D · Substantial damageNTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.May 18, 2018 · N7265K · Substantial damageNTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…May 17, 2018 · N7750F · Substantial damageNTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.May 17, 2018 · N182EW · Substantial damageNTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.May 16, 2018 · N63794 · Substantial damageNTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.May 16, 2018 · N44CP · Substantial damageNTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.May 16, 2018 · N77273 · Substantial damageNTSB CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.May 15, 2018 · N6550L · Substantial damageNTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.May 14, 2018 · N25WE · Substantial damageNTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.May 14, 2018 · N4144L · DestroyedNTSB WPR18FA141Accident · 1 fatalField investigationFinal reportCessna 182G · Cascade, IDThe non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.May 13, 2018 · N2377R · DestroyedNTSB GAA18CA282Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · LaGrange, GAThe student pilot’s failure to maintain lateral control during a soft-field takeoff.May 13, 2018 · N143MA · Substantial damageNTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…May 13, 2018 · N486T · DestroyedNTSB WPR18LA140Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58C · Yuma, AZA partial loss of engine power during an aerial application flight due to thermal damage to the 1st stage gas producer turbine nozzle and an irregular fuel spray pattern due to carbon buildup of the fuel nozzle. Contributing to the accident was maintenance…May 12, 2018 · N82857 · Substantial damageNTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.May 12, 2018 · N6333N · Substantial damageNTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.May 12, 2018 · N2485D · Substantial damageNTSB CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.May 12, 2018 · N507TX · DestroyedNTSB ANC18FA036Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-28-180 · Whittier, AKThe student pilot's decision to depart and continue on a solo cross-country flight through mountainous terrain in marginal visual flight rules conditions, which resulted in controlled flight into terrain.May 12, 2018 · N7061W · Substantial damageNTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.May 11, 2018 · N9216E · Substantial damageNTSB WPR18FA139Accident · 3 fatalField investigationFinal reportBeech 76 · Julian, CAThe pilot's failure to maintain sufficient altitude above mountainous terrain while maneuvering during night conditions in an area prone to turbulence, which resulted in a collision with terrain. Contributing to the accident was the flight instructor's…May 11, 2018 · N803FC · DestroyedNTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.May 11, 2018 · N610FT · Substantial damageNTSB GAA18CA275Accident · No injuriesData collectionFinal reportAeropro CZ S R O A240 · Chandler, AZThe pilot’s failure to stop and yield to the airplane taxiing on the taxiway, which resulted in a ground collision.May 11, 2018 · N481B · 2 aircraft · Substantial damageNTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.May 11, 2018 · N833DW · DestroyedNTSB CEN18LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Orrville, OHThe pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.May 11, 2018 · N738XT · Substantial damageNTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.May 10, 2018 · N430PA · Substantial damageNTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 10, 2018 · N82XC · Substantial damageNTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.May 10, 2018 · N67RE · Substantial damageNTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.May 9, 2018 · N210BG · Substantial damageNTSB GAA18CA270Accident · No injuriesData collectionFinal reportJetson'S Aircam · Bumpass, VAThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around.May 9, 2018 · N334JS · Substantial damageNTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…May 8, 2018 · N377ES · Substantial damageNTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.May 8, 2018 · N315BD · Substantial damageNTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.May 8, 2018 · N642RJ · Substantial damageNTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.May 8, 2018 · N99GN · Substantial damageNTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.May 8, 2018 · N3291U · Substantial damageNTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.May 7, 2018 · N2432H · Substantial damageNTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.May 7, 2018 · N632EP · Substantial damageNTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.May 7, 2018 · N699ZA · Substantial damageNTSB ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.May 7, 2018 · N534EA · Substantial damageNTSB DCA18CA169Accident · No injuriesData collectionFinal reportBoeing 737-8H4 · Baltimore, MDThe maintenance truck driver's failure to give way to the airplane that resulted in the truck colliding with the taxiing aircraft.May 7, 2018 · N8655D · Substantial damageNTSB GAA18CA304Accident · No injuriesData collectionFinal reportBeech 58 · Gainesville, GAThe pilot’s failure to maintain a proper landing flare in gusting crosswind conditions.May 6, 2018 · N406PA · Substantial damageNTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.May 6, 2018 · N5419E · Substantial damageNTSB GAA18CA257Accident · No injuriesData collectionFinal reportAeronca 7AC · Warrenton, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall.May 6, 2018 · N83581 · Substantial damageNTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.May 6, 2018 · N141C · Substantial damageNTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.May 5, 2018 · N81FS · Substantial damageNTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.May 5, 2018 · N263VX · Substantial damageNTSB GAA18CA273Accident · Minor injuriesData collectionFinal reportChristopher Lord ELA Eclipse 10 · Calhoun, GAThe student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.May 5, 2018 · N533EA · Substantial damageNTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.May 5, 2018 · N4534H · Substantial damageNTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.May 5, 2018 · N7762X · Substantial damageNTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.May 5, 2018 · N701XS · Substantial damage