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 CEN14CA533Accident · No injuriesData collectionFinal reportAviat Pitts S 2B · Grants, NMThe pilot's failure to maintain control of the airplane during landing in gusty wind conditions.NTSB ANC14CA032Accident · No injuriesData collectionFinal reportFound Acft Canada FBA 2C2 · Willow, AKThe pilot's loss of control of the airplane during landing on water due to an encounter with wind shear, which resulted in the airplane's abnormal contact with the surface.NTSB ERA14LA269Accident · Minor injuriesLimited investigationFinal reportGarlick Helicopters OH 58A+ · Whitefield, MEA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to land as soon as possible when the master caution warning light first illuminated as prescribed and his failure to ensure the proper setting of the…NTSB CEN14IA270Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Island 182AThe improper repair of the outer combustion case, which led to its ultimate failure due to the continued progression of a fatigue crack and resulted in a partial loss of engine power during takeoff.NTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.NTSB CEN14CA271Accident · No injuriesData collectionFinal reportBRM Aero Sro Bristell S-LSA · Boerne, TXThe instructor pilot's failure to regain control of the airplane following the student pilot's initial loss of control of the airplane.NTSB ANC14LA035Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Homer, AKThe flutter failure of the right elevator servo tab due to the improper fabrication of the servo tab and maintenance personnel’s subsequent failure to detect anomalies with the servo tab.NTSB ANC14CA033Accident · No injuriesData collectionFinal reportCessna 172F · Fairbanks, AKThe pilot's improper inflight planning, which resulted in fuel starvation and a loss of engine power. A factor was the pilot's selection of a low cruise flight altitude, which provided little time for the selection of suitable terrain for the forced landing…NTSB WPR14CA224Accident · No injuriesData collectionFinal reportMeyers MAC 145 · La Cholla, AZThe pilot's overcorrection to a wind gust, which resulted in a loss of directional control and runway veeroff.NTSB CEN14CA282Accident · No injuriesData collectionFinal reportLuscombe 8B · Galion, OHThe pilot's misapplication of brakes after landing, which resulted in the airplane nosing over.NTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.NTSB WPR14CA217Accident · No injuriesData collectionFinal reportCessna 210 · Moab, UTThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.NTSB CEN14LA262Accident · No injuriesLimited investigationFinal reportEmbraer EMB 135KL · Traverse City, MIAn in-flight collision with a bird during the descent to land, which resulted in substantial damage to the airplane.NTSB CEN14LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COThe pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC14FA030Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Chugiak, AKThe pilot's loss of control of the helicopter due to impairment or incapacitation from a sudden, acute cardiac event.NTSB ANC14CA031Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilot's inadequate remedial action during landing on soft terrain, which resulted in a nose-over.NTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.NTSB ERA14WA275Accident · 5 fatalForeign investigationBeech B200 · Colonia, UruguayOn May 27, 2014, about 1050 coordinated universal time (UTC), a Beechcraft B200, Argentina registration LV-CNT, was substantially damaged when it impacted the water near Rio de la Plata, Uruguay. The Argentinian pilot and four of the passengers were fatally…NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB CEN14LA255Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Gueydan, LAThe pilot's failure to maintain airplane control, which resulted in a stall and subsequent collision with power lines.NTSB CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB WPR14CA213Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Cedar Valley, UTThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in inadvertent terrain contact by the wing.NTSB WPR14CA210Accident · No injuriesData collectionFinal reportMeyers OTW 160 · Tehachapi, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with a fence.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.NTSB CEN14WA254Accident · 1 fatalForeign investigationAir Tractor AT802 · Seron, SpainOn May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal…NTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.NTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.NTSB ANC14CA029Accident · No injuriesData collectionFinal reportPiper PA 18-105 Special · Anchorage, AKThe pilot's loss of control of the airplane during landing roll on a rough, grass airstrip in gusting wind.NTSB ERA14FA255Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Fountain, FLThe pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…NTSB ERA14CA265Accident · No injuriesData collectionFinal reportDivis S L/Waltrip A J RV 4 · Harpswell, METhe pilot's inadequate preflight and in-flight planning which resulted in total loss of engine power due to fuel exhaustion.NTSB ERA14CA262Accident · Minor injuriesData collectionFinal reportEvolution Trikes Revo · Williamsburg, VAThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water.NTSB ERA14CA259Accident · No injuriesData collectionFinal reportBrantly B 2B · Essex, MDThe pilot's failure to maintain helicopter control during landing resulting in a hard landing and a roll over.NTSB CEN14CA252Accident · No injuriesData collectionFinal reportAerospatiale AS 365 N2 Dauphin · Constantine, MIThe pilot's loss of control while entering a vortex ring state (settling with power) condition, which resulted in a hard landing.NTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.NTSB WPR14LA207Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Arvin, CAThe pilot’s failure to reconnect the air-oil separator return line after completing an oil change, which resulted in a total loss of engine power due to oil starvation.NTSB WPR14FA209Accident · 1 fatalField investigationFinal reportKenneth A Berger Searey LSX · Electric City, WAThe pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.NTSB WPR14CA211Accident · No injuriesData collectionFinal reportFdr601 Zodiac 601XL · Lewiston, IDThe pilot's improper flare during landing.NTSB ERA14CA263Accident · Minor injuriesData collectionFinal reportCessna 182J · Perkasie, PAThe pilot's failure to select and attain a proper touchdown point during landing which resulted in a runway overrun.NTSB CEN14LA259Accident · Serious injuriesLimited investigationFinal reportSibley Glasair · Midlothian, TXThe pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.NTSB CEN14CA310Accident · No injuriesData collectionFinal reportCessna 421A · Dallas, TXThe improper rigging of the landing gear by maintenance personnel, which resulted in the landing gear collapse.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB CEN14CA257Accident · Minor injuriesData collectionFinal reportPiper PA 28R-200 · La Pointe, WIThe pilot's failure to maintain control of the airplane during the landing.NTSB WPR14LA206Accident · Minor injuriesLimited investigationFinal reportWilliams Helicopter UH 1H · Waitsburg, WAAn extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…NTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.NTSB WPR14CA401Accident · No injuriesData collectionFinal reportPiper PA 22 · Roundup, MTThe pilot's delayed action to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude.NTSB WPR14CA214Accident · No injuriesData collectionFinal reportOlson Kitfox II · Helena, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane nosing over.NTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, Bolivia