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 CEN15LA204Accident · Minor injuriesLimited investigationFinal reportGrumman G 164A · Maysville, OKThe loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA198Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunlap, ILA loss of main rotor rpm for reasons that could not be determined during postaccident examinations.NTSB WPR15LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hilo, HIWater contamination in the fuel system due to the flight instructor’s and pilot receiving instruction’s failure to drain all the water from the system during the preflight inspection, which resulted in a loss of engine power.NTSB WPR15FA147Accident · 1 fatalField investigationFinal reportRobert C. Hanson Pitts S2E · Lebec, CAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB CEN15LA219Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Evart, MIThe pilot's failure to follow the Before Landing checklist and to extend the landing gear and the flight instructor’s inadequate supervision, which resulted in a gear-up landing.NTSB ANC15FA021Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe pilot's decision to continue flight into known icing conditions, contrary to the airplane’s limitations, which resulted in a total loss of engine power due to icing.NTSB WPR15WA145Accident · 1 fatalForeign investigationBell 206 - B · Ziyang City, China, ChinaOn April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…NTSB ERA15RA199Accident · 2 fatalForeign investigationSwearingen SA226-TC · North Vancouver, CanadaOn April 13, 2015, at 0709 Pacific daylight time, a Swearingen SA226-TC, Canadian registration C-GSKC, operating as Carson Air flight 66, was destroyed in an area of mountainous terrain about 10 nautical miles north of North Vancouver, British Columbia. The…NTSB ERA15LA184Accident · Serious injuriesLimited investigationFinal reportCessna 162 · Shelter Island, NYThe pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.NTSB DCA15WA107Accident · No injuriesForeign investigationBoeing 737 - 804 · Khajuraho, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a BOEING 737 that occurred on April 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB ANC15LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Bettles, AKA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no mechanical anomalies that would have precluded normal operation.NTSB OPS15IA017Incident · No injuriesIncident investigationFinal reportBoeing 767 34AF · Miami, FLThe controller's issuance of a landing clearance to an arriving aircraft while another aircraft was in position on the same runway. Contributing to the incident was the controller's non-compliance with traffic advisory procedures, and insufficient…NTSB GAA15CA075Accident · Minor injuriesData collectionFinal reportHead Balloons AX8 105 - NO Series · Intercourse, PAThe pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.NTSB GAA15CA038Accident · Minor injuriesData collectionFinal reportUltramagic M90 - NO Series · Sherwood, ORThe pilot's failure to maintain the descent rate, resulting in a hard landing.NTSB ERA15WA182Accident · 3 fatalForeign investigationCessna 172S · Santander, ColombiaOn April 12, 2015, about 1915 coordinated universal time, a Cessna 172S, Colombian registration HK5064G, and a Cessna 150M, Colombian registration HK1912G, were substantially damaged after impacting mountainous terrain in the vicinity of the Serrania Los…NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.NTSB DCA15WA156Incident · No injuriesForeign investigationBoeing Boeing 737-530 · Zurich, SwitzerlandThe BFU of Switzerland (BFU-CH) has notified the NTSB of an incident involving a Boeing 737-530 airplane that occurred on April 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU-CH's investigation under the provisions of ICAO…NTSB WPR15FA144Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Prescott Valley, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack during the initial climb after a ground-tow launch, which resulted in an aerodynamic stall/spin.NTSB GAA15CA040Accident · No injuriesData collectionFinal reportTrom Wayne Vans RV6A · LaFayette, GAThe pilot's failure to maintain directional control during the landing roll in variable, gusting wind conditions, resulting in a runway excursion, and substantial damage to the airplane.NTSB ERA15WA193Accident · 1 fatalForeign investigationCessna 210L · Assuncao do Piaui, BrazilOn April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…NTSB ERA15LA183Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Spring City, TNThe pilot's failure to properly apply carburetor heat in conditions conducive to carburetor icing, which resulted the accumulation of carburetor ice and the subsequent total loss of engine power.NTSB CEN15LA195Accident · 1 fatalLimited investigationFinal reportQuad City Challenger - II · Chippewa Falls, WIThe pilot’s incapacitation due to a cardiovascular event, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN15CA196Accident · No injuriesData collectionFinal reportAeronca 7AC · Cambridge, OHThe pilot's failure to maintain control of the airplane while encountering a wind gust after landing.NTSB WPR15FA143Accident · 4 fatalField investigationFinal reportCessna T210M · Challis, IDThe pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.NTSB ERA15LA328Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G IV · Caribbean Sea, A1The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.NTSB ENG15IA017Incident · No injuriesIncident investigationFinal reportBoeing 707 338C · Victorville, CAthe fracture of one 1st stage turbine blade from a high cycle fatigue crack that originated from a break in the coating on the leading edge of the blade. The cause for the break in the coating could not be determined. Contributing to the uncontained release…NTSB CEN15CA197Accident · No injuriesData collectionFinal reportRennicke Midget Musta MM1 · Longmont, COThe pilot's failure attain/maintain pitch control prior to attaining a proper takeoff speed during takeoff roll, which resulted in a premature liftoff of the airplane and loss of control.NTSB ENG15WA018Incident · No injuriesForeign investigationShort Brothers & Harland SC-7 Skyvan S3 · Klatovy, Czech Republic, CzechiaAn Austrian registered Shorts SC7 Skyvan, registration number OE-FDN, being operated by Pink Aviation Services Gmbh, suffered an uncontained failure of No.2 turbine wheel on RH engine during descend, resulting in damage to the right-hand forward sidewall fuel…NTSB GAA15CA034Accident · Minor injuriesData collectionFinal reportCessna 182F · Portland, TNThe pilot's failure to perform a go-around in time to prevent a runway overrun and collision with terrain.NTSB CEN15LA207Accident · No injuriesLimited investigationFinal reportCessna 177B · Jennings, LAThe pilot's improper landing flare, which resulted in a hard landing, the nosewheel tire bursting, and a subsequent porpoise and nose-over.NTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…NTSB GAA15CA035Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot's improper flare which resulted in a loss of control and subsequent hard landing.NTSB ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.NTSB ERA15FA178Accident · 1 fatalField investigationFinal reportHughes 369D · Cherokee, ALThe pilot's spatial disorientation during a low-level river crossing in rainy, gray, reduced visibility meteorological conditions, which resulted in the helicopter's subsequent descent and impact with the water. Contributing to the accident was the pilot's…NTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB WPR15LA148Accident · No injuriesLimited investigationFinal reportCessna 206H · Honolulu, HIA blown nose landing gear tire during landing, which resulted in the pilot’s inability to maintain directional control.NTSB WPR15LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · Santa Maria, CAThe engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA15CA037Accident · No injuriesData collectionFinal reportJabiru Jabiru - SP · Surprise, AZThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15CA176Accident · Serious injuriesData collectionFinal reportBeech V35B · Wetumpka, ALThe pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.NTSB DCA15WA113Accident · 6 fatalForeign investigationEurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, MalaysiaNTSB CEN15WA191Accident · 2 fatalForeign investigationPiper Piper PA-28-140 · Loch Etive, United KingdomOn April 4, 2015, at an unknown time, a United Kingdom registered Piper PA-28-140 airplane, G-BHXK,impacted mountainous terrain near Lock Etive, Oban, Argyll, and Bute, United Kingdom.The two occupants were fatally injured. The investigation is under the…NTSB CEN15IA200Incident · No injuriesIncident investigationFinal reportAir Tractor AT 402A · Brickeys, ARThe in-flight separation of the attachment hardware at the elevator control pushrod due to maintenance personnel's improper reinstallation of the attachment hardware.NTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.NTSB GAA15CA041Accident · No injuriesData collectionFinal reportCessna 182R · Fort Myers, FLThe pilot's excessive descent rate during approach, which resulted in a hard landing.NTSB GAA15CA032Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Fort Davis, TXThe pilot's failure to maintain control of the helicopter during flight, which resulted in the helicopter impacting terrain.NTSB CEN15FA194Accident · 1 fatalField investigationFinal reportS C Aerostar S A YAK 52TW · Advance, INThe pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN15FA189Accident · 1 fatalField investigationFinal reportCessna 152 · Batesville, ARThe noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…NTSB GAA15CA033Accident · No injuriesData collectionFinal reportLancair LC 40 550FG · Middleton, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's inadequate compensation for the crosswind during landing.