NTSB investigations, 2015
81 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 year(c.\"eventDate\") = 2015
AND 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 year(c."eventDate") = 2015 AND 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 ERA15FA245Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Holly Ridge, NCThe pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB GAA15CA127Accident · No injuriesData collectionFinal reportPaquin Michael A A · Concord, NHThe pilot's inability to maintain directional control during takeoff, which resulted in a roll over. Contributing to the loss of control was the pilot's failure to disengage the main rotor brake prior to takeoff.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 ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.NTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…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 GAA15LA085Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Eltopia, WAThe flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…NTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.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 ERA15LA212Accident · No injuriesClass 2 · LimitedFinal reportGates Lear Jet 35 · Newport News, VAThe flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…NTSB ERA15CA209Accident · No injuriesData collectionFinal reportCessna 150D · Balsam Grove, NCThe pilot's decision to attempt an off airport takeoff, and failure to maintain adequate clearance during the initial climb in crosswind conditions, which resulted in a collision with trees.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 ERA15LA168Accident · Minor injuriesLimited investigationFinal reportTrick Trikes 582 Cyclone Storm · Live Oak, FLThe student pilot applicant’s failure to clear the engine during a prolonged descent of a simulated engine failure and his subsequent rapid throttle input at the completion of the maneuver, which resulted in the engine’s failure to respond. Contributing to…NTSB ERA15CA169Accident · No injuriesData collectionFinal reportBellanca 17 31A · Siler City, NCThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown.NTSB GAA15CA013Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Lake Hamilton, ARThe pilot's overcorrection to the landing pad shifting, which resulted in the helicopter impacting trees. A factor contributing to the accident was the collapse of the landing pad.NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.NTSB 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 ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…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 ERA15LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fernandina Beach, FLThe pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.NTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.