NTSB investigations, 2011

6 cases where NTSB found Misc hardware.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 140 cases
200812
20099
20106
20116
201210
20139
20144
20155
201610
201711
20187
20198
20207
20219
20225
20236
202410
20252
20264

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\", '010714'))
  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 DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…Dec 8, 2011 · N37SH · DestroyedNTSB ERA11LA469Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 180A · Lewiston, METhe separation of the inflation tank gas line due to an improperly positioned valve o-ring. Contributing to the accident was the use of an unapproved inflation tank.Aug 20, 2011 · N75213 · No damageNTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.Jul 5, 2011 · N5175D · Substantial damageNTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.Jun 12, 2011 · N189SB · Substantial damageNTSB ANC11CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Sterling, AKThe airplane owner improper fabrication of a fuel line, and subsequent inadequate inspection by an aviation mechanic, resulting in a loss of engine power.Feb 23, 2011 · N623MP · Substantial damageNTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.Feb 15, 2011 · N2561L · Substantial damage