NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.NTSB ERA10WA171Accident · 2 fatalForeign investigationRobinson R44 · Karelia, RussiaOn March 10, 2010, about 0900 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Russian registration RA-04163, operated by a private individual, was involved in an accident under unknown circumstances near Karelia, Russia. The helicopter departed…NTSB ERA10IA170Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Farmingdale, NYProgressive cracking from an undetermined initiation source, which resulted in the failure of the No. 4 cabin window outer pane, and the subsequent foreign object ingestion to the right engine.NTSB CEN10WA150Accident · 3 fatalForeign investigationCessna 421 · Tegucigalpa, HondurasThis investigation is under the jurisdiction and control of the Honduran government.NTSB CEN10LA149Accident · Serious injuriesLimited investigationFinal reportStump Davis · Seguin, TXThe pilot's improper flare, which resulted in a bounced landing and noseover during a downwind landing.NTSB CEN10CA163Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot's failure to maintain an appropriate glide path during approach. Contributing to the accident was the student pilot's decision to continue the approach instead of going around.NTSB ANC10LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Ophir, AKThe total loss of engine power for an undetermined reason.NTSB WPR10RA197Accident · Serious injuriesForeign investigationEagle 150B · Kota Bahru, MalaysiaOn March 9, 2010, about 1630 local time, an Eagle 150B, Malaysia registration 9M-BEV, crashed near Kota Bahru, Kelantan, Malaysia, subsequent to an in-flight propeller separation. The two occupants, a flight instructor and student pilot, sustained serious…NTSB ENG10RA020Incident · No injuriesForeign investigationBAE 146 · Jorge Chavez Intl Airport, PeruOn March 9, 2010, a Star Peru British Aerospace BAe 146-300, registration OB-1914-P, powered by 4 Honeywell ALF502R engines, experienced a No. 1 engine uncontained failure during take off run on Runway 33 of the Jorge Chavez International Airport, Lima, Peru.…NTSB CEN10CA146Accident · No injuriesData collectionFinal reportByler JDT MINI-MAX 1100R · New Paris, INA total loss of engine power in flight due to carburetor icing. Contributing to the accident was the soft field where the airplane nosed over.NTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.NTSB WPR10CA153Accident · No injuriesData collectionFinal reportAviat A-1C-200 · St. Johns, AZThe pilot's inadequate compensation for the crosswind gusts and failure to maintain proper runway alignment during takeoff.NTSB WPR10CA152Accident · No injuriesData collectionFinal reportCessna 172P · Camarillo Airport, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during landing.NTSB ERA10CA169Accident · No injuriesData collectionFinal reportCessna 150H · New Bedford, MAThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB CEN10WA205Accident · Serious injuriesForeign investigationBell 206 · Guatemala City, GuatemalaOn March 7, 2010, at 1900 universal coordinated time, a Bell 206-L1 helicopter, Guatemalan registration, TG-ELE, was destroyed during a forced landing in a field near Guatemala City, Guatemala. The pilot and 4 passengers received serious injuries. The…NTSB CEN10WA153Accident · 1 fatalForeign investigationPiper PA32 · Chambery, FranceThis accident is under the jurisdiction and control of the French government.NTSB CEN10LA207Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Baytown, TXThe failure of the landing gear bolts.NTSB ERA10LA166Accident · Minor injuriesLimited investigationFinal reportBelcher William B II Firestar · Wetumpka, ALThe student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.NTSB ERA10FA163Accident · 2 fatalField investigationFinal reportNorth American T6 · Santa Rosa Beach, FLThe pilot's failure to maintain airspeed during a low altitude,over water aerobatic maneuver, which resulted in an aggravated stall/spin. Contributing to the accident were the pilot's loss of situational awareness and his decision to perform aerobatics at a…NTSB ERA10CA173Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Mount Sterling, KYThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB ERA10CA165Accident · No injuriesData collectionFinal reportCessna P210N · Miami, FLThe pilot's failure to see and avoid an unlit and unmarked helicopter dolly while taxiing at night.NTSB CEN10WA148Accident · 2 fatalForeign investigationAlon Aircoupe A2-A · Ciborro, Montemor-o-Novo, PortugalThis accident is under the jurisdiction and control of the Portuguese government.NTSB CEN10LA145Accident · No injuriesLimited investigationFinal reportHawker Beechcraft A36 · Milwaukee, WIThe pilot's retraction of the landing gear prior to establishing a positive climb rate.NTSB CEN10FA139Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Cotulla, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning. Contributing to the accident was the low-altitude operating environment that would not allow for a successful autorotation after the loss of engine power.NTSB CEN10CA147Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Martinsville, INThe pilot's inadequate preflight planning and his exceedance of the airplane's takeoff capability.NTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.NTSB WPR10CA151Accident · No injuriesData collectionFinal reportTarantola Leonard RV-6A · Onalaska, WAThe pilot's bounced landing on a soft turf runway, resulting in a collapsed nose landing gear.NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.NTSB ERA10LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Vero Beach, FLThe certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.NTSB ERA10CA167Accident · No injuriesData collectionFinal reportCessna 172 · Poughkeepsie, NYThe pilot's failure to maintain directional control during the landing flare.NTSB CEN10LA140Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Slaton, TXThe loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.NTSB CEN10FA141Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Marysville, OHThe pilot's improper decision to initiate and continue a flight into instrument meteorological conditions that led to spatial disorientation and a loss of control during cruise flight.NTSB CEN10CA144Accident · Minor injuriesData collectionFinal reportCessna 172R · Newark, OHThe pilot's failure to maintain directional control during takeoff.NTSB ANC10LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Nanwalek, AKThe pilot's decision to land on a short, icy runway with poor braking action, resulting in a runway overrun/excursion and collision with a snowbank.NTSB WPR10LA150Accident · Serious injuriesLimited investigationFinal reportMuffett Quickslvr Sprnt II · Buena, WAA loss of engine power due to fuel exhaustion as a result of the student pilot’s inadequate fuel planning.NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.NTSB DCA10WA036Accident · No injuriesForeign investigationBoeing 747 · Taipai, TaiwanOn March 4, 2010, China Airline flight 5233, a Boeing 747-400, registration B-18723 and operating as a cargo flight, experienced a tail strike during takeoff from Ted Stevens Anchorage International Airport, Anchorage, Alaska. The airplane continued to its…NTSB CEN10CA138Accident · Serious injuriesData collectionFinal reportEnstrom 280FX · Goshen, INThe inadequate preflight inspection by both pilots, resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the disconnected fuel tank sending unit.NTSB CEN10CA137Accident · No injuriesData collectionFinal reportCessna 152 · Hearne, TXThe student pilot's decision to land with a quartering tailwind and his improper flare and recovery from a bounced landing.NTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.NTSB ERA10LA158Accident · 1 fatalLimited investigationFinal reportMonroig Pedro J Rans S-6S · Mayaguez, PRThe sport pilot's failure to maintain adequate airspeed during landing in crosswind conditions resulting in an aerodynamic stall.NTSB CEN10LA143Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · DeKalb, ILThe collapse of the landing gear during landing due to the company's improper maintenance practices and the pilot's decision to take off with an overextended landing gear strut.NTSB CEN10CA155Accident · No injuriesData collectionFinal reportSchulke Avid Magnum · Lowell, MIThe pilot's inability to maintain directional control while landing on a slush-covered runway due to inadequate maintenance of the airplane brakes by maintenance personnel.NTSB ERA10CA208Accident · No injuriesData collectionFinal reportCessna 172P · Ft. Pierce, FLThe student pilot's improper flare and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB ERA10CA156Accident · No injuriesData collectionFinal reportPiaggio P180 · Greensboro, NCThe pilot's failure to properly configure the landing gear for landing. Contributing to the accident was the pilot's diverted attention looking for traffic and manipulating the secondary trim controls.NTSB ERA10CA155Accident · No injuriesData collectionFinal reportSocata TBM 700 · Gaithersburg, MDThe pilot’s failure to maintain aircraft control while performing a go-around.NTSB DCA12WA015Incident · No injuriesForeign investigationBoeing 737 · Brussels, BelgiumThe Irish Air Accident Investigation Unit (AAIU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on March 1, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of…NTSB CEN10RA135Incident · No injuriesForeign investigationCessna 525 · Stuttgart, GermanyUnder the jurisdiction and control of the German government.NTSB CEN10LA131Accident · No injuriesLimited investigationFinal reportLacour Long-EZE SR7-1 · Falfurrias, TXA total loss of engine power due to a failure of the crankshaft behind the No. 3 connecting rod journal for undetermined reasons.