NTSB investigations, CA
20 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1985 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 2 |
| 1995 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 160)
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" = 160) 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 LAX06CA171Accident · No injuriesData collectionFinal reportCessna 320 · Long Beach, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.NTSB LAX05CA274Accident · No injuriesData collectionFinal reportBeech A36 · Healdsburg, CAthe pilot's failure to maintain lateral aircraft control during takeoff.NTSB LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.NTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.NTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.NTSB LAX02LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mammoth Lakes, CAThe onset of variable, gusty, crosswind conditions at the time of departure and the pilot's inadequate and improper compensation for the crosswind conditions.NTSB LAX01LA220Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Montague, CAA loss of control during landing flare. Contributing to the accident was the gusty wind condition.NTSB LAX00LA145Accident · No injuriesLimited investigationFinal reportOwens/Richburg Vans RV6-A · Sacramento, CAFailure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.NTSB LAX99LA321Accident · No injuriesLimited investigationFinal reportCessna 172N · Vacaville, CAThe pilot's inadequate compensation for the existing gusty crosswind condition and his subsequent failure to maintain directional control.NTSB LAX96LA100Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Folsom Lake, CAthe flight instructor's inadequate supervision of the dual student and improper remedial action. A factor relating to the accident was: failure of the student pilot to maintain directional control.NTSB LAX96LA053Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Fresno, CAfailure of the pilot to maintain proper control of the helicopter, while in a hover.NTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.NTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.NTSB LAX94FA292Accident · 1 fatalField investigationFinal reportCessna 414 · Taft, CAThe pilot's inadequate preflight planning/preparation and selection of the wrong runway for takeoff. Factors related to the accident were: the uphill slope of the runway, tailwind, high density altitude, and failure of the pilot to correctly configure the…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 LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…NTSB LAX87LA078Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Oakland, CAA Champion 7EC went out of control during the takeoff initial climb. The aircraft dragged a wing during takeoff ground run. The pilot was observed looking back towards the runway during the initial climb. The aircraft stalled and descended uncontrolled to the…NTSB LAX86FVD07Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot was making a slow pass and dragged one spray boom on the ground. Insufficient airspeed resulted in loss of control. Helicopter crashed.NTSB LAX85FUG04Accident · Serious injuriesFinal reportBriegleb Amature Built BG-12-BD · Hemet, CAIn was reported that Mr. Campbell departed perris airport, perris, CA at approximately 1215 PDT. It is unknown in what area he was flying. Mr. Campbell was sighted a few minutes prior to attempting to land in a field near 36875 menlo street, Hemet, CA. A…NTSB LAX85LA104Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Van Nuys, CAThis was the initial test flt after installation of rebuilt wings. On the takeoff roll, the acft began drifting to the right & the plt corrected with left aileron. He stated that the acft 'whipped violently further to right, caught a wing tip & ground…