NTSB investigations, 1990, CA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1990
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") = 1990 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 LAX91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yucca Valley, CAThe pilot's improper use of the flaps. Contributing to this accident was the loss of control during tailwind landing, and his tailwind and the pilot's inadequate inflight planning.NTSB LAX91LA062Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Imperial, CAFuel exhaustion.NTSB LAX91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilots failure to maintain directional control during the landing. A factor in the accident was his lack of total experience.NTSB LAX91LA055Accident · 1 fatalLimited investigationFinal reportCessna 150G · Fresno, CAThe pilots intentional flight into known adverse weather conditions and his failure to maintain control of the aircraft. Factors in the accident were: the foggy weather conditions; spatial disorientation; and the pilot's over confidence in his own personal…NTSB LAX91LA051Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Madera, CAEngine failure due to a plugged vent line, affecting the ability of the system to transfer fuel to the main tank.NTSB LAX91FA052Accident · Minor injuriesField investigationFinal reportde Havilland DHC-6-100 · Perris Valley, CAA loss of power on the left engine due to a fatigue failure of a compressor turbine blade leading to further compressor blade damage; a worn power turbine governor throttle cam assembly which led to loss of power on the right engine; and inadequate…NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.NTSB LAX91LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Livermore, CAInadvertent flight by the pilot into instrument meteorological conditions (IMC), and her failure to maintain adequate altitude and/or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB LAX91FA044Accident · 1 fatalField investigationFinal reportCessna T210-F · Fontana, CAThe pilot-in-command's decision to continue flight into known adverse weather conditions during the hours of darkness in mountainous terrain.NTSB LAX91LA046Accident · No injuriesLimited investigationFinal reportCessna T303A · Santa Ana, CAThe pilot's misjudging the distance between the airplane and hangar.NTSB LAX91FA037Accident · 1 fatalField investigationFinal reportRobinson R22Beta · Simi Valley, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the tailboom and cockpit.NTSB LAX91FA036Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Woodland, CAThe pilot's misjudgement of his altitude to assure terrain clearance during a night visual approach. Contributing factors were the dark night, unlit terrain, the pilot's lack of recent night time, the pilot's lack of familiarity with the airport, and an…NTSB LAX91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Fallbrook, CAThe failure of the number 5 cylinder piston connecting rod due to bending and subsequent fatigue fracture. Contributing to the accident was the improper starting procedure accomplished by an unidentified person which resulted in excessive fuel in the cylinder…NTSB LAX91LA032Accident · 1 fatalLimited investigationFinal reportCessna 172RG · San Clemente, CAThe pilots selection of improper cruise altitude while operating under a low overcast on a dark night. A factor in the accident was fatigue and lack of sleep.NTSB LAX91LA029Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAThe failure of the student pilot to maintain an adequate airspeed while maneuvering in the traffic pattern; maintain control of the aircraft and the inadvertent stall mush. A factor in the accident was the pilot's limited total expereince.NTSB LAX91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Dana Point, CAThe pilot's improper fuel consumption calculations.NTSB LAX91TL#02Accident · Minor injuriesClass 3Final reportMcDonnell Douglas 369E · Llano, CANTSB LAX91LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Paso Robles, CAThe pilot's delay in taking appropriate remedial action. A factor in the accident was the flight's encounter with a tailwind during the termination phase of the auto rotation.NTSB LAX91LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAAn engine failure for undetermined reasons.NTSB LAX91TL#01Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · Los Alamitos, CANTSB LAX91LA023Accident · No injuriesLimited investigationFinal reportCessna 150G · Columbia, CAPoor planning which resulted in fuel exhaustion.NTSB LAX91FA020Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Solana Beach, CAThe inadvertent stall/spin. Factors in the accident were: the pilot's decision to allow the reporter passenger to fly the aircraft in a critical flight situation, his decision to allow the aircraft to descend to an altitude too low to allow for contingencies,…NTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…NTSB LAX91GA016Accident · No injuriesFinal reportMcDonnell Douglas 369E · Compton, CAInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each to see-and-avoid conflicting traffic. Factors related to the accident were: darkness, failure of the pilot of air 28 (N48HR) to use his transponder near the tca, and…NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB LAX91LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · San Carlos, CAThe pilot's failure to maintain clearance between his aircraft and a hanger while taxiing. The failure of airport maintenance personnel to maintain taxiway markings was a factor in the accident.NTSB LAX91LA015Accident · No injuriesLimited investigationFinal reportCessna 172L · Placerville, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB LAX91LA014Accident · No injuriesLimited investigationFinal reportCessna 150E · S. Lake Tahoe, CAThe pilot's failure to ensure adequate clearance was available when he attempted to taxi pass a parked vehicle.NTSB LAX91DUM02Accident · Serious injuriesFinal reportAyres S2RT-T34 · El Centro, CACollision with a ground object after the pilot successfully made a night time emergency landing after experiencing an engine power interruption for undetermined reasons.NTSB LAX91LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · San Carlos, CAThe pilot's visual lookout was inadequate.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.NTSB LAX91LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAA failure of the pilot to perform preflight planning.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB LAX91LA008Accident · Serious injuriesLimited investigationFinal reportBell 47G4 · Merced, CALoss of engine power for an undetermined reason.NTSB LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.NTSB LAX91LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Riverside, CAThe pilot misjudged the airplane's altitude and the improper bounced landing recovery procedure. Contributing to this accident was the student pilot's total lack of expereince.NTSB LAX91FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Redlands, CAA total loss of engine power due to fuel starvation as a result of a fuel system leak of an undetermined origin.NTSB LAX91LA004Accident · 1 fatalLimited investigationFinal reportMooney M20K · Rio Linda, CAThe airplane's ground collision with an unauthorized person who was located on the active runway. A contributing factor was related to the nighttime (light) condition which limited the pilot's ability to see the person prior to the impact.NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB LAX91LA003Accident · 1 fatalLimited investigationFinal reportCessna 210 · Riverside, CAImpairment of the pilot from use of drugs (cocaine), and his failure to maintain clearance (or altitude) from the mountain. Factors related to the accident were: darkness and the pilot's psychological condtion (depression).NTSB LAX91DVW01Accident · Serious injuriesFinal reportMelton MMI · Death Valley, CAThe pilot's inaccurate calculation of fuel consumption and his decision to continue the flight with a malfunctioning fuel quantity indicator.NTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.NTSB LAX90DUG11Accident · Serious injuriesFinal reportVolksplane WE-1 · El Mirage, CAThe pilot's failure to maintain airspeed.NTSB LAX90LA340Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Vacaville, CAThe Balloon's encounter with a sudden increase in wind speed accompained by a strong down draft beyond the compensation capability of the Balloon.NTSB LAX90LA330Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Lakeport, CAThe pilot's failure to maintain control of the aircraft while high-speed water taxiing. The excessive taxi speed is considered a factor in the accident.NTSB LAX90FA336Accident · 8 fatalField investigationFinal reportLockheed PV-2 · Lakeport, CAThe pilot-in-command's failure to maintain airspeed during a pull-up from a low pass. Factors which contributed to the accident were: the pilot's poor judgement in buzzing the seaplanes which resulted in insufficient altitude to recover from the stall, and…NTSB LAX90DVA13Accident · Serious injuriesFinal reportBlaise Midget Mustang · Kernville, CAThe pilot's failure to maintain an airspeed sufficient to sustain flight during landing. A factor was the pilot's lack of expereince in this aircraft.NTSB LAX90DUG10Accident · 2 fatalFinal reportELY Thorp T-18 · Claremont, CAA loss of control for undetermined reason(s).