NTSB investigations, 2012

24 cases where NTSB found Monitoring environment.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 810 cases
200829
200960
201027
201128
201224
201335
201447
201545
201645
201757
201862
201962
202052
202152
202237
202338
202445
202548
202617

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\", '02021545'))
  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 CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.Dec 25, 2012 · N489AE · Substantial damageNTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…Nov 21, 2012 · N40781 · Substantial damageNTSB WPR13IA020Incident · No injuriesIncident investigationFinal reportAgusta A119 · Dolan Springs, AZInsufficient clearance between a truck and the main rotor blades of a helicopter on the ground with the engine running because of the lack of on-scene coordination between the agencies that responded to and were tasked with managing the vehicle accident site.Oct 20, 2012 · N207CF · Minor damageNTSB ERA13CA033Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Newton, GAThe pilot’s failure to maintain clearance from power lines while maneuvering, which resulted in a hard forced landing.Oct 20, 2012 · N502PB · Substantial damageNTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.Oct 10, 2012 · N333DR · Substantial damageNTSB ERA12CA580Accident · No injuriesData collectionFinal reportSikorsky S-76C · Theodore, ALThe pilot's failure to maintain adequate obstacle clearance while taxiing.Sep 24, 2012 · N781P · Substantial damageNTSB WPR12LA428Accident · Minor injuriesLimited investigationFinal reportRockwell International 690A · Ellensburg, WAThe pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.Sep 16, 2012 · N57112 · Substantial damageNTSB ERA12LA562Accident · 1 fatalLimited investigationFinal reportRepublic RC-3 · Cedar Bluff, ALThe pilot's failure to see and avoid power lines during final approach to landing.Sep 15, 2012 · N6072K · Substantial damageNTSB WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.Sep 1, 2012 · N611CK · Substantial damageNTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.Aug 17, 2012 · N6006J · Substantial damageNTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.Aug 15, 2012 · N167MB · Substantial damageNTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.Aug 15, 2012 · N36289 · Substantial damageNTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.Aug 14, 2012 · N1021D · Substantial damageNTSB ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.Aug 2, 2012 · N6802L · 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 ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.Jun 24, 2012 · N9542V · 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 WPR12CA260Accident · No injuriesData collectionFinal reportCessna 172P · Hemet, CAThe student pilot's failure to monitor and maintain clearance from an obstacle during taxi.May 28, 2012 · N216AF · Substantial damageNTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.May 24, 2012 · N8468V · Substantial damageNTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.May 14, 2012 · N9027M · Substantial damageNTSB WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…May 12, 2012 · N4861E · Substantial damageNTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.Apr 25, 2012 · N969W · Substantial damageNTSB WPR12CA179Accident · Minor injuriesData collectionFinal reportCessna 182J · Delle, UTThe pilot’s failure to properly monitor the environment during the departure from a gravel parking area and runway, which resulted in the airplane’s collision with a mound of gravel.Apr 22, 2012 · N2701F · Substantial damageNTSB WPR12CA173Accident · No injuriesData collectionFinal reportLindstrand LBL180A · Temecula, CAThe pilot failed to see and avoid a set of power lines while maneuvering to a landing site.Feb 17, 2012 · N49CD · Substantial damage