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 CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.Aug 27, 2014 · N369AB · Substantial damageNTSB ANC14CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Beluga, AKThe pilot's selection of an unsuitable takeoff area, resulting in an inflight collision with vegetation/brush during takeoff.Aug 27, 2014 · N5616Y · Substantial damageNTSB CEN14LA458Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe pilot’s failure to maintain airplane control during takeoff. Contributing to the severity of the accident was the pilot’s retraction of the landing gear before establishing a positive climb rate, which resulted in a gear-up landing.Aug 26, 2014 · N8176M · Substantial damageNTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.Aug 26, 2014 · N627RK · Substantial damageNTSB CEN14FA453Accident · 4 fatalField investigationFinal reportCessna 172R · Willoughby Hills, OHThe pilot's failure to maintain control of the airplane while returning to the airport immediately after takeoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall during the turn. Contributing to the…Aug 26, 2014 · N4207P · DestroyedNTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.Aug 25, 2014 · N7860D · Substantial damageNTSB ERA14LA405Accident · Minor injuriesLimited investigationFinal reportHiller UH 12E · Cape May Court House, NJThe mechanic’s failure to detect excessive wear on the engine’s lateral snubber vibration mount during the latest annual inspection, which resulted in an in-flight engine failure and a subsequent forced landing.Aug 25, 2014 · N4035A · Substantial damageNTSB CEN14CA459Accident · No injuriesData collectionFinal reportPiper PA 32R-301T · Sedalia, MOThe loss of engine power due to fuel starvation.Aug 25, 2014 · N532DR · Substantial damageNTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.Aug 24, 2014 · N341SL · Substantial damageNTSB CEN14LA454Accident · 1 fatalLimited investigationFinal reportRans S17 · Lowell, MIThe pilot’s overconfidence, which led to his improper decision to continue flight in the recently purchased, unregistered airplane without acquiring training and to his continued erratic handling of the airplane and subsequent loss of airplane control.Aug 24, 2014 · UNREG · Substantial damageNTSB ANC14FA068Accident · Serious injuriesField investigationFinal reportRyan Navion A · Coldfoot, AKThe pilot’s improper inflight planning and improper decision to deliberately operate the airplane at low altitude in close proximity to obstructions and rising terrain. Contributing to the accident were the pilot’s improper preflight planning and the Federal…Aug 24, 2014 · N4827K · Substantial damageNTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.Aug 23, 2014 · N334DF · DestroyedNTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…Aug 23, 2014 · N231MN · Substantial damageNTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.Aug 23, 2014 · N41224 · Substantial damageNTSB CEN14FA448Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Lago Vista, TXThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid the power lines.Aug 23, 2014 · N254AC · DestroyedNTSB ANC14CA067Accident · Minor injuriesData collectionFinal reportCessna 175 · Talkeetna, AKThe pilot's selection of an unsuitable takeoff area, resulting in a loss of control and subsequent inflight collision with terrain during takeoff. Contributing to the accident was the pilot's failure to use the checklist, resulting in an improper propeller…Aug 23, 2014 · N7119M · Substantial damageNTSB WPR14CA352Accident · Minor injuriesData collectionFinal reportRans S 6S · Rigby, IDThe student pilot's loss of directional control during takeoff in gusting wind conditions. Contributing to the accident was the flight instructor's failure to intervene and apply corrective flight control inputs.Aug 22, 2014 · N171CT · Substantial damageNTSB CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…Aug 22, 2014 · N8440N · Substantial damageNTSB CEN14LA447Accident · Serious injuriesLimited investigationFinal reportHerder Michael Zodiac 601 HD · Fredericksburg, TXThe pilot’s loss of airplane control during a gusting crosswind landing.Aug 21, 2014 · N318MH · Substantial damageNTSB ERA14FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Parsons, TNThe pilot’s failure to see and avoid trees during a low-level aerial application operation.Aug 20, 2014 · N802BB · Substantial damageNTSB ERA14CA397Accident · Minor injuriesData collectionFinal reportRaytheon G36 · Milton, FLThe pilot's inadequate preflight planning, which resulted in an attempted takeoff over the airplane's maximum gross weight and beyond its aft center of gravity limit. Contributing to the accident was the pilot's lack of total flight experience in the aircraft…Aug 20, 2014 · N636TM · Substantial damageNTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.Aug 20, 2014 · N3084Z · Substantial damageNTSB CEN14CA479Accident · No injuriesData collectionFinal reportQuicksilver 2S · Frontenac, MNThe loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.Aug 20, 2014 · UNREG · Substantial damageNTSB WPR14FA349Accident · 1 fatalField investigationFinal reportBeech V35B · Novato, CAThe instrument-rated pilot's decision to conduct a visual approach to the airport in night, instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's loss of situational awareness, the…Aug 19, 2014 · N1160T · Substantial damageNTSB WPR14CA350Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 34 · Marana, AZThe pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.Aug 19, 2014 · N7628 · Substantial damageNTSB CEN14LA445Accident · Serious injuriesLimited investigationFinal reportFranke Roland SKY Raider · Bethel, OHThe pilot's inadvertent aerodynamic stall while maneuvering after a loss of engine power during initial climb. Contributing to the accident was the total loss of engine power for reasons that could not be determined because the investigation could not…Aug 19, 2014 · N65692 · Substantial damageNTSB CEN14LA441Accident · Serious injuriesLimited investigationFinal reportBecker Elmer L Stol CH 750 · Grain Valley, MOThe pilot’s failure to maintain airplane control during a low-speed, high-pitch climb after the airplane experienced a loss of electrical power and subsequent total loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was…Aug 19, 2014 · N484XB · Substantial damageNTSB CEN14CA442Accident · No injuriesData collectionFinal reportRockwell International S 2R · Kerkhoven, MNThe pilot failure to see and avoid the guide wire during the aerial application flight.Aug 19, 2014 · N9646A · Substantial damageNTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.Aug 18, 2014 · N369GN · Substantial damageNTSB ANC14LA065Accident · No injuriesLimited investigationFinal reportTerry W. Thayer Zenith Stol CH701 · Nikiski, AKThe pilot’s improper positioning of the fuel selector valves, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow preflight checklists.Aug 18, 2014 · N957TT · Substantial damageNTSB WPR14FA348Accident · 1 fatalField investigationFinal reportCliff Starduster II SA300 · Placerville, CAThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions following a partial loss of engine power for reasons that could not be determined, because postaccident examination of the airframe and engine did not reveal…Aug 17, 2014 · N411TM · Substantial damageNTSB ERA14LA391Accident · Serious injuriesLimited investigationFinal reportLet L 23 Super Blanik · Sylacauga, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the student pilot's failure to properly assess her physical condition prior to conducting the flight.Aug 17, 2014 · N266SE · Substantial damageNTSB ERA14CA413Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Hayesville, NCThe pilot's failure to maintain control of the helicopter, and adequate clearance, which resulted in a collision with a hangar.Aug 17, 2014 · N752EC · Substantial damageNTSB CEN14FA437Accident · 3 fatalField investigationFinal reportLancair LC 40 550FG · Ranger, TXThe pilot's loss of airplane control shortly after takeoff as a result of spatial disorientation due to dark night conditions, the pilot's low overall night and instrument flight time, and his lack of recent night flights.Aug 17, 2014 · N6500Z · DestroyedNTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…Aug 17, 2014 · N734YW · Substantial damageNTSB WPR14CA358Accident · No injuriesData collectionFinal reportBoeing A75N1 (PT-17) · Seattle, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.Aug 16, 2014 · B719BL · Substantial damageNTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.Aug 16, 2014 · N10033 · Substantial damageNTSB WPR14CA347Accident · No injuriesData collectionFinal reportEipper Formance Mxii · Salt Lake City, UTThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Aug 16, 2014 · N1624Z · Substantial damageNTSB OPS14IA011Incident · No injuriesIncident investigationFinal reportBoeing 777 - 236 · Shemya, AKThe air traffic controller’s failure to identify a conflict between two aircraft and to issue an adequate clearance, which resulted in a loss of required separation. Contributing to the incident was the Federal Aviation Administration’s failure to provide…Aug 16, 2014 · N773AN · No damageNTSB ERA14CA408Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Baltimore, MDThe pilot/owner/builder's improper weight and balance calculations, which rendered the airplane uncontrollable in the pitch axis.Aug 16, 2014 · N853WD · Substantial damageNTSB ERA14CA394Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · Readington, NJThe pilot's failure to maintain aircraft control during landing which resulted in an aircraft nose-over.Aug 16, 2014 · N211A · Substantial damageNTSB CEN14LA480Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Hearne, TXThe pilot’s failure to maintain clearance from a crop.Aug 16, 2014 · N878C · Substantial damageNTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 16, 2014 · N60PE · Substantial damageNTSB ANC14CA066Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Skwentna, AKThe pilot's failure to maintain the proper approach path for landing, and his delayed remedial action, which resulted in an undershoot and collision with terrain.Aug 16, 2014 · N83422 · Substantial damageNTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.Aug 15, 2014 · N127BC · DestroyedNTSB WPR14LA346Accident · No injuriesLimited investigationFinal reportBoeing 737 7H4 · Salt Lake City, UTThe disconnection of baggage carts that subsequently collided with the parked airplane following the tug driving over a dip in the roadway.Aug 14, 2014 · N758SW · Substantial damageNTSB ERA14FA387Accident · 2 fatalField investigationFinal reportCessna 150 · Mount Pleasant, SCThe commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…Aug 14, 2014 · N66241 · Substantial damageNTSB ERA14CA398Accident · No injuriesData collectionFinal reportCessna 172F · Oxford, NCThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's improper compensation for wind conditions.Aug 14, 2014 · N8432U · Substantial damageNTSB ANC14CA064Accident · No injuriesData collectionFinal reportCessna 182A · Gustavus, AKThe pilot's unstable landing approach which resulted in a long landing, and subsequent collision with terrain.Aug 14, 2014 · N2121G · Substantial damageNTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…Aug 13, 2014 · N2190H · Substantial damage