NTSB investigations, 2014
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 year(c.\"eventDate\") = 2014 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.
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 year(c."eventDate") = 2014 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN14WA407Accident · 2 fatalForeign investigationSocata TBM 700 · Saint Jean les Deux Jumeaux, FranceNTSB CEN14LA408Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Decatur, ILDebris in the fuel system, which resulted in fuel starvation and a subsequent loss of engine power.NTSB CEN14CA413Accident · Minor injuriesData collectionFinal reportPhantom Phantom X 1 · Three Rivers, MIThe pilot did not maintain adequate airspeed while flying a visual pattern, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.NTSB ANC14CA060Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Anderson, AKThe pilot's inadequate compensation for wind conditions, which resulted in a hard landing.NTSB WPR14WA331Accident · 1 fatalForeign investigationPiper PA-32S-300 · Queenstown, New Zealand, New ZealandOn August 5, 2014, at 0400 universal coordinated time, a Piper PA 32S-300, ZK-DOJ, collided with remote terrain under unknown circumstances near the Poolburn Reservoir, Queenstown, New Zealand. The airplane was registered to Glenorchy Air Services & Tourist…NTSB WPR14LA329Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S 2B · Oceanside, CAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB WPR14LA327Accident · Serious injuriesLimited investigationFinal reportDavid L Thompson Challenger II · Winterhaven, CAA total loss of engine power during cruise for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s loss of control during the forced landing.NTSB WPR14FA330Accident · 2 fatalField investigationFinal reportDavid Fitzgerald Zenith · Warren, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.NTSB CEN14LA446Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 - D · Burnet, TXThe flight instructor’s failure to adequately supervise the student pilot and his decision to conduct training in an airplane without dual brakes, which resulted in the student pilot’s loss of directional control during initial taxi and subsequent impact with…NTSB CEN14LA406Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Manistee, MIThe pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…NTSB ERA14CA385Accident · No injuriesData collectionFinal reportCote James Rans S 6S · New Berlin, PAThe passenger's inadvertent interference with the rudder controls during the takeoff.NTSB WPR14CA326Accident · No injuriesData collectionFinal reportPiper PA20 - Undesignat · Dayton, ORThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB ERA14WA380Accident · 5 fatalForeign investigationEmbraer EMB 720C · Balsas, BrazilOn August 3, 2014, about 0910 UTC, an Embraer 720C (based on U.S. design of Piper PA-32-300), Brazil Registration PT-WPH, registered to and operated by a private individual, crashed into a residence during takeoff from Balsas Airport (SNBS), Maranhao, Brazil.…NTSB CEN14CA428Accident · Minor injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Frankfort, MIThe pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.NTSB WPR14CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and failure to maintain aircraft control during taxi, which resulted in a loss of tail rotor effectiveness and subsequent impact with the taxiway and a parked fuel truck.NTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.NTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.NTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.NTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.NTSB ANC14CA059Accident · No injuriesData collectionFinal reportSteven R Mcneese Airborne Edge X · Palmer, AKThe non-certificated pilot's failure to maintain directional control while performing a high speed taxi test and inadvertent lift-off, which resulted in an inflight collision with trees and terrain.NTSB WPR14LA323Accident · No injuriesLimited investigationFinal reportRans S-16 · Fort Bridger, WYThe fuel flow divider inlet line’s B-nut coming loose during takeoff, resulting in a total loss of engine power. Contributing to the accident was the pilot's failure to adequately tighten the B-nut during recent maintenance.NTSB WPR14LA322Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Tulelake, CAThe pilot's failure to maintain clearance from power lines while maneuvering during low-altitude operations.NTSB WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.NTSB ERA14LA374Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLA total loss of engine power for reasons that could not be determined during postaccident examination and testing.NTSB CEN14LA401Accident · No injuriesLimited investigationFinal reportMosquito XE · Oshkosh, WIThe failure of the retaining assembly on the tail rotor blade, which resulted in the separation of the blade and the subsequent loss of helicopter control.NTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…NTSB CEN14CA460Accident · No injuriesData collectionFinal reportAviat Husky · Steamboat Springs, COThe student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.NTSB ANC14CA057Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Illiamna, AKThe pilot's inadequate landing technique that resulted in a landing area overrun. Contributing was the glassy water conditions.NTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB ERA14IA370Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLThe nose landing gear collapse for reasons that could not be determined because examination of the airplane revealed no anomalies.NTSB CEN14FA399Accident · 1 fatalField investigationFinal reportZimmerman Breezy · Oshkosh, WIThe pilot’s failure to maintain airplane control during landing while the air traffic controller was simultaneously coordinating the landing of three airplanes on the same runway, which resulted in the airplane exiting the runway and impacting a parked ground…NTSB CEN14CA422Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Warsaw, INThe pilot failed to maintain directional control during landing.NTSB CEN14CA405Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Oakdale, LAThe pilot's excessive braking on landing, which resulted in a loss of control.NTSB CEN14CA404Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Traverse City, MIThe pilot's loss of directional control during landing, resulting in a runway excursion and the airplane nosing over.NTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.NTSB ANC14LA058Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 · Talkeetna, AKThe pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…NTSB WPR14CA328Accident · No injuriesData collectionFinal reportBeech A36 - Undesignat · San Carlos, CAThe pilot's failure to maintain directional control during taxi.NTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.NTSB DCA14LA137Accident · No injuriesLimited investigationFinal reportBoeing 757 · San Diego, CAthe first officer's failure to maintain the correct airspeed and pitch attitude during landing that resulted in a tailstrike.NTSB CEN14LA465Accident · No injuriesLimited investigationFinal reportBell 206B · Spring, TXThe pilot's distraction by a cell phone call, which led to his failure to perform an exterior check of the helicopter and resulted in a tie-down strap remaining attached to the main rotor during the engine start.NTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB DCA14WA135Accident · No injuriesForeign investigationBoeing 737-800 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on July 29, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB CEN14LA433Accident · No injuriesLimited investigationFinal reportSutton William J Stits Playmate SA11A · Bridgeport, TXThe pilot’s loss of airplane control during takeoff after encountering rapidly changing wind conditions.NTSB CEN14LA398Accident · Serious injuriesLimited investigationFinal reportHughes 369D · West Liberty, OHA total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.NTSB CEN14CA429Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Minden, NEThe pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.NTSB CEN14CA402Accident · No injuriesData collectionFinal reportCessna 182R · Pine Bluff, ARThe inadvertent aerodynamic stall during landing in crosswind conditions.NTSB WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.