NTSB investigations, 2017, CA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 10 |
|---|---|
| 1963 | 11 |
| 1964 | 659 |
| 1965 | 654 |
| 1966 | 755 |
| 1967 | 799 |
| 1968 | 668 |
| 1969 | 613 |
| 1970 | 617 |
| 1971 | 605 |
| 1972 | 510 |
| 1973 | 499 |
| 1974 | 523 |
| 1975 | 488 |
| 1976 | 484 |
| 1977 | 497 |
| 1978 | 548 |
| 1979 | 473 |
| 1980 | 472 |
| 1981 | 403 |
| 1982 | 391 |
| 1983 | 441 |
| 1984 | 388 |
| 1985 | 329 |
| 1986 | 316 |
| 1987 | 315 |
| 1988 | 322 |
| 1989 | 289 |
| 1990 | 318 |
| 1991 | 291 |
| 1992 | 277 |
| 1993 | 260 |
| 1994 | 242 |
| 1995 | 237 |
| 1996 | 223 |
| 1997 | 182 |
| 1998 | 212 |
| 1999 | 186 |
| 2000 | 222 |
| 2001 | 183 |
| 2002 | 176 |
| 2003 | 182 |
| 2004 | 171 |
| 2005 | 191 |
| 2006 | 187 |
| 2007 | 207 |
| 2008 | 158 |
| 2009 | 187 |
| 2010 | 158 |
| 2011 | 141 |
| 2012 | 134 |
| 2013 | 128 |
| 2014 | 117 |
| 2015 | 118 |
| 2016 | 119 |
| 2017 | 162 |
| 2018 | 119 |
| 2019 | 114 |
| 2020 | 105 |
| 2021 | 94 |
| 2022 | 111 |
| 2023 | 103 |
| 2024 | 101 |
| 2025 | 91 |
| 2026 | 79 |
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\") = 2017
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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' 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 WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB GAA18CA096Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox · Upper Lake, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the approach to land, which resulted in an aerodynamic stall.NTSB WPR18CA059Accident · No injuriesData collectionFinal reportCessna 182 · Santa Ana, CAThe pilot’s failure to follow ground control instructions and to see and avoid ground obstacles while taxiing.NTSB WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.NTSB WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.NTSB WPR18FA046Accident · 2 fatalField investigationFinal reportBeech A36 · San Diego, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.NTSB GAA18CA079Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Chino, CAThe pilot’s failure to maintain directional control during a touch-and-go landing.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 GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR18LA036Accident · Minor injuriesClass 3 · LimitedFinal reportDoshier Wilbert A GT-500 · Willows, CAA loss of engine power during takeoff due a coolant leak and the subsequent overheating of the engine, and the student pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall…NTSB WPR18FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Tehachapi, CAThe pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.NTSB GAA18CA063Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAAn in-flight collision with a bird.NTSB WPR18LA034Accident · Serious injuriesClass 2 · LimitedFinal reportCessna 172P · San Jose, CAThe pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…NTSB GAA18CA054Accident · Minor injuriesData collectionFinal reportQuicksilver MXL Sport · Point Mugu, CAThe pilot’s failure to see and avoid power wires.NTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.NTSB DCA18CA074Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Los Angeles, CAThe provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.NTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.NTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.NTSB WPR18LA021Accident · No injuriesLimited investigationFinal reportMetcalfe Robert B Vans RV 6 · Selma, CAThe pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power.NTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…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 WPR18LA004Accident · No injuriesClass 3 · LimitedFinal reportWestern International Avia UH 1H · Arbuckle, CAA collective control malfunction for reasons that could not be determined.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 GAA18CA002Accident · Minor injuriesData collectionFinal reportUltralight America Spitfire II · Camarillo, CAThe pilot’s failure to track the runway centerline during an attempted go-around, which resulted in impact with a hangar.NTSB WPR18LA007Accident · No injuriesClass 3 · LimitedFinal reportThomas Stephen Glasair Super II RG · Santa Ynez, CAA partial loss of engine power for reasons that were not determined.NTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.NTSB GAA17CA581Accident · No injuriesData collectionFinal reportCessna 414 · San Jose, CAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.NTSB GAA17CA562Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · Fullerton, CAThe pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.NTSB WPR17LA217Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Los Angeles, CAThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA551Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Santa Barbara, CAThe student pilot’s unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.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 GAA17CA573Accident · No injuriesData collectionFinal reportCessna 172 · Chino, CAAn in-flight collision with a bird while on downwind.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 WPR17LA210Accident · No injuriesLimited investigationFinal reportCessna 210 · Sacramento, CAPartial retraction of the main landing gear during the landing roll for reasons that could not be determined because postaccident examination and functional testing of the gear revealed no anomalies.NTSB WPR17LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-161 · El Cajon, CAA partial loss of engine power due to the formation of carburetor ice during descent for landing. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB WPR17LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · Salinas, CAThe pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB WPR17LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Watsonville, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose gear separation.NTSB DCA17CA195Accident · No injuriesData collectionFinal reportBoeing 737-924ER · Los Angeles, CAthe B737 flight crew's misjudgment of the clearance between their wingtip and the B767 horizontal stabilizer.NTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.NTSB WPR17FA200Accident · 2 fatalField investigationFinal reportRaytheon G36 · Benicia, CAThe pilot's failure to maintain adequate airspeed which caused the airplane to exceed its critical angle of attack and led to an aerodynamic stall.NTSB WPR17FA196Accident · 1 fatalField investigationFinal reportCessna 172N · Bolinas, CAThe non-instrument rated private pilot's improper decision to embark on a flight and continue to fly into forecasted instrument meteorological conditions and mountain obscuration while conducting a visual flight rules flight.NTSB WPR17LA201Accident · No injuriesLimited investigationFinal reportCobalt Aircraft Industries Co50 Valkyrie · Atwater, CAA loss of aileron effectiveness due to the airplane's design configuration, which resulted in the pilot's inability to control the roll axis and led to a hard landing.