Fatal NTSB investigations

278 cases where the sequence of events included Low altitude operation/event.

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '220' 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.

NTSB WPR15FA195Accident · 1 fatalField investigationFinal reportShort Brothers S312 Tucano T MK1 · Maricopa, CAThe pilot's failure to maintain clearance from terrain during low-level airwork, which resulted in uncontrolled collision with terrain. Contributing to the accident was the pilot's impairment from the combined effects of butalbital and codeine.Jun 22, 2015 · N206PZ · DestroyedNTSB ERA15WA246Accident · 1 fatalForeign investigationPiper PA-25-235 · Patrocínio Municipality,Minas Gerais, BrazilOn June 5, 2015, about 1506 universal coordinated time, Piper PA-25-235, Brazilian registration PR-ACH, was substantially damaged by collision with terrain while maneuvering at low altitude in Patrocinio Municipality, Minas Gerais, Brazil. The Brazilian…Jun 5, 2015 · PR-ACH · Substantial damageNTSB ERA15WA235Accident · 1 fatalForeign investigationCessna A188 · Puerto Gaitan, ColombiaOn June 4, 2015, about 1715 coordinated universal time, a Cessna A188, Colombian registration HK-1364, was substantially damaged when it impacted power lines and then terrain during an aerial application flight near Puerto Gaitan, Colombia. The commercial…Jun 4, 2015 · HK-1364 · Substantial damageNTSB ANC15FA032Accident · 1 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…May 30, 2015 · N1653U · Substantial damageNTSB WPR15FA161Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Juntura, ORThe pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.May 14, 2015 · N5042P · Substantial damageNTSB ERA15WA213Accident · 2 fatalForeign investigationCessna 182 · Bajo Hondo, ArgentinaOn May 13, 2015, about 1835 coordinated universal time (UTC), a Cessna 182, Argentine registration LV-CXM, impacted power lines while maneuvering during an aerial survey flight near Bajo Hondo, Argentina. The pilot and passenger were fatally injured, and the…May 13, 2015 · LV-CXM · DestroyedNTSB 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 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 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 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 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 damageNTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…Aug 9, 2014 · N3509M · Substantial damageNTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.Jun 9, 2014 · N9454L · DestroyedNTSB WPR14LA230Accident · 1 fatalLimited investigationFinal reportCessna 172M · Laytonville, CAThe pilot’s impairment due to alcohol ingestion, which resulted in his failure to maintain clearance from trees during a low-altitude flyby.Jun 6, 2014 · N1186U · Substantial damageNTSB CEN14WA254Accident · 1 fatalForeign investigationAir Tractor AT802 · Seron, SpainOn May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal…May 26, 2014 · EC-LCA · DestroyedNTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.May 23, 2014 · N4081H · Substantial damageNTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…May 4, 2014 · N68828 · DestroyedNTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.Apr 22, 2014 · N51990 · Substantial damageNTSB CEN14FA122Accident · 3 fatalField investigationFinal reportBell 206L 3 · Silt, COThe pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…Jan 27, 2014 · N207DS · DestroyedNTSB ERA14LA011Accident · 1 fatalLimited investigationFinal reportBoeing B75N1 · Tampa, FLThe parachutist’s low altitude departure from the right wing before the planned altitude and his delayed opening of his parachute canopy, which resulted in impact with a tree and then the ground before the parachute fully opened.Oct 19, 2013 · N65355 · No damageNTSB WPR14LA005Accident · 4 fatalLimited investigationFinal reportCessna 340A · Paulden, AZThe pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.Oct 4, 2013 · N312GC · Substantial damageNTSB WPR13LA420Accident · 1 fatalLimited investigationFinal reportMiller RV6 · Williams, CAThe pilot's improper decision to fly at a low altitude, which resulted in his failure to maintain clearance from power lines.Sep 24, 2013 · N67GM · DestroyedNTSB CEN13FA517Accident · 3 fatalField investigationFinal reportRobinson R44 II · Caballo, NMThe pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.Aug 31, 2013 · N3156U · Substantial damageNTSB CEN13LA461Accident · 2 fatalLimited investigationFinal reportHughes 369D · Ackerly, TXThe pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.Aug 5, 2013 · N8688F · No damageNTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.Aug 3, 2013 · N225CD · DestroyedNTSB ERA13FA340Accident · 1 fatalField investigationFinal reportFolland Gnat T 1 · Georgetown, SCThe loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…Jul 29, 2013 · N18GT · DestroyedNTSB CEN13LA377Accident · 1 fatalLimited investigationFinal reportDankelman Peter G RV-7A · Marion, TXThe pilot’s sudden incapacitation and natural death as a result of cardiovascular disease.Jun 28, 2013 · N445RV · DestroyedNTSB WPR13LA283Accident · 1 fatalLimited investigationFinal reportExtra 300/LT · Adrian, ORThe pilot's improper decision to conduct low-level maneuvering in a river canyon with power lines, which resulted in his failure to maintain clearance from the power lines.Jun 23, 2013 · N169TM · Substantial damageNTSB CEN13LA368Accident · 2 fatalLimited investigationFinal reportNanchang China CJ-6 · Wolcott, COThe pilots decision to perform an aerobatic maneuver at a low altitude from which he was unable to recover.Jun 23, 2013 · N2726C · Substantial damageNTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 8, 2013 · N7147R · Substantial damageNTSB WPR13FA244Accident · 2 fatalField investigationFinal reportRaytheon A36 · Mountainaire, AZThe pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…May 28, 2013 · N999PK · DestroyedNTSB CEN13FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Lamar, MOThe pilot's in-flight loss of control, which was likely due to a sudden cardiac event.May 5, 2013 · N82509 · Substantial damageNTSB CEN13FA241Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Norfolk, NEThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid power lines.Apr 28, 2013 · N3970T · Substantial damageNTSB WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.Feb 18, 2013 · N20620 · Substantial damageNTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.Jan 19, 2013 · N2341N · Substantial damageNTSB CEN13FA089Accident · 1 fatalField investigationFinal reportBeech 58 · Manhattan, ILAn in-flight loss of control and impact with terrain for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Dec 4, 2012 · N4016A · Substantial damageNTSB CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.Dec 1, 2012 · N3755Z · Substantial damageNTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…Nov 18, 2012 · N4267R · Substantial damageNTSB ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.Nov 15, 2012 · N369AW · Substantial damageNTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.Nov 4, 2012 · N368PD · Substantial damageNTSB ERA13WA030Accident · 1 fatalForeign investigationPiper PA25 · Juquiá Municipality, BrazilOn October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…Oct 3, 2012 · PT-DOX · DestroyedNTSB WPR12FA420Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Strawberry, AZThe flight instructor's and the evaluator's failure to divert at an appropriate time during cruise flight, which resulted in the airplane's inability to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was the flight…Sep 13, 2012 · N4188E · Substantial damageNTSB CEN12LA615Accident · 1 fatalLimited investigationFinal reportGoodyear F2G · Valley City, NDThe pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.Sep 7, 2012 · N5577N · Substantial damageNTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.Aug 24, 2012 · N1674A · Substantial damageNTSB CEN12LA440Accident · 1 fatalLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Darksville, MOThe pilot did not maintain clearance from a tree line at the completion of an agricultural spray run.Jul 13, 2012 · N6846Q · Substantial damageNTSB WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…Jun 30, 2012 · N729DP · Substantial damageNTSB WPR12LA259Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · East Wenatchee, WAThe pilot’s failure to adequately monitor the environment and maintain clearance from the power lines while maneuvering at low altitude.Jun 12, 2012 · N282MC · Substantial damageNTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…Jun 3, 2012 · N14447 · Substantial damageNTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.May 21, 2012 · N360MW · Substantial damage