NTSB investigations, CA
717 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 47 |
|---|---|
| 1983 | 38 |
| 1984 | 37 |
| 1985 | 30 |
| 1986 | 30 |
| 1987 | 29 |
| 1988 | 33 |
| 1989 | 29 |
| 1990 | 27 |
| 1991 | 26 |
| 1992 | 20 |
| 1993 | 26 |
| 1994 | 27 |
| 1995 | 31 |
| 1996 | 27 |
| 1997 | 24 |
| 1998 | 22 |
| 1999 | 21 |
| 2000 | 35 |
| 2001 | 24 |
| 2002 | 24 |
| 2003 | 23 |
| 2004 | 19 |
| 2005 | 21 |
| 2006 | 24 |
| 2007 | 23 |
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\" = 260)
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" = 260) 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 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 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 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 LAX07CA289Accident · No injuriesData collectionFinal reportLuscombe 8A · Reedley, CAThe pilot's failure to maintain directional control on landing.NTSB SEA07CA243Accident · No injuriesData collectionFinal reportCessna 172S · Bakersfield, CAThe student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a taxiway sign.NTSB SEA07CA215Accident · No injuriesData collectionFinal reportCessna 305-C · Chino, CAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX07CA199Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbara, CAthe pilot's failure to maintain directional control.NTSB SEA07CA192Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Palm Springs, CAThe pilot's failure to maintain directional control during landing which resulted in an inadvertent ground loop.NTSB SEA07LA187Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fresno, CAThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB SEA07CA146Accident · No injuriesData collectionFinal reportCessna T210N · Bakersfield, CAThe pilot's improper flare, which resulted in a loss of directional control. Factors included the crosswind and gusty wind condition.NTSB LAX07CA284Accident · Minor injuriesData collectionFinal reportCessna 150M · Sonoma, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB SEA07CA104Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Concord, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop/swerve and collapse of the nose landing gear. A contributing factor was the gusty wind condition.NTSB LAX07CA128Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Porterville, CAThe pilot's failure to maintain directional control.NTSB LAX07CA112Accident · No injuriesData collectionFinal reportCaywood Long-Ez · El Cajon, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.NTSB LAX07CA097Accident · Minor injuriesData collectionFinal reportMonocoupe 110 · Camarillo, CAThe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB LAX07CA096Accident · No injuriesData collectionFinal reportPeay Quckie Q-200 · Livermore, CAThe pilot failed to maintain directional control during an aborted takeoff.NTSB LAX07CA088Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Compton, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the passenger's interference with the pilot's manipulation of the controls.NTSB SEA07LA053Accident · Minor injuriesLimited investigationFinal reportRoss Hummer Pitts Special · Stockton, CAThe pilot's inadvertent ground loop/swerve, resulting in a nose over during an aborted takeoff. A contributing factor was the uneven runway surface, which restricted the pilot's ability to maintain directional control.NTSB SEA07LA044Accident · No injuriesLimited investigationFinal reportCessna 172S · Lancaster, CAThe reason for the loss of directional control was undetermined.NTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.NTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB LAX06CA263Accident · No injuriesData collectionFinal reportStinson 108-2 · Grass Valley, CAfailure of the pilot to maintain directional control on the landing rollout due to inadequate compensation for a gusty crosswind condition and an attempt to turn at an excessive taxi speed.NTSB LAX06LA260Accident · No injuriesLimited investigationFinal reportSicheneder Pitts S1S · Tracy, CAThe failure of the pilot to maintain directional control during the landing rollout.NTSB LAX06CA241Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Greenfield, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane during landing.NTSB LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB LAX06CA219Accident · Minor injuriesData collectionFinal reportCessna 170B · Vacaville, CAthe pilot's failure to maintain directional control. A contributing factor was pilot fatigue.NTSB LAX06CA218Accident · No injuriesData collectionFinal reportCessna T206H · Santa Maria, CAthe pilot's failure to maintain directional control during landing.NTSB LAX06CA215Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Carlsbad, CAthe pilot's failure to maintain runway alignment during the aborted landing, which resulted in a collision with a tree.NTSB LAX06CA212Accident · No injuriesData collectionFinal reportMaule M-7-235C · La Verne, CAthe pilot's failure to obtain/maintain directional control on the landing rollout.NTSB LAX06LA210Accident · No injuriesLimited investigationFinal reportBeech A36 · Schellville, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX06LA192Accident · No injuriesLimited investigationFinal reportCessna 180A · Marina, CAthe installation of the unapproved forward seat stop by unknown maintenance personnel, which did not allow for full depth engagement of the seat lock pin, resulting in the seat slipping aft during the takeoff roll and subsequent loss of directional control. A…NTSB LAX06CA179Accident · No injuriesData collectionFinal reportCessna A185F · Columbia, CAthe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the landing rollout.NTSB LAX06CA174Accident · No injuriesData collectionFinal reportCessna 172S · Madera, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…NTSB LAX06CA137Accident · No injuriesData collectionFinal reportCessna 170A · Hanford, CAthe pilot's failure to maintain directional control.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.NTSB ANC06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24 · La Vern, CAThe pilot's excessive taxi speed while turning, which resulted in an on ground collision with a taxiway light and the ground.NTSB LAX06LA112Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1A · Rancho Murieta, CAthe pilot's failure to maintain directional control of the airplane on the landing roll.NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.NTSB LAX06CA085Accident · Minor injuriesData collectionFinal reportPiper Seneca · Van Nuys, CAThe pilot's failure to maintain directional control during landing. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB LAX06CA074Accident · No injuriesData collectionFinal reportAvid Mark IV · California City, CAthe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane on takeoff.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.