NTSB investigations, 2001, 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\") = 2001
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") = 2001 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 LAX02LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Long Beach, CAThe student pilot's inadequate compensation for wind, and his failure to maintain directional control of the aircraft during the landing roll.NTSB LAX02LA058Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Winters, CAThe failure of the pilot to retard the engine throttle to idle while hand-propping the engine, which resulted in the engine starting at full (takeoff) power and the airplane taking off with no one aboard.NTSB LAX02LA055Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAThe pilot's inadequate preflight and in-flight planning/decision resulting in miscalculation of fuel consumption, fuel exhaustion and loss of engine power. Factors were rough terrain in a vineyard, power lines in the landing area, and night time.NTSB LAX02FA056Accident · 2 fatalField investigationFinal reportCessna 172N · San Clemente, CAa loss of engine power due to a loss of magneto to engine timing resulting from stress corrosion crack induced fracture, and separation of the magneto impulse coupling spring.NTSB LAX02LA053Accident · No injuriesLimited investigationFinal reportCessna T210N · San Diego, CAThe pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.NTSB LAX02LA051Accident · No injuriesLimited investigationFinal reportVernon Sonerai IIL · Camarillo, CAFailure of the pilot to maintain directional control on the landing rollout. Factors were the owner/pilot's inadequate remedial design changes and the freshly plowed field.NTSB LAX02LA050Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Maria, CAInadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.NTSB LAX02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's collision with an unobserved animal that entered the active runway during the dark nighttime when the pilot's visibility was diminished.NTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.NTSB LAX02LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Verne, CAThe pilot's failure to maintain directional control following his misjudged landing flare and hard touchdown.NTSB LAX02LA043Accident · 1 fatalLimited investigationFinal reportRominger Zic Zac Bird · Marina, CAthe failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.NTSB LAX02LA042Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Banning, CAOn final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.NTSB LAX02FA040Accident · No injuriesField investigationFinal reportCessna 172C · Corona, CAa loss of engine power due to the pilot's improper use of the carburetor heat controls while in weather conditions conducive to serious carburetor icing.NTSB LAX02FA038Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · El Dorado, CAthe pilot's intentional flight into adverse weather conditions and his subsequent failure to maintain aircraft control.NTSB LAX02LA037Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Long Beach, CAthe loss of aircraft control while maneuvering for undetermined reasons.NTSB LAX02LA035Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Banning, CAa loss of engine power due to a crack in the carburetor float and leaking portions of the carburetor that resulted in an overly rich mixture.NTSB LAX02FA031Accident · 5 fatalField investigationFinal reportAero Commander 500S · Eagleville, CAthe pilot's encounter with forecast mountain wave conditions, moderate or greater turbulence, and icing, with downdrafts that likely exceeded the climb capability of the airplane, which was encountered at an altitude that precluded recovery. Also causal in…NTSB LAX02FA028Accident · 2 fatalField investigationFinal reportCessna 340A · Santa Monica, CAThe pilot's failure to remove the control gust lock prior to takeoff and his failure to abort the takeoff with sufficient runway remaining to stop the airplane on the runway.NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB LAX02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Herald, CAThe pilot's delay initiating a go-around during a downwind approach to a short runway.NTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.NTSB LAX02FA020Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Escondido, CAthe pilot's failure to maintain an adequate clearance from obstacles while approaching to land at his private helipad. Factors in the accident were night conditions, inadequate illumination of the landing pad, and a likely low visibility condition due to fog.NTSB LAX02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Avalon, CAthe total loss of engine power during departure climb for undetermined reasons.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB LAX02LA015Accident · No injuriesLimited investigationFinal reportThomson Harmon Rocket II · Perris, CAthe airplane builder's failure to properly install a bolt and nut into the aileron and elevator flight control system. A contributing factor was the soft terrain conditions for the ensuing forced landing.NTSB LAX02IA013Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas 600N · Long Beach, CAThe fatigue failure of a 5/16-inch boom attach bolt was most probably caused by the angular misalignment between the tail boom bolt hole and the fuselage mounted nutplate.NTSB LAX02FA008Accident · 1 fatalField investigationFinal reportBrock Thorp T-18 · El Mirage, CAthe corrosion and fatigue failure of the tail wheel fork.NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…NTSB LAX02LA005Accident · Minor injuriesLimited investigationFinal reportAero Commander 690 · Temecula, CAa misrigging of the engine controls that resulted in an asymmetric reverse thrust condition.NTSB LAX02FA004Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Van Nuys, CAThe failure of the air traffic controller to provide effective separation on the runway surface as specified in FAA Order 7110.65, Paragraph 3-9-6.NTSB LAX02FA003Accident · 1 fatalField investigationFinal reportEdge 540 · San Juan Capist, CAthe pilot's failure to maintain an adequate terrain/object altitude clearance while intentionally performing low level aerobatics, which resulted in a loss of aircraft control.NTSB LAX02IA002Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Santa Ana, CAThe failure of the stabilizer electric trim motor as a result of internal mechanical seizure.NTSB LAX02LA001Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Petaluma, CAThe pilot's inadvertent (dark, nighttime) VFR flight into instrument meteorological conditions and subsequent loss of altitude control. A factor in the accident was the pilot's inadequate preflight weather evaluation.NTSB LAX01LA305Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAA hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.NTSB LAX01LA304Accident · 1 fatalLimited investigationFinal reportAerospatiale AS350BA · Chico, CAthe pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…NTSB LAX01FA302Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Chico, CAThe loss of right engine power for undetermined reasons, and the pilot's failure to maintain control of the aircraft due to his improper single engine emergency procedures.NTSB LAX01LA303Accident · 2 fatalLimited investigationFinal reportCessna P206B · Willits, CAthe failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.NTSB LAX01LA289Accident · No injuriesLimited investigationFinal reportCessna 150J · Sonoma, CAFuel exhaustion due to the pilot's inadequate preflight fuel consumption calculations and failure to ensure that adequate fuel was onboard the airplane prior to departure. A factor in the accident was the pilot's continued use of the airplane with known…NTSB LAX01LA301Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Bridgeport, CAThe failure of the pilot to maintain directional control of the tail wheel equipped aircraft during landing roll which resulted in a ground loop.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB LAX01LA296Accident · No injuriesLimited investigationFinal reportFunk C · Merced, CAThe pilot's improper modification of the airplane when he switched a nonvented fuel cap to the fuselage tank. A factor was the inadequate annual inspection.NTSB LAX01GA291Accident · 2 fatalFinal reportGrumman TS-2A · Hopland, CAthe failure of both pilots to maintain an adequate visual lookout. The failure of the pilot in Tanker 87 to comply with suggested procedures regarding positive radio contact and orbit entry was a factor.NTSB LAX01FA290Accident · No injuriesField investigationFinal reportPiper PA-32-301T · Fullerton, CAThe engine lost power for unknown reasons.NTSB LAX01LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe improper fabrication/reassembly and inspection of the engine throttle control linkage during aircraft restoration by the operator, and the failure of the operator's inspection personnel to detect the error during subsequent annual inspections.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB MIA01LA224Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Needles, CAan inadvertent in-flight encounter with turbulence.NTSB LAX01LA283Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Vinton, CAThe pilot's selection of an unsuitable landing site, which caused "brown-out" conditions during departure liftoff and resulted in loss of control of the helicopter.NTSB LAX01LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172-A · Groveland, CAa loss of engine power due to water contamination forced the pilot to land in an unsuitable area resulting in collision with a tree.NTSB LAX01LA281Accident · 2 fatalLimited investigationFinal reportJohnson Lancair 360 · Placerville, CAIn-flight loss of control for undetermined reasons.NTSB LAX01TA278Accident · Serious injuriesFinal reportDouglas DC-3C · Alturas, CAThe inadvertent encounter with terrain induced turbulence. A factor was the high terrain.