NTSB investigations, 2014
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ERA14LA462Accident · Serious injuriesLimited investigationFinal reportQuicksilver Eipper Acft GT 400 · Lebanon, CTThe pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.NTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…NTSB CEN14CA528Accident · Minor injuriesData collectionFinal reportCessna 182G · Port Eads, LAThe pilot's improper decision to depart from a runway not suitable for takeoff, which resulted in a loss of aircraft control.NTSB ANC14LA091Accident · No injuriesLimited investigationFinal reportPiper J3 · Ft. Yukon, AKThe pilot's improper preflight inspection and in-flight fuel management, which resulted in fuel exhaustion and a subsequent forced landing.NTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…NTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.NTSB ERA14CA463Accident · No injuriesData collectionFinal reportBeech D55 · Hazleton, PAThe brake application for unknown reasons resulting in rupture of the left main landing gear tire and tube, and subsequent loss of directional control.NTSB CEN14LA527Accident · 1 fatalLimited investigationFinal reportButcher Russell A RV9A · Shepherd, TXThe pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…NTSB CEN14CA523Accident · Minor injuriesData collectionFinal reportCessna 182G · Silver City, NMThe pilot overcorrected when the airplane experienced a downdraft during the takeoff which resulted in the airplane stalling and impacting the terrain.NTSB CEN14LA520Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Albuquerque, NMThe pilot's failure to maintain main rotor rpm during a pinnacle approach, which resulted in a loss of helicopter control and collision with terrain. Contributing to the accident was the pilot's decision to attempt the approach given the helicopter's weight…NTSB WPR14CA392Accident · No injuriesData collectionFinal reportCirrus SR22 - NO Series · Elko, NVThe pilot's failure to maintain directional control during landing roll in gusty wind conditions, which resulted in a runway excursion and collision with terrain.NTSB WPR14CA390Accident · No injuriesData collectionFinal reportWilliam M Oprendek Pitts S1S · Sedona, AZFailure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.NTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.NTSB DCA15WA039Accident · No injuriesForeign investigationBoeing 737-700 · Belo Horizonte, BrazilThe Aeronautical Accident Investigation and Prevention Center (CENIPA) of Brazil has notified the NTSB of an accident involving a Boeing 737-700 that occurred on September 25, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB DCA14WA173Incident · No injuriesForeign investigationBoeing 737 - 3L9 · Makassar, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia has notified the NTSB of an incident involving a Boeing 737-300, which occurred on September 25, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…NTSB CEN14WA529Accident · No injuriesForeign investigationBell 206L-3 · Suchitepéquez Department, GuatemalaOn September 25, 2014, about 1430 UTC, a Bell 206L-3 helicopter (s/n 51342), TG-LOU, impacted terrain during agricultural crop spraying operations near Municipio Santa Barbará, departamento de Suchitepéquez, Guatemala. The helicopter was substantially…NTSB CEN14CA525Accident · No injuriesData collectionFinal reportBell 206B · Nashoba, OKThe pilot's loss of directional control due a loss of tail rotor effectiveness.NTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.NTSB WPR14CA389Accident · No injuriesData collectionFinal reportPiper PA25 - 260 · Mokuleia, HIThe pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR14CA388Accident · Serious injuriesData collectionFinal reportLundak Robert Kitfox IV · Sonoma, CAThe pilot's inadequate fuel management which resulted in an engine failure due to fuel starvation and subsequent collision with power lines during the forced landing.NTSB ANC14CA088Accident · No injuriesData collectionFinal reportPiper PA 12 · Holy Cross, AKThe pilot's selection of unsuitable terrain for takeoff/landing and failure to maintain control of the aircraft.NTSB ERA14WA457Accident · 3 fatalForeign investigationBell 206B · Bolivar, VenezuelaOn September 23, 2014, about 2200 universal coordinated time, a Bell 206B helicopter, Venezuelan registration YV-2537, operated by Aerocopter C.A., impacted terrain after a loss of engine power in Bolivar State, Venezuela. The pilot and the two passengers…NTSB CEN14WA518Accident · 1 fatalForeign investigationAmateur Construction Denney Kitfox MK2 · Tempsford, United Kingdom, United KingdomNTSB WPR14CA385Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Mokuleia, HIThe pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.NTSB ERA14WA454Accident · 2 fatalForeign investigationDiamond Aircraft Industries IN DA20-C1 · Marina di Campo, ItalyOn September 22, 2014, about 1530 coordinated universal time (UTC), a Diamond, DA20, Italian registration OE-ADH, was substantially damaged when it impacted the ground shortly after takeoff from Aeroporto di Marina di Campo (LIRJ), Marina di Campo, Italy. The…NTSB CEN14CA515Accident · Minor injuriesData collectionFinal reportCessna 150J · Brookfield, WIThe pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.NTSB CEN14CA513Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a tail rotor strike.NTSB ANC14LA085Accident · No injuriesLimited investigationFinal reportCessna TU206 · Deadhorse, AKThe application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.NTSB ANC14CA086Accident · No injuriesData collectionFinal reportMiller Gregory S Bushwacker · Iliamna, AKThe pilot's failure to maintain control on landing, resulting in the collision with terrain.NTSB WPR14FA382Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Saratoga, WYThe pilot’s failure to maintain a positive climb rate after takeoff in dark, night conditions, which resulted in his controlled flight into terrain due to the lack of ground references or natural horizon.NTSB WPR14CA387Accident · No injuriesData collectionFinal reportBeech E33A · Las Vegas, NVThe pilot's incorrect engine start procedures, which included improper throttle position and failure to keep the brakes applied, which resulted in a loss of directional control and subsequent collision with a parked airplane.NTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB ERA14LA451Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Homosassa, FLA partial loss of engine power for reasons that could not be determined because engine examination did not reveal any anomalies that would have precluded normal operation.NTSB ENG14IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GATurbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…NTSB CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.NTSB WPR14WA398Accident · 4 fatalForeign investigationDe Havilland 6 · Mount Lawes, Papua New Guinea, Papua New GuineaOn September 20, 2014, at 0935 local time, a DeHavilland DHC-6 300, P2-KSF, collided with steep, jungle-covered terrain just below the summit of Mount Lawes, Papua New Guinea. The aircraft was operated by Hevilift under the pertinent civil regulations of the…NTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB ERA14LA450Accident · Serious injuriesLimited investigationFinal reportBarger Jerry L Challenger II · Clarion, PAThe pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…NTSB ERA14CA453Accident · Minor injuriesData collectionFinal reportSchleicher ASK 21 · Wurtsboro, NYA loss of lift during the landing approach, which resulted in impact with terrain.NTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.NTSB DCA14WA167Accident · No injuriesForeign investigationEmbraer ERJ190 - Undesignat · Taiching, TaiwanThe Aviation Safety Council of Taiwan (ASC) has notified the NTSB of an accident involving a EMBRAER ERJ190 that occurred on September 20, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of…NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…NTSB WPR14WA395Accident · 1 fatalForeign investigationCessna 172 - P · Sumenep, Indonesia, IndonesiaOn September 19, 2014 at 0636 universal coordinated time, a Cessna 172P, PK-MSN, collided with terrain shortly after takeoff from Trunojoyo Airport, Sumenep, Indonesia. The airplane was operated by Merpati Pilot School under the pertinent civil regulations of…NTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.NTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.NTSB ERA14LA448Accident · No injuriesLimited investigationFinal reportCessna 172M · Leesburg, FLThe flight instructor’s delayed remedial action and his subsequent loss of directional control during landing on a wet runway for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.NTSB ERA14LA446Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Piscataquis County, METhe fatigue fracture of the No. 3 exhaust valve, which initiated at the outer surface of the valve stem and resulted in the subsequent total loss of engine power over terrain unsuitable for landing.NTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.NTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.