NTSB investigations, CA
32 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 3 |
| 2005 | 1 |
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\" = 100)
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" = 100) 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 LAX05FA262Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot's failure to maintain aircraft control and adequate airspeed while executing an evasive maneuver during an aborted landing, which resulted in a cross-controlled accelerated stall and impact with terrain. Contributing to the accident was the probable…NTSB LAX03CA274Accident · Serious injuriesData collectionFinal reportBell 47D1 · Chino, CAthe student pilot's inappropriate remedial action through the application of excessive aft cyclic during a run-on landing. A factor in the accident was the student's disregard for company procedures.NTSB LAX03LA253Accident · No injuriesLimited investigationFinal reportBell 206B · Merced, CAThe pilot's excessive movement of the helicopter's controls during an aborted landing, which resulted in a loss of control (dynamic rollover) and an in-flight collision with terrain.NTSB LAX03LA176Accident · 1 fatalLimited investigationFinal reportWinters Glasair SH-2 · Riverside, CAThe pilot's failure to maintain control of the airplane during an abrupt, low altitude maneuver during the takeoff-initial climb, which resulted in a collision with terrain during the subsequent uncontrolled descent.NTSB LAX01LA307Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · San Francisco, CAthe captain's excessive use of the flight controls to level off from a descent, which resulted in a passenger injury.NTSB LAX98FA171Accident · 2 fatalField investigationFinal reportVans RV-8 · Ripley, CAthe intentional or unintentional sudden application of aft elevator control by an undetermined aircraft occupant that exceeded the design stress limits of the aircraft. The aircraft gross weight, which exceeded the maximum allowable for aerobatics, and…NTSB LAX97GA235Accident · 1 fatalFinal reportBell BHT-206L-1 · Highland, CALoss of engine power due to fuel contamination. Also causal was the ingestion of entrapped air that occurred during an abrupt maneuver and fuel-borne contamination that caused the fuel system check valves to leak, resulted in a lower than expected fuel level…NTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.NTSB LAX97LA014Accident · 1 fatalLimited investigationFinal reportCunningham Rotorway Exec · Mather, CAexcessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.NTSB LAX96LA231Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Inyokern, CAthe pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.NTSB LAX96LA207Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Thermal, CAinadequate design of the stress limits for cyclic control of the helicopter.NTSB LAX96LA037Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Richvale, CAthe attempt by the pilot to execute an aerobatic maneuver with inadequate altitude to effect recovery before impacting terrain.NTSB LAX94LA190Accident · 2 fatalLimited investigationFinal reportBushby Mustang II · Byron, CAan abrupt maneuver by the pilot that initiated an in-flight separation of the tail and wing sections during acrobatic flight.NTSB LAX93LA171Accident · Minor injuriesLimited investigationFinal reportMong SPORT-S · Fallbrook, CAFailure of the pilot to visually clear the runway before starting the takeoff ground run. Factors in the accident were inadequate airspeed at the time of liftoff which resulted in an aerodynamic stall.NTSB LAX92LA336Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · San Francisco, CAThe improper installation of the towbar. Contributing to the accident was a disconnected tow bar during push back.NTSB LAX92LA109Accident · 1 fatalLimited investigationFinal report85 Manista KB-2 · Rosamond, CAThe pilot's failure to maintain main rotor RPM adequate to avoid flapping. Factors which contributed to the accident were related to the pilot's performance of an excessively abrupt maneuver.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.NTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.NTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.NTSB DEN90FA059Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · Agoura, CALoss of control of the aircraft during acrobatic flight and the pilot's failure to recover from a spin.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB LAX88LA229Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dorris, CADuring a local pleasure flt, just as the airplane touched down, an antelope ran across the rwy. The plt swerved the airplane to avoid the animal, exited the runway and collided with the terrain. There were no mechanical failures or malfunctions with the…NTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…NTSB LAX87LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Long Beach, CAThe plt indicated that 10 min from his destination he became concerned that the fuel gauges read 'near zero.' The plt elected to divert to another aprt, which was closed. The plt maintained his alt in case of power loss. The plt stated, 'I also became glued…NTSB LAX87IA303Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Los Angeles, CADrg arr, japan airline flt 62 (Boeing 747, JA-8163) was initially vectored (by lax ARTCC) for an ILS rwy 24R apch in reduced visibility (haze). Bfr turning final, flt 62 was adzd of an acft that was 4 mi ahead. Flt 62 rprtd that they had the acft in sight.…NTSB LAX87FA286Accident · 2 fatalField investigationFinal reportLuscombe 8A · Oakdale, CAThe plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the…NTSB LAX87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Davis, CAA Cessna 152 nosed over in a rough plowed field after a partial loss of power while on a night VFR pleasure flight. The pilot indicated that he was on a date with his girl friend and offered to demonstrate negative gravity to her. He slowed the aircraft and…NTSB LAX86LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fullerton, CADuring an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the…NTSB LAX85LA319Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down.NTSB LAX84LA441Accident · No injuriesLimited investigationFinal reportBell P-63C-5-BE · Madera, CAThe plts of a Bell P-63 (king cobra), N62822 & a north American P-51 (mustang), N65206, were participating in an air- show when the acft collided during landing. An investigation revealed the P-63 plt had made a 360 overhead pattern before landing. At about…NTSB LAX84FA382Accident · 1 fatalField investigationFinal reportEntwicklungsgemeinschaft Phoebus C · Yermo, CAThe pilot encountered adverse soaring flight conditions during a long x-country attempt and was forced to divert to an intermediate airport. On a long glide to his selected landing site, the pilot encountered high powerlines. Turning to avoid them , he lost…