NTSB investigations, 2011

5 cases where NTSB found Oil.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 174 cases
200810
200911
20108
20115
201218
20136
201414
201513
201611
201715
201810
201914
20209
20218
20228
20237
20247

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\", '01071020'))
  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 CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.Dec 8, 2011 · N5813 · Substantial damageNTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.Sep 2, 2011 · N205PJ · Substantial damageNTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…Jul 23, 2011 · N122HB · 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 WPR11LA187Accident · No injuriesLimited investigationFinal reportZenith 701 · El Centro, CAA partial loss of engine power during the initial climb after takeoff due to oil starvation because of the failure of the No. 2 oil pump drive coupling.Apr 6, 2011 · N128CF · Substantial damage