Fatal NTSB investigations, 2010

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

Cases per year

20082026
Fatal NTSB investigations, 2010 per year, 2008–2026: 278 cases
200823
200918
201015
201117
201219
201316
201413
201515
201615
201723
201815
201919
202011
202112
202210
202315
20249
20258
20265

Latest cases

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\") = 2010
    AND 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 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 damage