NTSB investigations, 2012

6 cases where NTSB found Ground vehicle.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 132 cases
200812
20097
201011
20116
20126
20136
201411
201511
20168
201711
201813
20198
20204
20216
20224
20232
20242
20253
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\") = 2012
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022025'))
  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 CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…Nov 3, 2012 · N985GE · Substantial damageNTSB CEN13LA004Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIAn obstruction (a sleeve of cups) that lodged under the catering truck brake pedal, which prevented the driver from stopping the truck before it struck the parked airplane.Oct 5, 2012 · N894AT · Substantial damageNTSB WPR12LA443Accident · No injuriesLimited investigationFinal reportBeech V35A · Torrance, CAThe pilot's failure to maintain directional control during taxi, which resulted in a collision with a parked vehicle.Sep 28, 2012 · N6278V · Substantial damageNTSB CEN12LA443Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Red Oak, IAThe pilot's failure to maintain clearance from the ground-support vehicle during landing.Jul 14, 2012 · N556MM · Substantial damageNTSB ANC12CA054Accident · No injuriesData collectionFinal reportCessna 172 · Skwentna, AKThe improper decision of the driver of the all-terrain vehicle to enter an active runway.Jun 16, 2012 · N5874A · Substantial damageNTSB CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.May 7, 2012 · N5016P · Substantial damage