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 WPR12WA199Accident · 1 fatalForeign investigationAyres S2R · Moree, Australia, AustraliaOn April 10, 2012, at 2300 universal coordinated time, an Ayres Turbo Thrush S-2R, VH-WDD, collided with the terrain near Moree, Australia, while conducting agricultural operations. The airplane was operated by Alexander Aviation PTY LTD under the pertinent…Apr 10, 2012 · VH-WDD · Substantial damageNTSB CEN12LA227Accident · 1 fatalLimited investigationFinal reportGrumman F8F-1 · Breckenridge, TXThe pilot's loss of airplane control during a low-altitude aerobatic maneuver.Apr 4, 2012 · N14HP · Substantial damageNTSB ERA12WA223Accident · 1 fatalClass 5 · ForeignCessna 188 · Querencia do Norte, BrazilOn March 02, 2012, about 1350 universal coordinated time, a Cessna 188B, Brazilian registration PR-STO, was substantially damaged when it collided with power lines during a crop dusting flight, near Querencia do Norte, Brazil. The foreign certificated pilot…Mar 2, 2012 · PR-STO · Substantial damageNTSB CEN12FA158Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Osborn, MOThe pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.Feb 14, 2012 · N4824L · Substantial damageNTSB WPR12LA093Accident · 1 fatalLimited investigationFinal reportCessna 172N · Fresno, CAThe non-certificated pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s impairment due to performance-impairing drugs.Feb 6, 2012 · N7582D · Substantial damageNTSB CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.Dec 22, 2011 · N161PC · Substantial damageNTSB WPR12FA062Accident · 1 fatalField investigationFinal reportCrosley Vans RV-8 · Armistead, CAThe pilot’s failure to maintain clearance from terrain while performing low altitude aerobatic maneuvers.Dec 10, 2011 · N948RC · Substantial damageNTSB ERA12FA068Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Boynton Beach, FLThe right seat pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane.Nov 13, 2011 · N661FT · Substantial damageNTSB ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Oct 5, 2011 · N11HU · Substantial damageNTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.Aug 20, 2011 · N2BJ · Substantial damageNTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.Aug 20, 2011 · N7051Z · Substantial damageNTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.Jul 9, 2011 · N42333 · Substantial damageNTSB WPR11FA304Accident · 2 fatalField investigationFinal reportCessna 180D · Santa Paula, CAThe pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.Jul 4, 2011 · N6451X · Substantial damageNTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.Jul 3, 2011 · N4473N · Substantial damageNTSB CEN11FA437Accident · 3 fatalField investigationFinal reportAmerican Champion 7GCBC · Hayti, SDThe pilot's decision to attempt low-altitude flight and his failure to maintain adequate clearance from power lines.Jul 3, 2011 · N711AT · Substantial damageNTSB CEN11FA420Accident · 1 fatalField investigationFinal reportLuscombe 8A · Farmdale, OHThe pilot's decision to initiate an aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.Jun 26, 2011 · N71687 · Substantial damageNTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.May 14, 2011 · N282SC · Substantial damageNTSB CEN11FA337Accident · 1 fatalField investigationFinal reportBell OH-58C · New Athens, ILThe pilot’s failure to attain sufficient altitude to clear terrain while maneuvering.May 12, 2011 · N9263Y · Substantial damageNTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.Apr 10, 2011 · N286BA · Substantial damageNTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.Mar 20, 2011 · N99AE · Substantial damageNTSB WPR11LA133Accident · 1 fatalLimited investigationFinal reportBuckeye Breeze LX · Bullfrog, UTThe pilot’s loss of control while maneuvering to land at an off-airport site.Feb 13, 2011 · N75752 · Substantial damageNTSB WPR11LA094Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Oakley, CAAn in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…Jan 10, 2011 · N4977X · Substantial damageNTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.Nov 3, 2010 · N8533F · Substantial damageNTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.Oct 23, 2010 · N2XZ · Substantial damageNTSB WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.Oct 8, 2010 · N8437A · Substantial damageNTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportAug 17, 2010 · N540WC · DestroyedNTSB WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.Aug 13, 2010 · N3463Q · Substantial damageNTSB ERA10LA348Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Marion, KYThe pilot's failure to maintain clearance from power lines during an aerial application flight.Jul 5, 2010 · N857PM · Substantial damageNTSB ANC10LA053Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Unalaska, AKThe pilot's inappropriate low altitude maneuvering, which resulted in a collision with terrain.Jun 20, 2010 · N333DV · Substantial damageNTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.Jun 7, 2010 · N4184P · Substantial damageNTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.May 16, 2010 · N241WD · Substantial damageNTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…May 15, 2010 · N6868Y · Substantial damageNTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.May 14, 2010 · N1123 · Substantial damageNTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.May 6, 2010 · N756WN · Substantial damageNTSB CEN10LA184Accident · 1 fatalLimited investigationFinal reportStutesman Charles Lee RV-6 · Balmorhea, TXThe pilot's failure to maintain clearance from the lake while maneuvering at low altitude.Apr 4, 2010 · N4024K · Substantial damageNTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.Mar 17, 2010 · N75AG · Substantial damageNTSB WPR10FA131Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Redlands, CAThe pilot's failure to maintain aircraft control and altitude sufficient to recover from a low-level aerobatic maneuver.Feb 8, 2010 · N52VY · Substantial damageNTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.Nov 8, 2009 · N6644 · DestroyedNTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.Oct 22, 2009 · N120MS · Substantial damageNTSB ANC10FA004Accident · 1 fatalField investigationFinal reportCessna A185E · Healy, AKThe pilot's decision to maneuver at a low altitude over rising terrain in conditions conducive to turbulence/downdrafts, resulting in a loss of control and impact with terrain.Oct 14, 2009 · N2764J · Substantial damageNTSB WPR10FA012Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Fossil, ORThe pilot's failure to maintain clearance from a power pole to which he was connecting wire-pulling ropes.Oct 12, 2009 · N527SH · Substantial damageNTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.Aug 16, 2009 · N98AW · Substantial damageNTSB ERA09LA450Accident · 2 fatalLimited investigationFinal reportStump Bradley Kolb · Calhoun, TNThe pilot’s decision to perform aerobatics at a low altitude and his failure to maintain control of the airplane while performing aerobatics.Aug 8, 2009 · N2456 · Substantial damageNTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.Jul 17, 2009 · N974BW · DestroyedNTSB ERA09LA398Accident · 2 fatalLimited investigationFinal reportBarber John A Glasair · Switzerland, FLA loss of control in flight for undetermined reasons. Contributing to the accident was the pilot's performance of aerobatic maneuvers at altitudes lower than those recommended by the kit manufacturer, resulting in insufficient terrain clearance to conduct a…Jul 11, 2009 · N132JB · DestroyedNTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.Jul 8, 2009 · N7314S · Substantial damageNTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.Jul 4, 2009 · N97869 · Substantial damageNTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.Jul 3, 2009 · N8138B · Substantial damageNTSB CEN09LA355Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Cordova, ILThe pilot’s failure to maintain clearance with terrain after clearing an obstacle during an agricultural application pass.Jun 12, 2009 · N1734S · DestroyedNTSB WPR09FA284Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Morristown, AZThe pilot's failure to maintain clearance from the power line.Jun 11, 2009 · N149SH · Substantial damage