NTSB investigations, CA
10 cases where NTSB found Policy/procedure.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040210'))
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040210')) 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 GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…NTSB DCA17IA148Incident · No injuriesClass 1 · IncidentFinal reportAirbus A320-211 · San Francisco, CAThe flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…NTSB WPR15LA025Accident · No injuriesLimited investigationFinal reportCessna 172S · Santa Monica, CAThe separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.NTSB WPR14TA149Accident · No injuriesFinal reportBell OH-58A · Tehachapi, CAThe pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB OPS10IA020Incident · No injuriesIncident investigationFinal reportBoeing 777-222 · San Francisco, CAThe local controller's issuance of a takeoff clearance to the Boeing 777 without ensuring that approved separation would exist with the Cessna 182. Contributing to the incident were tower procedures that permitted transitioning aircraft to cross the runway 28…NTSB DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…NTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…