NTSB investigations, 1989, CA
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 | 81 |
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\") = 1989
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") = 1989 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 LAX90LA059Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Santa Barbara, CAThe pilot's failure to maintain adequate terrain clearance during a night visual approach.NTSB LAX90FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Santa Rosa, CAThe pilot's improper preflight planning/decision which resulted in the loss of tail rotor effectiveness. Contributing to the accident was the pilot allowing the maximum gross weight of the aircraft to be exceeded, and the tailwind.NTSB LAX90LA057Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Gorman, CAThe malfunctioning propeller governor, and the pilot's misjudgement of altitude and distance of the approach path during an emergency landing. Factors contributing to the accident were: the power lines across the approach path to the runway and the…NTSB LAX90LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Byron, CAThe pilot's failure to maintain sufficient terrain clearance altitude during a low altitude turn. Contributing to the accident was the pilot's poor judgement in conducting touch-and-go landings with a 700-foot ceiling.NTSB LAX90LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAThe pilot's improper level-off and improper recovery from a bounced landing.NTSB LAX90LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAThe copilot's overrotation of the aircraft during the flare which allowed the tail to collide with the runway. The failure of the captain to take appropriate corrective action was a factor in the accident.NTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.NTSB LAX90DXQ01Accident · Minor injuriesFinal reportBennet Spezio Tuholer · Chilcoot, CAThe pilot's improper inflight decision by failing to maintain proper terrain clearance while maneuvering near the ground to observe some deer.NTSB LAX90LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Monterey, CAPilot misjudged clearance between the aircraft's wing tip & the fuel truck. A factor related to the accident was: the proximity of the vehicle (fuel truck).NTSB LAX90LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Avalon, CAFailure of the pilot to attain the proper touchdown point for landing, and his failure to go around when he had too much speed and insufficient distance to stop on the runway. A factor related to the accident was: the uneven terrain beyond the departure end…NTSB LAX90LA049Accident · No injuriesLimited investigationFinal reportCessna 150D · Inyokern, CAThe pilot's failure to use carburetor heat when climatic conditions were conducive to the formation of carburetor ice.NTSB LAX90LA045Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Van Nuys, CAThe P-51 pilot's failure to see and avoid the standing C-172.NTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.NTSB LAX90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32-437 · Hayward, CAEngine failure due to water in fuel that was not discovered by the pilot during his preflight inspection of the fuel system.NTSB LAX90LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Concord, CAImproper use of the brakes by the pilot. The crosswind and the pilot's failure to maintain runway alignment were contributing factors.NTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.NTSB LAX90DUG02Accident · Serious injuriesFinal reportWittman Tailwind W-8 · Chino, CAA loss of engine power for undetermined reasons.NTSB LAX90LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Santa Ynez, CAThe student pilot's loss of directional control during a go-around.NTSB LAX90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hayward, CAInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.NTSB LAX90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rancho Calif, CAThe pilot's loss of directional control during a crosswind landing.NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB LAX90DVG02Accident · No injuriesFinal reportSchweizer G-164B · Knights Landing, CAThe failure of the right main Landing gear due to a sheared bolt that attached the spring leg to the gear.NTSB LAX90LA035Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Van Nuys, CAThe incorrect installation of the engine cowl and baffle seals during the installation of the engine following an overhaul.NTSB LAX90LA033Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas 369 · Barstow, CAImproper planning/decision by the pilot, and his delay in jettisoning the load.NTSB LAX90LA032Accident · No injuriesLimited investigationFinal reportMooney 201 · Concord, CAThe pilot's loss of directional control and subsequent collision with an object during a touch and go landing in visual meteorological conditions.NTSB LAX90DVG01Accident · No injuriesFinal reportSchweizer G-164B · Grimes, CAFailure of the counter weight bracket to the propeller assembly.NTSB LAX90LA030Accident · Minor injuriesLimited investigationFinal reportCessna 210 · North Hollywood, CAImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications, lack of a suitable area for a forced landing, and obstructions (utility pole &…NTSB LAX90FA031Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Camarillo, CAImproper IFR procedure by the pilot, and his failure to maintain the minimum descent altitude (mda) for that segment of the VOR approach. Factors related to the accident were: darkness, low ceiling, fog, haze, the pilot's lack of recent instrument experience,…NTSB LAX90LA029Accident · No injuriesLimited investigationFinal reportBell-Kitz Kopters 47D1 · Chino, CAA fatigue failure of both the main rotor stabilizer bar tube and the tie rod. In addition, the tie rod nut was loose and did not conform to engineering drawing specifications. Company personnel failed to detect the fatigue cracks during daily inspections.NTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…NTSB LAX90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Chino, CALoss of engine power for an undetermined reason. Soft terrain in the emergency landing area was a related factor.NTSB LAX90LA024Accident · No injuriesLimited investigationFinal reportCessna 320 · Hayward, CAFailure of the pilot to attain the proper touchdown point and his improper flare for landing. Factors related to the accident were: the pilot's lack of experience in the make and model of aircraft, and company induced pressure.NTSB SEA90LA011Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Chilcoot, CAThe pilot's improper inflight planning. Contributing to the accident was a down draft and the pilot's lack of recent expereince in this aircraft type.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.NTSB LAX90LA012Accident · No injuriesLimited investigationFinal reportCulver VEE · Santa Paula, CAThe pilot's failure to maintain sufficient airspeed for a positive rate of climb.NTSB LAX90LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CAThe flight instructor improperly supervised the flight and the dual student pilot failed to properly set the fuel selector valve in the proper position. Both pilots failed to use the emergency checklist.NTSB LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB LAX90LA015Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Borrego Springs, CAThe failure of the engine exhaust valve.NTSB LAX90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Bishop, CAThe pilot's neglect in failure to ensure adequate clearance was available to pass the parked refueling vehicle. The refueling vehicle parking position on an active taxiway was a factor in the accident.NTSB LAX90DUD01Accident · Minor injuriesFinal reportWheeler Acft. Express 100 · W. Los Angeles, CAThe mechanical failure of the engine due to the wearing away of the piston pin plug, connecting rod bearings, and the breakage of the connecting rod at the lower end. Contributing to the severity of the accident was the forced landing into a residential area…NTSB LAX90LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · Simi Valley, CAStudent pilot's failure to maintain the proper altitude.NTSB LAX90FA017Accident · 2 fatalField investigationFinal reportBeech F35 · Lake Berryessa, CAInadequate visual lookout by the pilot and his failure to maintain proper altitude. The power lines was a related factor.NTSB LAX90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ontario, CAImproper use of the brakes by the pilot of the Piper PA-31.NTSB LAX90FA016Accident · 3 fatalField investigationFinal reportCessna 177 · So Lake Tahoe, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions.NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.NTSB LAX90DUG01Accident · 1 fatalFinal reportMannon-Underwood JEANIE'S Teenie · Hemet, CAInadvertent stall experienced by the pilot and his lack of experience.NTSB LAX90DVA01Accident · Serious injuriesFinal reportHiller 12E · Huron, CAThe pilot failed to properly preflight the airplane before departing on the accident flight and misjudged the flare during the ensuing autorotation. Factors relating to this accident were oil starvation and total failure of the connecting rod.NTSB CHI90IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · San Francisco, CAThe extreme wear and eventual failure of a torque tube in the inboard trailing edge flap system. Inspection and lubrication intervals were a factor, as was the physical location of the torque tube with reference to external factors.NTSB LAX90LA006Accident · No injuriesLimited investigationFinal reportPiper J-2 · Santa Ynez, CAFailure of the pilot to adequately secure the aircraft before hand propping the engine.