NTSB investigations, 2011

6 cases where NTSB found Fog.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 78 cases
200811
20097
20106
20116
20129
20139
20143
20152
20163
20175
20181
20194
20203
20214
20233
20242

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\", '03035055'))
  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 CEN12LA109Accident · 1 fatalLimited investigationFinal reportCessna 172R · Denton, TXThe pilot's controlled flight into terrain while maneuvering at a low altitude in instrument meteorological conditions. Contributing to the accident was the pilot's decision to perform a circling maneuver in weather below circling minimums instead of flying…Dec 20, 2011 · N987BT · Substantial damageNTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.Dec 4, 2011 · N33315 · Substantial damageNTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 8, 2011 · N2286P · Substantial damageNTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.Jul 26, 2011 · N8525L · Substantial damageNTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.Jul 9, 2011 · N42333 · Substantial damageNTSB CEN11LA223Accident · No injuriesLimited investigationFinal reportLearjet 25 · Houston, TXThe flying pilot's failure to attain the proper touchdown point in low-visibility conditions, which resulted in a runway overrun. Contributing to the accident was mission pressure to land at that airport.Mar 4, 2011 · XA-TWH · Substantial damage