NTSB investigations
739 cases where the defining event was Miscellaneous/other.
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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900') 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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…NTSB CEN16WA060Incident · No injuriesForeign investigationSikorsky S92 · Wexford, IrelandOn December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…NTSB ERA16FA043Accident · 2 fatalField investigationFinal reportBeech A36TC · Orlando, FLThe pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…NTSB DCA16CA009Accident · Serious injuriesData collectionFinal reportBoeing 757 223 · Dallas, TXthe disabled passenger not being properly secured during the transfer from the aisle chair causing him to slide to floor and receive a serious injury.NTSB DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB ERA15LA358Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Manteo, NCThe inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.NTSB ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB ERA15LA337Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · New Smyrna Beach, FLThe pilot’s inadequate visual lookout and failure to maintain clearance from trees while maneuvering at low altitude.NTSB ERA15FA336Accident · 1 fatalField investigationFinal reportHenderson W A/Johnson W L RV 6A · Bon Aqua, TNThe pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.NTSB ERA15WA346Accident · Minor injuriesForeign investigationBell 206L-3 · Boyaca, ColombiaOn September 1, 2015, about 1925 UTC, a Bell 206L-3, HK 3311, registered to and operated by Sociedad Aerea De Ibague, was landed hard in a field during a forced landing near Municipality of Chita, Boyaca, Colombia. Visual meteorological conditions prevailed…NTSB ERA15LA304Accident · No injuriesLimited investigationFinal reportBoard James A Zenith 601 HD · Danville, KYThe pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.NTSB CEN15CA340Accident · Serious injuriesData collectionFinal reportThunder & Colt AX8 105S2 · Albuquerque, NMThe pilot did not properly brace herself during the landing, which resulted in a broken ankle and leg.NTSB ERA15LA281Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Albertson, NCThe pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.NTSB ERA15LA271Accident · No injuriesLimited investigationFinal reportYoung John E Searey · Corbin, KYThe pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.NTSB ERA15LA269Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Dunkirk, NYThe pilot's failure to maintain control of the airplane while attempting to close an open cabin door, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…NTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB ERA15CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Viola, TNThe pilot's failure to see and avoid a guy wire, which resulted in contact with the wire and subsequent collision with terrain.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.NTSB GAA15CA173Accident · No injuriesData collectionFinal reportCessna 182 · Athens, TNThe failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.NTSB CEN15CA312Accident · No injuriesData collectionFinal reportEurocopter EC 130 B4 · Somerset, COThe pilot's decision to fly at a low altitude when he was aware that there were wires in the area which resulted in the helicopter contacting a wire.NTSB CEN15WA302Incident · No injuriesForeign investigationRobinson R-22 Beta II · Hradec Kralove, Czech Republic, CzechiaOn June 29, 2015, about 0806 coordinated universal time (UTC), a Robinson R-22 Beta II, OK-ZYZ, experienced an in-flight anomaly and the pilot conducted an emergency autorotation to a field about 10 miles west of Hradec Kralove, Czech Republic. The two pilots…NTSB CEN15LA288Accident · Serious injuriesLimited investigationFinal reportBell 407 - NO Series · South Timbalier 127The pilot's lack of awareness of the severity of the gusting winds, which led to the helicopter being pushed off of the oil platform by a wind gust during engine start. Contributing to the accident was the unavailability of a nearby weather monitoring system.NTSB WPR15WA188Accident · 1 fatalForeign investigationRobinson R44 - Undesignat · Timber Creek, Australia, AustraliaOn June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…NTSB GAA15CA122Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Elk Mound, WIThe pilot's failure to maintain a positive rate of climb after taking off from the service truck, which resulted in the helicopter impacting terrain.NTSB DCA15WA210Incident · No injuriesForeign investigationBoeing 737 · Nauru, NauruThe Australian Transport Safety Board (ATSB) has notified the NTSB of an accident involving a BOEING 737 that occurred on June 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB DCA15WA130Incident · No injuriesForeign investigationBoeing 737 - 4D7 · Turin, ItalyThe Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving a Boeing 737-400, which occurred on June 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the…NTSB GAA15CA097Accident · No injuriesData collectionFinal reportBell 47G 3B 1 · Fort Pierre, SDThe pilot's inadequate preflight fuel planning that resulted in a total loss of engine power due to fuel exhaustion, and the pilot's failure to maintain control of the helicopter during the subsequent autorotation landing.NTSB CEN15LA242Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Superior, WIA stuck aileron due to a battery that had become jammed in the aileron bell crank.NTSB ANC15CA026Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Talkeetna, AKThe private pilot's failure to maintain clearance from a spruce tree during final approach, which resulted in a loss of control and hard landing. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB GAA15CA057Accident · Minor injuriesData collectionFinal reportCessna 182T · St Marys, PAThe pilot's decision to rotate the propeller by hand without properly securing the airplane.NTSB DCA15WA178Incident · No injuriesForeign investigationBoeing Boeing 777-228 IGW · Douala, CameroonThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) has notified the NTSB of an incident involving a Boeing 777-200, which occurred on May 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA…NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB GAA15CA002Accident · No injuriesData collectionFinal reportBell 407 · Justin, TXAbnormal ground contact during an autorotation demonstration, resulting in a severed tailrotor driveshaft.NTSB ERA15LA140Accident · Serious injuriesLimited investigationFinal reportBombardier Canadair CL600-2A12 · Marco Island, FLThe failure of a spring inside the No. 2 brake’s upper brake control valve and the fracture of the coupling subassembly of the No. 1 wheel speed sensor during landing, which resulted in the loss of braking action, and the pilot-in-command’s (PIC) deactivation…NTSB ERA15FA129Accident · 4 fatalField investigationFinal reportBeech 1900 · Miami, FLThe left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…NTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…NTSB CEN15LA131Accident · No injuriesLimited investigationFinal reportBell-Watson 47 G · North Little Rock, ARThe flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.NTSB ERA15WA082Accident · 7 fatalForeign investigationCessna T207 - A · Piedecuesta, ColombiaOn December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…NTSB CEN15LA066Accident · Minor injuriesLimited investigationFinal reportMD Helicopter MD 900 · Highlandville, MOThe pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.NTSB ERA15CA065Accident · No injuriesData collectionFinal reportSocata TB 20 Trinidad · Hilton Head Island, SCThe pilot's inadvertent selection of an incorrect frequency, which resulted in his inability to activate the airport lighting, and his subsequent decision to continue the approach in dark night conditions despite having not positively identified the runway…NTSB DCA15WA013Incident · No injuriesForeign investigationBoeing 777 · Dubai, United Arab EmiratesThe GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO Annex 13 as…NTSB ERA14LA465Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A · Ceiba, PRThe pilot’s loss of consciousness during taxi for reasons that could not be determined based on the available information.NTSB ERA14CA463Accident · No injuriesData collectionFinal reportBeech D55 · Hazleton, PAThe brake application for unknown reasons resulting in rupture of the left main landing gear tire and tube, and subsequent loss of directional control.NTSB WPR14CA385Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Mokuleia, HIThe pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB ANC14CA076Accident · No injuriesData collectionFinal reportCessna U206B · Gustavus, AKThe motor vehicles operators' lack of attention, and improper decision to cross the runway with the runway alert system active, resulting in a collision with the airplane.NTSB WPR14CA363Accident · Serious injuriesData collectionFinal reportHughes 369D · Willows, CAThe pilot's failure to adequately secure cargo (a jacket), which resulted in the jacket exiting the cabin compartment and colliding with the tail rotor during cruise flight.