NTSB investigations, 2010

7 cases where NTSB found Glare.

Cases per year

20082026
NTSB investigations, 2010 per year, 2008–2026: 109 cases
20088
20099
20107
20118
20126
20135
20146
20155
20167
20177
20186
20195
20205
20213
20229
20231
20246
20255
20261

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03036030'))
  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 WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.Dec 13, 2010 · N36041 · Substantial damageNTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N6030U · Substantial damageNTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.Jul 23, 2010 · N6139M · Substantial damageNTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.Jun 30, 2010 · N2990P · Substantial damageNTSB ERA10CA309Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Alcolu, SCThe pilot’s failure to maintain clearance from a tree. Contributing to the accident was the sunglare.Jun 10, 2010 · N5085Q · 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 WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.Mar 13, 2010 · N5392E · Substantial damage