NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.NTSB LAX05FA056Accident · 1 fatalField investigationFinal reportEurocopter France AS350BA · Panamint Spring, CAThe pilot's misjudged lateral distance from a mountainside and failure to maintain an adequate clearance from terrain and obstacles while performing a low altitude filming maneuver.NTSB LAX05CA055Accident · No injuriesData collectionFinal reportTop Dog Trike · Torrey Pines, CAthe pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.NTSB LAX05CA052Accident · No injuriesData collectionFinal reportClassic Waco YMF · Santa Barbara, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during landing rollout, which resulted in a ground loop.NTSB LAX05LA050Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ontario, CAa loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.NTSB LAX05LA049Accident · No injuriesLimited investigationFinal reportRobinson R22B · Los Angeles, CAThe activation of the low main rotor rpm warning system for undetermined reasons.NTSB LAX05CA043Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Monica, CAthe certified flight instructor's inadequate supervision, inadequate compensation for the tailwind condition, and delayed remedial action, which resulted in a runway overrun and collision with a ditch.NTSB LAX05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Big Pine, CAoil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…NTSB LAX05FA041Accident · 2 fatalField investigationFinal reportCessna 411 · Corona, CAA loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…NTSB LAX05LA039Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Rialto, CAthe pilot's failure to maintain adequate rotor rpm and altitude/clearance during the takeoff initial climb.NTSB LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.NTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.NTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB LAX05FA032Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Santa Barbara, CAThe pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…NTSB LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…NTSB LAX05LA020Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350-BA · Oxnard, CAThe inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…NTSB LAX05FA026Accident · 1 fatalField investigationFinal reportCessna T210M · Lomita, CAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.NTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.NTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.NTSB LAX05FA015Accident · 5 fatalClass 1 · FieldFinal reportLearjet 35A · San Diego, CAThe failure of the flight crew to maintain terrain clearance during a VFR departure, which resulted in controlled flight into terrain, and the air traffic controller's issuance of a clearance that transferred the responsibility for terrain clearance from the…NTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.NTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.NTSB LAX05TA008Accident · No injuriesFinal reportHughes OH-6A · Jacumba, CAthe pilot's failure to maintain adequate clearance from the mountainous terrain, which resulted in the helicopter's tail rotor blades impacting rocks. A factor in the accident was the pilot's complacency.NTSB LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.NTSB LAX05CA006Accident · Minor injuriesData collectionFinal reportCessna 182RG · Placerville, CAthe pilot's misjudged distance and speed, and failure to attain the proper touchdown point, which resulted in the airplane overrunning the runway surface and nosing over after encountering soft terrain.NTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.NTSB LAX04CA332Accident · No injuriesData collectionFinal reportBell 222U · Santa Rosa, CAthe pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.NTSB LAX04LA331Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Burbank, CAthe failure of maintenance personnel to correctly service the forward landing gear strut dampers in accordance with the manufacturer's maintenance instructions.NTSB LAX04FA330Accident · Serious injuriesField investigationFinal reportBushmaster 2000 · Fullerton, CAthe inadequate preflight inspection by the pilot-in-command, where the pilot failed to remove the makeshift gust lock attached to the rudder and left elevator of the airplane. As a result, the airplane veered off the runway surface during the takeoff roll,…NTSB LAX04CA326Accident · No injuriesData collectionFinal reportIar Sa Brasov 823 · Denair, CAthe pilot's failure to verify the fuel quantity on board prior to departure, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX04LA324Accident · No injuriesLimited investigationFinal reportCirrus SR-22 · Peters, CAThe pilot's decision to continue flight into adverse weather and the subsequent encounter with the outer boundaries of a level 5 thunderstorm, which resulted in his loss of control of the airplane.NTSB LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.NTSB LAX04LA320Accident · Serious injuriesLimited investigationFinal reportHebb Avid Magnum · Bridgeport, CAthe pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.NTSB LAX04LA318Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Los Angeles, CAthe flight's encounter with the wake turbulence from a preceding heavy airplane while on approach.NTSB LAX04CA317Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Monterey, CAthe pilot's failure to maintain proper alignment with the taxiway and adequate obstacle clearance. A factor was the bright morning sunglare.NTSB LAX04CA316Accident · No injuriesData collectionFinal reportSmith S-51D · Lancaster, CAthe pilot's misjudged landing flare, failure to correct the descent rate, and failure to execute a go-around during an unstablized landing approach.NTSB LAX04LA334Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 125-1000A · San Francisco, CAAn electrical arc from an undetermined source initiated a hydraulic line rupture, which resulted in an equipment bay fire.NTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.NTSB LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…NTSB LAX04LA308Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · San Rafael, CAA total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.NTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.NTSB LAX04LA325Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Auburn, CAa collapse of the landing gear for undetermined reasons.NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.NTSB LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.