NTSB investigations
1,558 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…NTSB ERA16LA192Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Batavia, NYThe student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.NTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…NTSB WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.NTSB CEN16LA170Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine 582 · Fortville, INThe collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.NTSB ERA16LA265Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PAMaintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.NTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…NTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…NTSB CEN16WA140Accident · 2 fatalForeign investigationCessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, GuatemalaOn March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…NTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.NTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB GAA16CA156Accident · No injuriesData collectionFinal reportRolladen-Schneider LS8 · Pine Grove, PAThe pilot's inability to maintain the glider's descent rate and glide path after encountering a downdraft, resulting in a collision with trees during an off airport landing.NTSB CEN16WA124Incident · No injuriesForeign investigationCessna 525 · Lugano, SwitzerlandNTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…NTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…NTSB ERA16LA110Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Palatka, FLA partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.NTSB ERA16LA113Accident · No injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL · Orlando, FLA failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB WPR16LA071Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Buckeye, AZThe pilot's improper decision to operate the high-performance aircraft despite warnings from a flight instructor that he did not have the experience to operate the aircraft that had different and more sensitive handling characteristics than the…NTSB WPR16LA070Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Petaluma, CAThe pilot's inadequate compensation for wind during the landing approach, which resulted in the balloon’s basket impacting a metal fence and a passenger sustaining serious injuries.NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB ERA16WA101Accident · Serious injuriesForeign investigationRobinson R66 · Aviatornyi, RussiaOn February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…NTSB GAA16CA123Accident · No injuriesData collectionFinal reportCessna 150 · Lapeer, MIThe student pilot's failure to achieve an adequate climb rate while turning to avoid obstacles during an aborted landing, resulting in an uncontrolled descent, collision with terrain, and a nose over.NTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.NTSB GAA16CA109Accident · Minor injuriesData collectionFinal reportCessna CE-208 · Hooper Bay, AKThe pilot's failure to identify the runway, resulting in the airplane touching down a few feet to the right of the runway.NTSB ERA16FA089Accident · 1 fatalField investigationFinal reportCaughran Terry Flightstar II · Wake, VAFailure of the left wing in flight due to compression loading from wing loads combined with preexisting damage.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 ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA16LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Charles Town, WVThe flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…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 CEN16FA054Accident · 2 fatalField investigationFinal reportCessna 140 · Keytesville, MOThe non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…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 ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…NTSB GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.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 ERA16CA060Accident · No injuriesData collectionFinal reportEurocopter Deutschland EC 135 · Monongahela, PAThe inadequate securing of the wheeled fire extinguisher's cover which resulted in it being blown off of the fire extinguisher and ingested into the helicopter's fenestron during takeoff, resulting in a loss of directional control.NTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…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 GAA16CA013Accident · No injuriesData collectionFinal reportBeech F33 · Marana, AZThe student pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an inadvertent aerodynamic stall and impact with terrain during recovery by the flight instructor.NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…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 ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…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 ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…