NTSB investigations, 2011

10 cases where NTSB found Pole.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 142 cases
200812
20099
20105
201110
20126
20135
20148
20158
201613
20178
201818
201911
20206
20219
20222
20234
20243
20254
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\") = 2011
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022010'))
  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 WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.Nov 18, 2011 · N741SB · Substantial damageNTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.Nov 12, 2011 · N3606C · Substantial damageNTSB CEN12FA025Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Watertown, WIThe separation of the number 2 connecting rod from the crankshaft for reasons that could not be determined during postaccident metallurgical examination, which ultimately resulted in a total loss of engine power.Oct 17, 2011 · N300KR · Substantial damageNTSB WPR11CA398Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Los Banos, CAThe pilot's failure to maintain clearance from the power poles while maneuvering during low-altitude operations.Aug 21, 2011 · N948DS · Substantial damageNTSB WPR11CA339Accident · No injuriesData collectionFinal reportBell 47G-5 · Watsonville, CAThe pilot's failure to maintain clearance from a pole while maneuvering during an aerial application flight.Jul 20, 2011 · N1375X · Substantial damageNTSB WPR11FA304Accident · 2 fatalField investigationFinal reportCessna 180D · Santa Paula, CAThe pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.Jul 4, 2011 · N6451X · Substantial damageNTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.Jun 19, 2011 · N12477 · Substantial damageNTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.Feb 5, 2011 · N6725K · Substantial damageNTSB WPR11LA096Accident · 1 fatalLimited investigationFinal reportRyan Aeronautical ST3KR · Warner Springs, CAThe pilot's failure to maintain clearance from the wind sock pole during landing.Jan 11, 2011 · N57027 · Substantial damageNTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.Jan 4, 2011 · N443PA · Substantial damage