NTSB investigations, 2012

25 cases where NTSB found Rough terrain.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 442 cases
200857
200948
201039
201120
201225
201328
201434
201519
201615
201713
201819
201919
202017
202119
202218
202314
202415
202517
20266

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\", '03021015'))
  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 CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.Dec 11, 2012 · N512JA · Substantial damageNTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.Nov 10, 2012 · N933CW · Substantial damageNTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.Oct 20, 2012 · N337T · Substantial damageNTSB WPR12LA437Accident · No injuriesLimited investigationFinal reportMccleery Rans S6ES · Elverta, CAA loss of engine power during initial climb due to a failed piston ring.Sep 25, 2012 · N623LB · Substantial damageNTSB WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.Sep 9, 2012 · N5745Y · Substantial damageNTSB WPR12CA398Accident · No injuriesData collectionFinal reportLake John K MA-5 Charger · Eagle Mountain, UTThe airplane’s encounter with a large hole in the runway during the landing roll, which resulted in a loss of control and subsequent runway excursion.Sep 5, 2012 · N795MC · Substantial damageNTSB WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.Sep 4, 2012 · N308DF · Substantial damageNTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.Sep 4, 2012 · N6744J · Substantial damageNTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.Aug 28, 2012 · N4316Z · Substantial damageNTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.Aug 17, 2012 · N5127T · Substantial damageNTSB WPR12CA360Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Coolin, IDThe pilot’s failure to attain a touchdown point sufficient to stop the airplane within the length of the runway.Aug 15, 2012 · N9382P · Substantial damageNTSB CEN12LA524Accident · No injuriesLimited investigationFinal reportCessna 177B · Carthage, TXThe loss of engine power during a low-level aerial observation flight as the result of the wearing of the rocker arm tip due to a thin carburized case layer, which resulted in a forced landing.Aug 7, 2012 · N17201 · Substantial damageNTSB CEN12LA424Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Bedford, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to return home.Jul 8, 2012 · N8733V · Substantial damageNTSB ANC12CA059Accident · No injuriesData collectionFinal reportDosser Dale A Blade 582 · Two Rivers, AKThe total loss of engine power during cruise flight due to fouled spark plugs, which resulted from a stuck mixture control.Jun 20, 2012 · N907AD · Substantial damageNTSB ANC12CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Willow, AKThe pilot's decision to land on an unsuitable landing surface into bright sunlight, which resulted in a loss of control.Jun 16, 2012 · N1203A · Substantial damageNTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…Jun 10, 2012 · N744JS · Substantial damageNTSB WPR12CA251Accident · No injuriesData collectionFinal reportCessna 172S · Bend, ORThe pilot’s inadequate crosswind correction, which resulted in a loss of airplane control and runway excursion into a berm.Jun 9, 2012 · N698SP · Substantial damageNTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N2435K · Substantial damageNTSB CEN12LA309Accident · Minor injuriesLimited investigationFinal reportQuicksilver Sprint II · Lebanon, ILThe total loss of engine power due to a fatigue failure of the crankshaft, attributed to the relative movement between the crankshaft and flywheel assembly.May 19, 2012 · N3521A · Substantial damageNTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.May 8, 2012 · N28WF · Substantial damageNTSB WPR12LA190Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Elberta, UTA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 1, 2012 · N210LH · Substantial damageNTSB WPR12LA181Accident · No injuriesLimited investigationFinal reportCub Crafters CC11-100 · Monmouth, ORA partial loss of engine power during takeoff for undetermined reasons.Apr 22, 2012 · N499CC · Substantial damageNTSB WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.Apr 7, 2012 · N1183K · Substantial damageNTSB WPR12LA128Accident · No injuriesLimited investigationFinal reportBeech 76 · Rio Linda, CAA loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.Mar 11, 2012 · N6697L · Substantial damageNTSB WPR12LA125Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Makakilo City, HIA partial loss of engine power while maneuvering over rough/uneven terrain that was precipitated by the failure of a 3rd stage turbine blade as a result of high-cycle fatigue.Mar 3, 2012 · N101MZ · Substantial damage