NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 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 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 ERA14LA404Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Gaithersburg, MDThe loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.NTSB 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.NTSB 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…NTSB ERA14CA419Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Pepperell, MAAn inadvertent collision with a bird, which resulted in substantial damage to the left wing.NTSB 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.NTSB CEN14WA452Accident · 1 fatalForeign investigationNasdalla Vans RV-7 · Modrava, CzechiaOn August 23, 2014, an experimental amateur-built Nasdalla model Vans RV-7 airplane, Norwegian registration LN-DSF, serial number 71683, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near Modrava, Czech…NTSB CEN14LA451Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gordonville, TXA loss of directional control during a crosswind landing.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB CEN14CA455Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Hemphill, TXThe airplane's inadvertent encounter with wake turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB ERA14LA402Accident · Minor injuriesLimited investigationFinal reportThibault Michael L RV4 · Polk Township, PAA total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB ERA14LA401Accident · No injuriesLimited investigationFinal reportCessna 150G · Pittstown, NJA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ENG14WA026Incident · No injuriesForeign investigationAirbus A320 - 231 · Cochin, India, IndiaOn August 21, 2014 at about 1540 UTC, an Air India Airbus A320, VT-ESI, experienced an uncontained No. 2 engine failure shortly after take-off for Cochin Airport (OCK), Kerala, India. The airplane was equipped with two International Aero Engines V2500-A1…NTSB CEN14LA447Accident · Serious injuriesLimited investigationFinal reportHerder Michael Zodiac 601 HD · Fredericksburg, TXThe pilot’s loss of airplane control during a gusting crosswind landing.NTSB 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.NTSB 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…NTSB DCA15WA014Incident · No injuriesForeign investigationBoeing 737 · Hat Yai, ThailandThe Department of Civil Aviation of Thailand has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DCA's investigation under the provisions of ICAO…NTSB CEN14WA475Accident · 1 fatalForeign investigationPiper PA-38-112 · Benthill Farm, Buckingham, UK, United KingdomOn August 20, 2014, about 2000 hours universal coordinated time, a Piper PA-38-112, United Kingdom registration G-BNDE, impacted terrain near Benthill Farm, Buckingham, United Kingdom. The pilot was fatally injured. The flight itinerary is under investigation…NTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.NTSB 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.NTSB 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…NTSB 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.NTSB ERA14FA396Accident · 2 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Northport, ALAn inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.NTSB 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…NTSB 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…NTSB CEN14LA439Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Wray, COA loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…NTSB CEN14CA442Accident · No injuriesData collectionFinal reportRockwell International S 2R · Kerkhoven, MNThe pilot failure to see and avoid the guide wire during the aerial application flight.NTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB ENG14RA025Incident · No injuriesForeign investigationAerospatiale AS 350 B-2 · Camp Fenelon, CanadaOn August 18, 2014, about 930 EDT, a Airbus AS 350 B-2, C-GSSS, operated by Expedition Helicopters, experienced a reported high-side overspeed governor failure on final for the helipad near Camp Fenelon, Canada. The pilot, the only person aboard, was…NTSB DCA14CA157Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · Reykjavik, IcelandThe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.NTSB CEN14WA530Incident · No injuriesForeign investigationRobinson Helicopter Robinson R44 II · Ringaskiddy, Ireland, IrelandOn August 18, 2014, about 1335 UTC, a Robinson R44, EI-DDA (s/n 10105) was involved in a forced landing following an inflight vibration near Ringaskiddy, Ireland. The engine was significantly damaged. The pilot was not injured. This investigation is under the…NTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.NTSB 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.NTSB 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…NTSB 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.NTSB ERA14LA390Accident · No injuriesLimited investigationFinal reportCessna R182 · Farmingdale, NYThe failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.NTSB 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.NTSB 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.NTSB 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…NTSB WPR14CA358Accident · No injuriesData collectionFinal reportBoeing A75N1 (PT-17) · Seattle, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB 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.NTSB 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.NTSB 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…NTSB ERA14LA392Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Itta Bena, MSA total loss of engine power during maneuvering due to an obstruction from air intake filter material being ingested into the carburetor, which resulted in a forced landing.NTSB 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.NTSB 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.NTSB CEN14WA531Accident · 2 fatalForeign investigationPiper PA-31 · Manan, CanadaNTSB CEN14LA480Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Hearne, TXThe pilot’s failure to maintain clearance from a crop.