NTSB investigations, 2016
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE year(c.\"eventDate\") = 2016 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 WHERE year(c."eventDate") = 2016 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 GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA17WA009Accident · 3 fatalForeign investigationCessna 207 · Santa Cruz, Cajamarca, PeruOn October 10, 2016, about 1427 universal coordinated time, a Cessna 207A, Peruvian registration OB-1936-P, was destroyed during a collision with mountainous terrain near Santa Cruz, Cajamarca, Peru. The pilot and two passengers were fatally injured. The…NTSB DCA17WA012Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia (KNKT/NTSC) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on October 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's…NTSB WPR17LA003Accident · Minor injuriesLimited investigationFinal reportMelborn Joe B Kolb Sport 600 · Roberts, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Toone, TNA stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.NTSB DCA17WA006Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB CEN17LA014Accident · No injuriesLimited investigationFinal reportCessna 150M · Beasley, TXThe No. 2 cylinder exhaust valve being stuck in the “full open” position due to carbon deposits, which resulted in a total loss of engine power.NTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA17CA008Accident · Serious injuriesData collectionFinal reportAlgimantas Jonusas RV-10 · Ashwood, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning and continued flight into instrument meteorological conditions, which resulted in impact with trees and terrain.NTSB DCA17WA032Accident · No injuriesForeign investigationCessna 172 · Brits, North West Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving ZS-MPF, a Cessna 172M airplane that occurred on October 07, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.NTSB GAA17CA017Accident · No injuriesData collectionFinal reportPiper PA 17 · Keene Valley, NYThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane and an impact with trees.NTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.NTSB GAA17CA010Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Boca Reservoir, CAThe pilot's decision to continue the taxi on unsuitable muddy terrain, which resulted in a nose-over.NTSB ERA17LA007Accident · Serious injuriesLimited investigationFinal reportJames Bruton Flying Flea · Plymouth, CTA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA006Accident · No injuriesLimited investigationFinal reportPiper PA24 · Hollywood, ALA failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power.NTSB ENG17WA002Incident · No injuriesForeign investigationMD Helicopter 500 · Wanaka, New ZealandThe Civil Aviation Authority of New Zealand has notified the NTSB of an incident involving a MD Helicopters MD520N, which occurred on October 6, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…NTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.NTSB ANC17WA002Accident · 1 fatalForeign investigationSteen Skybolt · Blackfalds, CanadaOn October 06, 2016, about 2050 Coordinated Universal Time, an amateur-built Steen Skybolt airplane, C-GWBD, impacted terrain near Blackfalds, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.NTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.NTSB GAA17CA023Accident · No injuriesData collectionFinal reportNorth American Navion · Palmer, AKThe pilot's failure to extend the landing gear for landing.NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.NTSB DCA17CA005Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Denver, COthe flight attendant losing her balance as she was removing her carry-on baggage resulted in her falling against an arm rest causing the serious injury.NTSB WPR17LA005Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Waimea, HIImpact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.NTSB GAA17CA052Accident · No injuriesData collectionFinal reportChaudoin George S RV 10 · Portsmouth, NHThe pilot’s failure to go around after recognizing that the airplane was high and fast, which resulted in a long landing on a wet runway and a runway excursion.NTSB GAA17CA007Accident · No injuriesData collectionFinal reportCessna T182 · Galesburg, ILThe pilot's improper landing flare, which resulted in a bounced, hard landing.NTSB ENG17WA001Accident · No injuriesForeign investigationBoeing 737 · Aldergrove, United KingdomOn October 4, 2016, a Boeing 737-400 experienced a partial right main gear failure during the landing roll at Belfast International Airport (EGAA), Aldergrove, Northern Ireland, United Kingdom. The flight originated from East Midlands Airport (EGNX),…NTSB CEN17LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmot, WIA failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.NTSB CEN17FA005Accident · 1 fatalField investigationFinal reportBeech D95A · Hitchcock, TXThe flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…NTSB GAA17CA029Accident · No injuriesData collectionFinal reportAirplane Factory Sling · Torrance, CAThe student pilot's improper landing flare in crosswind conditions, which resulted in a porpoised hard landing and a runway excursion.NTSB GAA17CA005Accident · No injuriesData collectionFinal reportCessna Ector 305 · Concord, NHThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA17WA004Accident · No injuriesForeign investigationCessna 208 · Contamana, PeruOn October 3, 2016, about 1530 universal coordinated time, a Cessna 208B, Peruvian registration OB-1998-P, was substantially damaged when the left main landing gear separated from the airplane while taxiing at Contamana Airport (SPCM), Contamana, Peru. The…NTSB CEN17LA011Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Fulshear, TXA partial loss of engine power due to the improper assembly of the mechanical fuel pump.NTSB WPR17CA001Accident · No injuriesData collectionFinal reportCessna R172K · Rosamond, CAThe pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.NTSB GAA17CA004Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Fort Valley, GAThe failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact.NTSB GAA17CA003Accident · No injuriesData collectionFinal reportAndrew Harold Stol CH 701 · Berryton, KSThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion.NTSB CEN17WA008Accident · 1 fatalForeign investigationNorth American P-51D · East Anglia, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted…NTSB CEN17LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Clarendon, TXThe failure of a cylinder piston pin, which resulted in an obstructed oil inlet screen, reduced the amount of oil available to the engine, and led to the subsequent loss of engine power. Contributing to the accident was the failure of the nonmechanic, who had…NTSB CEN17LA004Accident · No injuriesLimited investigationFinal reportVolaircraft 10A · Mandan, NDThe student pilot’s failure to maintain the proper approach path on landing, which resulted in impact with terrain short of the runway.NTSB CEN17CA013Accident · Minor injuriesData collectionFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's improperly planned landing, which resulted in a strike with power lines.NTSB ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…NTSB GAA17CA008Accident · No injuriesData collectionFinal reportBeech 35 · Lawrence, KSThe flight instructor’s delayed remedial action, which resulted in an unstabilized approach and collision with runway approach lights.NTSB GAA17CA001Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s improper crosswind correction, which resulted in a loss of pitch control and nose-over.NTSB ERA17LA026Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe pilot’s improper landing flare in gusting crosswind conditions, which resulted in a nose landing gear collapse.