NTSB investigations, CA
46 cases where NTSB found Aircraft capability.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 1 |
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 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\", '010610'))
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", '010610')) 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 WPR25LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Auburn, CAThe pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.NTSB WPR24LA214Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CAThe pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.NTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.NTSB ANC24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Huasna, CAThe pilot’s failure to maintain adequate airspeed during a low altitude maneuver, resulting in a loss of control.NTSB WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.NTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR22LA090Accident · Minor injuriesClass 3 · LimitedFinal reportTextron TTX Inc. T240 · Ravendale, CAThe inadequate maintenance and inspection of the engine induction system, which resulted in the separation of the right induction tube from the turbocharger compressor outlet and the subsequent loss of engine power during departure.NTSB WPR21FA232Accident · 1 fatalClass 3 · FieldFinal reportKitfox Series 6 · Likely, CAThe pilot’s poor decision making in attempting a takeoff from a field with high vegetation and a high-density altitude, which resulted in decreased takeoff performance and impact with terrain.NTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…NTSB WPR20LA289Accident · 2 fatalClass 3 · LimitedFinal reportBeech A36 · Redding, CAThe pilot’s failure to recognize the airplane’s inadequate takeoff performance given the length of the available runway and to abort the takeoff, which resulted in a runway excursion.NTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.NTSB GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.NTSB WPR18FA237Accident · 2 fatalClass 3 · FieldFinal reportChampion 7KCAB · Descanso, CAThe pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…NTSB WPR18LA205Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · San Diego/El Cajon, CAThe pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.NTSB WPR18FA077Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Newport Beach, CAThe pilot's failure to perform weight and balance calculations before departing on the flight, which resulted in his operation of the helicopter outside of its published weight and balance limitations and a subsequent loss of control shortly after takeoff.NTSB WPR18LA069Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Skyforest, CAThe pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.NTSB WPR17FA066Accident · 4 fatalField investigationFinal reportCessna T310Q · Riverside, CAThe pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…NTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.NTSB WPR17LA043Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mt. Baldy, CAThe pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…NTSB WPR16LA150Accident · No injuriesLimited investigationFinal reportBeech 65 A90 · Byron, CAThe pilot’s failure to maintain an adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Also causal to the accident was the pilot’s failure to follow prescribed spin…NTSB WPR16FA124Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 1B · Hawthorne, CAThe failure of both pilots to land the airplane on the remaining runway when a sufficient rate of climb could not be attained. Contributing to the accident was a reduction of available engine power due to severe camshaft lobe wear.NTSB WPR16FA067Accident · 2 fatalField investigationFinal reportFlight Design Ctls · Springville, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…NTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.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 GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.NTSB WPR15LA226Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 12-m · Selma, CAThe pilot receiving instruction's use of an excessive pitch attitude during takeoff with the airplane near its maximum gross weight in hot and humid conditions, which degraded the airplane’s climb performance and resulted in a collision with obstacles during…NTSB WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.NTSB WPR14LA257Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Agua Dulce, CAThe pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.NTSB WPR12LA321Accident · No injuriesLimited investigationFinal reportLoflin RV-7A · Novato, CAThe partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s failure to…NTSB WPR12FA203Accident · 1 fatalField investigationFinal reportM Squared Breese · Whitewater, CAThe pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.NTSB WPR11CA394Accident · No injuriesData collectionFinal reportBell 47G · Porterville, CAThe pilot's decision to takeoff in a tailwind condition, and his subsequent failure to attain sufficient lift during the takeoff.NTSB WPR11LA361Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Perris, CAThe pilot’s failure to maintain airplane control and the resulting encounter with an aerodynamic stall. Also causal were the pilot’s inadequate preflight planning and preflight inspection, his failure to ensure the pitch trim was positioned correctly for…NTSB WPR11FA334Accident · Serious injuriesField investigationFinal reportPiper PA-12 · Joshua Tree, CAThe pilot's decision to conduct low altitude flight at a high density altitude and into a box canyon, which resulted in the airplane colliding with rising terrain when its climb capability was exceeded.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR10CA175Accident · No injuriesData collectionFinal reportBeech 23 · Twenty Nine Palms, CAThe pilot's encounter with a wind shear/downdraft that exceeded the climb performance capabilities of the airplane during initial climb.NTSB WPR10CA023Accident · No injuriesData collectionFinal reportBoykin Stephen Vance Rotorway E · Meiners Oaks, CAThe pilot's improper preflight planning which resulted in a takeoff with a tailwind.NTSB WPR09CA393Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Westley, CAThe pilot’s inadequate preflight planning and preparation, and his decision to operate the airplane well in excess of its maximum gross weight.NTSB WPR09LA057Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · Santa Clarita, CAThe helicopter's encounter with a gusty crosswind condition during engine start that exceeded the helicopter's demonstrated wind envelope.NTSB SEA08CA199AccidentData collectionFinal reportCessna 177B · Truckee, CAThe pilot's improper decision to take off in a heavily loaded airplane under the ambient conditions that existed at the time. Contributing to the accident was the mountainous/hilly terrain, a high density altitude, gusty winds and downdrafts.NTSB LAX08PA259Accident · 9 fatalClass 1Final reportSikorsky S-61N · Weaverville, CAThe following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…NTSB LAX08CA171Accident · No injuriesData collectionFinal reportPiper Cub Crafters PA-18-150 · Fall RiverMills, CAThe pilot's selection of an unsuitable takeoff/landing area.