NTSB investigations, CA

304 cases where the sequence of events included Off-field or emergency landing.

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\" = '440' 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.

NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…Jan 4, 2020 · N45069 · Substantial damageNTSB WPR20LA009Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 206 · Stockton, CAA total loss of engine power after takeoff for reasons that could not be determined based on the available information.Oct 18, 2019 · N11379 · Substantial damageNTSB WPR20FA005Accident · 1 fatalClass 3 · FieldFinal reportBede BD5 · Camarillo, CAThe No. 4 connecting rod’s bearing shift and separation of the No. 4 connecting rod, which resulted in a total loss of engine power and subsequent forced landing.Oct 8, 2019 · N501BD · Substantial damageNTSB WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.Sep 11, 2019 · N1168U · Substantial damageNTSB GAA19CA504Accident · No injuriesData collectionFinal reportCessna 182 · Oakland, CAThe pilot's premature full retraction of the flaps during a go-around and his subsequent improper decision to turn with a minimal climb gradient, which resulted in an off-airport landing and a landing gear collapse.Aug 4, 2019 · N58628 · Substantial damageNTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.Jul 21, 2019 · N409EV · Substantial damageNTSB GAA19CA426Accident · Minor injuriesData collectionFinal reportNorth American T28 · Hollister, CAThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Jun 20, 2019 · N28CU · Substantial damageNTSB WPR19FA126Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Mill Creek, CAA total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.May 1, 2019 · N7302S · Substantial damageNTSB WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.Dec 28, 2018 · N8319T · Substantial damageNTSB WPR19LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV7A · Ramona, CAThe partial loss of engine power for reasons that could not be determined based on the available information.Nov 10, 2018 · N5433T · DestroyedNTSB WPR19LA014Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ · Agoura Hills, CAThe failure of the No. 5 piston rod end due to fatigue, which resulted in a total loss of engine power.Oct 23, 2018 · N7969C · DestroyedNTSB WPR18LA233Accident · No injuriesLimited investigationFinal reportBlue Oak CCK-1865 · Deadwood, CAA loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.Aug 20, 2018 · N14CK · Substantial damageNTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…Aug 11, 2018 · N328SK · Substantial damageNTSB WPR18FA198Accident · 2 fatalField investigationFinal reportRyan Navion · Truckee, CAA loss of engine power for reasons that could not be determined.Jul 17, 2018 · N5329K · Substantial damageNTSB WPR18TA157Accident · No injuriesClass 3Final reportCessna 182D · Crescent Mills, CAA total loss of engine power due to the development of carburetor icing.May 18, 2018 · N9163X · Substantial damageNTSB WPR18LA133Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Borrego Springs, CAThe loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.Apr 30, 2018 · N423ML · Substantial damageNTSB WPR18LA128Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G 164C · Maxwell, CAA total loss of engine power due to an uncommanded closing of the fuel shutoff valve, which terminated fuel to the engine. The reason for the fuel shutoff valve’s closure could not be determined based on the available information.Apr 29, 2018 · N6674K · Substantial damageNTSB WPR18CA096Accident · Serious injuriesData collectionFinal reportBell 47G · Pixley, CAA total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…Feb 28, 2018 · N7800S · Substantial damageNTSB GAA18CA140Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Woodland, CAThe pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application.Feb 24, 2018 · N630ML · Substantial damageNTSB WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA total 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.Dec 17, 2017 · N8884H · Substantial damageNTSB WPR18LA034Accident · Serious injuriesClass 2 · LimitedFinal reportCessna 172P · San Jose, CAThe pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…Nov 19, 2017 · N52492 · Substantial damageNTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.Nov 17, 2017 · N5966V · Substantial damageNTSB WPR18LA021Accident · No injuriesLimited investigationFinal reportMetcalfe Robert B Vans RV 6 · Selma, CAThe pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power.Oct 30, 2017 · N88MV · Substantial damageNTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.Oct 3, 2017 · N418CP · Substantial damageNTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.Sep 23, 2017 · N34BE · Substantial damageNTSB WPR17LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-161 · El Cajon, CAA partial loss of engine power due to the formation of carburetor ice during descent for landing. Contributing to the accident was the pilot’s failure to apply carburetor heat.Sep 17, 2017 · N2587X · Substantial damageNTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.Sep 4, 2017 · N75753 · Substantial damageNTSB WPR17LA191Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Fortuna, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have that would have precluded normal operation.Aug 27, 2017 · N8695H · Substantial damageNTSB GAA17CA505Accident · No injuriesData collectionFinal reportCessna 177RG · Byron, CAThe pilot’s improper preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 22, 2017 · N8053G · Substantial damageNTSB WPR17LA174Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe partial loss of engine power due to the overstress separation of three supercharger drive gear teeth.Aug 1, 2017 · N4913X · Substantial damageNTSB WPR17LA172Accident · No injuriesLimited investigationFinal reportCessna T210F · Llano, CAA failure of the turbocharger that resulted in complete depletion of the engine oil and catastrophic internal failure of the engine. Contributing to the accident was improper and/or incomplete maintenance and inspection of the turbocharger.Aug 1, 2017 · N6109R · Substantial damageNTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…Jul 21, 2017 · N3254E · Substantial damageNTSB WPR17LA158Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28C · Ontario, CAThe student pilot's mismanagement of the main rotor rpm, which resulted in low rotor rpm, a high descent rate, and a subsequent hard landing.Jul 19, 2017 · N5697B · Substantial damageNTSB WPR17LA156Accident · No injuriesClass 3 · LimitedFinal reportSimmons Gary F Stol CH 701 · Kenwood, CAFailure of the flywheel drive assembly, which resulted in a loss of engine power and subsequent forced landing to uneven terrain.Jul 15, 2017 · N422ES · Substantial damageNTSB WPR17LA142Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Vacaville, CAThe total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no mechanical failure or malfunction that would have precluded normal operation.Jul 7, 2017 · N7532V · Substantial damageNTSB WPR17LA140Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Bella Vista, CAA partial loss of engine power during low-altitude maneuvering for reasons that could not be determined because postaccident examinations of the engine and airframe revealed no evidence of any preaccident mechanical malfunctions or failures that would have…Jul 3, 2017 · N488AS · Substantial damageNTSB WPR17LA110Accident · Minor injuriesLimited investigationFinal reportJohnson Glastar · Concord, CAA total loss of engine power for reasons that could not be determined based on the available evidence.May 26, 2017 · N4579J · Substantial damageNTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.May 5, 2017 · N981RR · DestroyedNTSB WPR17LA094Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 52 · Porterville, CAA partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.Apr 29, 2017 · N132MD · Substantial damageNTSB WPR17LA090Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Banning, CAThe pilot's improper energy management during an emergency landing approach that was prompted by an engine power loss. The specific reason(s) for the power loss and the improper energy management could not be determined based on available evidence.Apr 24, 2017 · N6218Y · Substantial damageNTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 4, 2017 · N55339 · Substantial damageNTSB WPR17LA071Accident · No injuriesLimited investigationFinal reportBell 206B · Firebaugh, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge, which led the pilot to believe that there was adequate fuel onboard.Mar 1, 2017 · N211CS · Substantial damageNTSB WPR17LA067Accident · Minor injuriesLimited investigationFinal reportGuarino Vans · Marysville, CAA partial loss of engine power for reasons that could not be determined due to the fragmentation of the electrical system.Feb 24, 2017 · N470LM · Substantial damageNTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.Feb 14, 2017 · N4534G · Substantial damageNTSB WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…Dec 27, 2016 · N602L · Substantial damageNTSB WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 10, 2016 · N9556U · Substantial damageNTSB WPR17LA011Accident · No injuriesLimited investigationFinal reportMooney M20J · Coalinga, CAA partial loss of engine power due to the pilot's improper in-flight fuel management, which resulted in fuel starvation.Oct 23, 2016 · N201EU · Substantial damageNTSB WPR16LA149Accident · No injuriesLimited investigationFinal reportSwartz Gene Titan T 51 Mustang · Lancaster, CAA total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.Jul 23, 2016 · N5103 · Substantial damageNTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…Jul 2, 2016 · N6251G · Substantial damageNTSB WPR16LA125Accident · No injuriesLimited investigationFinal reportBell 206 · Bishop, CAThe pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…Jun 14, 2016 · N1076Y · Substantial damage