NTSB investigations, 2017, CA
18 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 8 |
| 2017 | 18 |
| 2018 | 14 |
| 2019 | 10 |
| 2020 | 9 |
| 2021 | 1 |
| 2022 | 6 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 9 |
| 2026 | 4 |
Where
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\") = 2017
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2017 AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR18LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Truckee, CAThe flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.NTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB WPR17LA211Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Long Beach, CAThe student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…NTSB GAA17CA514Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Sacramento, CAThe student pilot’s failure to maintain yaw control and the flight instructor’s delayed remedial action.NTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.NTSB WPR17LA140Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Bella Vista, CAA partial loss of engine power during low-altitude maneuvering for reasons that could not be determined because postaccident examinations of the engine and airframe revealed no evidence of any preaccident mechanical malfunctions or failures that would have…NTSB GAA17CA379Accident · No injuriesData collectionFinal reportAmerican General Acft AG5 · Rio Vista, CAThe student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.NTSB GAA17CA364Accident · No injuriesData collectionFinal reportCessna 305 · Ukiah, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…NTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.NTSB GAA17CA222Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Avalon, CAThe pilot’s failure to maintain the runway heading and the improper landing flare during landing.NTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.NTSB WPR17LA067Accident · Minor injuriesLimited investigationFinal reportGuarino Vans · Marysville, CAA partial loss of engine power for reasons that could not be determined due to the fragmentation of the electrical system.NTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.NTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.