NTSB investigations, CA
863 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR15LA251Accident · No injuriesLimited investigationFinal reportDova DV-1 · San Carlos, CAA partial loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.NTSB WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.NTSB WPR15FA238Accident · 1 fatalField investigationFinal reportAviat A 1 · Compton, CAThe pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB WPR15LA233Accident · 1 fatalLimited investigationFinal reportRyan Aeronautical ST3KR · Hollister, CAThe pilot's failure to observe the runway environment while operating in the traffic pattern and his subsequent failure to maintain clearance from a lawnmower on the runway during the landing roll. Contributing to the accident was the lawnmower operator's…NTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…NTSB GAA15CA200Accident · No injuriesData collectionFinal reportRobinson Helicopter R-22 · Corona, CAThe flight instructor's delayed remedial action to arrest the descent rate, which resulted in a running landing, the left skid catching rough terrain, and the main rotor blades impacting the ground.NTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.NTSB GAA15CA150Accident · Minor injuriesData collectionFinal reportCessna TR182 · Rio Vista, CAThe pilot's use of improper procedures during an aborted landing, resulting in a runway excursion and a collision with a canal.NTSB WPR15FA200Accident · 1 fatalField investigationFinal reportManiscalco Great Lakes · Corona, CAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while maneuvering, which resulted in a stall/spin at too low an altitude to allow recovery. Contributing to the accident was the pilot's improper…NTSB WPR15FA195Accident · 1 fatalField investigationFinal reportShort Brothers S312 Tucano T MK1 · Maricopa, CAThe pilot's failure to maintain clearance from terrain during low-level airwork, which resulted in uncontrolled collision with terrain. Contributing to the accident was the pilot's impairment from the combined effects of butalbital and codeine.NTSB WPR15LA193Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Salinas, CAThe non-instrument-rated pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control. Contributing to the accident was the pilot's impairment by high-dose opioid use.NTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.NTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.NTSB WPR15LA162Accident · No injuriesLimited investigationFinal reportEarl Allen Miglet · Corning, CAThe partial loss of engine power during initial climb due to a loose set screw, which allowed the throttle cable rig within the connector to slip.NTSB WPR15LA160Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Maxwell, CAThe pilot’s improper preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.NTSB WPR15LA138Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Firebaugh, CAA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA028Accident · Minor injuriesData collectionFinal reportLet L23 - NO Series · Los Alamitos, CAThe inadvertent deployment of the air brakes during initial climb, resulting in a loss of lift. Contributing to the accident was the pilot's failure to identify and remediate the cause.NTSB WPR15LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA30 - NO Series · Red Bluff, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…NTSB WPR15LA123Accident · Minor injuriesLimited investigationFinal reportGoudie Fisher Classic · Redlands, CAA loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate planning for the test flight, which resulted in insufficient altitude and no suitable place to land in the event of an emergency.NTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.NTSB WPR15LA104Accident · No injuriesLimited investigationFinal reportScottish Bulldog - 120 121 · Hayward, CAA total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the pilot’s inadequate preflight inspection of the fuel system.NTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.NTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…NTSB WPR15LA077Accident · No injuriesLimited investigationFinal reportCessna 172D · Fresno, CAThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR15CA076Accident · No injuriesData collectionFinal reportBeech 35 A33 · Angwin, CAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, and collision with a fence.NTSB WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…NTSB WPR15LA067Accident · Serious injuriesLimited investigationFinal reportFarthing James W II Beaver · Perris, CAThe partial loss of engine power during takeoff due to an improperly configured carburetor and fuel supply system. Contributing to the accident was the pilot's loss of airplane control during the off-field landing, which resulted in an aerodynamic stall.NTSB WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.NTSB WPR15IA046Incident · No injuriesIncident investigationFinal reportEmbraer EMB-505 · Palm Springs, CAThe failure of the gust lock actuator solenoid for reasons that could not be determined because postaccident examination of the rudder gust lock system revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR15CA047Accident · No injuriesData collectionFinal reportCessna 182Q · San Luis Obispo, CAThe pilot's failure to maintain airplane control during the landing flare with a crosswind.NTSB WPR15CA068Accident · No injuriesData collectionFinal reportCessna E162 · Santa Rosa, CAThe student pilot's improper flare which resulted in a hard landing and subsequent nose gear collapse.NTSB WPR15CA041Accident · No injuriesData collectionFinal reportChampion 7ECA · San Diego, CAThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB WPR15FA039Accident · 2 fatalField investigationFinal reportCessna 140A · Gilroy, CAThe pilot’s failure to maintain clearance from power lines while flying at a low altitude. Contributing to the accident was the obscuration of the pilot’s visibility due to sun glare.NTSB WPR15GA030Accident · 1 fatalFinal reportHawker Hawker Hunter MK.58 · Oxnard, CAThe pilot's failure to maintain adequate airspeed during the approach for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at an altitude too low for recovery.NTSB WPR15FA021Accident · 2 fatalField investigationFinal reportSlingsby T67M 260 · Ridgecrest, CAThe pilots' failure to recover from a spin for reasons that could not be determined based on available information. Contributing to the student's fatal injury was his delayed egress from the airplane below the specified egression altitude.NTSB WPR15FA016Accident · 1 fatalField investigationFinal reportSonex Sonex Trigear · Fawnskin, CAThe pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…NTSB WPR15LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Big Bear, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.NTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.NTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.NTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB WPR14LA367Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Warner Springs, CAThe glider pilot's failure to maintain directional control during the initial climb while being towed, which led to the tow plane's unstable flight and its subsequent aerodynamic stall. Contributing to the accident was the tow pilot's delayed release of the…NTSB WPR14LA337Accident · No injuriesLimited investigationFinal reportRyan Navion · Fresno, CAA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14LA329Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S 2B · Oceanside, CAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate fuel planning.