NTSB investigations, 2007, CA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 80 |
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\") = 2007
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") = 2007 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 SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.NTSB LAX08FA043Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Paso Robles, CAThe pilot's encounter with isolated moderate (or greater) turbulence, updrafts, and downdrafts associated with localized mountain wave conditions at low altitude, and, his failure to maintain adequate airspeed during the encounter that resulted in an…NTSB SEA08LA054Accident · Serious injuriesLimited investigationFinal reportHein Sonex · Murrieta, CAThe loss of engine power due to fuel exhaustion. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB SEA08LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-83 · Ontario, CAThe lack of turbulence forecasts available to the flight crew, which resulted in the flight attendants not being seated when the flight encountered severe terrain-induced turbulence. Contributing to the accident were the terrain-induced turbulence, the…NTSB SEA08CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Truckee, CAThe loss of partial engine power during cruise for undetermined reasons. A contributing factor was the snow covered terrain.NTSB SEA08CA055Accident · No injuriesData collectionFinal reportBrooks Exec 162F · Santa Maria, CAThe pilot's failure to maintain control of the helicopter during hover. Contributing to the accident was the pilot's lack of experience in rotorcraft.NTSB LAX08IA042Incident · No injuriesIncident investigationFinal reportEurocopter France AS350 B3 · Fresno, CAMalfunction of a hydraulic servo while on final approach due to excessive wear of the locking finger.NTSB SEA08CA047Accident · No injuriesData collectionFinal reportCessna 172S · El Cajon, CAThe excessive speed while turning off of the runway which resulted in a loss of aircraft control. The ditch was a factor.NTSB LAX08CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fallbrook, CAThe pilot's misjudged distance and altitude that led to an undershoot and a failure to obtain the proper touchdown point.NTSB LAX08CA034Accident · Serious injuriesData collectionFinal reportAir Tractor AT-401 · Soledad, CAThe pilot's failure to maintain an adequate clearance from mountainous terrain while maneuvering during an aerial application mission. Contributing to the accident was the pilot's diverted attention inside the cockpit.NTSB LAX08IA032Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Fresno, CAFailure of the tail rotor system support bracket during landing.NTSB SEA08CA049Accident · No injuriesData collectionFinal reportBeech A23 · Death Valley, CAThe pilot's improper flare during landing.NTSB SEA08LA040Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Carlsbad, CAThe pilot's improper flare resulting in a porpoise and hard landing.NTSB SEA08FA036Accident · 2 fatalField investigationFinal reportCessna 177 · Auburn, CAThe pilot failed to maintain an adequate airspeed while maneuvering in the traffic pattern for landing, which resulted in a stall/spin. Contributing to the accident was the pilot's impairment during the flight from the effects of over-the-counter medications.NTSB SEA08CA032Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Ramona, CAAn excessive descent rate during a simulated 180-degree power-off autorotation, and the flight instructor's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB SEA08CA034Accident · No injuriesData collectionFinal reportAyres S2R-G1 · Calexico, CAThe pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.NTSB SEA08CA030Accident · Minor injuriesData collectionFinal reportCessna 172N · Atwater, CAThe failure of the student pilot to maintain directional control during the landing roll. Factors contributing to the accident included the sign and the ditch.NTSB SEA08LA028Accident · No injuriesLimited investigationFinal reportCessna 210L · Santa Barbara, CAThe left main landing gear's down limit switch plunger being bent and stuck in the closed position, which resulted in the collapse of the landing gear during the landing roll. The reason for the down limit switch plunger being bent could not be determined.NTSB SEA08LA033Accident · No injuriesLimited investigationFinal reportBeech A36 · El Centro, CAThe failure of maintenance personnel to properly secure the #2 cylinder through bolts. A contributing factor was the lack of suitable terrain for landing.NTSB SEA08LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Byron, CAThe failure of the right main landing gear aft trunnion attach fitting due to overload during the landing roll.NTSB LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.NTSB LAX08FA028Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · McFarland, CAThe pilot's inadequate preflight preparation and improper fueling procedures that led to fuel exhaustion.NTSB SEA08LA021Accident · 3 fatalLimited investigationFinal reportCessna 340 · Garberville, CAThe pilot's intentional visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the trees and terrain during climb. Contributing to the accident were the weather conditions of fog and a low…NTSB LAX08FA026Accident · 2 fatalField investigationFinal reportBeech A100 · Chino, CAThe pilot's failure to maintain a positive climb rate during an instrument takeoff. Contributing to the accident was the low visibility.NTSB SEA08CA018Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot's failure to maintain clearance from a ditch while taxiing. Contributing factors were the pilot's inadequate visual lookout and the ditch.NTSB LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.NTSB SEA08LA014Accident · No injuriesLimited investigationFinal reportRaytheon Corporate Jets Hawker 800XP · Santa Ana, CAThe failure of the pilot-in-command to follow procedures stipulated in the airplane flight manual regarding brake cooling time periods. Factors contributing to the accident were the intentional aborted takeoffs which resulted in the hot brakes, and the…NTSB LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.NTSB SEA08LA012Accident · No injuriesLimited investigationFinal reportBeech F35 · San Carlos, CAA total loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX08LA024Accident · 1 fatalLimited investigationFinal reportNorth Wing Mustang II 17.5 · Tracy, CAFailure or disconnection of a wing support/brace assembly for undetermined reasons during an undetermined phase of flight.NTSB LAX08CA021Accident · No injuriesData collectionFinal reportBeech A36 · Camarillo, CAThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall.NTSB LAX08CA020Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Fresno, CAThe pilot's failure to maintain the proper glide path to clear objects during approach for landing.NTSB LAX08CA019Accident · Minor injuriesData collectionFinal reportPloof Progressive Aerodyne's Searey · Lake Berryessa, CAThe airplane's encounter with a submerged object during landing in water, which resulted in the airplane nosing over.NTSB LAX08CA018Accident · No injuriesData collectionFinal reportBell 206L-1 · Ramona, CAThe pilot's failure to maintain control and correct a descent and a loss of tail rotor effectiveness while maneuvering at a low altitude and reduced airspeed.NTSB LAX08CA016Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAThe student pilot's improper execution of low rotor rpm procedures. Contributing to the accident was the flight instructor's inadequate supervision, failure to guard the throttle, and failure to take immediate remedial action.NTSB LAX08CA015Accident · No injuriesData collectionFinal reportCessna 172N · Daggett, CAThe flight's encounter with a strong gusty wind condition.NTSB SEA08CA011Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Tehachapi, CAThe pilot's misjudged distance/altitude that led to an undershoot, and his failure to attain the proper touchdown point.NTSB LAX08CA006Accident · No injuriesData collectionFinal reportAviat A-1 · Arroyo Grande, CAThe pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.NTSB LAX08LA004Accident · No injuriesLimited investigationFinal reportYakovlev YAK-50 · El Cajon, CAThe inadequate visual lookout of the pilot of another airplane and his failure to maintain clearance from a taxiing airplane.NTSB LAX08CA003Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hemet, CAThe pilot's failure to maintain a proper descent rate due to his failure to close the air brake and/or partially retract the flaps during an encounter with lost lift on final approach.NTSB LAX08FA002Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Oak Hills, CAThe pilot's continued flight into instrument meteorological conditions and failure to maintain terrain clearance during cruise flight. Contributing to the accident were mountainous terrain, dark night, and fog.NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.NTSB LAX07CA285Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Stockton, CAThe pilot's inadequate compensation for the gusty, crosswind and downdraft wind condition, which resulted in a hard landing.NTSB LAX07CA283Accident · No injuriesData collectionFinal reportLuscombe 8E · Ramona, CAthe installation and subsequent failure of an incorrect part, which jammed in one wheel's brake caliper and induced the pilot's loss of directional control.NTSB LAX07CA282Accident · Minor injuriesData collectionFinal reportPiper J5A · Turlock, CAThe pilot's failure to properly and adequately tie down the airplane during the engine start operation.NTSB SEA07CA271Accident · Minor injuriesData collectionFinal reportLangley Tri-Quickie · Chino, CAThe premature rotation of the airplane on the takeoff roll as a result of the pilot failing the verify the elevator trim position, resulting in a loss of control and subsequent impact with terrain during an aborted takeoff.NTSB SEA07CA267Accident · No injuriesData collectionFinal reportCessna 340A · Schellville, CAThe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. Contribution factors are the pilot's inadvertent landing at the wrong airport with a shorter runway than his intended destination and limited braking effectiveness…NTSB SEA07LA266Accident · Serious injuriesLimited investigationFinal reportSt. Claire Ragtop-01 · Perris, CAThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing factors to the accident were the fence and the undetermined brake malfunction.NTSB LAX07TA277Accident · No injuriesFinal reportAir Tractor AT-802A · Big Bear City, CALoss of engine power while maneuvering due to the failure of the number 1 bearing that was caused by electrical discharge damage to the bearing originating from the starter-generator. Contributing to the accident was the operator's failure to follow the…