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 WPR14CA033Accident · No injuriesData collectionFinal reportTecnam P92 · Watsonville, CAThe pilot's failure to maintain directional control during landing.Oct 22, 2013 · N137LM · Substantial damageNTSB ERA14FA010Accident · 3 fatalField investigationFinal reportEurocopter AS 350 B3 · Somerville, TNThe pilot’s inadvertent encounter with night, instrument meteorological conditions while responding to an obstacle alert, resulting in an in-flight loss of helicopter control.Oct 22, 2013 · N353HW · DestroyedNTSB ERA14CA016Accident · No injuriesData collectionFinal reportDenisar Richard A Lancair 320 · Lumberton, NJA hard landing by the pilot, which resulted in overload failure of landing gear components and surrounding structure.Oct 22, 2013 · N825D · Substantial damageNTSB WPR14LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172 - M · Hardin, MTA rough-running engine and partial loss of power, which resulted from the pilot’s failure to use carburetor heat appropriately while operating in an area conducive to carburetor icing.Oct 21, 2013 · N80257 · Substantial damageNTSB WPR14CA028Accident · No injuriesData collectionFinal reportCessna 180 · Butte, MTThe pilot's failure to maintain directional control of the airplane while landing with a crosswind.Oct 21, 2013 · N156JM · Substantial damageNTSB ERA14CA030Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Charleston, MSThe pilot's failure to maintain directional control, which resulted in a runway excursion and collision with a fence.Oct 21, 2013 · N1022N · Substantial damageNTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.Oct 21, 2013 · N113WS · DestroyedNTSB CEN14FA014Accident · 2 fatalField investigationFinal reportPiper PA 32R-301 · Huntsville, ARThe noninstrument-rated pilot’s continued flight into an area of known rain with reduced visibility and his failure to maintain airplane control while maneuvering the airplane after entering these conditions.Oct 21, 2013 · N888TP · DestroyedNTSB WPR14LA025Accident · No injuriesLimited investigationFinal reportAviat S2 · Livermore, CAFailure of the pilots of the Pitts airplane to maneuver the airplane as necessary to observe the taxi route and avoid the Cessna airplane ahead. Contributing to the accident was the local controller's failure to provide the required warning of traffic ahead…Oct 20, 2013 · N15TA · 2 aircraft · Substantial damageNTSB WPR14CA022Accident · No injuriesData collectionFinal reportCollins Zenith Stol CH 701 · Deer Park, WAThe pilot's inadequate flare and failure to maintain control of the airplane during the landing with a tailwind.Oct 19, 2013 · N2849C · Substantial damageNTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.Oct 19, 2013 · N5184W · Substantial damageNTSB ERA14LA011Accident · 1 fatalLimited investigationFinal reportBoeing B75N1 · Tampa, FLThe parachutist’s low altitude departure from the right wing before the planned altitude and his delayed opening of his parachute canopy, which resulted in impact with a tree and then the ground before the parachute fully opened.Oct 19, 2013 · N65355 · No damageNTSB ERA14LA005Accident · No injuriesLimited investigationFinal reportAerotek Pitts S 1T · Punta Gorda, FLThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot’s decision to operate the airplane with known ergonomic restrictions due to his size.Oct 19, 2013 · N53CG · Substantial damageNTSB ERA14LA004Accident · No injuriesLimited investigationFinal reportMcdonald Howard Brian Zenair 701 · Zephyrhills, FLThe failure of the propeller speed reduction unit drive belts due to inadequate belt tension being applied during installation, which resulted in a complete loss of thrust.Oct 19, 2013 · N538HB · Substantial damageNTSB ERA14CA031Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1 26E · Eighty Four, PAThe pilot's failure to maintain proper airspeed and glide path, which resulted in an overshoot, a hard landing, and a subsequent collision with terrain. Contributing to the accident was the pilot's lack of total experience in make and model.Oct 19, 2013 · N2997H · Substantial damageNTSB ERA14CA021Accident · Minor injuriesData collectionFinal reportCessna A185F · Northeast Carry, METhe pilot's improper decision to take off for an intended night water landing, and his subsequent loss of depth perception during that landing attempt.Oct 19, 2013 · N93037 · Substantial damageNTSB WPR14CA019Accident · No injuriesData collectionFinal reportRobinson R44 - II · Sedro Woolley, WAThe non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…Oct 18, 2013 · N414CC · Substantial damageNTSB ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Oct 18, 2013 · N11ML · DestroyedNTSB CEN14FA009Accident · 2 fatalField investigationFinal reportCessna 500 · Derby, KSThe airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…Oct 18, 2013 · N610ED · DestroyedNTSB ANC14FA002Accident · 1 fatalField investigationFinal reportCessna 172C · Fairbanks, AKThe pilot’s failure to ensure that adequate fuel was on board the airplane, which resulted in fuel exhaustion and a subsequent collision with terrain.Oct 18, 2013 · N1512Y · Substantial damageNTSB WPR14CA020Accident · No injuriesData collectionFinal reportL Goldner Zenith 701 · Milford, UTThe pilot's improper decision to execute a precautionary landing to unsuitable terrain.Oct 17, 2013 · N67MG · Substantial damageNTSB ERA14CA003Accident · Minor injuriesData collectionFinal reportCessna 305A · Slatington Airport, PAThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident was the pilot's decision to land with a tailwind condition and the airfield's inaccurate windsock.Oct 17, 2013 · N305CR · Substantial damageNTSB CEN14LA008Accident · No injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Wichita, KSThe pilot’s improper brake application during landing, which resulted in a loss of directional control.Oct 16, 2013 · N610AS · Substantial damageNTSB ERA14CA012Accident · No injuriesData collectionFinal reportClassic Waco YMF · Somerville, NJThe pilot's failure to maintain aircraft control while applying wheel brakes during landing roll resulting in the airplane nosing over.Oct 15, 2013 · N62XX · Substantial damageNTSB WPR14CA017Accident · No injuriesData collectionFinal reportBeller Quicksilver Mxlii · Orland, CAThe pilot's failure to maintain aircraft control during taxi with a strong gusting wind condition which resulted in the airplane nosing over.Oct 14, 2013 · N75556 · Substantial damageNTSB CEN14CA018Accident · No injuriesData collectionFinal reportBeech A36 · Telluride, COThe pilot's decision to take off in gusting tailwinds resulting in exceeding the performance capabilities of the airplane and subsequent loss of control.Oct 13, 2013 · N26RG · Substantial damageNTSB WPR14LA051Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Calexico, CAThe pilot’s failure to maintain the proper pitch attitude during the landing, which resulted in the nose landing gear contacting the surface hard and then separating from the airplane.Oct 12, 2013 · N14TG · Substantial damageNTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.Oct 12, 2013 · N9599S · Substantial damageNTSB WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.Oct 12, 2013 · N40WY · Substantial damageNTSB CEN14LA045Accident · No injuriesLimited investigationFinal reportSutphin Rans S-12 · French Lick, INThe pilot's failure to maintain adequate airspeed while in a steep turn, which resulted in an aerodynamic stall/mush at a low altitude.Oct 11, 2013 · N8028W · Substantial damageNTSB ERA14LA006Accident · 4 fatalLimited investigationFinal reportCessna 340A · Hampton Roads, VAThe pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.Oct 10, 2013 · N4TK · DestroyedNTSB CEN14CA023Accident · No injuriesData collectionFinal reportCessna 172R · Tomball, TXThe student pilot delay in aborting the takeoff which resulted in the airplane going off the end of the runway and impacting trees.Oct 10, 2013 · N999UF · Substantial damageNTSB ANC14CA004Accident · No injuriesData collectionFinal reportPiper J3C 65 · Talkeetna, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.Oct 10, 2013 · N70604 · Substantial damageNTSB WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.Oct 9, 2013 · N7145U · DestroyedNTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.Oct 9, 2013 · N9528A · Substantial damageNTSB CEN14LA006Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Xenia, OHThe nose landing gear failure as a result of a fatigue fracture of the engine mount nose gear actuator feet in an area detailed in a service bulletin. Contributing to the accident was maintenance personnel’s inadequate completion of the inspection specified…Oct 9, 2013 · N561C · Substantial damageNTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.Oct 8, 2013 · N5760Y · Substantial damageNTSB ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.Oct 8, 2013 · N4216V · Substantial damageNTSB CEN14LA003Accident · Serious injuriesLimited investigationFinal reportKenneth M Franz Ultra PUP · Belleville, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while turning back to the airport instead of landing straight ahead following a partial loss of engine power, which resulted in an aerodynamic…Oct 7, 2013 · N106KF · Substantial damageNTSB ANC14CA001Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Iliamna, AKThe pilot's failure to maintain aircraft control during the landing roll with a tailwind.Oct 7, 2013 · N91144 · Substantial damageNTSB WPR14LA008Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas Heli 369 · Paducah, TXThe pilot’s failure to maintain clearance from a power transmission line tower while maneuvering to pick up a rope in gusting wind conditions.Oct 6, 2013 · N530KF · Substantial damageNTSB WPR14LA007Accident · 3 fatalLimited investigationFinal reportPiper PA32 - 300 · Tinian IslandThe pilot’s failure to maintain terrain clearance while maneuvering at low altitude in dark night conditions.Oct 6, 2013 · N4089W · DestroyedNTSB WPR14CA009Accident · Serious injuriesData collectionFinal reportBeech A36 · Tilden, TXThe pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.Oct 6, 2013 · N2051N · Substantial damageNTSB ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.Oct 6, 2013 · N909GD · Substantial damageNTSB CEN14LA005Accident · Serious injuriesLimited investigationFinal reportCameron N105 - NO Series · Albuquerque, NMThe pilot's decision to land the balloon from a high approach altitude due to high winds, which resulted in a hard landing.Oct 5, 2013 · N4113T · No damageNTSB WPR14LA005Accident · 4 fatalLimited investigationFinal reportCessna 340A · Paulden, AZThe pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.Oct 4, 2013 · N312GC · Substantial damageNTSB ERA14LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Selinsgrove, PAThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during postmaintenance checks and the pilot's inadequate preflight check.Oct 4, 2013 · N170JH · Substantial damageNTSB ERA14LA035Accident · Serious injuriesLimited investigationFinal reportAirborne Edge Executive · Eustis, FLThe pilot's inadvertent stalling of the wing following a total loss of engine power for reasons that could not be determined during postaccident examinations, which resulted in a hard landing.Oct 3, 2013 · N927H · Substantial damageNTSB WPR14CA003Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Wellton, AZThe pilot’s distracted attention and failure to maintain sufficient altitude to clear terrain while maneuvering in dark night conditions.Oct 2, 2013 · N402TR · Substantial damageNTSB CEN14CA041Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Benton Harbor, MIThe pilot's failure to maintain aircraft control during engine start.Oct 2, 2013 · N8084W · Substantial damage