NTSB investigations, 2011
11 cases where NTSB found Management.
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 11 |
| 2012 | 22 |
| 2013 | 11 |
| 2014 | 23 |
| 2015 | 11 |
| 2016 | 6 |
| 2017 | 10 |
| 2018 | 12 |
| 2019 | 8 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 8 |
| 2023 | 5 |
| 2024 | 13 |
| 2025 | 3 |
| 2026 | 2 |
Where
Open the mapLatest 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\", '0402'))
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.
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", '0402')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…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…NTSB ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…NTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…NTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…NTSB CEN11LA368Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe flight instructor’s failure to maintain clearance from the propeller when exiting the airplane. Contributing to the accident were the instructor’s decision not to shut down the engine before exiting the airplane and the operator’s lack of a policy…NTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…NTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB OPS11IA401Incident · No injuriesIncident investigationFinal reportArlington, VAThe tower controller's loss of consciousness induced by lack of sleep, fatigue resulting from working successive midnight shifts, and air traffic control scheduling practices.