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 WPR18LA179Accident · No injuriesLimited investigationFinal reportCessna 340A · Orlando, FLThe pilot's delayed decision to discontinue the takeoff when confronted with abnormal acceleration and airspeed indication; the reason for the abnormal acceleration could not be determined based on the available information.Jun 25, 2018 · N60E · Substantial damageNTSB GAA18CA376Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's failure to see and avoid a post during a go-around following a landing on unsuitable terrain.Jun 25, 2018 · N249T · Substantial damageNTSB GAA18CA375Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Goose Bay, AKThe pilot’s failure to maintain a proper approach path during landing in dusky, flat light conditions, which resulted in a tree strike.Jun 25, 2018 · N3570T · Substantial damageNTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.Jun 25, 2018 · N52584 · Substantial damageNTSB CEN18LA239Accident · Serious injuriesLimited investigationFinal reportSibila MH-1 · Beach City, OHThe total loss of engine power for reasons that could not be determined based on the available evidence.Jun 25, 2018 · N32KS · Substantial damageNTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…Jun 24, 2018 · N3896P · Substantial damageNTSB WPR18FA178Accident · 1 fatalClass 2 · FieldFinal reportSchempp-Hirth Standard Cirrus · Aguila, AZThe pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.Jun 23, 2018 · N7880 · Substantial damageNTSB GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.Jun 23, 2018 · N7072Y · Substantial damageNTSB ANC18LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe failure of the brake line tube due to an improper flare.Jun 23, 2018 · N3125D · Substantial damageNTSB ANC18LA047Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-2 · Dillingham, AKThe pilot's failure to maintain directional control while landing in gusting wind conditions.Jun 23, 2018 · N5221G · Substantial damageNTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.Jun 22, 2018 · N61862 · Substantial damageNTSB ERA18FA174Accident · 1 fatalField investigationFinal reportCessna 172 · Diamondhead, MSThe student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.Jun 22, 2018 · N7239Q · DestroyedNTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…Jun 21, 2018 · N1979P · Substantial damageNTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.Jun 21, 2018 · N9496D · Substantial damageNTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.Jun 21, 2018 · N6KG · Substantial damageNTSB GAA18CA370Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot’s failure to maintain directional control during landing.Jun 21, 2018 · N4427B · Substantial damageNTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.Jun 20, 2018 · N9130T · Substantial damageNTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Jun 20, 2018 · N3169D · Substantial damageNTSB GAA18CA369Accident · No injuriesData collectionFinal reportCessna 172 · Bruington, VAThe pilot’s improper decision to abort the takeoff with insufficient runway remaining to safely stop the airplane.Jun 20, 2018 · N8090X · Substantial damageNTSB ERA18LA175Accident · Minor injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Newburyport, MAThe pilot's failure to adequately compensate for existing crosswind conditions during the final approach and landing flare, which led to the airplane drifting left of the runway, and his delayed decision to go around, which resulted in the airplane touching…Jun 20, 2018 · N239AM · Substantial damageNTSB GAA18CA366Accident · No injuriesData collectionFinal reportRobinson R66 · Cordova, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in impact with brush and a loss of helicopter control.Jun 19, 2018 · N7040P · Substantial damageNTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.Jun 19, 2018 · N969TM · Substantial damageNTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.Jun 19, 2018 · N9819D · Substantial damageNTSB ERA18LA170Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Raleigh, NCThe pilot's inadequate preflight inspection, during which he failed to detach ground handling equipment from the helicopter before initiating the takeoff, which resulted in the subsequent dynamic rollover.Jun 19, 2018 · N303HP · Substantial damageNTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.Jun 19, 2018 · N3002X · Substantial damageNTSB CEN18FA232Accident · 1 fatalClass 2 · FieldFinal reportAir Tractor AT 502B · Enid, OKThe pilot's failure to see and avoid a known obstacle (communications tower) during agricultural spraying operations.Jun 19, 2018 · N2063B · DestroyedNTSB GAA18CA380Accident · No injuriesData collectionFinal reportJabiru J250 · Ferndale, WAThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident were the pilot’s lack of experience and training in the accident airplane make and model.Jun 18, 2018 · N722BL · Substantial damageNTSB GAA18CA368Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Columbia, SCThe pilot's failure to maintain directional control during landing.Jun 18, 2018 · N41AL · Substantial damageNTSB GAA18CA356Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 · Winnsboro, SCThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s improper decision to provide instruction in an airplane with only one control stick.Jun 18, 2018 · N584J · Substantial damageNTSB CEN18LA230Accident · No injuriesLimited investigationFinal reportCessna TR182 · Beloit, KSThe mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.Jun 18, 2018 · N756SW · Substantial damageNTSB GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.Jun 17, 2018 · N11YB · Substantial damageNTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.Jun 17, 2018 · N6284X · Substantial damageNTSB GAA18CA361Accident · No injuriesData collectionFinal reportRaytheon A36 · Lakeview, ARThe pilot’s failure to extend the landing gear before landing, which resulted in a propeller strike, followed by an aborted landing and a subsequent hard, precautionary landing.Jun 17, 2018 · N174DM · Substantial damageNTSB GAA18CA355Accident · No injuriesData collectionFinal reportPiper PA18 · Salcha, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 17, 2018 · N9098D · Substantial damageNTSB GAA18CA352Accident · No injuriesData collectionFinal reportBell 206 · Orondo, WAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Jun 17, 2018 · N2762P · Substantial damageNTSB CEN18CA294Accident · No injuriesData collectionFinal reportRobinson R22 · Sterling City, TXThe pilot’s improper decision to exit the helicopter without shutting down the engine, which allowed the collective/throttle to increase and resulted in a loss of control of the unattended helicopter.Jun 17, 2018 · N410MM · Substantial damageNTSB GAA18CA378Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369 · Yabucoa, PRThe pilot's failure to maintain main rotor clearance from a fiber line while picking up a lineman.Jun 16, 2018 · N900FF · Substantial damageNTSB GAA18CA358Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Spanish Fork, UTThe pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 16, 2018 · N992CT · Substantial damageNTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 16, 2018 · N81047 · DestroyedNTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…Jun 15, 2018 · N580B · DestroyedNTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.Jun 15, 2018 · N3764Z · Substantial damageNTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.Jun 15, 2018 · N8273C · Substantial damageNTSB GAA18CA354Accident · No injuriesData collectionFinal reportBoeing B75 · Waukegan, ILThe flight instructor’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.Jun 15, 2018 · N52107 · Substantial damageNTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.Jun 15, 2018 · N6672Q · Substantial damageNTSB CEN18FA227Accident · 2 fatalField investigationFinal reportCessna 172N · Rotan, TXThe pilot's reckless decision to conduct low-level flight over a canyon, resulting in the airplane's impact with power lines and terrain.Jun 15, 2018 · N734BS · DestroyedNTSB ANC18LA046Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Ambler, AKThe pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.Jun 15, 2018 · N2957K · Substantial damageNTSB WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.Jun 14, 2018 · N2165 · Substantial damageNTSB GAA18CA360Accident · No injuriesData collectionFinal reportCessna 172 · Salem, ILThe student pilot’s failure to maintain clearance from a pole while taxiing the airplane on the ramp.Jun 14, 2018 · N98395 · Substantial damageNTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.Jun 14, 2018 · N67404 · Substantial damageNTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…Jun 14, 2018 · N56213 · Substantial damage