NTSB investigations, 2011

13 cases where NTSB found Object/animal/substance, general.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 224 cases
200815
20099
201013
201113
20125
20135
201412
201522
201628
201728
201833
201926
20206
20213
20222
20233
20251

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\", '03022000'))
  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 ANC12CA015Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Hughes, AKThe pilot did not clear the area surrounding the airplane prior to taxi, resulting in the airplane contacting a piece of baggage.Dec 15, 2011 · N9FW · Substantial damageNTSB WPR12LA036Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodburn, ORThe pilot’s failure to maintain ground clearance while maneuvering with an external load line.Nov 14, 2011 · N16HA · Substantial damageNTSB ERA12CA022Accident · No injuriesData collectionFinal reportAeronca 0-58A · Westmoreland, TNThe pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.Oct 9, 2011 · N46513 · Substantial damageNTSB ANC11CA111Accident · No injuriesData collectionFinal reportCessna 180H · Chenga Bay, AKThe pilot's failure to maintain clearance from an obstruction while landing at an off-airport site, resulting in a loss of control.Sep 27, 2011 · N9083M · Substantial damageNTSB ERA11CA487Accident · Serious injuriesData collectionFinal reportKaribian Hurant Thorp T-18 · Panama City, FLThe pilot's selection of an unsuitable landing site, which resulted in a collision with a culvert.Sep 10, 2011 · N407HK · Substantial damageNTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2011 · N3135J · Substantial damageNTSB CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.Jul 31, 2011 · N5647F · Substantial damageNTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.Jul 1, 2011 · N56417 · Substantial damageNTSB WPR11LA266Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mount Pleasant, UTThe pilot’s failure to determine the airplane’s fuel quantity before takeoff, which resulted in a loss of engine power due to fuel exhaustion.Jun 18, 2011 · N65654 · Substantial damageNTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…Jun 18, 2011 · N6991Q · Substantial damageNTSB CEN11LA328Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fredenberg Township, MNThe pilot's inadequate directional control during a crosswind landing.May 7, 2011 · N195T · Substantial damageNTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.Mar 31, 2011 · N7302A · Substantial damageNTSB CEN11CA232Accident · No injuriesData collectionFinal reportBell 230 · Gulf of Mexico, LAThe pilot's failure to maintain adequate clearance from the safety skirting during the repositioning landing.Mar 17, 2011 · N974RH · Substantial damage