NTSB investigations, 2011

20 cases where NTSB found Rough terrain.

Cases per year

20082026
NTSB investigations, 2011 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\") = 2011
    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 ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.Nov 26, 2011 · N5AW · Substantial damageNTSB CEN12LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Princeton, MNThe inadequate installation of the threaded insert in the No. 2 cylinder spark plug hole by maintenance personnel, which resulted in a loss of engine power during initial climb.Nov 22, 2011 · N6436P · Substantial damageNTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.Oct 12, 2011 · N52013 · Substantial damageNTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.Oct 12, 2011 · N64MG · Substantial damageNTSB ANC11CA106Accident · No injuriesData collectionFinal reportPiper PA-12 · Beluga, AKThe pilot's decision to take off uphill into rising terrain.Sep 23, 2011 · N78564 · Substantial damageNTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.Aug 17, 2011 · N388BA · Substantial damageNTSB WPR11CA342Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Preston, IDThe glider's impact with crops during the off-airport landing.Jul 21, 2011 · N78AB · Substantial damageNTSB WPR11CA486Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Brigham City, UTThe glider pilot did not take timely action to locate a safe outlanding area after entering an area where atmospheric lift was not sufficient to maintain soaring flight.Jul 19, 2011 · N797V · Substantial damageNTSB WPR11CA447Accident · No injuriesData collectionFinal reportCessna 120 · Pendleton, ORThe pilot's excessive brake application while landing on rough terrain.Jul 19, 2011 · N1705N · Substantial damageNTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.Jul 14, 2011 · N7709Z · Substantial damageNTSB WPR11LA320Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAHigh-cycle fatigue on the 1st-stage compressor blade retaining ring, which resulted in the ring’s fracture and a subsequent loss of engine power.Jul 9, 2011 · N7503L · Substantial damageNTSB CEN11LA429Accident · Minor injuriesLimited investigationFinal reportKeesler W8 Tailwind · Oshkosh, WIThe loss of engine power during initial climb for undetermined reasons.Jun 29, 2011 · N56PK · Substantial damageNTSB ANC11CA057Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK 1 · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff.Jun 27, 2011 · N561TA · Substantial damageNTSB ANC11CA051Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bethel, AKThe pilot's selection of an unsuitable off-airport landing site, resulting in a nose over during the landing roll.Jun 17, 2011 · N9314D · Substantial damageNTSB ANC11LA038Accident · No injuriesLimited investigationFinal reportCessna P206C · Wasilla, AKThe pilot's failure to maintain directional control during takeoff from an unpaved airstrip, resulting in a collision with trees.May 27, 2011 · N8665Z · Substantial damageNTSB ERA11LA307Accident · No injuriesLimited investigationFinal reportFlightstar Flightstar II · Grantville, GAA total loss of engine power while maneuvering due to a seized piston.May 22, 2011 · N194PG · Substantial damageNTSB WPR11LA140Accident · No injuriesLimited investigationFinal reportRearwin 8135 · Casa Grande, AZThe partial loss of engine power due to the separation of an exhaust valve rocker box as a result of the failure of the rocker box attaching studs.Feb 18, 2011 · NC25545 · Substantial damageNTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.Feb 15, 2011 · N2561L · Substantial damageNTSB WPR11FA114Accident · 1 fatalField investigationFinal reportMooney M20J · Furnace Creek, CAThe magneto clamps were not securely fastened to the mount, which led to a partial loss of engine power and a subsequent forced landing on unsuitable terrain.Jan 29, 2011 · N50BJ · Substantial damageNTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.Jan 2, 2011 · N6774B · Substantial damage