NTSB investigations, 2014
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WPR14TA248Accident · No injuriesFinal reportLockheed SP 2H · Fresno, CAThe collapse of the nosewheel landing gear due to the disengagement of the nosewheel landing gear pin. Contributing to the accident was the failure of the main hydraulic system due to overpressurization for reasons that could not be determined during…NTSB WPR14CA247Accident · No injuriesData collectionFinal reportCessna 180 · Casper, WYThe pilot's inadequate flare and loss of directional control during landing.NTSB ERA14LA302Accident · Minor injuriesLimited investigationFinal reportBailey Robert Moyes Dragonfly · Melfa, VAThe pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.NTSB DCA14WA123Incident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Kinmen, ChinaThe Aviation Safety Council (ASC) of Taiwan, R.O.C. has notified the NTSB of an incident involving a Boeing MD-82 which occurred on June 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of…NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB CEN14CA318Accident · No injuriesData collectionFinal reportMeyer Geoffrey A Goat · Wolcott, COThe failure of an oil line leading to the oil pressure transducer which resulted in oil starvation and subsequent loss of engine power.NTSB CEN14CA302Accident · No injuriesData collectionFinal reportCessna 180 · Springview, NEThe pilot's failure to maintain directional control of the airplane while landing in a crosswind. Contributing to the accident was the gusty crosswind.NTSB CEN14CA295Accident · Minor injuriesData collectionFinal reportCessna 414 · Pleasanton, TXThe pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.NTSB WPR14LA265Accident · No injuriesLimited investigationFinal reportPiper PA 18-135 · Turner, ORThe collapse of the left main landing gear during landing roll for reasons that could not be determined because the pilot would not make the airplane available for a postaccident examination.NTSB WPR14LA249Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Quincy, CAThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…NTSB WPR14FA244Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5B · Florence, ORThe noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB ERA14LA290Accident · 1 fatalLimited investigationFinal reportCameron Balloons US Z-225 · Spring City, PAThe pilot's fall from the balloon’s basket during touchdown in a field for reasons that could not be determined based on the available evidence, which resulted in his fatal injury.NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB ERA14CA310Accident · No injuriesData collectionFinal reportJackson Fred M Clipper · Altamont, NYThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.NTSB ERA14CA298Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Milton, FLThe pilot's failure to maintain the proper approach path, and his delayed remedial action, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB CEN14WA304Accident · No injuriesForeign investigationReims Cessna F150L · Nottingshire, United KingdomThis is preliminary information, subject to change, and may contain errors. On June 14, 2014, about 1240 UTC, a Cessna F150L airplane, G-YIII (s/n 0827) impacted terrain near Hucknall Airfield (EGNA), Nottinghamshire, United Kingdom. The airplane was…NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB WPR14LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Princeton, CAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14FA243Accident · 2 fatalField investigationFinal reportDittenber Thomas J Auriga · Echo Bay, NVThe pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.NTSB WPR14CA246Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Jackson, MTThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB ERA14WA340Accident · Serious injuriesForeign investigationCessna 525 · Aruana, BrazilOn June 13, 2014, at 0747 local time, a Cessna 525, Brazilian registration PP-PIM, was substantially damaged during a runway overrun at Fazenda Europa Airport (SWEF), Aruanã, Goiás, Brazil. One crewmember was seriously injured, and one crewmember and the five…NTSB ERA14FA289Accident · 1 fatalField investigationFinal reportMeyer Clair O 2/3 P 51B/C Mustang · Marion, SCThe airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB ERA14CA307Accident · No injuriesData collectionFinal reportBeech 58 · Tupelo, MSThe pilot's inadvertent retraction of the landing gear on the runway, which resulted in a landing gear collapse.NTSB ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.NTSB CEN14WA292Accident · 1 fatalForeign investigationSchweizer 269C · Cerfontaine, Belgium, BelgiumOn June 13, 2014, about 1500 UTC, a Schweizer 269C, OO-JCS (s/n S1749) impacted terrain at the airfield of Cerfontaine, Belgium (EBCF). The helicopter was destroyed. One pilot was fatally injured and one pilot was seriously injured. This investigation is…NTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.NTSB CEN14LA287Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Pearsall, TXThe failure of the No. 1 cylinder rod at the link pin. Contributing to the accident was oil starvation to the rod bearing due to the improper flushing of the oil cooler, which allowed metal and other debris in the oil to clog the drain and the led to the…NTSB ERA14IA301Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Burlington, MAA loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…NTSB CEN14WA294Accident · No injuriesForeign investigationPiper J3C 65 · Rolleville, FranceNTSB CEN14LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winner, SDThe pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB CEN14FA286Accident · 2 fatalField investigationFinal reportBell 206 L4 · South Timbalier PlatformThe pilot's loss of helicopter control for reasons that could not be determined based on the available information.NTSB ANC14LA041Accident · No injuriesClass 3 · LimitedFinal reportAirbus/Eurocopter AS 350 B3 · Anchorage, AKThe pilot’s improper engine start procedure, which resulted in an overspeed of the engine and main rotor drive system.NTSB ERA14WA296Incident · No injuriesForeign investigationBeech 300 · Pucallpa, PeruOn June 10, 2014, at 1212 universal coordinated time, a Beech 300, Peruvian registration OB-1881P, operated by Aero Transporte S.A., sustained minor damage when its No. 1 engine experienced vibrations and was subsequently shutdown, while on approach to the…NTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…NTSB ERA14FA282Accident · 2 fatalField investigationFinal reportLiberty Aerospace XL-2 · Merritt Island, FLThe failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…NTSB ENG14WA030Incident · No injuriesForeign investigationBoeing 737 - 6H3 · Budapest, HungaryOn June 10, 2014, about 1830 local (1630 UTC), a TunisAir Boeing 737-6H3, TS-IOK, operating as flight TU-4671, experienced a malfunction of the No. 1 (left) engine during the takeoff roll at Budapest, Hungary. The pilots rejected the takeoff. A borescope…NTSB CEN14LA537Accident · Minor injuriesLimited investigationFinal reportHughes TH 55A · Hudson, WIThe nonhelicopter-rated pilot’s operation of the helicopter and its subsequent collision with trees during takeoff for reasons that could not be determined based on the available evidence.NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.NTSB ERA14WA287Accident · 3 fatalForeign investigationCessna 172N · Premana Lecco, ItalyNTSB ANC14LA040Accident · No injuriesLimited investigationFinal reportCessna U206C · Chitina, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue, which resulted in a total loss of engine power during cruise flight.NTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB WPR14LA237Accident · No injuriesLimited investigationFinal reportCraig W Sherman Super Glasair TT · Madera, CAThe loosening of a B-nut in the fuel system which resulted in a rapid, undetected fuel leak and subsequent fuel exhaustion.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…NTSB ERA14CA280Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Reading, PAThe pilot's loss of control while landing the tailwheel-equipped airplane in a quartering tailwind. A factor in the accident was the changing wind conditions.NTSB CEN14WA297Accident · No injuriesForeign investigationCessna F182 - Q · Monhoudou, FranceOn June 8, 2014, at 0800 UTC, a Cessna F182Q, French Registration F-GAQR, was destroyed during a runway excursion while landing at the Chateau de Monhoudou private airstrip (LK7255) near Monhoudou, France. The pilot and three passengers were not injured. The…NTSB CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.NTSB WPR14LA238Accident · No injuriesLimited investigationFinal reportSkykits Savannah VGW · Helena, MTThe overload failure of the nosewheel fork retaining bolts during landing, which resulted in a nose-over.