NTSB investigations, CA
444 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 34 |
|---|---|
| 1983 | 34 |
| 1984 | 37 |
| 1985 | 23 |
| 1986 | 22 |
| 1987 | 30 |
| 1988 | 20 |
| 1989 | 25 |
| 1990 | 26 |
| 1991 | 23 |
| 1992 | 9 |
| 1993 | 13 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 12 |
| 1997 | 10 |
| 1998 | 10 |
| 1999 | 11 |
| 2000 | 10 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 16 |
| 2004 | 9 |
| 2005 | 18 |
| 2006 | 13 |
| 2007 | 13 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) 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 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 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 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 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 SEA07FA277Accident · 1 fatalField investigationFinal reportBellanca 8KCAB-180 · Mammoth Lakes, CAThe pilot’s inadvertent encounter with downdrafts that exceeded the climb capability of the airplane. Contributing to the accident were the downdrafts, high density altitude, and mountainous terrain.NTSB LAX07CA206Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Bridgeport, CAThe pilot's encounter with an unfavorable wind and high sink rate conditions.NTSB LAX07FA200Accident · 2 fatalField investigationFinal reportBeech E90 · Carlsbad, CAThe pilot's failure to maintain clearance from wires during an instrument takeoff attempt. Contributing to the accident were fog, reduced visibility, and the low ceiling.NTSB SEA07CA176Accident · Minor injuriesData collectionFinal reportCommonwealth 185 · Redlands, CAThe pilot's inadequate weather evaluation which resulted in the airplane's lack of climb performance and subsequent collision with terrain. Contributing factors included the downdraft and the high temperature.NTSB SEA07LA132Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Lake Elsinore, CAThe glider's encounter with a downdraft while in the traffic pattern, resulting in insufficient altitude to reach the airport. A contributing factor was the pilot's selection of an unsuitable off-airport landing area, which led to an on-ground collision with…NTSB SEA07CA123Accident · No injuriesData collectionFinal reportPiper PA28-235 · San Jose, CAWind shear encounter during approach for landing.NTSB SEA07FA106Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's VFR flight into IMC and his ensuing failure to maintain terrain clearance. Contributing factors were the cloudy weather conditions and the mountainous terrain.NTSB LAX07LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Los Angeles, CAThe flight's encounter with a turbulence event that occurred while the flight attendants were unseated. Contributing to the accident was the apparent conflicting information provided by the flight deck to the flight attendants and the flight attendants'…NTSB LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.NTSB LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.NTSB LAX07FA056Accident · 3 fatalField investigationFinal reportBell 412SP · Hesperia, CAThe pilot's inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain terrain clearance. Contributing to the accident were the dark night conditions, fog, and mountainous terrain.NTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…NTSB LAX06LA249Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Independence, CAthe pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.NTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.NTSB SEA07CA138Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Williams, CAThe loss of thermal lift during cruise flight that resulted in a forced landing.NTSB LAX06FA186Accident · 3 fatalField investigationFinal reportCessna T182T · Burney, CAthe pilot's decision to continue VFR flight into instrument meteorological conditions and his failure to maintain clearance from mountainous terrain.NTSB LAX06FA148Accident · 2 fatalField investigationFinal reportCessna T337C · Wrightwood, CAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions, which resulted in controlled flight into mountainous terrain.NTSB LAX06FA131Accident · 2 fatalField investigationFinal reportCessna 208B · Oak Glen, CAThe pilot's continued flight into instrument meteorological weather conditions and his subsequent failure to maintain an adequate airspeed while maneuvering, that led to a stall/spin.NTSB ANC06LA030Accident · 1 fatalLimited investigationFinal reportMooney M-10 · Salinas, CAThe pilot's continued flight into known adverse weather, and his failure to maintain sufficient airspeed, which resulted in a loss of control and an inadvertent stall/spin during cruise flight. Factors associated with the accident are a low ceiling with…NTSB LAX06CA118Accident · Serious injuriesData collectionFinal reportMooney M20F · Willits, CAThe pilot's failure to maintain visual contact with the runway at night, which resulted in a descent below the proper glide path and a collision with a tree. Also causal was the flight instructor's inadequate supervision of the flight.NTSB LAX06IA076Incident · No injuriesIncident investigationFinal reportSaab-Scania SF340B+ · Santa Maria, CAAn in-flight loss of control due to ice accreted in supercooled liquid droplets (SLD) conditions, and the flight crew's failure to maintain the specified minimum airspeed in icing conditions. Contributing to the accident was the flight crew's decision to…NTSB LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.NTSB LAX06LA064Accident · 4 fatalLimited investigationFinal reportCessna 172 · Gilroy, CAThe non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…NTSB LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.NTSB LAX06CA081Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe flight's encounter with downdrafts. A contributing factor was the unsuitable vegetation-covered mountainous terrain.NTSB LAX06FA014Accident · 3 fatalField investigationFinal reportLancair LC-41-550FG · Warner Springs, CAThe flight crew's failure to maintain adequate terrain clearance and their decision to continue flight into known adverse weather conditions. Contributing to the accident was overcast conditions, and terrain obscuration. A finding of the investigation is that…NTSB LAX05FA311Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Baker, CAThe pilot's continued VFR flight into adverse weather conditions that resulted in a collision with mountainous terrain. Contributing to the accident was the obscuration of mountainous terrain by rain and low clouds, moderate turbulence, and the pilot's…NTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…NTSB LAX05LA216Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Mojave, CAthe pilot's encounter with a downdraft or wind shear during takeoff the initial climb.NTSB LAX05FA213Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Mt. Shasta, CAThe pilot's continued cruise flight into instrument meteorological conditions, which resulted in the pilot's controlled flight into high mountainous terrain (CFIT).NTSB LAX05CA190Accident · No injuriesData collectionFinal reportS.A. Centrair Pegase 101D · Williams, CAloss of thermal lift during flight that resulted in a forced landing in an area without suitable landing terrain. Also causal was the pilot's inadequate compensation for the existing crosswind.NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…NTSB LAX05LA144Accident · Serious injuriesLimited investigationFinal reportBishop RV6A · Dulzura, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising mountainous terrain.NTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.NTSB LAX05FA132Accident · 3 fatalField investigationFinal reportCessna T210L · Tranquility, CAthe pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…NTSB LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.NTSB LAX05LA105Accident · Serious injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Los Angeles, CAthe in-flight encounter with turbulence.NTSB LAX05FA092Accident · 2 fatalField investigationFinal reportCessna P210N · Lebec, CAthe pilot's in-flight loss of control due to the flight's encounter with unforecasted localized mountain wave activity with severe to potentially extreme turbulence, downdrafts, and rotors.NTSB LAX05FA088Accident · 1 fatalField investigationFinal reportCirrus Design SR22 G2 · Norden, CAthe pilot's in-flight loss of control following an inadvertent encounter with unforecast severe icing conditions. A factor in the accident was the inaccurate icing forecast developed by the NWS Aviation Weather Center.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 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 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 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 LAX04LA265Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Santa Clarita, CAthe pilot's inadequate planning/decision by his inadequate evaluation of the weather resulting in an attempt to conduct flight beyond the aircraft's climb performance capability.NTSB LAX04FA177Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Ukiah, CAThe non-instrument rated pilot's flight intentional flight into instrument meteorological conditions during takeoff-initial climb, which resulted in spatial disorientation, a subsequent loss of aircraft control, and an uncontrolled descent into terrain. A…