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 ERA15LA319Accident · Serious injuriesLimited investigationFinal reportHead AX9 118 · New Holland, PAThe pilot's failure to adequately secure the vent line, which resulted in the premature deflation of the balloon’s envelope and its subsequent contact with power lines. Contributing to the accident were the pilot's choice of an unsuitable landing area, which…NTSB ERA15LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Bristow, VAThe student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.NTSB ERA15FA313Accident · 1 fatalField investigationFinal reportBeech C35 · Hicksville, NYThe pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…NTSB DCA15WA189Incident · No injuriesForeign investigationBritish Aerospace Civil Aircr BAe 146-200 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a British Aerospace BAe-146, which occurred on August 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB CEN15WA372Accident · No injuriesForeign investigationBeech A100 · Margaree, CanadaOn August 16, 2015, at 1910 UTC, a Beechcraft A100, Canadian registration C-FDOR, was substantially damaged following a hard landing at Margaree, Nova Scotia, Canada (CCZ4). The four people onboard were not injured. The accident investigation is under the…NTSB CEN15WA364Accident · Minor injuriesForeign investigationMX MX2 · Châteauneuf-sur-Cher, FranceNTSB CEN15LA403Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Big Piney, WYThe pilot's failure to maintain adequate altitude while operating over high mountainous terrain, which resulted in an emergency landing after the airplane's encounter with a downdraft.NTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.NTSB ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.NTSB GAA15CA229Accident · No injuriesData collectionFinal reportMckinney Charles R Searey · Augusta, KYThe amphibious airplane's impact with a submerged object during a water landing, which resulted in a nose over.NTSB ERA15WA383Incident · No injuriesForeign investigationBeech 350 · Boyaca, ColombiaOn August 15, 2015, about 1800 Universal Coordinated Time (UTC), a Beech 350, N188RU, sustained minor damage after it experienced a collapse of the nose landing gear while landing at Juan Jose Rondon Airport (SKPA), in Boyaca, Colombia. The two pilots and…NTSB ERA15FA312Accident · 1 fatalField investigationFinal reportCessna T206H · West Caldwell, NJA loss of engine power due to a malfunction of the turbocharging system likely due to contaminated oil. Also causal were the pilot's decision to continue the takeoff although the airplane was not performing normally and his failure to maintain adequate…NTSB ERA15CA321Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Pittsboro, NCThe pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.NTSB ERA15CA320Accident · Minor injuriesData collectionFinal reportSanderson Herbert H SHA Glasair · Bladenboro, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.NTSB DCA15LA173Accident · No injuriesLimited investigationFinal reportAirbus A321 · Charlotte, NCan encounter with a small microburst on short final at low altitude that resulted in a loss of lift and a tail strike during the go-around. Contributing to the accident was the captain's decision to continue the approach without applying appropriate windshear…NTSB CEN15LA371Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Venice, LAThe pilot's failure to attain a safe landing approach airspeed with a crosswind.NTSB WPR15LA242Accident · 1 fatalLimited investigationFinal reportBartels Lancair · Pacific Ocean (Pacific Ocean)The pilot's incapacitation for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB WPR15LA240Accident · Minor injuriesLimited investigationFinal reportStinson SR 9B · Chula Vista, CAA total loss of engine power due to fuel exhaustion as a result of the pilot’s failure to verify the fuel quantity before the flight.NTSB GAA15CA228Accident · No injuriesData collectionFinal reportCessna 337F · Danbury, CTThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing, nose gear collapse, runway excursion, and collision with terrain.NTSB ERA15WA324Accident · 1 fatalForeign investigationRobinson R44 · Sakha Republic, RussiaOn August 14, 2015, about 1055 coordinated universal time, a Robinson R-44, Russian Registration RA-04339, was substantially damaged after impacting a light pole shortly after departure from a mountainous landing area in the Sakha Republic, in the Russian…NTSB ERA15WA316Accident · 1 fatalForeign investigationRobinson R44 - II · Limpio, ParaguayOn August 14, 2015, about 0830 local time (1130 coordinated universal time), a Robinson R44 Raven II, designated A02 and operated by the Paraguayan National Police, was destroyed when it impacted terrain in Limpio, Paraguay, about 6 nautical miles northeast…NTSB ERA15LA311Accident · Serious injuriesLimited investigationFinal reportThomas A Siminski Zenith CH 750 · Allentown, PAA partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…NTSB ERA15CA317Accident · Minor injuriesData collectionFinal reportErcoupe 415 C · Fairmont, WVThe pilot's failure to maintain airspeed and his exceedance of the wing's critical angle of attack, which resulted in an aerodynamic stall and subsequent collision with terrain.NTSB CEN15LA360Accident · 1 fatalLimited investigationFinal reportNorth American T 28A · Las Cruces, NMFailure of the No. 6 cylinder connecting rod, due to improper rotation of the propeller during a previous hydraulic lock.NTSB WPR15FA241Accident · 2 fatalField investigationFinal reportCessna T182T · Oroville, WAThe pilot’s failure to maintain terrain clearance while maneuvering. Contributing to the accident was the pilots’ selection, for undetermined reasons, of a route different than the most commonly used route.NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB ERA15LA314Accident · No injuriesLimited investigationFinal reportGrumman G164 · Trenton, NCThe pilot's decision to land the airplane with a tailwind and his subsequent application of excessive braking, which resulted in a nose-over.NTSB ERA15WA310Accident · Minor injuriesForeign investigationCessna 208B · Saba, NTOn August 12, 2015, at 1630 Universal Coordinated Time (UTC), a Cessna 208B, U.S. Registration N924FE, operated by Mountain Air Cargo, was substantially damaged following a loss of engine power and ditching in the Caribbean Sea near Saba, Netherlands…NTSB ERA15FA308Accident · 2 fatalField investigationFinal reportBeech N35 · Weirsdale, FLA partial loss of engine power during takeoff. The reason for the partial loss of power could not be determined due to the extensive fire and impact damage to the engine.NTSB DCA15RA171Accident · No injuriesForeign investigationSikorsky S76 - C · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a SIKORSKY S76 - C helicopter that occurred on August 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the NAIB investigation under the…NTSB CEN15LA377Accident · No injuriesLimited investigationFinal reportGrumman G 164B · Sac City, IAThe loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15CA356Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Pearland, TXThe student pilot inadvertently shut off the fuel valve while on the downwind leg, which resulted in a total loss of engine power due to fuel starvation and a forced landing short of the runway.NTSB GAA15CA223Accident · Minor injuriesData collectionFinal reportCessna 170B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB GAA15CA221Accident · No injuriesData collectionFinal reportBell 47D1 · Clanton, ALThe student pilot's abrupt cyclic and collective inputs during the approach to land which resulted in abnormal runway contact and a subsequent tail boom strike by the main rotor blades.NTSB DCA15WA180Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 747 airplane, which occurred on August 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN15LA361Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookfield, MOThe pilot's failure to visually check the quantity of fuel in the fuel tanks in accordance with the Preflight checklist, which resulted in a loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB GAA15CA222Accident · No injuriesData collectionFinal reportCessna A185F · Emily, MNThe pilot's failure to retract the landing gear, which resulted in a gear down water landing and a nose over.NTSB ERA15LA306Accident · Serious injuriesLimited investigationFinal reportWright Daniel J Volksplane VP-1 · Brooksville, FLThe pilot's failure to abort the takeoff after determining that the engine was not producing adequate power. Contributing to the accident was the engine's inability to produce adequate power for reasons that could not be determined due to extensive postimpact…NTSB ERA15FA299Accident · 1 fatalField investigationFinal reportPiper PA-28R · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation while turning after takeoff in dark night conditions in a sparsely populated area, which resulted in the airplane’s descent into water. Contributing to the…NTSB CEN15LA350Accident · Minor injuriesLimited investigationFinal reportJal R Dennis Trixy Princess · Midland, TXThe pilot's inadequate preflight planning during which he failed to account for the high-density altitude conditions and high gross weight, which degraded the gyroplane's climb performance and resulted in a hard landing.NTSB CEN15FA347Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5A · Harrisburg, ILThe student pilot's improper decision to conduct a flight in dark, night conditions and his subsequent controlled flight into terrain.NTSB CEN15FA342Accident · 1 fatalField investigationFinal reportPiper PA 32R-300 · Harbor Springs, MIThe pilot's failure to maintain clearance from the trees during the approach in dark, night conditions, which resulted in controlled flight into trees and terrain.NTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.NTSB WPR15FA238Accident · 1 fatalField investigationFinal reportAviat A 1 · Compton, CAThe pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…NTSB ERA15WA309Accident · 3 fatalForeign investigationCessna 172N · Bajo Baudo, ColombiaOn August 9, 2015, about 2200 coordinated universal time, a Cessna 172N, Colombian registration TI-BAA, was destroyed when it impacted terrain during a rejected landing at Pizarro Airport (SK-195), Bajo Baudo, Colombia. The two pilots and one passenger were…NTSB ERA15LA301Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe student pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to fuel contamination.NTSB ERA15CA302Accident · Minor injuriesData collectionFinal reportCessna 206G · Titusville, FLThe pilot's landing with a tailwind at an excessive speed, which resulted in a runway excursion, and collision with a ditch.NTSB CEN15RA352Accident · 1 fatalForeign investigationDehavilland DHC 2 · Akureyri, IcelandOn August 9, 2015, at an unknown time, a De Havilland DHC-2 airplane, United States registration N610LC, was substantially damaged when it impacted mountainous terrain near Akureyri, Iceland. One occupant sustained fatal injuries, and one occupant sustained…NTSB CEN15LA354Accident · Serious injuriesLimited investigationFinal reportCessna C421B · Clovis, NMThe pilot's improper management of fuel to the left engine during approach for landing, which resulted in a total loss of left engine power due to fuel starvation, and his subsequent failure to maintain control during the final landing approach, which…NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.