NTSB investigations, 2015, CA
19 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 33 |
| 2010 | 25 |
| 2011 | 24 |
| 2012 | 17 |
| 2013 | 23 |
| 2014 | 24 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 27 |
| 2018 | 22 |
| 2019 | 13 |
| 2020 | 17 |
| 2021 | 18 |
| 2022 | 21 |
| 2023 | 13 |
| 2024 | 9 |
| 2025 | 8 |
| 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\") = 2015
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\" = '240' 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") = 2015 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" = '240' 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 WPR16FA042Accident · 1 fatalField investigationFinal reportPiper PA32R · Castro Valley, CAThe pilot's loss of control due to spatial disorientation while maneuvering during an instrument approach in instrument meteorological conditions.NTSB WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…NTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…NTSB WPR16FA029Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350B3E · Carlsbad, CAThe pilot's loss of control during landing on a dolly. Contributing to the accident were the pilot's decision to conduct the flight without an instructor despite multiple flight instructors' recommendations to the contrary, his failure to land on the ramp…NTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…NTSB WPR16FA014Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Morongo Valley, CAThe non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and…NTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…NTSB GAA16CA002Accident · No injuriesData collectionFinal reportCessna 172 · Avalon, CAThe pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.NTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.NTSB WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.NTSB WPR15FA200Accident · 1 fatalField investigationFinal reportManiscalco Great Lakes · Corona, CAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while maneuvering, which resulted in a stall/spin at too low an altitude to allow recovery. Contributing to the accident was the pilot's improper…NTSB WPR15LA193Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Salinas, CAThe non-instrument-rated pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control. Contributing to the accident was the pilot's impairment by high-dose opioid use.NTSB WPR15LA176Accident · 1 fatalLimited investigationFinal reportAyres S2R T34 · Blythe, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.NTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.NTSB WPR15FA088Accident · 2 fatalField investigationFinal reportBeech 36 · Mountain Pass, CAAn in-flight loss of control for reasons that could not be determined based on available information.NTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…