NTSB investigations, CA
906 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 36 |
|---|---|
| 1983 | 69 |
| 1984 | 49 |
| 1985 | 51 |
| 1986 | 41 |
| 1987 | 33 |
| 1988 | 59 |
| 1989 | 31 |
| 1990 | 48 |
| 1991 | 41 |
| 1992 | 36 |
| 1993 | 34 |
| 1994 | 45 |
| 1995 | 38 |
| 1996 | 27 |
| 1997 | 11 |
| 1998 | 30 |
| 1999 | 22 |
| 2000 | 25 |
| 2001 | 25 |
| 2002 | 20 |
| 2003 | 29 |
| 2004 | 20 |
| 2005 | 24 |
| 2006 | 31 |
| 2007 | 31 |
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\" = 250)
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" = 250) 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 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 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 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 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 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 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 LAX07CA273Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Oakland, CAThe student pilot's failure to adequately compensate for the crosswind conditions and to maintain directional control.NTSB SEA07FA247Accident · 6 fatalField investigationFinal reportLancair LC41-550FG · Kernville, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. Contributing to the accident was the pilot's failure to maintain an adequate airspeed.NTSB LAX07FA258Accident · 2 fatalField investigationFinal reportRaytheon A36 · Cameron Park, CAThe airplane's sudden encounter with a wind shift during the initial takeoff climb that resulted in degraded climb performance and a stall mush condition. Contributing to the accident was the airplane's over gross weight condition, high density altitude, the…NTSB SEA07LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Blythe, CAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB SEA07FA231Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus-CM · Benton, CAThe pilot's failure to maintain aircraft control while maneuvering and the inadvertent entry into a stall/spin. Contributing to the accident were the mountainous terrain conditions, unfavorable wind conditions, and the terrain-induced turbulent wind…NTSB LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB SEA07LA196Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Camarillo, CAThe pilot's failure to maintain aircraft control during a go-around. Contributing to the accident was the pilot's lack of experience in the make and model of airplane.NTSB LAX07FA219Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAthe pilot's inadequate in-flight decision to attempt low altitude flight operations into a box canyon in mountainous terrain, and his failure to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated stall and spin.NTSB LAX07GA217Accident · No injuriesFinal reportEurocopter France AS350 B3 · Paso Robles, CAa loss of control for undetermined reasons, which resulted in an uncommanded roll and subsequent collision with terrain. Contributing factors in the accident were the flying pilot's failure to request assistance from the second pilot in a timely manner and…NTSB LAX07CA194Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Fresno, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB SEA07LA154Accident · No injuriesLimited investigationFinal reportBell UH-1B · Biggs, CALoss of control during hover for undetermined reasons.NTSB LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.NTSB SEA07LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Rosamond, CAThe pilot's failure to abort the takeoff due to lack of airplane climb performance, which resulted in a collision with terrain.NTSB LAX07LA175Accident · 1 fatalLimited investigationFinal reportSkygear Skygear · Chino, CAThe pilot's failure to maintain an adequate airspeed that resulted in an inadvertent stall.NTSB SEA07CA130Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Merced, CAThe student pilot's inadvertent stall/mush during a simulated power loss after takeoff and the flight instructor's delayed remedial action, which resulted in a hard landing. A contributing factor was the flight instructor's lack of familiarity with the…NTSB LAX07CA152Accident · No injuriesData collectionFinal reportStinson 108 · Auburn, CAThe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in a stall/mush.NTSB LAX07LA147Accident · 1 fatalLimited investigationFinal reportCeridono Vegas Sport Flyer · Mountain Pass, CAThe loss of airplane control while maneuvering after takeoff for an undetermined reason.NTSB LAX07LA142Accident · 1 fatalLimited investigationFinal reportMcDonald J4B-2 · Marysville, CAAn in-flight loss of control for undetermined reasons. Contributing to the accident was the impairment of the pilot by the drug substances identified in the toxicological testing.NTSB LAX07LA140Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Carlsbad, CAthe pilot's loss of control due to spatial disorientation.NTSB SEA07CA107Accident · Minor injuriesData collectionFinal reportCessna 172B · Los Angeles, CAThe pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.NTSB SEA07CA084Accident · No injuriesData collectionFinal reportBoykin Rotorway Exec 162F · Camarillo, CAThe pilot's failure to maintain main rotor RPM resulting in an uncontrolled descent to a hard landing. A contributing factor was his lack of experience in make and model of aircraft.NTSB LAX07LA099Accident · 1 fatalLimited investigationFinal reportMallian Rocket II · Arvin, CALoss of control during cruise for undetermined reasons.NTSB LAX07CA087Accident · 1 fatalData collectionFinal reportWampole Mini-Max · Adelanto, CAa loss of control for undetermined reasons.NTSB LAX07MA069Accident · 2 fatalMajor investigationFinal reportCessna 525 · Van Nuys, CAThe pilot's failure to maintain an adequate airspeed during the initial climb resulting in an inadvertent stall/spin. Contributing to the accident were the second pilots inadequate preflight, failure to properly secure the front baggage door, and the front…NTSB SEA07LA046Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · San Diego, CAThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor to the accident was the improper takeoff configuration of the airplane.NTSB LAX07LA067Accident · 1 fatalLimited investigationFinal reportCessna 150J · San Diego, CAThe pilot's improper use of the throttle and failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.NTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.NTSB LAX07TA051Accident · No injuriesFinal reportLearjet 36 · San Diego, CAThe pilot's failure to maintain aircraft control while maneuvering, which resulted in exceeding the design stress limits of the aircraft. Contributing to the accident was the sunglare.NTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.NTSB LAX07LA023Accident · 1 fatalLimited investigationFinal reportMoyes Dragonfly · Brentwood, CAthe pilot's failure to obtain and maintain an adequate airspeed during the initial climb resulting in a stall and uncontrolled descent into terrain.NTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.NTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.NTSB LAX06CA279Accident · No injuriesData collectionFinal reportCessna T210G · So Lake Tahoe, CAthe pilot's failure to maintain an adequate airspeed and his inadequate remedial actions during a balloon in the landing flare, which resulted in a stall and hard landing.NTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.NTSB LAX06LA262Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Mojave, CAthe pilot's failure to maintain an adequate airspeed while performing low-level aerobatics that resulted in an inadvertent accelerated stall and in-flight collision with terrain.NTSB LAX06LA255Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Chowchilla, CAThe pilot's loss of control while maneuvering resulting from an incapacitating physiological event.NTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.NTSB LAX06CA250Accident · Minor injuriesData collectionFinal reportRobinson R-22B · Chino, CAthe certified flight instructor's inadequate supervision and incorrect remedial action. A factor was the student pilot's loss of control in a hovering turn.NTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.NTSB LAX06CA221Accident · No injuriesData collectionFinal reportRobinson R-44 · Fresno, CAthe pilot's failure to maintain directional control following a loss of tail rotor effectiveness while in a downwind hover.NTSB LAX06LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chino Hills, CAA loss of aircraft control for undetermined reasons.NTSB LAX06LA170Accident · 1 fatalLimited investigationFinal reportSchlitter Rans S-18 Stinger · Llano, CAan in-flight loss of control and collision with terrain for undetermined reasons.NTSB LAX06CA168Accident · No injuriesData collectionFinal reportGrumman G-164A · Yuba City, CAthe pilot's failure to attain and maintain an adequate airspeed during the takeoff initial climb.