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 CEN16LA380Accident · Serious injuriesLimited investigationFinal reportPiper PA 30 · Mineral Wells, TXThe pilot's fuel mismanagement, which resulted in fuel starvation to both engines and their subsequent loss of engine power.NTSB ANC16CA073Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe pilot’s failure to maintain an adequate glidepath during landing, which resulted in an unintended touchdown before the chosen landing area.NTSB GAA16CA501Accident · No injuriesData collectionFinal reportPiper PA28R · Ottumwa, IAThe pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the…NTSB ERA16WA341Accident · No injuriesForeign investigationAir Tractor AT602 · Sao Jose do Rio Preto, BrazilOn September 21, 2016, about 1415 coordinated universal time, an Air Tractor AT-602, N1001R, was substantially damaged during a forced landing to a sugar plantation, following a total loss of engine power during descent near Sao Jose do Rio Preto, Brazil. The…NTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ENG16WA040Incident · No injuriesForeign investigationAirbus A319 · Chiclayo, PeruThe Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB CEN16LA382Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Wooster, OHA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16WA396Incident · No injuriesForeign investigationSwearingen SA227 · Cologne, GermanyOn September 20, 2016, at 1725 UTC, a Fairchild Swearingen Corporation SA-227-AC Metroliner, German registration D-CPSW, owned and operated by BINAIR Aero, sustained minor damage when the airplane veered off the runway while landing at the Cologne/Bonn…NTSB CEN16FA378Accident · 2 fatalField investigationFinal reportPiper PA 28-235 · Lee's Summit, MOThe pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.NTSB GAA16CA495Accident · No injuriesData collectionFinal reportPiper PA 11 · Grand Isle, VTThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during a simulated engine failure and forced landing with a tailwind, which resulted in an aerodynamic stall.NTSB ERA16WA337Accident · 1 fatalForeign investigationEmbraer EMB810 · Miranda, BrazilOn September 19, 2016, at 2000 coordinated universal time (1600 local), a Piper designed Embraer EMB810-D, Brazilian registration PT-VKY, was destroyed when it impacted terrain in the Miranda Municipality, State of Mato Grosso Do Sul, Brazil. The pilot was…NTSB ENG16IA037Incident · No injuriesIncident investigationFinal reportAirbus A320 · Miami, FLthe incorrect latching of the #2 Engine Fan Cowl following a routine maintenance check that resulted in separation of the cowl during takeoff.NTSB CEN16LA379Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Chesterfield, MOThe pilot's unstable approach and subsequent loss of airplane control during an attempted go-around.NTSB CEN16LA375Accident · No injuriesLimited investigationFinal reportPiper PA 32R-300 · Grants, NMA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN16FA373Accident · 2 fatalField investigationFinal reportCessna 182 · Ephraim, WIThe pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.NTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.NTSB WPR16LA185Accident · Minor injuriesLimited investigationFinal reportHoover David Arnold AR 6 · Reno, NVThe pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…NTSB WPR16FA183Accident · Serious injuriesField investigationFinal reportCessna 182P · Gilbert, AZAn inadvertent explosion of pyrotechnics, which were contained in a box that had been installed on the airplane's left main landing gear assembly spring leg which resulted in shrapnel striking the airplane's left wing and breaching the left wing fuel tank,…NTSB GAA16LA525Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Davis, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover. Contributing to the accident was the failure of the seatbelt anchor bracket.NTSB GAA16CA517Accident · No injuriesData collectionFinal reportJerant Frank Mong · Reno, NVThe other pilot's failure to maintain adequate separation and visual lookout during landing, which resulted in his airplane colliding with the airplane ahead of it on the runway.NTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB ERA16LA319Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Chestertown, MDLoss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.NTSB CEN16WA377Accident · 4 fatalForeign investigationPiper PA28 · Gödöllo, Pest, Hungary, HungaryNTSB ANC16CA066Accident · No injuriesData collectionFinal reportPiper PA 18 · McGrath, AKThe pilot's excessive taxi speed, which resulted in a loss of control and subsequent nose over.NTSB WPR16LA184Accident · No injuriesLimited investigationFinal reportOGG Richard A OGG Glasair I · Reno, NVThe failure of an induction elbow following an engine backfire, which resulted in an in-flight fire and loss of engine power.NTSB WPR16LA181Accident · No injuriesLimited investigationFinal reportDehavilland DH115 Vampire · Reno, NVThe in-flight failure of the canopy and subsequent loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB WPR16FA182Accident · 3 fatalField investigationFinal reportBeech 95 B55 (T42A) · Broadus, MTThe airplane's departure from cruise flight for reasons that could not be determined based on the available information.NTSB GAA16CA509Accident · Minor injuriesData collectionFinal reportGrumman G44 · Lakeport, CAThe pilot's failure to retract the landing gear, which resulted in a gear-down water landing and a nose over.NTSB GAA16CA500Accident · No injuriesData collectionFinal reportAerotek Pitts Special · Reno, NVThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA16CA499Accident · No injuriesData collectionFinal reportAlex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJThe student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.NTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.NTSB GAA16CA523Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.NTSB GAA16CA510Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Port St. Lucie, FLThe pilot's failure to avoid the drainage pipe during the landing roll on a private grass airstrip. Contributing to the accident was the pilot's reduced forward view from the rear seat.NTSB GAA16CA498Accident · No injuriesData collectionFinal reportAirtime Cygnet · Venice, FLThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.NTSB GAA16CA494Accident · No injuriesData collectionFinal reportBeech B23 · Raleigh, NCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA16LA318Accident · No injuriesLimited investigationFinal reportCessna P210 · Lancaster, PAA landing gear collapse during landing for reasons that could not be determined because postaccident examination and testing of the landing gear did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal…NTSB ERA16FA316Accident · 1 fatalField investigationFinal reportCessna A188 · Alapaha, GAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.NTSB DCA16WA232Accident · No injuriesForeign investigationBell 430 · Cabinda, AngolaThe Angola Ministry of Transport (MoT) has notified the NTSB of an accident involving a BELL 430 helicopter that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MoT's investigation under the provisions of…NTSB DCA16WA231Accident · No injuriesForeign investigationBoeing 727 · Kamina, Congo - KinshasaThe government of Dem. Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 727 airplane that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's investigation…NTSB ANC16LA068Accident · Serious injuriesLimited investigationFinal reportJeffery D Tuttle BDK Carbon Concepts · Wasilla, AKThe structural failure of both wings’ leading-edge slats, which resulted in a loss of airplane control.NTSB ANC16LA067Accident · No injuriesLimited investigationFinal reportHelio H 295 · Fairbanks, AKExcessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.NTSB WPR16WA186Accident · 4 fatalForeign investigationLittle Eagle LE500 · Shijiazhuang City, ChinaOn September 15, 2016, about 0308 Universal Time, a Little Eagle LE500 single-engine airplane, Chinese registration B-9246, impacted flat terrain about 1,640 feet from the approach end of runway 18, at the Luan Cheng General Aviation Airport, Shijiazhuang…NTSB GAA16CA491Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Valparaiso, INThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…NTSB ERA16WA317Accident · 2 fatalForeign investigationPiper PA28 · Flanders, ColombiaOn September 15, 2016, about 1523 universal coordinated time, a Piper PA-28-140; Colombian registration, HK1328G, operated by Aeroandes Flight Training School, and a Cessna 152; Columbian registration, HK2092G, operated by Acahel Flight Training School…NTSB DCA16WA239Incident · No injuriesForeign investigationCessna 152 · Malindi, KenyaThe Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an incident involving a Cessna 152 airplane that occurred on September 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under the…NTSB GAA16CA488Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Cedar City, UTThe flight instructor’s delayed remedial action while providing hover instruction in gusting wind conditions, which resulted in dynamic roll-over.NTSB CEN16LA369Accident · No injuriesLimited investigationFinal reportStinson V77 · Jordan, MNA partial loss of engine power due to carburetor icing.NTSB CEN16FA370Accident · 2 fatalField investigationFinal reportPiper PA 11 · Arcanum, OHThe student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.