NTSB investigations, 2011

6 cases where NTSB found Ground vehicle.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 132 cases
200812
20097
201011
20116
20126
20136
201411
201511
20168
201711
201813
20198
20204
20216
20224
20232
20242
20253
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\", '03022025'))
  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 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 CEN11FA663Accident · 1 fatalField investigationFinal reportThorp T-18 · Plainwell, MIThe pilot did not maintain clearance from a semitrailer along the approach path.Sep 23, 2011 · N54WB · Substantial damageNTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.Aug 14, 2011 · N216AF · Substantial damageNTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.Jul 2, 2011 · N1953Z · Substantial damageNTSB WPR11LA179Accident · Serious injuriesLimited investigationFinal reportEagle DW1 · Newman, CAThe pilot’s inadequate visual lookout and failure to maintain clearance from a vehicle during a low-altitude operation.Apr 1, 2011 · N8812A · Substantial damageNTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…Mar 10, 2011 · N930FE · Substantial damage