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 CEN14CA078Accident · No injuriesData collectionFinal reportCessna 152 · Columbia Station, OHThe pilot's inadequate flight planning and decision to land on the soft grass/turf runway which resulted in a nose over.NTSB WPR14CA066Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Monticello, UTThe passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.NTSB ERA14FA066Accident · 1 fatalField investigationFinal reportTexas Helicopter M74L · Sebring, FLA partial loss of engine power as a result of contamination of the engine’s fuel supply, and the pilot’s impaired performance due to his use of diphenhydramine, which resulted in his inability to complete a forced or precautionary autorotative landing…NTSB WPR14LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Fair Oaks, CAThe loss of engine power during cruise flight for reasons that could not be determined because postaccident examinations of the airplane and engine did not reveal any anomalies that would have precluded normal operation.NTSB DCA14WA019Accident · No injuriesForeign investigationBoeing 767 - 300ER · Madrid, SpainNTSB CEN14CA082Accident · No injuriesData collectionFinal reportSikorsky S 76B · Port Fourchon, LAThe pilot's loss of control of the helicopter when it entered a settling with power condition during sudden gusty wind conditions on takeoff resulting in the helicopter subsequently impacting terrain.NTSB ERA14WA069Accident · 5 fatalForeign investigationBritten Norman BN2A - 2 · Novo Prgresso, BrazilOn December 4, 2013, about 1430 coordinated universal time (UTC), a Britten Norman Aircraft, model BN-2A, Brazilian registration PT-WMY, was substantially damaged when it impacted the ground shortly after takeoff from Novo Progresso Airport (SJNP), Novo…NTSB DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaNTSB CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.NTSB ANC14CA010Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…NTSB ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB ERA14CA062Accident · Minor injuriesData collectionFinal reportAnderson Andreas Rans S-6S · Traveler's Rest, SCThe pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.NTSB ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA060Accident · No injuriesData collectionFinal reportBeech G35 · Placerville, CAThe airplane's collision with a deer on the runway during landing.NTSB ERA14LA059Accident · Minor injuriesLimited investigationFinal reportMoffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SCThe airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.NTSB CEN14LA075Accident · No injuriesLimited investigationFinal reportCessna 560 · Walton, INThe inflight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB WPR14FA094Accident · 5 fatalField investigationFinal reportBeech B36TC · Yellow Pine, IDThe pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.NTSB WPR14CA092Accident · No injuriesData collectionFinal reportCessna 177RG · Richland, WAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot's diverted attention and not using a checklist.NTSB CEN14LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-181 · Rock Lake, NDThe noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…NTSB ERA14LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Elkmont, ALA stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…NTSB ERA14CA065Accident · No injuriesData collectionFinal reportCessna 150D · Portland, METhe failure of the pilot to maintain directional control during landing.NTSB DCA14RA018Accident · 33 fatalForeign investigationEmbraer ERJ190 - Undesignat · Rundu, NamibiaThe Namibia Ministry of Works and Transport (MWT) has notified the NTSB of an accident involving an Embraer ERJ-190 that occurred on November 30, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the MWT investigation under the…NTSB ANC14MA008Accident · 5 fatalMajor investigationFinal reportCessna 208B · Saint Marys, AKThe pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…NTSB WPR14LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, ORThe failure of the hydraulic power pack, which prevented the extension of the landing gear and resulted in a partial gear-up landing.NTSB CEN14WA073Accident · 9 fatalForeign investigationEurocopter EC135 · Glasgow, United KingdomOn November 29, 2013, at 2222 universal coordinated time (UTC), a United Kingdom registered EC-135 T2 helicopter, G-SPAO, impacted a public house near Glasgow, United Kingdom. The crew of three in the helicopter and six other persons were fatally injured. The…NTSB CEN14FA071Accident · 1 fatalField investigationFinal reportCessna 182E · Delta, COThe student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.NTSB ERA14LA052Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Trussville, ALThe failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.NTSB ERA14LA051Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Montrose, PAThe pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.NTSB ERA14CA055Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Tunica, MSThe student pilot's failure to maintain control of the helicopter during the attempted takeoff, and the flight instructor's inadequate supervision of the student pilot.NTSB ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.NTSB CEN14FA072Accident · 1 fatalField investigationFinal reportBiesemeier David I Smyth Sidewinder · Boulder, COThe pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.NTSB WPR14CA058Accident · No injuriesData collectionFinal reportQuad City Ultralight Acft Challenger II · Kalispell, MTA loss of engine power due to the spark plug coming out of the cylinder head.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.NTSB ERA14FA049Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Graniteville, SCThe pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…NTSB DCA14WA017Accident · No injuriesForeign investigationCessna C208B · Kamusi, Papua New GuineaOn November 25, 2013, about 0100 UTC, P2-SAH (previous US Reg N41149), a Cessna Grand Caravan (C208B) airplane, operated by Tropicair, reportedly had an engine failure and crashed during a forced landing near the Kamusi airport, Kamusi, Papua New Guinea. On…NTSB DCA14CA031Accident · No injuriesData collectionFinal reportDe Havilland DHC8 - 102 · Philadelphia, PAan inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.NTSB ANC14CA012Accident · No injuriesData collectionFinal reportDouglas DC-6 · Nuiqsut, AKA load shift during takeoff, which resulted in substantial damage to the aft bulkhead and associated structures.NTSB ERA14LA071Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Monroe, NCThe pilot’s operation of the airplane with underinflated tires, which resulted in the right tire’s failure during takeoff and a subsequent runway excursion.NTSB DCA14WA033Accident · No injuriesForeign investigationMcdonnell Douglas MD11 - F · Sao Paulo, BrazilThe Government of Brazil (CENIPA) has notified the NTSB of an accident involving a McDonnell Douglas MD11F, which occurred on November 24, 2013. The accident investigation has been delegated to the Bundesstelle für Flugunfalluntersuchung, German Federal…NTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.NTSB WPR14CA057Accident · No injuriesData collectionFinal reportNew Piper PA46 350P · Salt Lake City, UTThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's improper use of the checklist.NTSB ANC14CA009Accident · No injuriesData collectionFinal reportCessna A185F · Nenana, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrain.NTSB DCA14IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 - 409LCF · Wichita, KSthe flight crew's failure to properly identify the airport and runway of intended landing. Contributing to the incident was the flight crew's failure to follow company procedures for crosschecking navigational information and visual cues to verify the airport…NTSB ANC14LA007Accident · No injuriesLimited investigationFinal reportBeech 1900C · Deadhorse, AKThe captain’s decision to initiate a visual flight rules approach and attempted landing into an area of instrument meteorological conditions, which resulted in the airplane touching down short of the runway. Contributing to the accident was the operator’s…NTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNTSB ERA14FA045Accident · 4 fatalField investigationFinal reportLearjet 35 · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…NTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…NTSB CEN14WA067Accident · 2 fatalForeign investigationRobinson R44 - II · Neuhausen ob Eck, GermanyOn November 19, 2013, at 1134 coordinated universal time, a Robinson R44 II, Germany-registered D-HOMI, was substantially damaged when it impacted forested terrain near Neuhausen ob Eck, Germany. Instrument meteorological conditions prevailed at the time of…