NTSB investigations

1,311 cases where NTSB found Altitude.

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062012'))
  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.

NTSB CEN15FA211Accident · 1 fatalField investigationFinal reportHoffman Zenith 701 · Trinidad, COThe noncertificated pilot's failure to maintain airspeed following a loss of engine power while maneuvering at a low altitude, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the…Apr 30, 2015 · N95MH · Substantial damageNTSB GAA15CA042Accident · Minor injuriesData collectionFinal reportCessna 140 · Mize, MSThe pilot's failure to maintain clearance from obstacles during an off airport precautionary landing roll.Apr 18, 2015 · N76452 · Substantial damageNTSB WPR15FA147Accident · 1 fatalField investigationFinal reportRobert C. Hanson Pitts S2E · Lebec, CAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.Apr 14, 2015 · N75BH · DestroyedNTSB ERA15FA178Accident · 1 fatalField investigationFinal reportHughes 369D · Cherokee, ALThe pilot's spatial disorientation during a low-level river crossing in rainy, gray, reduced visibility meteorological conditions, which resulted in the helicopter's subsequent descent and impact with the water. Contributing to the accident was the pilot's…Apr 6, 2015 · N555JC · Substantial damageNTSB GAA15LA027Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC18 180 · Westfield Township, OHThe pilot’s failure to maintain clearance from trees during a base-to-final turn while landing toward the sun.Mar 28, 2015 · N550BS · Substantial damageNTSB WPR15FA135Accident · 1 fatalField investigationFinal reportPiper PA32R - 301 · Townsend, MTThe pilot's decision to depart on and to continue a visual flight rules flight over mountainous terrain into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of recent…Mar 26, 2015 · C-GAUS · Substantial damageNTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.Mar 13, 2015 · N919EM · DestroyedNTSB WPR15CA119Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Bernardino, CAThe pilot's failure to maintain adequate clearance from the ground, which resulted in a loss of control and subsequent dynamic rollover.Mar 3, 2015 · N4003S · Substantial damageNTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.Feb 27, 2015 · N4774S · Substantial damageNTSB CEN15FA154Accident · 1 fatalField investigationFinal reportRose Thunder Mustang · Helotes, TXThe pilot’s failure to maintain terrain clearance from terrain after initiating an aerobatic maneuver at a low altitude.Feb 25, 2015 · N7TR · DestroyedNTSB ERA15CA127Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Carthage, NYThe non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.Feb 1, 2015 · N20059 · Substantial damageNTSB CEN15FA092Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Vaughn, NMThe noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.Dec 30, 2014 · N2558M · Substantial damageNTSB CEN15FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Odessa, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.Dec 22, 2014 · N9922V · DestroyedNTSB WPR15FA062Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · Ronan, MTThe pilot’s failure to maintain clearance from terrain while performing an intentional, abrupt low-level maneuver.Dec 16, 2014 · N5989Z · Substantial damageNTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.Nov 30, 2014 · N7422W · Substantial damageNTSB 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.Nov 27, 2014 · N902LC · Substantial damageNTSB ERA15CA055Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter MD500 · Decatur, ALAn undetermined pilot's failure to maintain clearance from an electrical transmission tower resulting in substantial damage to a main rotor blade. Postaccident investigation could not determine which of two pilots was flying the helicopter at the time the…Nov 18, 2014 · N8371F · Substantial damageNTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.Nov 15, 2014 · N6466U · DestroyedNTSB CEN15LA042Accident · Minor injuriesLimited investigationFinal reportMosier Robert S Mosquito XET · Angleton, TXThe pilot’s failure to maintain adequate clearance from trees during a precautionary landing. Contributing to the accident was the pilot’s inadequate preflight inspection during which he failed to detect a loose drive belt, which resulted in an in-flight…Nov 8, 2014 · N922RM · Substantial damageNTSB CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…Oct 24, 2014 · N34WS · Substantial damageNTSB CEN15CA025Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Harper, TXThe pilot's failure to maintain clearance from trees while maneuvering.Oct 24, 2014 · N7192K · Substantial damageNTSB ERA15LA044Accident · Serious injuriesLimited investigationFinal reportItec Maverick · Dunnellon, FLA cell blowout in the fabric wing, which resulted in an asymmetrical loss of lift and a subsequent loss of aircraft control.Oct 21, 2014 · N356MV · DestroyedNTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.Oct 7, 2014 · N449DF · DestroyedNTSB CEN15LA004Accident · 2 fatalLimited investigationFinal reportCelier Xenon R · Loma, COThe pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.Oct 5, 2014 · N719MB · Substantial damageNTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.Oct 4, 2014 · N304AK · Substantial damageNTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.Oct 2, 2014 · N6044W · Substantial damageNTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…Sep 29, 2014 · N37E · Substantial damageNTSB ERA14CA453Accident · Minor injuriesData collectionFinal reportSchleicher ASK 21 · Wurtsboro, NYA loss of lift during the landing approach, which resulted in impact with terrain.Sep 20, 2014 · N421SL · Substantial damageNTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.Sep 19, 2014 · N531KG · DestroyedNTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.Sep 19, 2014 · N333TB · Substantial damageNTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.Sep 11, 2014 · N142MA · Substantial damageNTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…Sep 10, 2014 · N26105 · Substantial damageNTSB CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…Sep 10, 2014 · N711YM · DestroyedNTSB ERA14CA426Accident · Serious injuriesData collectionFinal reportSchleicher ASW 19B · Avoca, NYThe pilot's decision to attempt a return to his departure airport which resulted in the glider's encounter with atmospheric conditions where the lift was not sufficient to maintain flight and an off-airport landing.Sep 7, 2014 · N31GF · Substantial damageNTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.Sep 6, 2014 · N699TQ · Substantial damageNTSB WPR14FA362Accident · 1 fatalField investigationFinal reportCessna 177B · Neihart, MTThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude in turbulent conditions over mountainous terrain. Contributing to the accident was the pilot's improper decision to traverse the mountainous area with the airplane over…Sep 2, 2014 · N34880 · DestroyedNTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.Sep 1, 2014 · N8307R · Substantial damageNTSB WPR14LA356Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gardnerville, NVThe pilot’s failure to monitor the environment and to maintain clearance from wires during takeoff.Aug 27, 2014 · N4187W · Substantial damageNTSB ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.Aug 27, 2014 · N5850G · Substantial damageNTSB CEN14LA458Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe pilot’s failure to maintain airplane control during takeoff. Contributing to the severity of the accident was the pilot’s retraction of the landing gear before establishing a positive climb rate, which resulted in a gear-up landing.Aug 26, 2014 · N8176M · Substantial damageNTSB ANC14FA068Accident · Serious injuriesField investigationFinal reportRyan Navion A · Coldfoot, AKThe pilot’s improper inflight planning and improper decision to deliberately operate the airplane at low altitude in close proximity to obstructions and rising terrain. Contributing to the accident were the pilot’s improper preflight planning and the Federal…Aug 24, 2014 · N4827K · Substantial damageNTSB CEN14FA448Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Lago Vista, TXThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid the power lines.Aug 23, 2014 · N254AC · DestroyedNTSB ERA14FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Parsons, TNThe pilot’s failure to see and avoid trees during a low-level aerial application operation.Aug 20, 2014 · N802BB · Substantial damageNTSB WPR14FA349Accident · 1 fatalField investigationFinal reportBeech V35B · Novato, CAThe instrument-rated pilot's decision to conduct a visual approach to the airport in night, instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's loss of situational awareness, the…Aug 19, 2014 · N1160T · Substantial damageNTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.Aug 18, 2014 · N369GN · Substantial damageNTSB WPR14CA347Accident · No injuriesData collectionFinal reportEipper Formance Mxii · Salt Lake City, UTThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Aug 16, 2014 · N1624Z · Substantial damageNTSB CEN14LA480Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Hearne, TXThe pilot’s failure to maintain clearance from a crop.Aug 16, 2014 · N878C · Substantial damageNTSB CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.Aug 13, 2014 · N9071Z · Substantial damageNTSB CEN14CA426Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Lancaster, WIThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during an aerial application flight.Aug 13, 2014 · N8343P · Substantial damageNTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.Aug 12, 2014 · N7089J · Substantial damage